Performing a snapshot rollback restore using a script or RMAN command

This topic describes how to perform a snapshot rollback restore using a script or RMAN command.

Note:

If the data file you want to restore has not changed since it was backed up, the rollback may fail. Initiate the restore from a script and use the Oracle FORCE option.

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;
}

Performing a snapshot rollback restore using a script or RMAN command

Feedback

Feedback