Data Guard

Oracle Data GuardChapter 3 - Implementing Standby Databases

Backup of the Primary Database

Issue the following statement on the primary database site to create the standby control file:

ALTER DATABASE STANDBY
CONTROLFILE AS '/tmp/stanbycontrol.ctl';

This statement can be executed when the database is mounted or open.  The control file should then be transferred to the standby site using the operating system utility.

Modifying the Initialization Parameter File

To support the standby database, initialization parameters on both the primary and the Oracle instance will need to be modified. The changes in the primary database parameter are minor.

On the primary site, new archive log destination parameters should be added to point to the standby database. These parameters are log_archive_dest and log_archive_dest_state. Add these two parameters for each of the standby databases in the Data Guard configuration. Assume that there is only one physical standby database in the configuration and its service name is stdby1. The initialization parameters on primary site will look like the following: