dgmgrl:show configuration not stable---sometimes good, sometimes error
9233598Aug 15 2012 — edited Aug 16 2012we have a test environment has some issues, but I not sure which issues are they.
OS: linux redhat 5
db: 11gr2
2 RAC nodes primary with 2 rac nodes standby
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
dwstst - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
Warning: ORA-16829: fast-start failover configuration is lagging
dwstst - (*) Physical standby database
Warning: ORA-16829: fast-start failover configuration is lagging
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
Warning: ORA-16829: fast-start failover configuration is lagging
dwstst - (*) Physical standby database
Warning: ORA-16829: fast-start failover configuration is lagging
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
Warning: ORA-16829: fast-start failover configuration is lagging
dwstst - (*) Physical standby database
Warning: ORA-16829: fast-start failover configuration is lagging
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
dwstst - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
dwstst - (*) Physical standby database
Error: ORA-16810: multiple errors or warnings detected for the database
Fast-Start Failover: ENABLED
Configuration Status:
ERROR
DGMGRL> show configuration
Configuration - dwtst_dg
Protection Mode: MaxPerformance
Databases:
dwtst - Primary database
dwstst - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
I got those by query database:
Error 16198
WARN: ARC3: Terminating pid 23729 hung on an I/O operation
15-AUG-2012 00:52:02
Error 16198
ARC3: Error 16198 due to hung I/O operation to LOG_ARCHIVE_DEST_2
SEVERITY ERROR_CODE
------------- ----------
MESSAGE
--------------------------------------------------------------------------------
TO_CHAR(TIMESTAMP,'DD-MON-
--------------------------
15-AUG-2012 00:52:04
Error 16198
WARN: ARC1: Terminating pid 29931 hung on an I/O operation
15-AUG-2012 05:45:22
Error 16198
SEVERITY ERROR_CODE
------------- ----------
MESSAGE
--------------------------------------------------------------------------------
TO_CHAR(TIMESTAMP,'DD-MON-
--------------------------
ARC1: Error 16198 due to hung I/O operation to LOG_ARCHIVE_DEST_2
15-AUG-2012 05:45:25
69 rows selected.
I think something is really wrong with the database. However seems standby is in sync with primary.
Any help here? Thanks.