4 Replies Latest reply: Apr 24, 2014 10:42 AM by FreddieEssex RSS

    Standby DB status Shows Warning when changing the Property

    vk82
      Today when i am trying to edit the LogArchiveFormat property of standby db i got warning messgae.

       

      Prior to change status of standby db :-

       

      DGMGRL> SHOW DATABASE VERBOSE sbyorcl

       

      Database - sbyorcl

       

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

       

      Properties:
      DGConnectIdentifier = 'sbyorcl'
      ObserverConnectIdentifier = ''
      LogXptMode = 'ASYNC'
      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 = '/u01/app/oracle/oradata/orcl, /u01/app/oracle/oradata/sbyorcl'
      LogFileNameConvert = '/u01/app/oracle/oradata/orcl, /u01/app/oracle/oradata/sbyorcl'
      FastStartFailoverTarget = ''
      StatusReport = '(monitor)'
      InconsistentProperties = '(monitor)'
      InconsistentLogXptProps = '(monitor)'
      SendQEntries = '(monitor)'
      LogXptStatus = '(monitor)'
      RecvQEntries = '(monitor)'
      HostName = 'sbyorcl.localdomain'
      SidName = 'sbyorcl'
      StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sbyorcl.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SBYORCL_DGMGRL.localdomain)(INSTANCE_NAME=sbyorcl)(SERVER=DEDICATED)))'
      StandbyArchiveLocation = '/u01/app/oracle/flash_recovery_area/SBYORCL/'
      AlternateLocation = ''
      LogArchiveTrace = '0'
      LogArchiveFormat = '%t_%s_%r.dbf'
      TopWaitEvents = '(monitor)'

       

      Database Status:
      SUCCESS

       

      Command which i used to change the property is EDIT DATABASE 'sbyorcl' SET PROPERTY 'LogArchiveFormat'='log_%t_%s_%r_%d.arc';

       

      DGMGRL> EDIT DATABASE 'sbyorcl' SET PROPERTY 'LogArchiveFormat'='log_%t_%s_%r_%d.arc';

       

      Status of Standby DB after editing property:-

       

      DGMGRL> SHOW DATABASE VERBOSE sbyorcl

       

      Database - sbyorcl

       

      Role: PHYSICAL STANDBY
      Intended State: APPLY-ON
      Transport Lag: 0 seconds
      Apply Lag: 0 seconds
      Real Time Query: OFF
      Instance(s):
      sbyorcl
      Warning: ORA-16714: the value of property LogArchiveFormat is inconsistent with the database setting

       

      Properties:
      DGConnectIdentifier = 'sbyorcl'
      ObserverConnectIdentifier = ''
      LogXptMode = 'ASYNC'
      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 = '/u01/app/oracle/oradata/orcl, /u01/app/oracle/oradata/sbyorcl'
      LogFileNameConvert = '/u01/app/oracle/oradata/orcl, /u01/app/oracle/oradata/sbyorcl'
      FastStartFailoverTarget = ''
      StatusReport = '(monitor)'
      InconsistentProperties = '(monitor)'
      InconsistentLogXptProps = '(monitor)'
      SendQEntries = '(monitor)'
      LogXptStatus = '(monitor)'
      RecvQEntries = '(monitor)'
      HostName = 'sbyorcl.localdomain'
      SidName = 'sbyorcl'
      StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sbyorcl.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SBYORCL_DGMGRL.localdomain)(INSTANCE_NAME=sbyorcl)(SERVER=DEDICATED)))'
      StandbyArchiveLocation = '/u01/app/oracle/flash_recovery_area/SBYORCL/'
      AlternateLocation = ''
      LogArchiveTrace = '0'
      LogArchiveFormat = 'log_%t_%s_%r_%d.arc'
      TopWaitEvents = '(monitor)'

       

      Database Status:
      WARNING

       


      Please guide me where i done mistake