Re: Database Integrity

In article <388eb7d1_at_eeyore.callnetuk.com>,   "Robert Francis" <robert_at_kita.co.uk> wrote:
> Is there any method / tool of measuring the integrity of a database?
>
> Any responses will be gratefully welcomed
>
> From a worried student
>
> Robert
>

The answer depends on what you mean by integrity. Every time Oracle starts it checks the file headers to be sure every data file and the control file are at the same checkpoint, i.e., that the entire database is at one consistent point in time. If it is not Oracle checks the on- line redo logs for the necessary information and applies it as in the case of instance recovery or issues a media recovery error in the case where datafiles can not be accessed or have old header information.

The above is a simplified explanation of database integrity but you can still have data integrity problems depending on how your applications are designed.

You can use the dbverify (dbv on many UNIX platforms) utility to check the validity of database files and backups. It is described in the Utilities manual.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 11:46:25 CST