Using FLASHBACK to Reinstate a Standby after a FAILOVER

PERFORM A FAILOVER USING DATA GUARD BROKER

DGMGRL> failover to 'standby_blade07';
Performing failover NOW, please wait...
Failover succeeded, new primary is "standby_blade07"

On the NEW PRIMARY issue this command to obtain the SCN to FLASHBACK the old primary(new standby) to

SQL> conn / as sysdba
Connected.

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

FLASHBACK THE OLD PRIMARY AND CONVERT IT TO A PHYSICAL STANDBY

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  574619648 bytes
Fixed Size                  2022408 bytes
Variable Size             327156728 bytes
Database Buffers          239075328 bytes
Redo Buffers                6365184 bytes
Database mounted.

SQL> FLASHBACK DATABASE TO SCN 2147132;
Flashback complete.

SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
Database altered.

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL>

USING DATA GUARD BROKER REINSTATE THE NEW STANDBY DATABASE INTO THE DATA GUARD CONFIGURATION

DGMGRL> reinstate database 'streams2';Reinstating database "streams2", please wait...
Operation requires shutdown of instance "streams2" on database "streams2"
Shutting down instance "streams2"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "streams2" on database "streams2"
Starting instance "streams2"...
ORACLE instance started.
Database mounted.
Continuing to reinstate database "streams2" ...
Reinstatement of database "streams2" succeeded

DGMGRL> show configuration;
Configuration
  Name:                streams2.hq.emirates.com
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Fast-Start Failover: DISABLED
  Databases:
    streams2        - Physical standby database
    standby_blade07 - Primary database
Current status for "streams2.hq.emirates.com":
SUCCESS