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.
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;
Thank you for your comment !