RMAN Script: POINT IN TIME RECOVERY

[point_intime_recovery.scp]

# This scenario assumes that all initializaiton filesa nd the current controlfile arein place and you want to recover to a point in time '2001-04-09"14:30:00'.

# Ensure you set your NLS_LANG enviroment variable

        STARTUP MOUNT FORCE;

        RUN

        {

        SET UNTIL TIME "TO_DATE('2001-04-09:14:30:00','yyyy-dd-mm:hh24:mi:ss')";

        RESTORE DATABASE;

        RECOVER DATABASE;

        ALTER DATABASE OPEN RESETLOGS;

        }

# You must take a new whole database backup after resetlogs,since backups of previous incarnation are not easily usable