Recovery -- Can 't place tablespace offline ? 2004-03-17 - By Prem Khanna J
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
