| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recovery -- Can't place tablespace offline ?
An ALTER TABLESPACE OFFLINE expects that all the files in the Tablespace are
available so that it can Checkpoint all the files.
If any of the files has been ovewritten or lost, you cannot issue the
OFFLINE NORMAL.
You'd have to OFFLINE IMMEDIATE.
Hemant
At 06:57 PM 17-03-04 +0900, you wrote:
>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
>-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 24-Jan-04}
"If you wish to leave your footprints on the sand, do not drag your feet"
-- 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 - 10:28:18 CST
 |
 |