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

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Wed, 17 Mar 2004 20:03:32 +0900
Message-ID: <00d301c40c0f$7cbefa70$dd00a8c0@prem>

Hi Richard,

Thanx again for ur explanation.
I was able to recover it.

Regards,
Prem.

>>-----Original Message-----
>>From: Richard 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

---

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:58:46 CST