|
 |
|
< Data GuardDonald K. Burleson
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:
|
