RE: datafile corruption??
- From: "Martin Brown" <martinfbrown@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 20:07:07 +0000
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@xxxxxxxxxxxxxxx>
>Reply-To: oracle-l@xxxxxxxxxxxxx
>To: <oracle-l@xxxxxxxxxxxxx>
>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@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:
