NetBackup™ for Oracle Administrator's Guide

To specify a snapshot rollback restore using a script or RMAN command, follow this example:

• If you want to use a shell script or RMAN command, set a new variable, NB_PC_ORA_RESTORE=rollback

  • Example:

    RUN {
        allocate channel t1 'SBT_TAPE';
        send 'NB_ORA_PC_RESTORE=rollback';
        sql 'alter tablespace TEST offline immediate'
        restore tablespace TEST;
        recover tablespace TEST;
        release channel t1;
    }