<< Putting the Database in Backup Mode | Recovering the Database >>

Creating a Snapshot

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Creating a Snapshot on the Remote Mirroring Site

Remote Mirroring of an Oracle Database Using Data Replicator Software

6-5

The

db_suspend

script creates a PFILE if one does not exist on the primary database site

by using the following command.

CREATE PFILE FROM SPFILE;

The

db_suspend

script creates a binary backup control file and a backup control file to

trace by using the following commands.

ALTER DATABASE BACKUP CONTROLFILE TO '${ORA_DUMP}/

backup_control.ctl' REUSE;

ALTER DATABASE BACKUP CONTROLFILE TO trace;

The

db_suspend

script edits the backup control file to trace only to contain the required

recovery statements to issue to the remote database site.

The

db_suspend

script puts the primary database in backup mode by using the following

command.

ALTER DATABASE BEGIN BACKUP;

Creating a Snapshot on the Remote Mirroring Site

After the databases have been stopped and suspended, take a snapshot of volumes of the
remote site storage system. This action is done with a function within the

erm.ksh

script

as shown in "

Re-create a Snapshot

" on page

D-4

Resuming the Database

To take the primary database out of Backup mode, type the following command to invoke
the

db_resume

script.

db_resume $PRI_DB_ID $ORA_SID $ORA_HOME $ORA_DUMP $LOG $TRACE

$PRI_SCRIPT_DIR $PRI_HOST

This command invokes the db_resume script with the parameters shown in

Table 6-3

db_resume

Script Parameters (1 of 2)

Parameter

Definition

$PRI_DB_ID

Owner of the Oracle software installation

$ORA_SID

Same as

$ORACLE_SID

$ORA_HOME

Same as

$ORACLE_HOME

$ORA_DUMP

The

user_dump_dest