Home » Server Options » Data Guard » Dataguard - Role Transition (Oracle Database, 10.2.0.5.0,Windows Server 2003)
Dataguard - Role Transition [message #606182] Mon, 20 January 2014 23:48 Go to next message
Guna4324
Messages: 11
Registered: January 2014
Junior Member
Hi All,

Greetings,

At the time of manual switchover (role-change) from primary to standby i got this below error,

What is the exact reason...

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN.

It shows the below error on primary.
ERROR at line 1:
ORA-16416: Switchover target is not synchronized with the primary


My DB version is 10.2.0.5.0

Also the switchover_status is sessions active.


Re: Dataguard - Role Transition [message #606187 is a reply to message #606182] Tue, 21 January 2014 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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.

You have to fill the gap: all archived logs generated on the primary must be applied on the standby to be able to switchover.



Re: Dataguard - Role Transition [message #606215 is a reply to message #606187] Tue, 21 January 2014 04:28 Go to previous messageGo to next message
Guna4324
Messages: 11
Registered: January 2014
Junior Member
Hi Michel Cadot

Greetings,

Your are right, I had make a manual log-switch for more than 20 times.

Both primary and standby showing(Archivelog list) as Same.



But I am not clear about this archivelog applied gap, How can we change the time delay???? Is there any possibilities to do this???

Regards

Guna4324





Re: Dataguard - Role Transition [message #606217 is a reply to message #606215] Tue, 21 January 2014 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can slow down the archive apply using "archive_lag_target" parameter, you cannot speed it up; the default is to apply as fast as possible.
Re: Dataguard - Role Transition [message #606652 is a reply to message #606217] Tue, 28 January 2014 00:34 Go to previous message
Guna4324
Messages: 11
Registered: January 2014
Junior Member
Thanks Michel...
Previous Topic: I need a doc about creating dataguard in rac
Next Topic: ORA-16224: Database Guard is enabled
Goto Forum:
  


Current Time: Thu Mar 28 10:44:14 CDT 2024