Re: Check integrity of database !!!

dbverify (run as dbv from the command prompt).

Works on all data files, whether hot or cold. Also works on Control Files (rather to my surprise, and in direct contradiction of the Oracle documentation).

dbv file=/bing/bong/blah.dbf blocksize=8192 (or whatever blocksize you've actually got).

Detailed instructions on my web site, tips, backup and recovery, article on checking backups for corruption (but as I say, it's just as good on live databases).

There are also some init.ora parameters you can use to keep data files in good condition (DB_BLOCK_CHECKING). Do not touch DB_BLOCK_CHECKSUM with a barge pole if you value performance. But they only check data files, and I'm not comfortable that the performance overhead even with ...CHECKING is totally insignificant.

You can also use log miner to analyze online redo logs. If it detects corruption, it will bomb out with fireworks and warnings.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Đuro Dretvić" <Djuro.Dretvic_at_Infodom.hr> wrote in message
news:9rodp3$bj6$1_at_sunce.iskon.hr...


> Dear all

>

> Question:

>

> How to check database integrity  on RDBMS 8.1.7 installed on  Windows NT

> 2000 operating system.

>

> I want to check is there coruption on data block etc, and I want to check

> complete database.

> Are there any tool to perform that operation.

>

> Thanks.

>

> Regards D.

>

>