<<Back to Oracle DataGuard Main Page
To use sqlplus instead broker follow the steps on this blog
HOW TO CONVERT PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE USING SQLPLUS
HOW TO CONVERT PHYSICAL STANDBY DATABASE TO SNAPSHOT STANDBY DATABASE USING DGMGRL- Dataguard Broker Utility
Current Configuration
Primary DB: ORCL1PP
Standby DB: ORCL1PS
dgmgrl sys/xxxxx@ORCL1PP.ORACLE.COM
Disable Fast Start Failover if enabled
DGMGRL> DISABLE FAST_START FAILOVER;
Change to maximum performance:
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;
Convert to snapshot standby
DGMGRL> CONVERT DATABASE ORCL1PS TO SNAPSHOT STANDBY;
CONVERING BACK THE SNAPSHOT STANDBY TO PHYSICAL STANDBY USING DGMGRL- Dataguard Broker Utility
Connect to primary database over listener
dgmgrl sys/xxxxx@ORCL1PP.ORACLE.COM
Convert to standby
DGMGRL> CONVERT DATABASE ORCL1PS TO PHYSICAL STANDBY;
Change back to maximum availability and enable FSFO if required
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
DGMGRL> ENABLE FAST_START FAILOVER;
Related Posts:
Comments
Post a Comment