About switchover latent [message #347005] |
Wed, 10 September 2008 07:19 |
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 |
|
BlackSwan
Messages: 26766 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.
|
|
|