O'Reilly logo

Oracle Utilities Pocket Reference by Sanjay Mishra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

dbv

Use dbv (DB Verify) to validate the physical structure of the datafiles of a database. You can use dbv to ensure that a backup is valid or to check data block corruption. dbv can also be used against an online database, an offline database, or on the datafile backups. dbv can check the validity of datafiles only, and not the redo log or control files.

When run against open files, dbv may return incorrect results when it encounters blocks that are being updated. In such cases, use exp to ensure that the data blocks are readable and consistent. For this reason, dbv is most useful against cold backups of datafiles.

Syntax

The dbv utility can be invoked to validate the structure of either a single datafile or a single segment (the segment may be spread across multiple datafiles). Use the following syntax:

dbv [paramval [paramval...]

paramval ::= parameter=one_value}

parameter ::= {
     userid=userid/password[@net_service_name]
    |file=data_file_with_directory
    |start=block_address
    |end=block_address
    |blocksize=size_in_bytes
    |logfile=file_name
    |feedback=n
    |parfile=parameter_file_name
    |segment_id=segment_id }

Parameters

userid=userid/password[@net_service_name]

Specifies the userid, password, and (optionally) the net service name for the Oracle instance to which to connect. You need to specify this parameter if you use Automatic Storage Management (ASM) or specify the segment_id parameter.

file=data_file_with_directory

Specifies the name of the datafile you want to verify. You need to specify ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required