When I read the document of oracle 9i (Oracle9i Database Utilities Release 2 (9.2) Part Number A96652-01 ),I found the different function of dbv between 9i and 10g.
Now , let's look at the de.ion of dbv in oracle 9i document .
In fact , dbv in oracle 9i can use a .line database.But
Actually ,there is a different(10g ):
Now,the dbv maybe make a little progress in 10g -:),and ,for caution's sake,you just can use dbv of oracle 9i against a offline database(cold datafiles).
Now , let's look at the de.ion of dbv in oracle 9i document .
DBVERIFY is an external command-line utility that performs a physical data structure integrity check .
an offline database. It can be used against backup files and .line files (or pieces of files). You use DBVERIFY primarily when you need to ensure that a backup database (or datafile) is valid before it is restored or as a diagnostic aid when you have encountered data corruption problems.
Because DBVERIFY can be run against an offline database, integrity checks are significantly faster.
Because DBVERIFY can be run against an offline database, integrity checks are significantly faster.
In fact , dbv in oracle 9i can use a .line database.But
Although it can be used against open data files, the primary purpose of dbv is to verify the integrity of cold datafiles that would be used for a backup.
If used against .line datafiles, intermittent errors can occur and the utility should be executed again against the same file to verify accuracy.
Actually ,there is a different(10g ):
DBVERIFY is an external command-line utility that performs a physical data structure integrity check.
It can be used . offline or .line databases, as well . backup files. You use DBVERIFY primarily when you need to ensure that a backup database (or datafile) is valid before it is restored, or as a diagnostic aid when you have encountered data corruption problems.
Because DBVERIFY can be run against an offline database, integrity checks are significantly faster.
Because DBVERIFY can be run against an offline database, integrity checks are significantly faster.
Now,the dbv maybe make a little progress in 10g -:),and ,for caution's sake,you just can use dbv of oracle 9i against a offline database(cold datafiles).
DBAs should automate and execute the dbv utility . a regular basis.
本文转自Be the miracle!博客51CTO博客，原文链接http://blog.51cto.com/miracle/127659如需转载请自行联系原作者
Larry.Yue
