Friday, April 9, 2021

Error: ORA-16765: Redo Apply is running


DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production

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

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

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

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
  Instance(s):
    DB_DG1 (apply instance)
      Error: ORA-16765: Redo Apply is running

    DB_DG2

  Properties:
      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' ;
Succeeded.

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

DGMGRL> show configuration

Configuration - TEST DG configuration

  Protection Mode: MaxPerformance
  Databases:
    DB_PROD  - Primary database

    DB_DG - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

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

No comments:

Post a Comment

Popular Posts - All Times