DBMS_Backup_Restore

Abstract

The package DBMS_BACKUP_RESTORE is undocumented in the Oracle9i Supplied PL/SQL Packages and Types Reference as well as in Oracle Database PL/SQL Packages and Types Reference of Oracle10g and subsequent releases. Restoring database files with Recovery Manager (RMAN) requires either that a control file with bookkeeping information on the files to restore is mounted or that a database session to an RMAN catalog with like information is available. DBMS_BACKUP_ RESTORE makes possible a restore without RMAN in a disaster scenario. Such a scenario is characterized by the loss of all current control files, and the lack of or unavailability of a recovery catalog or control file backup that contains records of the most recent data file and archived redo log backups. Note that bookkeeping information on backups is aged out of the control file depending on the setting of the initialization parameter CONTROL_FILE_RECORD_KEEP_TIME. The default setting of this parameter is merely seven days.