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:
To 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;
Comments
Post a Comment