Mani's Blog

September 20, 2012

ORA-16792: configurable property value is inconsistent with database setting

I have DG broker configured on stand-alone database servers (primary and standby).  After I migrated standby database to new ASM diskgroup I ran into issue “Warning: ORA-16608: one or more databases have warnings” and “ORA-16792: configurable property value is inconsistent with database setting”

Restarting the Data guard broker fixed the issue.

DGMGRL> show configuration

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-16608: one or more databases have warnings

DGMGRL> show database xnodbcnt

Database
Name:            xnodbcnt
Role:            PHYSICAL STANDBY
Enabled:         YES
Intended State:  APPLY-ON
Instance(s):
XNODBCNT

Current status for “xnodbcnt”:
Warning: ORA-16792: configurable property value is inconsistent with database setting

I just restarted as below.

 

SQL> alter system set dg_broker_start=false scope=both;

System altered.

SQL> alter system set dg_broker_start=true scope=both;

System altered.

SQL>

Then the issue is gone.

 

DGMGRL> show database xnodbcnt

Database
Name:            xnodbcnt
Role:            PHYSICAL STANDBY
Enabled:         YES
Intended State:  APPLY-ON
Instance(s):
XNODBCNT

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