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
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
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