Veritas NetBackup™ for Oracle Administrator's Guide

About restoring from a data file copy to ASM storage using RMAN

When you use a proxy method for data file copies, NetBackup cannot place the file directly back in ASM storage. You need to do a two-step restore for the data file copies.

If the backups are stream-based then restore directly from NetBackup.

When you restore back to the appliance share, make sure that the share on the appliance is configured with the no_root_squash NFS export option enabled.

For more information, refer to the Managing shares chapter in the Veritas NetBackup Appliance Administrator's Guide.

The first step is to stage the files to a file system. The second step is to use RMAN to restore the files into ASM storage.

The following is an example RMAN script to stage the files to a file system:

RUN {
ALLOCATE CHANNEL ch00
   TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=clientname,NB_ORA_SERV=servername';
SET NEWNAME FOR TABLESPACE USERS TO '/dump/%U';
RESTORE TABLESPACE USERS;
RELEASE CHANNEL ch00;
}

Once the file is on a file system, then you can restore to ASM storage by running the following:

RUN {
ALLOCATE CHANNEL dc00 DEVICE TYPE DISK;
RESTORE TABLESPACE USERS;
RECOVER DATABASE;
RELEASE CHANNEL dc00;
}