To do a tablespace point in time recovery, you have to recover the tablespace to a clone database and export the necessary data and import it to the live database. You can't do recovery to a live database as far as I know. At least that was what I have always believed. Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J Sent: Wednesday, March 17, 2004 4:57 AM To: Freelists Subject: Recovery -- Can't place tablespace offline ? Hi List, -------- oracle 9.2.0.4 on win2k -------- I need to try recovery scenario {case 6} in Freeman's RMAN book. In order to simulate datafile corruption , i decided to overwite the database file with a small text file when the database is open. But later in order to recover,i am not able to place the tablespace ( which had the datafile ) offline. Doing so , i get the error : ORA-01115 : IO error reading block from file 5 (block #1) ORA-01110 : datafile 5 : 'd:\indx01.dbf' ORA-27091 : skgfqio: unable to queue I/O ORA-27070 : skgfdisp: async read/write failed 1.How do i place the tablespace offline in the above case and proceed further with recovery when DB is OPEN ? However , I am able to recover when the DB is mounted. 2.How to corrupt a datafile when DB is open other than as i did ? Regards, Prem. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------