High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

how to stop log apply when real time apply is active

I have a Oracle 19.12 Data Guard pair using DG broker.  The customer wants to stop the log apply to the standby database on a nightly basis to do some static report generation.  The current DG configuration is below:
DGMGRL> show database verbose primaryDB

Database - primaryDB

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

  Properties:
    DGConnectIdentifier             = 'primaryDB'
    ObserverConnectIdentifier       = ''
    FastStartFailoverTarget         = ''
    PreferredObserverHosts          = ''
    LogShipping                     = 'ON'
    RedoRoutes                      = ''
    LogXptMode                      = 'ASYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '30'
    TransportLagThreshold           = '30'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center