Loading....
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
Please follow and like us:

Last Update: June 25, 2009  

June 25, 2009 97 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, , ,

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?