RE: Recovery -- Can't place tablespace offline ?
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2004 09:34:31 -0500
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
-----------------------------------------------------------------
Other related posts:
