ORA-16607: one or more databases have failed

DGMGRL> connect sys@db1db
Password:
Connected.
DGMGRL>
DGMGRL> show configuration

Configuration
  Name:                db1db
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: DISABLED
  Databases:
    dg1db - Physical standby database
    db1db  - Primary database

Current status for "db1db":
Warning: ORA-16607: one or more databases have failed

Reason:

Data Guard broker detected a failure for one or more databases in the Data Guard configuration.

Workaround:

Shutdown standby database, recreate SPFILE and mount standby database again.


SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initdg1db.ora';

File created.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  536870912 bytes

Fixed Size                  1220460 bytes

Variable Size             155189396 bytes

Database Buffers          377487360 bytes

Redo Buffers                2973696 bytes

SQL> alter database mount standby database;

Database altered.

DGMGRL> show configuration;

Configuration
  Name:                db1db
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: DISABLED
  Databases:
    dg1db  - Physical standby database
    db1db  - Primary database

Current status for "db1db":
SUCCESS