Thursday, October 11, 2007

Using DB_VERIFY Utility in Oracle 10g Enterprise Database for identifying block corruption in backup files and live datafiles

This was in my Alert Log file

Wed Oct 07 22:00:57 2009
GATHER_STATS_JOB encountered errors. Check the trace file.
Wed Oct 07 22:00:57 2009
Errors in file d:\oracle\product\10.2.0\admin\synapse\bdump\synapse_j001_1036.trc:
ORA-01578: ORACLE data block corrupted (file # 1, block # 51522)
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SYNAPSE\SYSTEM01.DBF'


Using Using DB_VERIFY Utility in Command prompt

C:\>dbv file=D:\ORACLE\PRODUCT\10.2.0\ORADATA\SYNAPSE\SYSTEM01.DBF

DBVERIFY: Release 10.2.0.4.0 - Production on Thu Oct 8 11:36:18 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = D:\ORACLE\PRODUCT\10.2.0\ORADATA\SYNAP
SE\SYSTEM01.DBF
Page 51342 is influx - most likely media corrupt
Corrupt block relative dba: 0x0040c88e (file 1, block 51342)
Fractured block found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x0040c88e
last change scn: 0x0000.01f696a1 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00345352
check value in block header: 0xb5cc
computed block checksum: 0x82d

Page 51343 is marked corrupt
Corrupt block relative dba: 0x0040c88f (file 1, block 51343)
Bad header found during dbv:
Data in bad block:
type: 3 format: 0 rdba: 0x00000005
last change scn: 0x0003.00020002 seq: 0x0 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x7010
consistency value in tail: 0x000005d8
check value in block header: 0x3
computed block checksum: 0xe09f

Page 51344 is marked corrupt
Corrupt block relative dba: 0x0040c890 (file 1, block 51344)
Bad header found during dbv:
Data in bad block:
type: 16 format: 2 rdba: 0x000009a8
last change scn: 0x0d78.00000294 seq: 0x0 flg: 0x00
spare1: 0x0 spare2: 0x0 spare3: 0xbd
consistency value in tail: 0x7f00001d
check value in block header: 0x201
block checksum disabled

Page 51345 is marked corrupt
Corrupt block relative dba: 0x0040c891 (file 1, block 51345)
Bad header found during dbv:
Data in bad block:
type: 255 format: 3 rdba: 0x23000000
last change scn: 0xba00.0000fdfb seq: 0x26 flg: 0x01
spare1: 0x2a spare2: 0x1b spare3: 0x100
consistency value in tail: 0x00000000
check value in block header: 0x100
block checksum disabled

Page 51346 is influx - most likely media corrupt
Corrupt block relative dba: 0x0040c892 (file 1, block 51346)
Fractured block found during dbv:
Data in bad block:
type: 0 format: 0 rdba: 0x00000000
last change scn: 0x0000.00000000 seq: 0x0 flg: 0x00
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000000
check value in block header: 0x0
block checksum disabled

Page 51347 is marked corrupt
Corrupt block relative dba: 0x0040c893 (file 1, block 51347)
Completely zero block found during dbv:

Page 51381 is marked corrupt
Corrupt block relative dba: 0x0040c8b5 (file 1, block 51381)
Bad check value found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x0040c8b5
last change scn: 0x0000.01f73e6b seq: 0x2 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x3e6b0602
check value in block header: 0x94a3
computed block checksum: 0x89d9

Page 51522 is marked corrupt
Corrupt block relative dba: 0x0040c942 (file 1, block 51522)
Bad check value found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x0040c942
last change scn: 0x0000.01fb92b7 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x92b70601
check value in block header: 0x1201
computed block checksum: 0x1



DBVERIFY - Verification complete

Total Pages Examined : 66560
Total Pages Processed (Data) : 40487
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 8111
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1929
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 16025
Total Pages Marked Corrupt : 8
Total Pages Influx : 2
Highest block SCN : 33440950 (0.33440950)
Using DB_VERIFY Utility in Oracle 10g Enterprise Database for identifying block corruption in backup files and live datafilesSocialTwist Tell-a-Friend

1 comment:

  1. Hello , if you have any recent backups(RMAN) so restore datafile which one is currepted.

    alter database datafile# offline
    restore datafile;
    recover datafile;
    alter database datafile# online;

    thanks
    satya

    ReplyDelete