Oracle―用户管理的备份（二)(二)
ck (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)
检查数据文件system01.dbf，feedback=100表示检查每100个数据块就打上一个点；默认情况下，检查从一个块开始到最后一个结束；使用logfile可以把检查的结果信息放到一个文件中。 如下：
如[oracle@oracle11g wilson]$ dbv file=system01.dbf feedback=100
DBVERIFY: Release 11.2.0.1.0 - Production on Fri Aug 23 12:37:43 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/oradata/wilson/system01.dbf
................................................................................
................................................................................
.
DBVERIFY - Verification complete
Total Pages Examined : 97280
Total Pages Processed (Data) : 66872
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 12537
Total Pages Failing (Index): 0
Total Pages Processed (Other): 3343
Total Pages Processed (Seg) : 1
Total Pages Failing (Seg) : 0
Total Pages Empty : 14528
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 2828302 (0.2828302)
2.它也可以来用来检查数据文件的一个表或者索引。
在p1用户下有一张表fruit,
SQL> select * from p1.fruit;
NAME
--------------------------------
two apple
在表sys_dba_segs中找到 Segment ID (tsn.relfile.block) 的数值；
SQL> select segment_name,tablespace_id,header_file,header_block from sys_dba_segs where owner='P1';
SEGMENT_NAME TABLESPACE_ID HEADER_FILE HEADER_BLOCK
--------------- --------------- - ----------- ------------
FRUIT 4 4 810
然后在操作
系统下，使用查到的数值，就可以查到某一个表了。
[oracle@oracle11g ~]$ dbv userid=p1/p1_12345 segment_id=4.4.810
DBVERIFY: Release 11.2.0.1.0 - Production on Fri Aug 23 13:25:50 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : SEGMENT_ID = 4.4.810
DBVERIFY - Verification complete
Total Pages Examined : 8
Total Pages Processed (Data) : 5
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 2
Total Pages Processed (Seg) : 1
Total Pages Failing (Seg) : 0
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 2798211 (0.2798211)