Home » Server Options » Data Guard » About switchover latent (Oracle 10.2,window)
About switchover latent [message #347005] Wed, 10 September 2008 07:19 Go to next message
raj_roshan_009
Messages: 29
Registered: May 2008
Junior Member
Hi all,

can anyone let me know abount Switchover latent.
How can i change the value of switchover_status from "Switchover Latent" to "To Primary".



SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
SWITCHOVER LATENT

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required


Regards
Roshan.
Re: About switchover latent [message #347046 is a reply to message #347005] Wed, 10 September 2008 09:03 Go to previous message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
16139, 00000, "media recovery required"
// *Cause:  An error has occurred while performing a switchover.
// *Action: If you were switching a primary database to the standby role, the
//          conversion was successful, but one or more errors occurred after
//          the conversion completed. See the alert log for more information.
//          You can proceed with switching the target standby database to the
//          primary role, but you must address the errors reported at the old
//          primary database before it can protect the new primary database.
//
//          If you encountered this error while switching a physical standby
//          database to the primary role, the switchover did not succeed
//          because additional redo must be applied. Verify that redo apply is
//          active and wait until the SWITCHOVER_STATUS column of the
//          V$DATABASE dynamic performance view reports TO_PRIMARY or 
//          SESSIONS_ACTIVE before retrying the switchover.
Previous Topic: standby_archive_dest full
Next Topic: Error: ORA-16642: db_unique_name mismatch
Goto Forum:
  


Current Time: Tue Dec 06 00:13:57 CST 2016

Total time taken to generate the page: 0.28705 seconds