OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » DG

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DG [message #504073]

Thu, 21 April 2011 07:27

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

Report message to a moderator

Re: DG [message #504074 is a reply to message #504073]

Thu, 21 April 2011 07:37

John Watson
Messages: 8880
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.

Report message to a moderator

Re: DG [message #504076 is a reply to message #504073]

Thu, 21 April 2011 07:39

ramoradba
Messages: 2456
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

Report message to a moderator

Re: DG [message #504082 is a reply to message #504074]

Thu, 21 April 2011 07:54

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

Report message to a moderator

Previous Topic:	datagaurd configuration
Next Topic:	switchover_status=not allowed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 02 03:30:01 CDT 2023