Different oracle dbv between 9i and 10g-Be the miracle!
When I read the document of oracle 9i (Oracle9i Database Utilities> 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.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.
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.
页:
[1]