Database Software

Hi all,

I am using oracle EE version 10.2.0.4.I have a setup of primary and standby database named prim and standby.I have tested failover method.I have shutted down primary and converted standby to new primary database.


•Stop Redo Apply.
Issue the following SQL statement on the target standby database:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
•Finish applying all received redo data.
By this we are giving indication to the standby database that primary database is no more.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
Once the FINISH command has completed, the protection mode of the primary database is lowered to Maximum Performance, regardless of its original protection mode.This is done because the new primary can be activated with out an standby
sql> select protection_mode , protection_level from v$database
Protection Mode Protection Level
——————– ——————–
MAXIMUM PERFORMANCE UNPROTECTED

•Verify that the target standby database is ready to become a primary database.

Query the SWITCHOVER_STATUS column of the V$DATABASE view on the target standby database.
•Switch the physical standby database to the primary role.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
•Open the new primary database
SQL> ALTER DATABASE OPEN;
•At this stage the protection level is changed to Max Performance from ‘Unprotected’
•Backup the new primary database.



how can i fail back from this situation to previous one?