Re: Recovery -- Can't place tablespace offline ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 17 Mar 2004 21:21:49 +1000
Message-ID: <01ca01c40c12$0a6e4540$0100000a@FOOTE>

Hi Prem,

When you place a tablespace offline, Oracle attempts to perform a checkpoint on the datafiles associated with the tablespace to ensure it's consistent after it's offline (else how do you write the dirty blocks in memory after it's offline ?).

The problem of course is that the datafile(s) is stuffed and the checkpoint can't be completed.

Therefore you need to use the 'immediate' clause to let Oracle know that a checkpoint is not possible (or 'temporary' where Oracle will checkpoint what datafiles it can).

The outstanding dirty blocks then get written to a deferred rollback segment and applied when the tablespace is recovered and brought back online.

Cheers

Richard

Original Message ----- From: "Prem Khanna J" <jprem_at_kssnet.co.jp> To: "Freelists" <oracle-l_at_freelists.org> Sent: Wednesday, March 17, 2004 7:57 PM 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_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
> -----------------------------------------------------------------
>

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 - 04:12:27 CST