RE: datafile corruption??

From: Martin Brown <martinfbrown_at_hotmail.com>
Date: Tue, 27 Jul 2004 20:07:07 +0000
Message-ID: <BAY18-F19V5xzTSh7vT000537e9@hotmail.com>

Scan the alert log to make sure there are no other errors like this. You should also do:
select status, name from v$datafile;

See if you can find out what other files on on this spindle. It may take some help from your S/A.
I think this may be hardware failure, but not sure. The S/A can look at log files and stuff to check for hits.

I would look at moving everything off of that mount piont if that's the case. Your file looks like an index dbf? If it is, it's not so bad. You can rebuild all of the indexes for that tablespace.

>From: <Paula_Stankus_at_doh.state.fl.us>
>Reply-To: oracle-l_at_freelists.org
>To: <oracle-l_at_freelists.org>
>Subject: RE: datafile corruption??
>Date: Tue, 27 Jul 2004 15:52:47 -0400
>
>Guys,
>
>redolog errors appeared in alert.log and lgwr trace with "STALE" but =
>"CURRENT" redo log group. I did an alter system switch logfile which =
>switch to a different online log and since there is a checkpoint then =
>maybe things aren't so bad.
>
>However, there is a dbwr trace with the following:
>
>KCF: write/open error block=3D0x7d94 online=3D1
> file=3D14 /u04/CSTAT/cstat_bidx01.dbf
> error=3D27063 txt: 'SVR4 Error: 5: I/O error
>Additional information: -1
>Additional information: 4096'
>Automatic datafile offline due to write error on
>file 14: /u04/CSTAT/cstat_bidx01.dbf
>
>
>Looks like a datafile (ndx) went offline due to I/O error. However, is =
>this a corruption error or something else? Also, what is the quickest =
>way to check the status on my other files - it has been a long time.
>
>Thanks,
>Paula
>----------------------------------------------------------------
>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 Tue Jul 27 2004 - 15:04:12 CDT