Mani's Blog

June 22, 2012

Warning: ORA-16607: one or more databases have failed

Filed under: Dataguard,Oracle — mani @ 12:15 am

After the Switchover, you may get a warning “ORA-16607: one or more databases have failed”.   It obviously means you new to restart the new standby database.

1. Display the configuration.

DGMGRL> show configuration verbose
Configuration
  Name:                PRETZEL
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Databases:
    XNOPRTZ   - Primary database
    XNOPRTZDG - Physical standby database
Fast-Start Failover: DISABLED
Current status for "PRETZEL":
Warning: ORA-16607: one or more databases have failed
DGMGRL>
2. Restart the database.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.6724E+10 bytes
Fixed Size          2160272 bytes
Variable Size        1.1543E+10 bytes
Database Buffers     1.5032E+10 bytes
Redo Buffers          146423808 bytes
Database mounted.
SQL>
3. Start the apply process.  Apply command may change based on type of standby.  This is applicable to active Dataguard.
SQL> alter database recover managed standby database cancel;
 
Database altered.
 
SQL> ALTER DATABASE OPEN READ ONLY;
 
Database altered.
 
SQL> alter database recover managed standby database using current logfile disconnect;
 
Database altered.
 
SQL>
4.  Display the config status, make sure the Warning message is gone.
DGMGRL> show configuration verbose
Configuration
  Name:                PRETZEL
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Databases:
    XNOPRTZ   - Primary database
    XNOPRTZDG - Physical standby database
Fast-Start Failover: DISABLED
Current status for "PRETZEL":
SUCCESS
DGMGRL>
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: