Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: incomplete RMAN recovery

RE: incomplete RMAN recovery

From: Freeman Robert - IL <>
Date: Mon, 21 Apr 2003 14:12:36 -0800
Message-ID: <>

RMAN will to tablespace point and time recovery (TSPITR) using Oracle's transportable tablespace feature. You have to setup an auxillary database, the tablespace must be transportable, etc....

Off the top of my head I don't recall if it does it in 8i or not, but I know it does in 9i.

This is covered in my book, Oracle9i RMAN Backup and Recovery, in detail.


-----Original Message-----

To: Multiple recipients of list ORACLE-L Sent: 4/21/2003 3:57 PM

Thanks for the suggestion . Actaully I already do the point in time recovery for the complete db . I was guessing if RMAN has got some cute stuff which can do tablesapce PIT on fly . It might check for the data integrity and then do the PIT recovery for the tablesapce . This tablespace is indepenedent .  


You R doing a NO NO.  

Incomplete Tablespace recovery... REALLY... now .. Ask youself ... If I recovery a tablespace to a point in time where does that leave the rest of my database...  

You are breakin the fundamental rules.. Point in time Recovery for a tablespace is more complicated because
you have to recover the entire backup to a point in time... and then use the plug in a tablespace method to
get that into your orginal database...  

Hope that rings some bells.  

Brian Spears

-----Original Message-----

Sent: Monday, April 21, 2003 12:17 PM
To: Multiple recipients of list ORACLE-L

I am testing incomlete tablespace recovery using rman . I dropped a table at 21-apr-2003 at 8:10 . Using following script to reocery the tablespace. Script does work . But I am not able to see dropped table . Why is it not recovering until time 8:03 . Any Idea ?  

run {
SQL "ALTER SESSION SET NLS_DATE_FORMAT=''DD-MON-YYYY HH24:MI:SS''"; set until time '21-apr-2003 08:03:00';
sql "alter tablespace akdata offline temporary"; allocate channel ch1 type disk;
restore tablespace akdata;
recover tablespace akdata ;
release channel ch1;
sql "alter tablespace akdata online";  




Please see the official ORACLE-L FAQ:

Author: Freeman Robert - IL

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 21 2003 - 17:12:36 CDT

Original text of this message