dbv检查数据文件与backup validate check得到的块数不等

laobu

某数据库11.2.0.3+aix5.3+raw
意外发现其中一个数据文件用dbv检查，和用backup validate check logical datafile检查，得到的块数不等，基本差一半
该裸设备约8G，dbv只认了约4G，而其上分配的extents已经超过了6G
发现这个现象已经有两个月了，而数据访问一切正常
这可能是什么缘故呢？

>dbv file=rlv_8g_data15 blocksize=8192
DBVERIFY: Release 11.2.0.3.0 - Production on Thu Jan 24 17:35:17 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
DBVERIFY - Verification starting : FILE = /dev/rlv_8g_data15
DBVERIFY - Verification complete

Total Pages Examined         : 524288  注意这里是524288
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 519295
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 3691
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1302
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 3821080943 (2808.3821080943)



RMAN> backup validate check logical datafile 19;
Starting backup at 24-JAN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1301 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00019 name=/dev/rlv_8g_data15
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19   OK     0              219227       1048320         12064098379692  注意这里是1048320
  File Name: /dev/rlv_8g_data15
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              824384         
  Other      0              4709            
Finished backup at 24-JAN-13

Select * from v$database_block_corruption ;
no rows selected

laobu

select BYTES/8192 from v$datafile where FILE#=19;
BYTES/8192
----------
   1048320
瞧，这个数字是对的，跟backup check得到的一致

laobu

终于解决了，请参考360032.1
SQL> select bytes from dba_data_files where file_id=19;
BYTES
----------
8587837440
SQL>alter database datafile 19 resize 8587837441;
Database altered.
SQL>alter database datafile 19 resize 8587837440;
Database altered.

$ dbv file=/dev/rlv_8g_data15
DBVERIFY: Release 11.2.0.3.0 - Production on Wed Jan 30 17:57:41 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /dev/rlv_8g_data15
DBVERIFY - Verification complete
Total Pages Examined : 1048320  =======>终于正常了
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 854336
Total Pages Failing (Index): 0
Total Pages Processed (Other): 4797
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 189187
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 279064813 (2809.279064813)