Re: Check database consistency

In article <3885C0D0.55C3616B_at_steria.fr>,   Alain Martinez <alain.martinez_at_steria.fr> wrote:
> Il s'agit d'un message multivolet au format MIME.
> --------------4EC8E014BE06B1E41811B0F7
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi,
> I need to check consistency between my database and creation files.
> My database has been created a long time ago. A lot of evolution have
> been made with upgrade scripts. But I don't know if every upgrades
have
> been written in my creation scripts.
>
> Do you have any idea to compare my creation files with my database ?
>
> email;internet:alain.MARTINEZ_at_steria.fr
> fn:alain MARTINEZ
> end:vcard
>

Pretty much everything you need can be found by querying v$controlfile
v$logfile
sys.dba_tablespaces
sys.dba_data_files

I do not have a fancy script to regen a create database script but checking the spool files from queries on the above against our creation script for a 100 files database only took 10 minutes to verify every tablespace, its default parameters, and all files were accounted for.

--
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 19 2000 - 09:06:31 CST