ORA-16714: the value of property 에러

OS환경 : Oracle Linux 6.8 (64bit)

DB 환경 : Oracle Database 11.2.0.4

에러 : ORA-16714: the value of property  에러

dgmgrl 툴에서 show instance verbose 시 나오는 에러 메세지

DGMGRL> show instance verbose adg11gsb
 
Instance 'adg11gsb' of database 'adg11gsb'
 
  Host Name: adg2
  PFILE:     
  Properties:
    SidName                         = 'adg11gsb'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adg2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=adg11gsb_DGMGRL)(INSTANCE_NAME=adg11g)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/app/oracle/arch/adg11gsb'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'
 
  Instance Warning(s):
    ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
    ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
 
Instance Status:
WARNING

해결 방법 : 해당 속성에 대해 알맞을 값 삽입

해당 db(standby db) InconsistentProperties 조회

DGMGRL> show database 'adg11gsb' InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE 
        adg11gsb     ArchiveLagTarget                    0                                         0 
        adg11gsb LogArchiveMinSucceedDest                    1                                         1 

memory_value와 broker_value는 0, 1 로 존재하지만 spfile에는 값이 없음

위 값에 맞게 수정(spfile)

Standby DB 에서 실행

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.

InconsistentProperties 재확인

DGMGRL> show database 'adg11gsb' InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE 

더이상 내용이 나오지 않음(정상)

Primary DB에서 재확인(instance verbose)

DGMGRL> show instance verbose adg11gsb
 
Instance 'adg11gsb' of database 'adg11gsb'
 
  Host Name: adg2
  PFILE:     
  Properties:
    SidName                         = 'adg11gsb'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adg2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=adg11gsb_DGMGRL)(INSTANCE_NAME=adg11g)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/app/oracle/arch/adg11gsb'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'
 
Instance Status:
SUCCESS

SUCCESS 로 표시됨

원인 : Inconsistent(불일치)한 파라미터 설정

해당 db(standby db) InconsistentProperties 조회시

DGMGRL> show database 'adg11gsb' InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE 
        adg11gsb     ArchiveLagTarget                    0                                         0 
        adg11gsb LogArchiveMinSucceedDest                    1                                         1 

memory_value와 broker_value는 0, 1 로 존재하지만 spfile에는 값이 없어서 발생한 문제

3개의 값이 동일해야 에러가 발생하지 않음

참조 : 

https://easyoradba.com/2012/12/05/warning-ora-16714-the-value-of-property-is-inconsistent-with-the-database-setting/

https://tutel.me/c/dba/questions/186065/register.html

http://www.br8dba.com/tag/ora-16714-the-value-of-property-archivelagtarget-is-inconsistent-with-the-database-setting/

https://positivemh.tistory.com/680

https://positivemh.tistory.com/674

https://positivemh.tistory.com/237