176
ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
On Primary
[oracle@rac1 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - DELL
Protection Mode: MaxPerformance
Databases:
DELL - Primary database
DELL_DG - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with database setting
Fast-Start Failover: DISABLED
Configuration Status:
WARNING <------------
DGMGRL>
DGMGRL> SHOW CONFIGURATION VERBOSE;
Configuration - DELL
Protection Mode: MaxPerformance
Databases:
DELL - Primary database
DELL_DG - Physical standby database
Warning: ORA-16792: configurable property value is inconsistent with database setting
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
WARNING
DGMGRL>
DGMGRL> show database "DELL" statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
DGMGRL> show database "DELL_DG" statusreport
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
DELL_DG WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
DELL_DG WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
DELL_DG WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
DGMGRL>
DGMGRL> show database "DELL_DG" InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
DELL_DG ArchiveLagTarget 0 0
DELL_DG LogArchiveMaxProcesses 4 4
DELL_DG LogArchiveMinSucceedDest 1 1
Solution:
On Standby
SQL> select name,open_mode,db_unique_name,database_role from v$database;
NAME OPEN_MODE DB_UNIQUE_NAME DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
DELL MOUNTED DELL_DG PHYSICAL STANDBY
SQL>
SQL> alter system set log_archive_max_processes=4 scope=both;
System altered.
SQL> alter system set archive_lag_target=0 scope=both;
System altered.
SQL> alter system set log_archive_min_succeed_dest=1 scope=both;
System altered.