DG [message #504073] |
Thu, 21 April 2011 07:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2f20a59717d276bc89414e414d6ac617?s=64&d=mm&r=g) |
sri6885
Messages: 5 Registered: April 2011 Location: hyderabad
|
Junior Member |
|
|
HI ALL,
alter database commit to switchover to physical standby;
i am getting ora-16416 switchover target is not synchronized with the primary what to do
|
|
|
Re: DG [message #504074 is a reply to message #504073] |
Thu, 21 April 2011 07:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I see that this is your third post today regarding Data Guard. Before you try to swtichover, are you sure that you have set it up correctly? What checks have you made? I would begin with a very simple query, run it on both the primary and the standby:
select process,status,sequence#,block# from v$managed_standby;
If Data Guard is working, this view will show you that redo blocks are being transmitted, received, and applied.
|
|
|
|
Re: DG [message #504082 is a reply to message #504074] |
Thu, 21 April 2011 07:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/2f20a59717d276bc89414e414d6ac617?s=64&d=mm&r=g) |
sri6885
Messages: 5 Registered: April 2011 Location: hyderabad
|
Junior Member |
|
|
yeah,i dint know till now any thing about datagaurd,just started
practicing.the archives are not transmitting that i come to know
when i switch log file from primary and observe the archive is
generated in archive destination of standby side
by exceuting the suggeted query by u
i am getting as
primary:
process status sequence# block#
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
standby:
process status sequence# block#
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
|
|
|