ORA-16792: configurable property value is inconsistent with database setting

ENMOEDU  主库 ORA11GR2 备库
[root@ora2 ~]# su - oracle
[oracle@ora2 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - Production


Copyright (c) 2000, 2009, Oracle. All rights reserved.


Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/oracle@ ENMOEDU
Connected.
DGMGRL> SHOW CONFIGURATION VERBOSE;


Configuration - sdf


  Protection Mode: MaxAvailability
  Databases:
    enmoedu  - Primary database
      Warning: ORA-16792: configurable property value is inconsistent with database setting
    ora11gr2 - Physical standby database
  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'


Fast-Start Failover: DISABLED


Configuration Status:
WARNING
DGMGRL> SHOW DATABASE VERBOSE ENMOEDU;
Database - enmoedu
  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    ENMOEDU
      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
  Properties:
    DGConnectIdentifier             = 'enmoedu'
    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               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'
Database Status:
WARNING
DGMGRL> HELP EDIT;
Edits a configuration, database, or instance
Syntax
  EDIT CONFIGURATION SET PROTECTION MODE AS 
    {MaxProtection|MaxAvailability|MaxPerformance};
  EDIT CONFGURATION SET PROPERTY = ;
  EDIT DATABASE SET PROPERTY = ;
  EDIT DATABASE RENAME TO ;
  EDIT DATABASE SET STATE =
    [WITH APPLY INSTANCE = ];
  EDIT INSTANCE [ON DATABASE ]
    SET AUTO PFILE [ = {|OFF} ];
  EDIT INSTANCE [ON DATABASE ]
    SET PROPERTY = ;
  EDIT INSTANCE * ON DATABASE
    SET PROPERTY = ;

DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY ArchiveLagTarget=0;
Property "archivelagtarget" updated
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY LogArchiveMaxProcesses=4;
Property "logarchivemaxprocesses" updated
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTYLogArchiveMinSucceedDest=1;
DGMGRL> EDIT DATABASE ENMOEDU SET PROPERTY LogArchiveMinSucceedDest=1;
Property "logarchiveminsucceeddest" updated
DGMGRL> SHOW DATABASE VERBOSE enmoedu;

Database - enmoedu
  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    ENMOEDU
  Properties:
    DGConnectIdentifier             = 'enmoedu'
    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               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'


Database Status:
SUCCESS

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30176559/viewspace-1697040/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30176559/viewspace-1697040/