Re: problem: Corrupt block dba

In article <325ACEB9.7309_at_jolt.att.com> Chi-Sharn Wu <swu_at_jolt.att.com> writes:
>Hi:
> I got "Corrupt block dba" message from oracle trace file like follows.
>I check the disk which seems OK. Is this a oracle bug ?
>Thanks for any inof.
>
>Chi Wu
>swu_at_probe.att.com
>
>
>Mon Oct 7 20:25:54 1996
>*** SESSION ID:(4.1) 1996.10.07.20.25.54.000
>ORA-01171: datafile 2 going offline due to error advancing checkpoint
>ORA-01122: database file 2 failed verification check
>ORA-01110: data file 2: '/db_data1/oracle/tsppdata1.dbf'
>ORA-01204: file number is 3 rather than 2 - wrong file

Have you been renaming or restoring files?

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O