Recovery -- Can't place tablespace offline ?

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Wed, 17 Mar 2004 18:57:16 +0900
Message-ID: <00cf01c40c06$3aa908f0$dd00a8c0@prem>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Mar 17 2004 - 03:52:26 CST