Skip to Main Content

Oracle Database Discussions

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!

Dataguard Issues

494959Oct 27 2010
OS :Windows 2003
DB version:10.2.0.4.0- primary
DB version:10.2.0.4.0- Physical stand by



when I configuring the data guard , getting the below error.

Can you please suugest me ?

DGMGRL> show database tan statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
tan ERROR ORA-16737: the redo transport service for standby database "venus" has an error
tan WARNING ORA-16714: the value of property StandbyFileManagement is inconsistent with the database setting
tan WARNING ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
tan WARNING ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting

DGMGRL> show database venus statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
* ERROR ORA-16816: incorrect database role
* ERROR ORA-16700: the standby database has diverged from the primary database
venus WARNING ORA-16714: the value of property StandbyFileManagement is inconsistent with the database setting
venus WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
venus WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
venus WARNING ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
venus WARNING ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
venus WARNING ORA-16714: the value of property LogArchiveTrace is inconsistent with the database setting
venus WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting
* ERROR ORA-16766: Redo Apply unexpectedly offline
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2010
Added on Oct 27 2010
0 comments
420 views