RMAN Reinstate Standby

Step 1 Determine the SCN at which the old standby database became the primary database.


	   SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;

Step 2 Flashback the Failed Primary Database to SCN standby_became_primary_scn.


	   SQL> SHUTDOWN IMMEDIATE; 

	   SQL> startup mount; 

	   SQL> FLASHBACK DATABASE TO SCN ;

Step 3 Convert the database to a physical standby database and Restart database in mount stage.


	   SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; 

	   SQL> SHUTDOWN IMMEDIATE; 

	   SQL> STARTUP MOUNT;

Step 4 Start Redo Appply.


	   SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;