High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Strange finding in a data guard alert log

I have created a dataguard configuration between two databases, primary and standby. Then I switched over from standby to primary and then back. So Now DB1 is primary and DB2 is a standby. At least that's what I see if I check the database_role of each database. Meanwhile the dataguard alert log shows DB2 as primary and DB1 as standby. The entry in the log looks like this:

Data Guard Broker Status Summary:
  Type                        Name                             Severity  Status
  Configuration               DB1_DG                         Warning  ORA-16607
  Primary Database           DB2                             Error  ORA-16825
  Physical Standby Database   DB1                            Warning  ORA-16631

I know Warning ORA-16607 means one or more databases have failed, Error:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center