DGMGRL> show configuration
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
DGMGRL> show database ‘PRIMARY’ InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
swx2 ArchiveLagTarget 0 0
swx2 LogArchiveMaxProcesses 4 4
swx2 LogArchiveMinSucceedDest 1 1
SOLUTION :
—————–
FROM SQLPLUS SET THE PARAMETERS AND UPDATE IN SPFILE AND MEMORY
SQL> alter system set log_archive_max_processes=4 scope=both sid=’*’;
SQL> alter system set archive_lag_target=0 scope=both sid=’*’;
SQL> alter system set log_archive_min_succeed_dest=1 scope=both sid=’*’;
One comment
Thank you very much, Mr. Shadab for providing a solution for a problem I was facing with one of my standby databases in multiple standby Data Guard setup. This set was also successful with your invaluable assistance in the past.
Now, dg broker configuration is showing success for both of standby databases.
Thanks and regards
Mohammad Ahsan