On short, after upgrading one of my databases from 11203 to 11204, I’ve noticed that the standby database was in a DISABLED state:
DGMGRL> show configuration Configuration - DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI- Primary database DB_STANDBY - Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS
I tried to set it to ENABLED state like this:
DGMGRL> enable database 'DB_STANDBY' Error: ORA-16631: operation requires shutdown of database or instance "" Failed. DGMGRL> exit
To fix this, I’ve found the following document on Metalink:
DGMGRL> show configuration Configuration - DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI - Primary database DB_STANDBY - Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL> edit database 'DB_STANDBY' set state='ONLINE'; Error: ORA-16635: network connection failed during transmission Failed. DGMGRL> show configuration Configuration - DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI - Primary database DB_STANDBY - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL>
Advertisements
