Friday, April 9, 2021

Error: ORA-16765: Redo Apply is running

DGMGRL for Linux: Version - 64bit Production

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

Welcome to DGMGRL, type "help" for information.
DGMGRL> show configuration
Configuration - TEST DG configuration

  Protection Mode: MaxPerformance
    DB_PROD  - Primary database
    DB_DG - Physical standby database
      Error: ORA-16765: Redo Apply is running
Fast-Start Failover: DISABLED
Configuration Status:

DGMGRL> show database verbose 'DB_DG';

Database - DB_DG

  Enterprise Manager Name: DB_DGP
  Role:                    PHYSICAL STANDBY
  Intended State:          APPLY-OFF
  Transport Lag:          10 hours 10 minutes 13 seconds (computed 8 seconds ago)
  Apply Lag:               10 hours 22 minutes 26 seconds (computed 0 seconds ago)
  Apply Rate:              (unknown)
  Real Time Query:         ON
    DB_DG1 (apply instance)
      Error: ORA-16765: Redo Apply is running


      DGConnectIdentifier             = 'DB_DG'
      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               = ''
      LogFileNameConvert              = '+REDO_DG1/DB_PROD, +REDO_DG1/DB_DG, +REDO_DG2/DB_PROD, +REDO_DG2/DB_DG'
      FastStartFailoverTarget         = ''
      InconsistentProperties          = '(monitor)'
      InconsistentLogXptProps         = '(monitor)'
      SendQEntries                    = '(monitor)'
      LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
      ApplyLagThreshold               = '0'
      TransportLagThreshold           = '0'
      TransportDisconnectedThreshold  = '30'

In a DG Broker configuration, we must always use DGMGRL to start or stop the redo apply service or any other action we want to perform to manage the dataguard. If we try to start redo apply service using SQLPLUS, dataguard broker configuration may not sense this and would return ORA-16765. To solve this problem, disable log apply using DGMGRL, and then enable it immediately after it. See bellow how to do this.

DGMGRL> edit database 'DB_DG' set state='APPLY-OFF' ;

DGMGRL> edit database 'DB_DG' set state='APPLY-ON';

DGMGRL> show configuration

Configuration - TEST DG configuration

  Protection Mode: MaxPerformance
    DB_PROD  - Primary database

    DB_DG - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:


 As you can see, there is no more ORA-16765

1 comment:

Popular Posts - All Times