Oracle 11g Data Guard Enabling Active Data Guard

Oracle 11g Data Guard Enabling Active Data Guard

 

開啟ADG需要standby database instance redo-only mode and starting redo logfiles

 

The general process of enabling Active Data Guard is as simple as opening the

standby database in read-only mode and starting Redo Apply.

This section describes how to enable Active Data Guard on a standby database.

1. If the standby instance and redo apply have been cleanly shut down

a. Using SQL*PlusMaximum Availability Architecture

Oracle Active Data Guard: Oracle Data Guard 11g Page 9

i. Start the standby instance in read-only mode.

SQL> startup

ii. Once the database is open, start Redo Apply:

SQL> recover managed standby database disconnect

using current logfile;

b. If you are using the Data Guard broker to manage your Data

Guard configuration

i. Start the standby instance in read-only mode. Connect

to the standby instance using DGMGRL and issue the

following command:

DGMGRL> startup

ii. The default state for the standby database is APPLY ON

and Redo Apply starts automatically. If the default has

been changed, then start Redo Apply by issuing the

following command:

DGMGRL> EDIT DATABASE ‘RTQ' SET STATE=‘APPLY-ON’

2. If the standby database is mounted and redo apply is running using the following steps

a. Using SQL*Plus

i. Stop redo apply

SQL> recover managed standby database cancel;

ii. Open the database read only

SQL> alter database open read only;

iii. Once the database is open, start redo apply:

SQL> recover managed standby database disconnect

using current logfile;

b. If you are using the Data Guard broker to manage your Data

Guard configuration

i. Stop redo apply using DGMGRL

DGMGRL> EDIT DATABASE ‘RTQ' SET STATE=‘APPLY-OFF’

ii. In SQL*Plus open the database read only

SQL> alter database open read only;

iii. Restart redo apply by issuing the following command:

DGMGRL> EDIT DATABASE ‘RTQ' SET STATE=‘APPLY-ON’

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26442936/viewspace-768476/，如需轉載，請註明出處，否則將追究法律責任。