This is the current configurtion
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
here apply instance is currently TROY2. We will change it to TROY1
DGMGRL> show database 'TROY'
Database - TROY
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
TROY1
TROY2 (apply instance)
Database Status:
SUCCESS
set redo apply off and then edit the instance
DGMGRL> edit database 'TROY' set state='apply-off';
Succeeded.
DGMGRL> show database 'TROY'
Database - TROY
Role: PHYSICAL STANDBY
Intended State: APPLY-OFF
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
TROY1
TROY2 (apply instance)
Database Status:
SUCCESS
DGMGRL> edit database 'TROY' set state='apply-on' with apply instance ='TROY1';
Succeeded.
now verify
DGMGRL> show database 'TROY'
Database - TROY
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: ON
Instance(s):
TROY1 (apply instance)
TROY2
Database Status:
SUCCESS
DGMGRL> show configuration
Configuration - broker_config
Protection Mode: MaxPerformance
Databases:
TROY_DR - Primary database
TROY - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS