Re: Check database consistency

Why don't you just ALTER DATABASE BACKUP CONTROLFILE TO TRACE (from svrmgrl connect as internal) and then look in the file it creates!!! (found somewhere in /tmp or wherever user_dump_dest is pointing to).

Beware though that the output file will be called something completly weird (I have just done one and it is called ora_15903.trc) easiest way to find it is to grep for your SID in all *.trc files.

<markp7832_at_my-deja.com> wrote in message news:864jta$6rs$1_at_nnrp1.deja.com...
> 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 - 11:40:22 CST