Handy Oracle Data guard Broker Commands Part-I

 

Handy Oracle Data guard Broker Commands: -

Here,

Primary database is : ORCL

Standby Database is : ORCLDR

Login DGMGRL utility

dgmgrl / [Here connection happens through os authentication] or dgmgrl sys/<sys_password>@<connect dentifier>

 

To check current status and configuration

DGMGRL> show configuration;   Configuration - my_dg_config     Protection Mode: MaxPerformance   Members:   orcl   - Primary database     orcldr - Physical standby database   Fast-Start Failover:  Disabled   Configuration Status: SUCCESS   (status updated 16 seconds ago)

 

To Display information of members under Dataguard configuration

DGMGRL> show database orcl   Database - orcl     Role:               PRIMARY   Intended State:     TRANSPORT-ON   Instance(s):     orcl   Database Status: SUCCESS   DGMGRL> show database orcldr   Database - orcldr     Role:               PHYSICAL STANDBY   Intended State:     APPLY-ON   Transport Lag:      0 seconds (computed 0 seconds ago)   Apply Lag:          0 seconds (computed 0 seconds ago)   Average Apply Rate: 30.00 KByte/s   Real Time Query:    OFF   Instance(s):     orcl   Database Status: SUCCESS

 

 

Performing a Switchover using dataguard broker

DGMGRL> switchover to orcldr; Performing switchover NOW, please wait... Operation requires a connection to database "orcldr" Connecting ... Connected to "ORCLDR" Connected as SYSDBA. New primary database "orcldr" is opening... Operation requires start up of instance "orcl" on database "orcl" Starting instance "orcl"... Connected to an idle instance. ORACLE instance started. Connected to "orcl" Database mounted. Switchover succeeded, new primary is "orcldr"

 

 

To Display detailed information of configuration

DGMGRL> show configuration verbose   Configuration - my_dg_config     Protection Mode: MaxPerformance   Members:   orcl   - Primary database     orcldr - Physical standby database     Properties:     FastStartFailoverThreshold      = '30'     OperationTimeout                = '30'     TraceLevel                      = 'USER'     FastStartFailoverLagLimit       = '30'     CommunicationTimeout            = '180'     ObserverReconnect               = '0'     FastStartFailoverAutoReinstate  = 'TRUE'     FastStartFailoverPmyShutdown    = 'TRUE'     BystandersFollowRoleChange      = 'ALL'     ObserverOverride                = 'FALSE'     ExternalDestination1            = ''     ExternalDestination2            = ''     PrimaryLostWriteAction          = 'CONTINUE'     ConfigurationWideServiceName    = 'orcl_CFG'   Fast-Start Failover:  Disabled   Configuration Status: SUCCESS

 

 

To Display properties and a brief information of the database

DGMGRL> show database verbose orcldr   Database - orcldr     Role:               PHYSICAL STANDBY   Intended State:     APPLY-ON   Transport Lag:      0 seconds (computed 1 second ago)   Apply Lag:          0 seconds (computed 1 second ago)   Average Apply Rate: 23.00 KByte/s   Active Apply Rate:  765.00 KByte/s   Maximum Apply Rate: 2.26 MByte/s   Real Time Query:    OFF   Instance(s):     orcl     Properties:     DGConnectIdentifier             = 'orcldr'     ObserverConnectIdentifier       = ''     FastStartFailoverTarget         = ''     PreferredObserverHosts          = ''     LogShipping                     = 'ON'     RedoRoutes                      = ''     LogXptMode                      = 'ASYNC'     DelayMins                       = '0'     Binding                         = 'optional'     MaxFailure                      = '0'     ReopenSecs                      = '300'     NetTimeout                      = '30'     RedoCompression                 = 'DISABLE'     PreferredApplyInstance          = ''     ApplyInstanceTimeout            = '0'     ApplyLagThreshold               = '30'     TransportLagThreshold           = '30'     TransportDisconnectedThreshold  = '30'     ApplyParallel                   = 'AUTO'     ApplyInstances                  = '0'     StandbyFileManagement           = ''     ArchiveLagTarget                = '0'     LogArchiveMaxProcesses          = '0'     LogArchiveMinSucceedDest        = '0'     DataGuardSyncLatency            = '0'     LogArchiveTrace                 = '0'     LogArchiveFormat                = ''     DbFileNameConvert               = ''     LogFileNameConvert              = ''     ArchiveLocation                 = ''     AlternateLocation               = ''     StandbyArchiveLocation          = ''     StandbyAlternateLocation        = ''     InconsistentProperties          = '(monitor)'     InconsistentLogXptProps         = '(monitor)'     LogXptStatus                    = '(monitor)'     SendQEntries                    = '(monitor)'     RecvQEntries                    = '(monitor)'     HostName                        = 'EGC-MUN-STBY-PH'     StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCLDR_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'     TopWaitEvents                   = '(monitor)'     SidName                         = '(monitor)'     Log file locations:     Alert log               : D:\ORACLE\diag\rdbms\orcldr\orcl\trace\alert_orcl.log     Data Guard Broker log   : D:\ORACLE\diag\rdbms\orcldr\orcl\trace\drcorcl.log   Database Status: SUCCESS