Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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;