CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE USING BROKER DGMGRL



CONVERTING PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE


         Using Datagurad Broker DGMGRL to Convert Physical Standby to Snapshot Standby 




Connect to primary database  over listener
dgmgrl sys/xxxxx@PRIMARY.ORACLE.COM


Disable Fast Start Failover
DGMGRL> DISABLE FAST_START FAILOVER;


Change to maximum performance:
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

Convert to snapshot standby
DGMGRL> CONVERT DATABASE STANDBY TO SNAPSHOT STANDBY;



Convert back to Physical standby.
dgmgrl sys/xxxxx@PRIMARY.ORACLE.COM

DGMGRL> CONVERT DATABASE STANDBY TO PHYSICAL STANDBY;


Change back to maximum availability and enable FSFO

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

DGMGRL> ENABLE FAST_START FAILOVER;

No comments:

Post a Comment