Database Reference
In-Depth Information
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on Wed Oct 10 21:33:44 2007
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL procedure successfully completed.
device type SBT_TAPE
Restoring from piece CF-DB-NINE-20071010-vsiu61og
PL/SQL procedure successfully completed.
SQL> !ls -l /tmp/control.ctl
-rw-r----- 1 oracle dba 1413120 Oct 10 21:33 /tmp/control.ctl
The control file was restored as file
/tmp/control.ctl
. If this control file contains the backup
piece names of the most recent data file and archived log backups, the database should be
mounted and the restore continued with RMAN in the usual manner. However, if no control
file backup with the most recent backup piece names exists, simply since the control file was
not backed up after the last backup (e.g., since automatic control file backup is disabled), data
files and archived logs must also be restored by calling
DBMS_BACKUP_RESTORE
. For these purposes,
the source code depot contains the scripts
dbms_backup_restore.sql
and
dbms_backup_restore_
arch_tdpo.sql
.
Source Code Depot
Table 17-2 lists this chapter's source files and their functionality.
Table 17-2.
DBMS_BACKUP_RESTORE Source Code Depot
File Name
Functionality
dbms_backup_restore.sql
Disaster recovery script for restoring a control file
and multiple data files using a disk channel
dbms_backup_restore_arch_tdpo.sql
Disaster restore script for restoring archived redo
logs from a backup set, which may consist of several
backup pieces, using TDPO (device type
SBT_TAPE
)
dbms_backup_restore_cf_tdpo.sql
Disaster restore script for restoring a control file using
TDPO (device type
SBT_TAPE
)
