Oracle | DBMS_DBVERIFY

Oracle DBMS_DBVERIFY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Internal API to the DBV executable for database datafile integrity verification

AUTHID CURRENT_USER

Dependencies

STANDARD (only)

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsdbv.sql

DBV2

Verify data file integrity

Note: Any information on how to interpret the output will be greatly appreciated. dbms_dbverify.dbv2( fname IN VARCHAR2, start_blk IN BINARY_INTEGER, end_blk IN BINARY_INTEGER, blocksize IN BINARY_INTEGER, output IN OUT VARCHAR2, error IN OUT VARCHAR2, stats IN OUT VARCHAR2);

conn sys@pdbdev as sysdba

      

      col name format a30

      col value format a30

      

      SELECT name, value

      FROM gv$parameter

      WHERE name LIKE '%block%';

      

      NAME                           VALUE

      ------------------------------ ------------------------------

      db_block_buffers                0

      db_block_checksum               TYPICAL

      db_block_size                   8192

      db_file_multiblock_read_count   128

      db_block_checking               FALSE

      

      conn sys@pdbdev as sysdba

      

      SELECT file_name, tablespace_name

      FROM dba_data_files

      ORDER BY 2,1;

      

      FILE_NAME                                                    TABLESPACE_NAME

      ------------------------------------------------------------ ---------------

      C:\APP\ORACLE\ORADATA\ORABASE2\ORCL\EXAMPLE01.DBF            EXAMPLE

      C:\APP\ORACLE\ORADATA\ORABASE2\ORCL\SYSAUX01.DBF             SYSAUX

      C:\APP\ORACLE\ORADATA\ORABASE2\ORCL\SYSTEM01.DBF             SYSTEM

      C:\APP\ORACLE\ORADATA\ORABASE2\ORCL\SAMPLE_SCHEMA_USERS01.DB USERS

      

      SELECT MIN(dbms_rowid.rowid_block_number(rowid)) MINBLOCK

      FROM sh.sales;

      

        MINBLOCK

      ----------

            6290

      

      SELECT MAX(dbms_rowid.rowid_block_number(rowid)) MAXBLOCK

      FROM sh.sales;

      

        MAXBLOCK

      ----------

           21761

      

      set serveroutput on

      
        
          DECLARE

             lOut   VARCHAR2(4000);

             lErr   VARCHAR2(4000);

             lStats VARCHAR2(4000);

            BEGIN

              dbms_dbverify.dbv2('c:\oracle\oradata\pdbdev\example01.dbf', 6290, 21761, 8192, lOut, lErr, lStats);

            

              dbms_output.put_line('Output: ' || lOut);

              dbms_output.put_line('Error:  ' || lErr);

              dbms_output.put_line('Stats:  ' || lStats);

            END;

            /