Handy Oracle Data guard Broker Commands Part-II

Following command will validate the configuration of the specified database.

DGMGRL> validate database 'db_name'; DGMGRL> validate database proddr;     Database Role:     Physical standby database   Primary Database:  prod     Ready for Switchover:  Yes   Ready for Failover:    Yes (Primary Running)     Flashback Database Status:     prod  :  On     proddr:  Off     Managed by Clusterware:     prod  :  NO     proddr:  NO     Validating static connect identifier for the primary database prod...     The static connect identifier allows for a connection to database "prod".   DGMGRL>

 

 

Following command will display the current Fast-Start Failover configuration.

DGMGRL> show fast_start failover   Fast-Start Failover:  Disabled     Protection Mode:    MaxPerformance   Lag Limit:          30 seconds     Threshold:          30 seconds   Active Target:      (none)   Potential Targets:  (none)   Observer:           (none)   Shutdown Primary:   TRUE   Auto-reinstate:     TRUE   Observer Reconnect: (none)   Observer Override:  FALSE   Configurable Failover Conditions   Health Conditions:     Corrupted Controlfile          YES     Corrupted Dictionary           YES     Inaccessible Logfile            NO     Stuck Archiver                  NO     Datafile Write Errors          YES     Oracle Error Conditions:     (none)

 

 

The following command is used to convert database to snapshot standby.

DGMGRL> convert database 'db_name' to snapshot standby; DGMGRL> convert database sbdb to Snapshot standby; Converting database "sbdb" to a Snapshot Standby database, please wait... Database "sbdb" converted successfully

 

The following command is used to convert database to physical standby.

DGMGRL> convert database 'db_name' to physical standby;   DGMGRL> convert database sbdb to Physical standby; Converting database "sbdb" to a Physical Standby database, please wait... Operation requires shut down of instance "PROD" on database "sbdb" Shutting down instance "PROD"... Connected to "SBDB" Database closed. Database dismounted. ORACLE instance shut down. Operation requires start up of instance "PROD" on database "sbdb" Starting instance "PROD"... Connected to an idle instance. ORACLE instance started. Connected to "SBDB" Database mounted. Connected to "SBDB" Database "sbdb" converted successfully

 

The following command validates static connect identifier for given db_name

DGMGRL> VALIDATE STATIC CONNECT IDENTIFIER FOR SBDB; Oracle Clusterware is not configured on database "sbdb". Connecting to database "sbdb" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=az-psdb1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SBDB_DGMGRL)(INSTANCE_NAME=PROD)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ... Succeeded. The static connect identifier allows for a connection to database "sbdb".   DGMGRL>

 

Execute sql statement from DGMGRL prompt. Select command doesn’t work from this prompt.

 

DGMGRL> sql "alter system switch logfile" Succeeded. DGMGRL>