当前位置:
首页 >
oracle dbv使用详解
发布时间:2024/8/26
36
豆豆
生活随笔
收集整理的这篇文章主要介绍了
oracle dbv使用详解
小编觉得挺不错的,现在分享给大家,帮大家做个参考.
DBV的意思是,数据库验证(database verify),我们可以使用它来验证数据库的一个文件是否有问题,例如 :
dbv file = /u01/app/oracle/10.2.4.0/JXDX_ODS/oradata/system01.dbf
就可以了。
在命令行模式下输入 BDV就会显示如下信息
[xiong.qiang@localhost ~]$ dbv
DBVERIFY: Release 10.2.0.1.0 - Production on Thu Aug 7 02:18:40 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Keyword Description (Default)
----------------------------------------------------
FILE File to Verify (NONE)
START Start Block (First Block of File)
END End Block (Last Block of File)
BLOCKSIZE Logical Block Size (8192)
LOGFILE Output Log (NONE)
FEEDBACK Display Progress (0)
PARFILE Parameter File (NONE)
USERID Username/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)
HIGH_SCN Highest Block SCN To Verify (NONE)
(scn_wrap.scn_base OR scn) 都能看懂了是吧!以后再写点 DBVERIFY: Release 10.2.0.4.0 - Production on Thu Aug 7 02:38:11 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/xiongqiang/test_200805_01.dbf
DBVERIFY - Verification complete Total Pages Examined : 128
Total Pages Processed (Data) : 18
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 19
Total Pages Failing (Index): 0
Total Pages Processed (Other): 30
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 61
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 575372 (0.575372)
----------------------------------------------------
FILE File to Verify (NONE)
START Start Block (First Block of File)
END End Block (Last Block of File)
BLOCKSIZE Logical Block Size (8192)
LOGFILE Output Log (NONE)
FEEDBACK Display Progress (0)
PARFILE Parameter File (NONE)
USERID Username/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)
HIGH_SCN Highest Block SCN To Verify (NONE)
(scn_wrap.scn_base OR scn) 都能看懂了是吧!以后再写点 DBVERIFY: Release 10.2.0.4.0 - Production on Thu Aug 7 02:38:11 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/xiongqiang/test_200805_01.dbf
DBVERIFY - Verification complete Total Pages Examined : 128
Total Pages Processed (Data) : 18
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 19
Total Pages Failing (Index): 0
Total Pages Processed (Other): 30
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 61
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 575372 (0.575372)
总结
以上是生活随笔为你收集整理的oracle dbv使用详解的全部内容,希望文章能够帮你解决所遇到的问题。
- 上一篇: oracle错误号大全(查询ora错误号
- 下一篇: 一步一步学DataGuard之基础篇