|
|
|
|
| Re: Using DBVERIFY utility to validate segment? [message #137584 is a reply to message #137575] |
Thu, 15 September 2005 10:46   |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
Sorry mahesh i know you will think it as spoon feeding ...
but i was trying this
dbv USERID=username/password SEGMENT_ID=tsn.segfile.segblock
I dont know so
[1]--->can u tell me what i have to specify at segfile and segblock.
[2]---> One thing more what should be username ?
thanks
sunil
|
|
|
|
| Re: Using DBVERIFY utility to validate segment? [message #137599 is a reply to message #137584] |
Thu, 15 September 2005 11:32 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I should have explained it better.
quoting docs
| Quote: |
USERID
Specifies your username and password.
SEGMENT_ID
Specifies the segment that you want to verify. You can identify the tsn, segfile, and segblock by joining and querying the appropriate data dictionary tables, for example, USER_TABLES and USER_SEGMENTS
|
.
Segment_id is segment you want to examine.
scott@9i > analyze table emp validate structure;
Table analyzed.
scott@9i > !dbv help=y
DBVERIFY: Release 9.2.0.4.0 - Production on Thu Sep 15 12:08:22 2005
Copyright (c) 1982, 2002, Oracle Corporation. 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 (2048)
LOGFILE Output Log (NONE)
FEEDBACK Display Progress (0)
PARFILE Parameter File (NONE)
USERID Username/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)
---
-- THe segment_id information can get obtained from sys_user_segs.
---
scott@9i > !sqlplus "scott/tiger as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 15 12:10:03 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
sys@9i > desc sys_user_segs
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
SEGMENT_NAME VARCHAR2(81)
PARTITION_NAME VARCHAR2(30)
SEGMENT_TYPE VARCHAR2(18)
SEGMENT_TYPE_ID NUMBER
TABLESPACE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BLOCKSIZE NUMBER
HEADER_FILE NUMBER
HEADER_BLOCK NUMBER
BYTES NUMBER
BLOCKS NUMBER
EXTENTS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
BUFFER_POOL_ID NUMBER
SEGMENT_FLAGS NUMBER
SEGMENT_OBJD NUMBER
--
--Or as explained in documentation
--
sys@9i > get dbv
1 select tab.ts#,seg.header_file,seg.header_block
2 from v$tablespace tab,dba_segments seg
3 where seg.segment_name='EMP'
4 and Tab.name=seg.tablespace_name
5* and seg.owner='SCOTT'
sys@9i > /
TS# HEADER_FILE HEADER_BLOCK
---------- ----------- ------------
5 5 11
sys@9i > !dbv userid=scott/tiger segment_id=5.5.11
DBVERIFY: Release 9.2.0.4.0 - Production on Thu Sep 15 12:31:29 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : SEGMENT_ID = 5.5.11
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
