TABLESPACE POINT IN TIME RECOVERY:

POINT IN TIME RECOVERY:


RMAN> recover tablespace TEST1,TEST2 until time "to_date('07/06/12 12:15:00','DD/MM/YY HH24:MI:SS')" 
auxiliary destination '/aux/dest/oracle/atp/resto';

recover tablespace our_data until time
"to_date('2009-08-04 12:15:00’,’YYYY-MM-DD HH24:MI:SS')"
auxiliary destination ’/opt/oracle/temp’;

Once the above statement is executed, RMAN does the following for us:

    •    Creates auxiliary instance (including the pfile etc..)
    •    Mounts the auxiliary instance
    •    Makes the candidate tablespace into OFFLINE
    •    Restores the basic tablespace UNDO, SYTEM,SYSAUX and then the required tablespace
    •    Applies archives (completes recovery)
    •    Opens the database
    •    Performs an export of the objects residing in the tablespace
    •    Shutdown aux instance
    •    Import the objects into the target database
    •    Remove aux instance and cleanup
That's it....you now have all the objects back in the tablespace!




Refrence: http://www.online-database.eu/index.php/recovery-manager-rman/186-tablespace-point-in-time-recovery-tspitr