怎樣檢查資料庫壞塊(DBV)

tpctest$dbv help=y

DBVERIFY: Release 9.2.0.4.0 - Production on Sat Mar 3 15:48:16 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Keyword Description (Default)
----------------------------------------------------
FILE File to Verify (NONE)
START Start Block (First Block of File)
END End Block (Last Block of File)
BLOCKSIZE Logical Block Size (2048)
LOGFILE Output Log (NONE)
FEEDBACK Display Progress (0)
PARFILE Parameter File (NONE)
USERID Username/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)

壞塊檢查:

dmdii-node1$dbv file=base_data01.dbf blocksize=8192

DBVERIFY: Release 9.2.0.4.0 - Production on Sat Mar 3 16:17:21 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = base_data01.dbf
Page 51896 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x0280cab8 (file 10, block 51896)
Fractured block found during dbv:
Data in bad block -
type: 0 format: 2 rdba: 0x0000cab8
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
consistency value in tail: 0x00000000
check value in block header: 0xcdb8, computed block checksum: 0x1
spare1: 0x0, spare2: 0x0, spare3: 0x0
***

Page 51897 is marked corrupt
***
Corrupt block relative dba: 0x0280cab9 (file 10, block 51897)
Completely zero block found during dbv:

Page 51898 is marked corrupt
***
Corrupt block relative dba: 0x0280caba (file 10, block 51898)
Completely zero block found during dbv:

Page 51899 is marked corrupt
***
Corrupt block relative dba: 0x0280cabb (file 10, block 51899)
Completely zero block found during dbv:

Page 51900 is marked corrupt
***
Corrupt block relative dba: 0x0280cabc (file 10, block 51900)
Completely zero block found during dbv:

Page 51901 is marked corrupt
***
Corrupt block relative dba: 0x0280cabd (file 10, block 51901)
Completely zero block found during dbv:

Page 51902 is marked corrupt
***
Corrupt block relative dba: 0x0280cabe (file 10, block 51902)
Completely zero block found during dbv:

Page 51903 is marked corrupt
***
Corrupt block relative dba: 0x0280cabf (file 10, block 51903)
Completely zero block found during dbv:

Page 51904 is marked corrupt
***
Corrupt block relative dba: 0x0280cac0 (file 10, block 51904)
Completely zero block found during dbv:

Page 51905 is marked corrupt
***
Corrupt block relative dba: 0x0280cac1 (file 10, block 51905)
Completely zero block found during dbv:

Page 51906 is marked corrupt
***
Corrupt block relative dba: 0x0280cac2 (file 10, block 51906)
Completely zero block found during dbv:

Page 51907 is marked corrupt
***
Corrupt block relative dba: 0x0280cac3 (file 10, block 51907)
Completely zero block found during dbv:

Page 51908 is marked corrupt
***
Corrupt block relative dba: 0x0280cac4 (file 10, block 51908)
Completely zero block found during dbv:

Page 51909 is marked corrupt
***
Corrupt block relative dba: 0x0280cac5 (file 10, block 51909)
Completely zero block found during dbv:

Page 51910 is marked corrupt
***
Corrupt block relative dba: 0x0280cac6 (file 10, block 51910)
Completely zero block found during dbv:

Page 51911 is marked corrupt
***
Corrupt block relative dba: 0x0280cac7 (file 10, block 51911)
Completely zero block found during dbv:

Page 51912 is marked corrupt
***
Corrupt block relative dba: 0x0280cac8 (file 10, block 51912)
Completely zero block found during dbv:

Page 51913 is marked corrupt
***
Corrupt block relative dba: 0x0280cac9 (file 10, block 51913)
Completely zero block found during dbv:

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

DBVERIFY - Verification complete

Total Pages Examined : 256008
Total Pages Processed (Data) : 15320
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 1
Total Pages Failing (Index): 0
Total Pages Processed (Other): 223
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 240445
Total Pages Marked Corrupt : 19
Total Pages Influx : 2
dmdii-node1$

19 個

http://tolywang.itpub.net/post/48/266280