Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  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.
  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter