Re: Recovery -- Can't place tablespace offline ?
- From: "Richard Foote" <richard.foote@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2004 21:21:49 +1000
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@xxxxxxxxxxxx>
To: "Freelists" <oracle-l@xxxxxxxxxxxxx>
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@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
> -----------------------------------------------------------------
>
----------------------------------------------------------------
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:
