- ANKUSH THAVALI
- 03 Dec, 2023
- 0 Comments
- 2 Mins Read
Dataguard Switchover Using DGMGRL Utility
Step1 :- Check the Primary Database
DGMGRL> SHOW DATABASE VERBOSE 'prim'; Database - prim Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): prim Properties: DGConnectIdentifier = 'prim' 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 = 'test.learnomate.org' StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.learnomate.org)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prim_DGMGRL)(INSTANCE_NAME=prim)(SERVER=DEDICATED)))' TopWaitEvents = '(monitor)' SidName = '(monitor)' Log file locations: Alert log : /data/app/oracle/diag/rdbms/prim/prim/trace/alert_prim.log Data Guard Broker log : /data/app/oracle/diag/rdbms/prim/prim/trace/drcprim.log Database Status: SUCCESS
Step2 :- Check the Standby Database That is the Target of the Switchover
DGMGRL> SHOW DATABASE 'stand'; Database - stand Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 0 seconds ago) Apply Lag: 0 seconds (computed 1 second ago) Average Apply Rate: 0 Byte/s Real Time Query: OFF Instance(s): stand Database Status: SUCCESS
Step3 :- Confirm That the Database Is Ready for a Role Change
DGMGRL> VALIDATE DATABASE 'prim'; Database Role: Primary database Ready for Switchover: Yes Flashback Database Status: prim: Off Managed by Clusterware: prim: NO Validating static connect identifier for the primary database prim... The static connect identifier allows for a connection to database "prim". DGMGRL> VALIDATE DATABASE 'stand'; Database Role: Physical standby database Primary Database: prim Ready for Switchover: Yes Ready for Failover: Yes (Primary Running) Flashback Database Status: prim : Off stand: Off
Step4 :- Issue the Switchover Command
DGMGRL> switchover to 'stand'; Performing switchover NOW, please wait... Operation requires a connection to database "stand" Connecting ... Connected to "stand" Connected as SYSDBA. New primary database "stand" is opening... Operation requires start up of instance "prim" on database "prim" Starting instance "prim"... Connected to an idle instance. ORACLE instance started. Connected to "prim" Database mounted. Connected to "prim" Switchover succeeded, new primary is "stand"
Step5 :- Show the Configuration
DGMGRL> show configuration Configuration - prim Protection Mode: MaxPerformance Members: stand - Primary database prim - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 12 seconds ago)