ORA-01154 trying to shutdown second Standby Database in Maximum Protection (Doc ID 1431533.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Setup:
  • There is a Primary Database in Maximum Protection Mode having at least two associated Standby Databases.
  • Both Standby Databases are serving the Maximum Protection Mode, ie. Log Transport Services to these Standby Databases are using 'LGWR SYNC AFFIRM'
  • One or both Standby Databases are Physical Standby Databases in Active Data Guard Mode or at least open 'READ ONLY'

Behaviour:

If we now try to shutdown such a Standby Database which is open READ ONLY, if fails with

ORA-01154: database busy. Open, close, mount, and dismount not allowed

although the remaining Standby Databases are serving the Maximum Protection Mode, too.

In the ALERT.LOG we can find Entries like this:

Attempt to shut down Standby Database
Standby Database operating in NO DATA LOSS mode
Detected primary database alive, shutdown primary first, shutdown aborted

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms