Different oracle dbv between 9i and 10g

最新推荐文章于 2025-08-10 13:24:43 发布

weixin_34319999

最新推荐文章于 2025-08-10 13:24:43 发布

阅读量59

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/weixin_34319999/article/details/85192482

本文对比了Oracle 9i与10g中DBVERIFY工具的功能差异，详细介绍了该工具如何进行离线数据库的物理数据结构完整性检查，适用于备份文件验证及数据损坏诊断。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.