Veritas NetBackup™ for Oracle Administrator's Guide

Restoring data files to a new location

NetBackup for Oracle with Snapshot Client can restore the data files that are backed up by proxy to a new location. The new location can be specified by using the RMAN set newname command or ALTER DATABASE RENAME DATAFILE statement before a restore is initiated. For example, to restore a data file for tablespace TEST to a new location, you can use the following RMAN commands:

   RUN
    {
    allocate channel t1 'SBT_TAPE';
    sql 'alter tablespace TEST offline immediate'
    # restore the datafile to a new location
    set newname for datafile '/oradata/test.f' to
    '/oradata_new/test.f';
    restore tablespace TEST;
    # make the control file recognize the restored file as current
    switch datafile all;
    recover tablespace TEST;
    release channel t1;
    }

The RMAN procedure for the data files that are backed up by proxy is the same as for conventionally backed up data files. RMAN knows that the data files were backed up by proxy, and it issues a proxy restore request to NetBackup for Oracle, which restores the data files to the new location. For more information on the required procedure, see your Oracle documentation.