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

Resuming the Database

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Creating a Snapshot on the Remote Mirroring Site
Remote Mirroring of an Oracle Database Using Data Replicator Software
5-5
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 the volumes of
the remote site storage system. This action is done with a function within the
sun_erm.ksh
script as shown in "
Recreate a Snapshot
" on page
C-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 $ORA_SID $ORA_HOME $LOG
This command invokes the
db_resume
script with the parameters shown in
Table 5-4
.
The
db_resume
script takes the primary database out of Backup mode by using the
following command.
ALTER DATABASE END BACKUP;
The
db_resume
script archives the unarchived redo logs, so that the all required redo is
available.
ALTER SYSTEM ARCHIVE LOG CURRENT;
Table 5-4
db_resume
Script Parameters
Parameter
Definition
$ORA_SID
Same as
$ORACLE_SID
$ORA_HOME
Same as
$ORACLE_HOME
$LOG
The log directory