DG Broker always restore previous known state

Problem: Logical standby DG is configured with dataguard broker. After shutdown & startup mount, database is in open state (expected to be in mount)

SQL> select dataguard_broker from v$database
/

DATAGUARD_BROKER
—————-
ENABLED

SQL> alter database stop logical standby apply;
SQL> shutdown immediate
SQL> startup mount exclusive

SQL> select open_mode from v$database;

OPEN_MODE
———-
OPEN

Reason: DG Broker always restores database state to previous known state.

Solution: Disable broker, perform required operations and then re-enable broker

SQL> alter system set dg_broker_start=false;

System altered.

SQL> alter database stop logical standby apply;

Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount exclusive
ORACLE instance started.

Total System Global Area 1.7180E+10 bytes
Fixed Size 2060304 bytes
Variable Size 6039801840 bytes
Database Buffers 1.1123E+10 bytes
Redo Buffers 14712832 bytes
Database mounted.

SQL> select open_mode from v$database;

OPEN_MODE
———-
MOUNTED

SQL> alter system set dg_broker_start=true;

Advertisements
This entry was posted in Oracle Data Guard, Oracle Data Guard Broker and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s