Oracle | DBMS_DBVERIFY

Oracle DBMS_DBVERIFY Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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;

            /