dbv能用来检查日志文件吗
添加时间: 2008-4-23 22:56:04 作者: Oracle指导 阅读次数:15 来源: http://www.d9soft.com
Oracle提供命令行工具DBV用来 检查 数据文件的完好性.
那么DBV可以用来检查日志文件么?
答案是不能.
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) |
上下文章:
上一篇文章: 开发技术:调查您的应用程序需求 下一篇文章: 索引与Null值对Hints及执行计划的影响
相关文章: