Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Errors setting up DataGuard Broker

h.mehdiMay 8 2010 — edited May 19 2010
Hi,

I'm setting up Data Guard Broker and get these errors, hope you can help.

My Primary (orcl) is in open state and Standby (orcldg) is in open read only state.

I've run these on both of my 2 node primary RAC
dgmgrl
connect sys
create configuration dg_tst as primary database is orcl connect identifier is orcl;
add database orcldg as connect identifier is orcldg maintained as physical;
exit;
Then
enable configuration;
and now get following errors:
DGMGRL> show database orcl;

Database
  Name:            orcl
  Role:            PRIMARY
  Enabled:         YES
  Intended State:  ONLINE
  Instance(s):
    orcl1

Current status for "orcl":
Error: ORA-16810: multiple errors or warnings detected for the database


DGMGRL> show database orcl statusreport;
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT
               orcl1      ERROR ORA-16736: unable to find the destination entry of standby database "orcldg" in V$ARCHIVE_DEST
               orcl1    WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
               orcl1    WARNING ORA-16714: the value of property LogArchiveTrace is inconsistent with the database setting
               orcl1    WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
               orcl2      ERROR ORA-16532: Data Guard broker configuration does not exist

DGMGRL> show database orcl LogXptStatus;
Error: ORA-16777: unable to find the destination entry of a standby database in V$ARCHIVE_DEST

DGMGRL> 
This post has been answered by Anudeep_G on May 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2010
Added on May 8 2010
3 comments
12,461 views