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))