dbv查询mysql数据错误_DBV-00600: 致命错误 – [21] [5] [0] [0] 错误原因

11.2.0.4 dbv检查

C:\Users\Administrator>dbv file=D:\TEMP\example01.dbf blocksize=8192

DBVERIFY: Release 11.2.0.4.0 - Production on 星期三 7月 4 18:04:34 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

DBV-00600: 致命错误 - [21] [5] [0] [0]

12.2 dbv检查

oracle@localhost ~]$ dbv file=/tmp/example01.dbf

DBVERIFY: Release 12.2.0.1.0 - Production on Wed Jul 4 06:28:51 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

DBV-00113: FILE (/tmp/example01.dbf) file size is not a multiple of block size

OS文件大小

---linux

[oracle@localhost ~]$ ls -l /tmp/example01.dbf

-rwxrwxrwx 1 root root 104865793 Jul 3 11:46 /tmp/example01.dbf

---win

C:\Users\Administrator>dir D:\TEMP\example01.dbf

驱动器 D 中的卷是 本地硬盘

卷的序列号是 EECC-4D96

D:\TEMP 的目录

2018-07-03 23:46 104,865,793 example01.dbf

1 个文件 104,865,793 字节

0 个目录 2,192,213,327,872 可用字节

数据库记录文件大小

DUL> dump datafile 5 block 1

Block Header:

block type=0x0b (file header)

block format=0xa2 (oracle 10)

block rdba=0x01400001 (file#=5, block#=1)

scn=0x0000.00000000, seq=1, tail=0x00000b01

block checksum value=0xebd0=60368, flag=4

File Header:

Db Id=0x58a78964=1487374692, Db Name=ORCL, Root Dba=0x0

Software vsn=0x0, Compatibility Vsn=0xb200000, File Size=0x3200=12800 Blocks

File Type=0x3 (data file), File Number=5, Block Size=8192

Tablespace #6 - EXAMPLE rel_fn:5

比较明显数据文件头记录文件大小为12800*8192+8192(block 0)=104865792,而文件系统中显示的文件大小为104865793,不是8192的整数倍。因此出现相关错误DBV-00600: 致命错误 – [21] [5] [0] [0] 或者 DBV-00113(通过mos确认Bug 18232647 – DBVerify reports DBV-600 [21] [5] [0] [0] when datafile size is beyond expected – produce a more meaningful error (Doc ID 18232647.8))