« Oracle9i到10g,空闲等待事件的变化 | Blog首页 | Windows Live Messenger可以自由申请 »
dbv能用来检查日志文件么?
作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】链接：http://www.eygle.com/archives/2006/04/dbv_check_datafiles.html
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)
|
Oracle官方文档地址:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/dbverify.htm
存此备忘.
历史上的今天...
>> 2007-04-18文章:
>> 2005-04-18文章:
------
这篇 【dbv能用来检查日志文件么?】来自 eygle.com | CSDN网摘| del.icio.us|Google订阅 | 鲜果订阅 | 抓虾订阅
By eygle on 2006-04-18 17:01 | Comments (3) | Posted to FAQ | Edit |
留言 (3)
老大,您的网站能不能不挂这种减肥的广告呢,放一些it广告也行啊,搞的上班的时候不敢看,经理看见以为我在看黄色网站
Posted by: client at November 21, 2008 3:51 PM
晕，这是阿里妈妈的选择，我把图片允许去掉了，只允许文字链。
过几天也许都删除了，广告没有收益！
Posted by: eygle at November 21, 2008 4:01 PM
我早就说过了...
Posted by: Julia at November 21, 2008 4:06 PM