Converting back physical standby database from Primary DB

 

Note: Please note that your database was earlier running as physical standby database and you have converted it into read-write mode for some testing purpose or reporting purpose. Now again you want to convert back the primary database to physical standby database. In this case, you have to perform below manual method of converting Primary database into Physical Standby database.

 

Step 1: First make sure the below few things are checked before going ahead. Ensure your database is in archivelog mode. Ensure that flashback is enabled in the database. Ensure that guaranteed restore point is created.

 

Step 2: Note guaranteed restore point details. SQL> select name,open_mode,log_mode,flashback_on from v$database; SQL> select name from v$restore_point;

 

Step 3: Shut down the database and start it in mount stage. SQL> shut immediate; SQL> startup mount;

 

Step 4: Flashback the database till guaranteed restore point. SQL> flashback database to restore point RP1;

 

Step 5: Now drop the created restore point once you flashed back the database and also disabled the flashback. SQL> drop restore point RP1; SQL> alter database flashback off;

 

Step 6: Disable below flashback destination parameters. SQL> alter system set db_recovery_file_dest=''; SQL> alter system set db_recovery_file_dest_size=1m;

 

Step 7: Now convert the primary database into physical standby. SQL> alter database convert to physical standby;

 

Step 8: Now shut down the database and mount the newly converted physical standby database. Also start media recovery. SQL> shut immediate;  SQL> startup nomount;  SQL> alter database mount standby database;  SQL> alter database recover managed standby database disconnect from session;

 

Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !