### On Primary: (before simulation)
SQL> select name, switchover_status,flashback_on from v$database;
SQL> alter system archive log current;
------------------------------------------------------------
### On Standby: (before simulation)
SQL> SET NUMFORMAT 999999999999999999
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> select name, time, scn from v$restore_point;
SQL> CREATE RESTORE POINT BEFORE_SIMULATION GUARANTEE FLASHBACK DATABASE;
SQL> select name, time, scn from v$restore_point;
SQL> STARTUP MOUNT FORCE;
SQL> col space_limit for 999999999999999999999
SQL> col space_used for 999999999999999999999
SQL> select space_limit/1024/1024/1024 avail_GB, space_used/1024/1024/1024 Used_GB from v$recovery_file_dest;
SQL> col name for a20
SQL> col time for 999999999999999999999999999999
SQL> col time for a35
SQL> select name, time, scn from v$restore_point;
?SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
(if recovery needs to continue)
------------------------------------------------------------
### On Standby: (DR simulation invoked..)
?SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
(if recovery needs to be cancelled)
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
SQL> STARTUP MOUNT FORCE;
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
SQL> ALTER DATABASE OPEN;
SQL> select open_mode, database_role from v$database;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;
SQL> select scn_to_timestamp(STANDBY_BECAME_PRIMARY_SCN) from v$database;
------------------------------------------------------------
### On Primary:
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;
### Handover to application team for testing DR Standby....
------------------------------------------------------------
### On Standby: (after bcp test - recovery / rollback)
SQL> select current_scn, standby_became_primary_scn from v$database;
CURRENT_SCN STANDBY_BECAME_PRIMARY_SCN
------------------- --------------------------
13223120496345 13222215208347
SQL> STARTUP MOUNT FORCE;
SQL> select name, time, scn from v$restore_point;
SQL> FLASHBACK DATABASE TO RESTORE POINT BEFORE_SIMULATION;
SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
SQL> STARTUP MOUNT FORCE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
SQL> drop restore point before_simulation;
------------------------------------------------------------
### On Primary: (after bcp test - recovery / rollback)
SQL> alter system set log_archive_dest_state_2=enable;
SQL> alter system switch logfile;
------------------------------------------------------------
### make sure restore point is dropped..!
END.
