dbv能用来检查日志文件吗

文章作者 100test 发表时间 2007:03:14 13:47:36
来源 100Test.Com百考试题网

oracle提供命令行工具dbv用来检查数据文件的完好性.
那么dbv可以用来检查日志文件么?aE3 .?2_\. ’w]" ^[本资料来源于贵州学习网 http://www.gzu521.com]aE3 .?2_\. ’w]" ^
答案是不能.
oracle在文档中这样描述dbv工具:
dbverify is an external command-line utility that performs a physical data structure integrity check. it can be used on offline or online databases, as well on backup files.
dbverify checks are limited to cache-managed blocks (that is, data blocks). because dbverify is only for use with datafiles, it will not work against control files or redo logs.
再次注意到读文档是有好处的,以前并不知道dbv可以直接用来针对数据段进行检查,引用一个文档中的例子:
这是命令格式:
dbv userid=username/password segment_id=tsn.segfile.segblock

假定hr用户具有sysdba权限,执行:
dbv userid=hr/hr segment_id=1.2.67

输出如下:
dbverify - verification starting : segment_id = 1.2.67
dbverify - verification complete
total pages examined : 8
total pages processed (data) : 0
total pages failing (data) : 0
total pages processed (index): 1
total pages failing (index): 0
total pages processed (other): 2
total pages processed (seg) : 1
total pages failing (seg) : 0
total pages empty : 4
total pages marked corrupt : 0
total pages influx : 0
highest block scn : 7358 (0.7358)