Connection to physical standby database keeps failing
edited Nov 22, 2013 10:50AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 10 commentsAnswered
My system info:
Oracle 10G running in Windows 2003 server.
DGMGRL for 32-bit Windows: Version 10.2.0.3.0 - Production
This DataGuard configuration has been running for years. The logs in the primary are still transported successfully to the standby server, but I got this error message below
Current status for "DGSFCPICIS":
Warning: ORA-16607: one or more databases have failed
I tried to enable the physical standby database 'STDBYSFC'. It was a successful enabling:
DGMGRL> enable database 'STDBYSFC';
Enabled.
The result looked good again after that:
DGMGRL> show configuration;
Configuration
Name: DGSFCPICIS
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
SFCPICIS - Primary database
0