hi,Denham Eva dba: 0x03012945 ---- 0000 0011 00#00 0001 0010 1001 0100= 0101 , file id : 12 , block 76101 i am fuzzy with "file 0 is system datafile ," please check the object_name first ,for example select segment_name from dba_extents where 76101 between = block_id and block_id + blocks and file_id =3D 12(or 0 ?); if it is a index and not file 0 then rebuild ,if tables= and not file 0 ,then recognize the table. can you do a recovery ? no backup datafile ? Best regards yahoo id: feng_chunpei msn: biti_rainy@xxxxxxxxxxx =3D=3D=3D=3D=3D=3D from the mail=3D=3D=3D=3D=3D=3D=3D=3D=3D >Hello Group, > >We had a Disk go on us the other day, I got a=3D20 > >*** >Corrupt block relative dba: 0x03012945 (file 12, block 76101) >Bad header found during buffer read >Data in bad block - > type: 6 format: 2 rdba: 0x03012945 > last change scn: 0x0000.05dae8f2 seq: 0x2 flg: 0x00 > consistency value in tail: 0xe8f20602 > check value in block header: 0xc1d5, block checksum disabled > spare1: 0x0, spare2: 0x0, spare3: 0x0 >*** > >In the Alert Log. The disk was replaced and the Raid rebuilt. > >I also dropped and rebuilt the object involved, all successful.= Backup =3D >also runs smoothly without error. > >However when I do a DB_Verify, I get the following > >E:\oracle>dbv file=3D3De:\oracle\oradata\xxxxxx\xxxxxxxx05.ora =3D >feedback=3D3D1000 blocksi >ze=3D3D8192 > >DBVERIFY: Release 8.1.7.4.1 - Production on Mon Apr 19 09:32:13= 2004 > >(c) Copyright 2000 Oracle Corporation. All rights reserved. > >DBVERIFY - Verification starting : FILE =3D3D =3D >e:\oracle\oradata\xxxx\xxxxxx05.or >a >................................................................= .........=3D >....Page > 76101 is marked corrupt >*** >Corrupt block relative dba: 0x03012945 (file 0, block 76101) >Bad header found during dbv: >Data in bad block - > type: 6 format: 2 rdba: 0x03012945 > last change scn: 0x0000.05dae8f2 seq: 0x2 flg: 0x00 > consistency value in tail: 0xe8f20602 > check value in block header: 0xc1d5, block checksum disabled > spare1: 0x0, spare2: 0x0, spare3: 0x0 >*** > >..... >................................................................= .........=3D >........ > >................................................................= .........=3D >........ > >................. > >DBVERIFY - Verification complete > >Total Pages Examined : 256000 >Total Pages Processed (Data) : 194147 >Total Pages Failing (Data) : 0 >Total Pages Processed (Index): 513 >Total Pages Failing (Index): 0 >Total Pages Processed (Other): 123 >Total Pages Empty : 61216 >Total Pages Marked Corrupt : 1 >Total Pages Influx : 0 > >Question is Is there some way that to correct Oracle's marked= status, or =3D >should I live with it? > >TIA >Regards >Denham >----------------------------------------------------------------= >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 >----------------------------------------------------------------= - > >. =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 ---------------------------------------------------------------- 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 -----------------------------------------------------------------