Mani's Blog

September 17, 2012

Warning: ORA-16607: one or more databases have failed Error: ORA-16816: incorrect database role

Filed under: Data Guard Broker,Database,Dataguard,Oracle — mani @ 10:01 pm
Tags:

I have Data guard broker configured on my Primary and Standby database servers.  For some reason we had to failover using SQL commnad (didn’t use DG manager).  Later on dgmgrl shows errors as below.

DGMGRL> show configuration

Configuration
Name:                CONTACT
Enabled:             YES
Protection Mode:     MaxPerformance
Databases:
XNODBCNT   – Primary database
XNODBCNTDG – Physical standby database

Fast-Start Failover: DISABLED

Current status for “CONTACT”:
Warning: ORA-16607: one or more databases have failed

DGMGRL> show database ‘XNODBCNT’

Database
Name:            XNODBCNT
Role:            PRIMARY
Enabled:         YES
Intended State:  TRANSPORT-ON
Instance(s):
XNODBCNT

Current status for “XNODBCNT”:
Error: ORA-16816: incorrect database role

Solution: I tried many thing like enabling/disabling configuration, database and other nothing helped,  I had reconfigure it again as below to make DG broker to work properly.

DGMGRL> create configuration CONTACT as primary database is XNODBCNTDG connect identifier is xnodbcntdg;
Configuration “contact” created with primary database “xnodbcntdg”
DGMGRL> add database XNODBCNT as connect identifier is xnodbcnt maintained as physical;
Database “xnodbcnt” added
DGMGRL> show configuration;

Configuration
Name:                contact
Enabled:             NO
Protection Mode:     MaxPerformance
Databases:
xnodbcntdg – Primary database
xnodbcnt   – Physical standby database

Fast-Start Failover: DISABLED

Current status for “contact”:
DISABLED

DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration verbose

Configuration
Name:                contact
Enabled:             YES
Protection Mode:     MaxPerformance
Databases:
xnodbcntdg – Primary database
xnodbcnt   – Physical standby database

Fast-Start Failover: DISABLED

Current status for “contact”:
Warning: ORA-16610: command “EDIT DATABASE xnodbcnt SET PROPERTY” in progress

DGMGRL> show configuration verbose

Configuration
Name:                contact
Enabled:             YES
Protection Mode:     MaxPerformance
Databases:
xnodbcntdg – Primary database
xnodbcnt   – Physical standby database

Fast-Start Failover: DISABLED

Current status for “contact”:
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

Blog at WordPress.com.

%d bloggers like this: