Friday 27 September 2013

Dataguard Issues - How to resolve ORA-16792

If the setting of dataguard related parameter is different between database and the broker, when doing the show configuration within DGMGRL, the following error will appear:
 


DGMGRL> show configuration;

Configuration
Name: DGA24L
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
DGA24L - Primary database
DGA24LPS - Physical standby database

Current status for "DGA24L":
Warning: ORA-16608: one or more databases have warnings


DGMGRL> show database verbose 'DGA24L';

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

Properties:
...


o find out what is the differences, by using this command:
DGMGRL> show database '<db_name>'  'InconsistentProperties';



DGMGRL> show database 'DGA24L' 'InconsistentProperties';
INCONSISTENT PROPERTIES
   INSTANCE_NAME  PROPERTY_NAME    MEMORY_VALUE   SPFILE_VALUE    BROKER_VALUE
          DGA24L  LogArchiveTrace             1            513             513


For example, the inconsistent is this parameter log_archive_trace

Either change the value using sqlplus or DGMGRL to make it consistent.


1. sqlplus / as sysdba
   SQL> alter system set log_archive_trace=513;

or


2. DGMGRL
   DGMGRL> edit database '<db_name>' set property 'LogArchiveTrace'=1;
 

3 comments:

  1. Thank you for this. Do we need to do this on both live and backup box or if I do on live it will feed through to the backup box?

    ReplyDelete
  2. Thanks - Great tip and solved the issue we're having !

    ReplyDelete