Link to home
Start Free TrialLog in
Avatar of Muhammad Khan
Muhammad KhanFlag for Canada

asked on

Error while performing failover in Dataguard configuration

I have one configuration where i have one primary and two physical standby databases...
primary database is working in Maximum availability modes.. standby redo logs are set on all three databases.
to check one of my standby databases can take over primary role , i am trying to mock the primary database failure by disconnecting one of my standby database from network.. and making that standby database primary by performing following steps

SQL>alter database recover managed standby database finish;

Database altered
SQL>alter database commit to switchover to primary;

this statement gave me error
"Media recovery required"

and failover failed...

in alert log file i can see the following


alter database recover managed standby database finish
Terminal Recovery: request posted
Fri Nov 14 23:46:02 2008
Warning: log 4 of thread 1 is being archived or modified
MRP0: Background Media Recovery terminated with error 261
Fri Nov 14 23:46:02 2008
Errors in file /oracle/admin/dar/bdump/dar_mrp0_196840.trc:
ORA-00261: log 4 of thread 1 is being archived or modified
ORA-00312: online log 4 thread 1: '/std_loga/log01a.log'
ORA-00312: online log 4 thread 1: '/std_logb/log01b.log'
Recovery interrupted.
MRP0: Background Media Recovery process shutdown
Fri Nov 14 23:46:03 2008
Terminal Recovery: completion detected
Completed: alter database recover managed standby database fi
Fri Nov 14 23:46:03 2008
alter database commit to switchover to primary
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
Database not recovered through End-Of-REDO
Database not recovered through End-Of-REDO
Switchover: Media recovery required - standby not in limbo
ORA-16139 signalled during: alter database commit to switchover to primary...



the strange thing is.. if i do this two three times , it will succeed once...

any ideas why it is happening?
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial