Oracle DBVERIFY Command

DBVERIFY is an external command-line utility that performs a physical data structure integrity check. It can be used on offline or online databases, as well on 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.

dbv help=yes


dbv file='D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF' blocksize=8192



DBVERIFY: Release 9.2.0.1.0 - Production on Thu Jan 1 15:13:45 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE =

D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF



DBV-00200: Block, dba 4245143, already marked corrupted



DBVERIFY - Verification complete



Total Pages Examined : 55040

Total Pages Processed (Data) : 38573

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 4901

Total Pages Failing (Index): 0

Total Pages Processed (Other): 1631

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 9935

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

Resize, recreate undo tablespace, ORA-30013, ORA-03297

Resize, recreate undo tablespace.


rem Get rid of these errors.

ERROR at line 1:
ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value



Rem Resize, recreate undo tablespace.



create undo tablespace undotbs2 datafile

'D:\ORACLE\ORA9I\ORADATA\ORA9I\UNDOTBS02.DBF' SIZE 200M REUSE AUTOEXTEND ON;


Rem This tablespace as Undo Tablespace.



alter system set undo_tablespace = undotbs2;

drop tablespace undotbs1 including contents and datafiles;

Rem there is similar procedure to resize, recreate Temp tablespace.