Shulou(Shulou.com)06/01 Report--

1. Environment description

11g RAC+ADG maximum available mode

2. Off-machine recovery

An error is reported in the alarm log as follows:

ORA-16072: a minimum of one standby database destination is required

Instance terminated by LGWR

Then the instance terminates abnormally

3. Reasons

Although you removed all configuration files, removed the Standby Database

And reset all LOG_ARCHIVE_DEST_n-Parameters, the Primary Database has still

The Protection Mode stored in the Data Dictionary. The Protection Mode

Requires a running connection to a Standby Database with LGWR SYNC as

Log-Transportation Mode. Since the standby is not available anymore

LGWR of the primary terminates the instance.

4. Treatment method

Startup the Primary Database in Mount State and set the Protection Mode back

To Maximum Performance Mode, which is the Default:

-- in the database mount state, execute the following command, and then restart the database

SQL > ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE

Then shutdown the Database and restart again.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.