RE: Recovery -- Can't place tablespace offline ?
- From: "Prem Khanna J" <jprem@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2004 20:03:32 +0900
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@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:
