[20160719]关于dbv使用问题2.txt
$ dbv help=y
DBVERIFY: Release 11.2.0.4.0 - Production on Tue Jul 19 11:08:58 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. 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)
--再看看看SEGMENT_ID参数。按照帮助提示Segment ID 由 (tsn.relfile.block)组成,表空间号.相对文件号.块号。
--实际上帮助并没有讲清楚block是指段的块头。通过例子来说明:
SEGMENT_ID => Specifies the segment that we want to verify. It is composed of the tablespace ID number (tsn), segment
header file number (segfile), and segment header block number (segblock). We can get this information from
SYS_USER_SEGS.
1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------- -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
create table t as select * from dba_objects;
2.要完整的获得tsn.relfile.block信息,必须查询SYS_DBA_SEGS视图,注意这个视图没用定义同义词,必须要schema=sys.
SELECT * FROM sys.SYS_DBA_SEGS WHERE SEGMENT_NAME = 'T' and owner='SCOTT';
Record View
As of: 2016/7/19 11:00:23
OWNER: SCOTT
SEGMENT_NAME: T
PARTITION_NAME:
SEGMENT_TYPE: TABLE
SEGMENT_TYPE_ID: 5
SEGMENT_SUBTYPE: ASSM
TABLESPACE_ID: 4
TABLESPACE_NAME: USERS
BLOCKSIZE: 8192
HEADER_FILE: 4
HEADER_BLOCK: 562
BYTES: 10485760
BLOCKS: 1280
EXTENTS: 25
INITIAL_EXTENT: 65536
NEXT_EXTENT: 1048576
MIN_EXTENTS: 1
MAX_EXTENTS: 2147483645
MAX_SIZE: 2147483645
RETENTION:
MINRETENTION:
PCT_INCREASE:
FREELISTS:
FREELIST_GROUPS:
RELATIVE_FNO: 4
BUFFER_POOL_ID: 0
FLASH_CACHE: 0
CELL_FLASH_CACHE: 0
SEGMENT_FLAGS: 4325633
SEGMENT_OBJD: 95295
SCOTT@book> SELECT TABLESPACE_ID, HEADER_FILE, HEADER_BLOCK FROM SYS.SYS_DBA_SEGS WHERE SEGMENT_NAME = 'T' and owner='SCOTT';
TABLESPACE_ID HEADER_FILE HEADER_BLOCK
------------- ----------- ------------
4 4 562
SCOTT@book> @ &r/desc dba_segments
Name Null? Type
----------------- -------- ---------------
1 OWNER VARCHAR2(30)
2 SEGMENT_NAME VARCHAR2(81)
3 PARTITION_NAME VARCHAR2(30)
4 SEGMENT_TYPE VARCHAR2(18)
5 SEGMENT_SUBTYPE VARCHAR2(10)
6 TABLESPACE_NAME VARCHAR2(30)
7 HEADER_FILE NUMBER
8 HEADER_BLOCK NUMBER
9 BYTES NUMBER
10 BLOCKS NUMBER
11 EXTENTS NUMBER
12 INITIAL_EXTENT NUMBER
13 NEXT_EXTENT NUMBER
14 MIN_EXTENTS NUMBER
15 MAX_EXTENTS NUMBER
16 MAX_SIZE NUMBER
17 RETENTION VARCHAR2(7)
18 MINRETENTION NUMBER
19 PCT_INCREASE NUMBER
20 FREELISTS NUMBER
21 FREELIST_GROUPS NUMBER
22 RELATIVE_FNO NUMBER
23 BUFFER_POOL VARCHAR2(7)
24 FLASH_CACHE VARCHAR2(7)
25 CELL_FLASH_CACHE VARCHAR2(7)
-- 而这个视图显示的表空间名,而非表空间的TS#.
3.测试dbv:
$ dbv userid=scott/book segment_id=4.4.562
DBVERIFY: Release 11.2.0.4.0 - Production on Tue Jul 19 11:21:23 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : SEGMENT_ID = 4.4.562
DBVERIFY - Verification complete
Total Pages Examined : 1280
Total Pages Processed (Data) : 1252
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 27
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 : 359590069 (3.359590069)
--//很清楚显示该段T占用1280块。数据块1252.
--//1252+27+1=1280
$ dbv userid=scott/book segment_id=4.4.563
DBVERIFY: Release 11.2.0.4.0 - Production on Tue Jul 19 11:21:27 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : SEGMENT_ID = 4.4.563
Specified SEGMENT_ID does not exist