# Different oracle dbv between 9i and 10g

+关注继续查看
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 .

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.

Larry.Yue

9964 0

26761 0

13723 0
windows server 2008阿里云ECS服务器安全设置

9135 0

4645 0

4443 0

7315 0
+关注
5489

0

《2021云上架构与运维峰会演讲合集》

《零基础CSS入门教程》

《零基础HTML入门教程》