<<Back to Oracle DataGuard Main Page
Changing apply instance using dgmgrl in oracle RAC dataguard configuration
Find the current apply instanceDGMGRL> show configuration
Configuration - TSTDB1P_DG
Protection Mode: MaxPerformance
Members:
TSTDB2P - Primary database
TSTDB1P - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 6 seconds ago)
DGMGRL> show database 'TSTDB1P';
Database - TSTDB1P
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: 38.00 KByte/s
Real Time Query: OFF
Instance(s):
TSTDB1P1 (apply instance) <= This is the current apply instance
TSTDB1P2
TSTDB1P3
Database Status:
SUCCESS
Stop redo apply
DGMGRL> edit database 'TSTDB1P' set state='apply-off';
Succeeded.
Start apply process at desired instance
DGMGRL> edit database 'TSTDB1P' set state='apply-on' with apply instance ='TSTDB1P2';
Succeeded.
Verify the apply process running at desired instance
DGMGRL> show database 'TSTDB1P';
Database - TSTDB1P
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: 372.00 KByte/s
Real Time Query: OFF
Instance(s):
TSTDB1P1
TSTDB1P2 (apply instance)<= This is now the current apply instance
TSTDB1P3
Database Status:
SUCCESS
Comments
Post a Comment