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
0 Comments