 |
|
DB_VERIFY Utility
Oracle Tips by Burleson
|
In this section I want to cover the DB_VERIFY
utility. The DB_VERIFY utility is an external command line-based
utility that is used to perform a physical structure integrity check
on an offline (shutdown) database. The utility can be used against
backup files and online files or pieces of online files. The utility
is used to ensure a backup database or datafile is valid before
recovery. The utility can also serve as a diagnostic aid when
corruption is suspected.
DB_VERIFY runs against a shutdown database, so
it can perform checks significantly faster than export or other
utilities. Be aware that the utility is named differently on different
platforms; for example, it may be called dbv on Sun, Sequent, Linux,
or NT, or something else on your system. Therefore, verify its name
with the system-specific documentation you should have received (if
you didn’t, call your Oracle rep and complain). The utility only
verifies cache-managed blocks.
The DB_VERIFY utility has the following
general syntax:
DBVERIFY: Release 9.0.1.1.1 - Production on
Sun Mar 3 16:19:05 2002
(c) Copyright 2001 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)
LOCKSIZE 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)where:
FILE. The name of the database file to
verify.
START. The starting block address to
verify. These are Oracle block addresses. If you get an ORA error
giving a file number and block that is corrupted, you can use this to
check that block.
END. The ending block to verify. This
is an Oracle block number.
BLOCKSIZE. The Oracle blocksize if not
2-KB blocks.
LOGFILE. Specifies where logging data
should be kept.
FEEDBACK_DB_VERIFY. Shows a dot for
each n blocks verified.
HELP. Provides on-screen help.
PARFILE. Specifies the name of the file
to read parameters from.
USERID. Specifies the userid and
password
SEGMENTID. Specifies the segment to
verify in the format tsn.relfile.block (tablespace number, relative
file number, and block number).
The following shows an example run of the
DB_VERIFY against an Oracle database file:
C:\>dbv
file=D:\ORACLE\ORADATA\AULTDB1\MILLMT.ORA blocksize=4096
DBVERIFY: Release 9.0.1.1.1 - Production on
Sun Mar 3 16:23:26 2002
(c) Copyright 2001 Oracle Corporation. All
rights reserved.
DBVERIFY -
Verification starting : FILE = D:\ORACLE\ORADATA\AULTDB1\MILLMT.ORA
DBVERIFY -
Verification complete
Total Pages
Examined : 51200
Total Pages Processed (Data) : 45989
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 20
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 5191
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
The following
example shows how to get online help:
% dbv help=y
DBVERIFY:
Release 9.0.1.0.0 - Mon Dec 3 17:09:50 2001
(c) Copyright
2001 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 Userid/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)
This is sample output of verification for the file,
apl_data01.dbf. The feedback parameter has been given the value 100 to
display on-screen 1 dot for every 100 blocks processed:
% dbv
file=apl_data01.dbf feedback=100 blocksize=8192
DBVERIFY: Release Release 9.0.1.0.0 - Mon Dec
3 17:18:32 2001
(c) Copyright 2001 Oracle Corporation. All
rights reserved.
DBVERIFY -
Verification starting : FILE = tools01.dbf
..............................................................
DBVERIFY -
Verification complete
Total Pages
Examined : 1280
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 8
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 1272
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
See
Code Depot for Full Scripts
 |
This is an excerpt
from Mike Ault, bestselling author of "Oracle
10g Grid and Real Application Clusters".
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
|
