Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-16628: the broker protection mode is inconsistent with the database setting

Posted by Hendry chinnapparaj on May 24, 2010

Problem and Diagnosis

————————–

ORA-16628: the broker protection mode is inconsistent with the database setting

DGMGRL> show configuration;

Configuration

Name:                cpstest_dgb

Enabled:             YES

Protection Mode:     MaxPerformance

Fast-Start Failover: DISABLED

Databases:

cpstest_j – Physical standby database

cpstest_f – Primary database

Current status for “cpstest_dgb”:

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

Cd /u01/oracle/product/10.2.0/db_1/admin/cpstest/bdump

Cat drccpstest.log

DG 2010-05-24-10:13:03        0 2 719363232 Operation CTL_GET_STATUS cancelled during phase 2, error = ORA-16628

DG 2010-05-24-10:14:03        0 2 0 RSM Error: protection mode ‘MaxPerformance’ set in Broker metadata is inconsistent with the actual protection mode ‘MAXIMUM AVAILABILITY’ currently set in database

DG 2010-05-24-10:14:03        0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16628: the broker protection mode is inconsistent with the database setting

DGMGRL> show database verbose cpstest_f

Database

Name:            cpstest_f

Current status for “cpstest_f”:

Error: ORA-16628: the broker protection mode is inconsistent with the database setting

Cause

——–

You have changed the protection_mode to maximum availability in the database using Sql, but not in the data guard broker

Solution

———–

DGMGRL> Edit configuration set protection mode as maxavailability;

Succeeded.

DGMGRL> show configuration;

Configuration

Name:                cpstest_dgb

Enabled:             YES

Protection Mode:     MaxAvailability

Fast-Start Failover: DISABLED

Databases:

cpstest_j – Physical standby database

cpstest_f – Primary database

Current status for “cpstest_dgb”:

SUCCESS

This gets replicated to standby database as well

Advertisements

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

 
%d bloggers like this: