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';
For example, the inconsistent is this parameter log_archive_trace
Either change the value using sqlplus or DGMGRL to make it consistent.
or
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;
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?
ReplyDeleteexcellent tip!
ReplyDeleteThanks - Great tip and solved the issue we're having !
ReplyDelete