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'
0