Recovering Protected Databases Using Local Backups

When you create protected database backups to a local disk location, you can use regular RMAN commands to perform recovery. You need to configure one of the following before you restore and recover the protected database:

  • disk channels that corresponds to the disk location where the backups are stored

  • SBT channels that correspond to backups on legacy media management environments where the backups are stored

To perform complete recovery of a protected database using local disk backups:

  1. Connect RMAN to the protected database as TARGET and connect to the RMAN recovery catalog as CATALOG.

    The following command connects as TARGET to the protected database with net service name hr_ptdb and as CATALOG to an RMAN recovery catalog database with net service name rco. hradm is a user with SYSBACKUP privileges on the protected database and rco is the RMAN recovery catalog owner. Enter the passwords for the hradm and rco users when prompted.

    % rman TARGET hradm@hr_ptdb CATALOG rco@catdb
    
  2. Allocate an RMAN channel of device type DISK to use backups stored on local disk storage.

    The following command allocates a disk channel that creates backups to the local disk storage.

    RMAN> ALLOCATE CHANNEL d1 DEVICE TYPE DISK;
    
  3. Restore and recover the protected database using the RESTORE and RECOVER commands respectively.

    The following example performs complete recovery of the protected database:

    RUN
    {
       STARTUP MOUNT;
       ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
       RESTORE DATABASE;
       RECOVER DATABASE;
       ALTER DATABASE OPEN;
    }