Home » Server Options » Data Guard » DG
DG [message #504073] Thu, 21 April 2011 07:27 Go to next message
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 messageGo to next message
John Watson
Messages: 8268
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 #504076 is a reply to message #504073] Thu, 21 April 2011 07:39 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
ORA-16416:
Switchover target is not synchronized with the primary
Cause: The switchover target incurred an error or has a gap at the time the switchover operation was attempted.
Action: Allow the switchover target to become synchronized and then re-attempt the switchover.


Please Post DB version with 4 digits.
Read doc id 8287155.8

Sriram
Re: DG [message #504082 is a reply to message #504074] Thu, 21 April 2011 07:54 Go to previous message
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
Previous Topic: datagaurd configuration
Next Topic: switchover_status=not allowed
Goto Forum:
  


Current Time: Wed May 27 18:11:50 CDT 2020