Time for action – disabling and enabling database
Follow these steps to test disabling and enabling the standby database:
Check the status of the standby database as follows:
DGMGRL> show database 'INDIA_UN'; Database - INDIA_UN Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds Apply Lag: 0 seconds Real Time Query: ON Instance(s): INDIA Database Status: SUCCESS
Disable the database from the configuration as follows:
DGMGRL> disable database 'INDIA_UN'; Disabled.
Check the database status after disabling it from the configuration as follows:
DGMGRL> show database 'INDIA_UN'; Database - INDIA_UN Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: (unknown) Apply Lag: (unknown) Real Time Query: OFF Instance(s): INDIA Database Status: DISABLED
Physical standby information still exists in the configuration, but the database will be in a
DISABLED
state and won't be monitored by the...