ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting

DGMGRL> show database 'dsdfdbs';


Database - dsdfdbs


  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: ON
  Instance(s):
    dsdfdb
      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


Database Status:
WARNING


解决:
报错是因为备库的参数与主库设置的不一致,所以先查看主库的参数
DGMGRL> SHOW DATABASE VERBOSE 'dsdfdbm';
Database - dsdfdbm


  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    dsdfdb


  Properties:
    DGConnectIdentifier             = 'dsdfdbm_dgmgrl'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'dsdfdb'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibpsdba)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dsdfdbm_DGMGRL.cuiyan1.com)(INSTANCE_NAME=dsdfdb)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/arch'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'


Database Status:
SUCCESS


通过查看主库的参数来修改备库的参数数值


DGMGRL> edit database 'dsdfdbs' set property 'ArchiveLagTarget'='0';
DGMGRL> edit database 'dsdfdbs' set property 'LogArchiveMinSucceedDest'='1';
DGMGRL> edit database 'dsdfdbs' set property 'LogArchiveMaxProcesses'='4';


DGMGRL> show database 'dsdfdbs';


Database - dsdfdbs


  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: ON
  Instance(s):
    dsdfdb


Database Status:

SUCCESS


类似问题都可以通过这个方法解决。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值