Stop The Observer

Onur ARDAHANLI

3 years ago

The Observer stop command should be called either from the Primary Database or from the Standby Databases connected to the Primary Database.

1. We stop the Observer.

[Primary-1]

DGMGRL> stop observer;
Done.

1 2	DGMGRL> stop observer; Done.

2. We see the information that there is an immediate stop on the terminal server where the Observer is started.

3. When the configuration is queried, we see the warning that the Observer is not running.

DGMGRL> show configuration verbose;

Configuration - Broker_Configuration

  Protection Mode: MaxPerformance
  Databases:
    primary - Primary database
      Warning: ORA-16819: fast-start failover observer not started

    standby - (*) Physical standby database
      Warning: ORA-16819: fast-start failover observer not started

    logical - Logical standby database

  (*) Fast-Start Failover target

  Properties:
    FastStartFailoverThreshold      = '100'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '900'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '15'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: ENABLED

  Threshold:          100 seconds
  Target:             standby
  Observer:           (none)
  Lag Limit:          900 seconds
  Shutdown Primary:   TRUE
  Auto-reinstate:     TRUE
  Observer Reconnect: 15 seconds
  Observer Override:  FALSE

Configuration Status:

DGMGRL> show configuration verbose;

Configuration - Broker_Configuration

Protection Mode: MaxPerformance

Databases:

primary - Primary database

Warning: ORA-16819: fast-start failover observer not started

standby - (*) Physical standby database

Warning: ORA-16819: fast-start failover observer not started

logical - Logical standby database

(*) Fast-Start Failover target

Properties:

FastStartFailoverThreshold = '100'

OperationTimeout = '30'

FastStartFailoverLagLimit = '900'

CommunicationTimeout = '180'

ObserverReconnect = '15'

FastStartFailoverAutoReinstate = 'TRUE'

FastStartFailoverPmyShutdown = 'TRUE'

BystandersFollowRoleChange = 'ALL'

ObserverOverride = 'FALSE'

ExternalDestination1 = ''

ExternalDestination2 = ''

PrimaryLostWriteAction = 'CONTINUE'

Fast-Start Failover: ENABLED

Threshold: 100 seconds

Target: standby

Observer: (none)

Lag Limit: 900 seconds

Shutdown Primary: TRUE

Auto-reinstate: TRUE

Observer Reconnect: 15 seconds

Observer Override: FALSE

Configuration Status:

WARNING