How to open Physical Standby Database in Read-Write Mode

 

Step 1: First determine below few things before going ahead (If created already). Ensure your database is in archivelog mode. Check flashback is enabled in the database. Ensure that guaranteed restore point is created.

 

Step 2: Note guaranteed restore point details(If created already). SQL> select name,open_mode,log_mode,flashback_on,database_role,controlfile_type from v$database; SQL> select name from v$restore_point;

 

Step 3: Defer the destination in primary database. SQL> alter system set log_archive_dest_state_2=defer;

 

Step 4: Cancel the Media Recovery process. SQL> alter database recover managed standby database cancel;

  

Step 5: Set below flashback parameters. SQL> alter system set db_recovery_file_dest_size=50G; SQL> alter system set db_recovery_file_dest='/u01/flashback/';

Step 6: Enable flashback feature in the database and create guaranteed restore point. SQL> alter database flashback on; SQL> create restore point RP1 guarantee flashback database;

Step 7: Activate the standby database to open it in read-write mode.

SQL> alter database activate standby database; 

Step 8: Set the database mode to maximum performance and open the database. SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE; SQL> alter database open;

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