DATA - GUARD Trouble Shooting (Warning: ORA-16608: one or more databases have warnings)

Warning: ORA-16608: one or more databases have warnings

DGMGRL> show configuration

Configuration

  Name:                FDSS_PRDB

  Enabled:             YES

  Protection Mode:     MaxPerformance

  Fast-Start Failover: DISABLED

  Databases:

    FDSS_PRDB - Primary database

    FDSS_DRDB - Physical standby database

Current status for "FDSS_PRDB":

Warning: ORA-16608: one or more databases have warnings

DR TROUBLESHOOTING

1. select group#,thread#,archived from v$log;

1. DGMGRL> SHOW DATABASE 'FDCORE_DRDB' StatusReport;

STATUS REPORT

       INSTANCE_NAME   SEVERITY ERROR_TEXT

                   *    WARNING ORA-16826: apply service state is inconsistent with the DelayMins property

1. DGMGRL> SHOW DATABASE 'FDCORE_PRDB' StatusReport;

STATUS REPORT

       INSTANCE_NAME   SEVERITY ERROR_TEXT

1. THE SOLUTION IS TO DISABLE AND ENABLE THE CONFIGURATION

http://things2notefor.wordpress.com/2009/08/04/ora-16826-apply-service-state-is-inconsistent-with-the-delaymins-property/