Warning: ORA-16792: configurable property value is inconsistent with member setting

OS환경 : Oracle Linux 6.8 (64bit)

DB 환경 : Oracle Database 12.2.0.1

에러 : Warning: ORA-16792: configurable property value is inconsistent with member setting

DGMGRL> show configuration
 
Configuration - adg1
 
  Protection Mode: MaxPerformance
  Members:
  adg1 - Primary database
    adg2 - Physical standby database 
      Warning: ORA-16792: configurable property value is inconsistent with member setting
 
Fast-Start Failover: DISABLED
 
Configuration Status:
WARNING   (status updated 20 seconds ago)

2번 노드 속성값에 불일치가 존재함

해결 방법 : show instance verbose로 원인 확인 후 파라미터값 변경

show instance verbose 로 확인

$ dgmgrl sys/oracle
DGMGRL> show instance verbose adg2
 
Instance 'adg2' of database 'adg2'
 
  Host Name: adg2
  PFILE:     
  Properties:
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adg2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=adg2_DGMGRL)(INSTANCE_NAME=adg2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/app/oracle/adg2/archive'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'
 
  Instance Warning(s):
    ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting
    ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting
    ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting
    ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting
 
  Log file locations:
    Alert log               : /app/oracle/diag/rdbms/adg2/adg2/trace/alert_adg2.log
    Data Guard Broker log   : /app/oracle/diag/rdbms/adg2/adg2/trace/drcadg2.log
 
Instance Status:
WARNING

4가지 파라미터에 대해 문제가 발생함

불일치한 파라미터 확인

$ dgmgrl sys/oracle
DGMGRL> show database 'adg2' InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE 
          adg2       ArchiveLagTarget            0                                         0
          adg2     LogArchiveMaxProcesses        4                                         4
          adg2     LogArchiveMinSucceedDest      1                                         1
          adg2     DataGuardSyncLatency          0                                         0

모두 memory와 broker에는 값이 있지만 spfile에는 값이 없음

spfile 변경

SQL> alter system set archive_lag_target=0 scope=both;
 
System altered.
 
SQL> alter system set log_archive_max_processes=4 scope=both;
 
System altered.
 
SQL> alter system set log_archive_min_succeed_dest=1 scope=both;
 
System altered.
 
SQL> alter system set data_guard_sync_latency=0 scope=both;
 
System altered.

브로커 configuration 값 재확인

DGMGRL> show configuration
 
Configuration - adg1
 
  Protection Mode: MaxPerformance
  Members:
  adg1 - Primary database
    adg2 - Physical standby database 
 
Fast-Start Failover: DISABLED
 
Configuration Status:
SUCCESS   (status updated 35 seconds ago)

정상

원인 : 브로커와 spfile의 불일치한 파라미터 값

브로커와 spfile의 불일치한 파라미터 값

참조 : http://positivemh.tistory.com/236

https://positivemh.tistory.com/680

https://positivemh.tistory.com/674