Re: Control Files

From: <mmorgan1_at_mail.tds.net>
Date: 1997/06/05
Message-ID: <865536483.32564@dejanews.com>#1/1

Craig,

If your version of Oracle is late enough (7.0 ??) you can issue the following command:

ALTER DATABASE BACKUP CONTROLFILE TO TRACE; This will dump the contents of your control file to a trace file in your background_dump_dest (or was it user_dump_dest ?) directory. This file will contain all the necessary information for rebuilding your database. You should probably issue the command fairly regularly - at least whenever you change the structure of your database such as adding a file to a tablespace, etc.

As you can probably tell, I'm responding from memory - my manuals are not at hand. If the above information is not exactly correct, I'm sure I'm close.

Whatever you do, DON'T EDIT your control file. Never take a chance that the control files could be corrupted. Without them your database is unaccessible. (I know, I know. the control files are multiplexed which provides redundancy but you know Murphy's Law ...)

Mike

---

In article <01bc71b7$06f3dc10$59204810_at_waltersc1>,   "craig walters" <waltersc_at_mail.dec.com> wrote:

>

> Hi all,
> Is there a utility or way to see what the contents of the Oracle control
> file are? I can see a few things by opening a copy of a control file into
> wordpad, but because of the binary nature, I am not getting a complete
> picture. Any thoughts?
> Thanks,
> craig
> waltersc_at_mail.dec.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Thu Jun 05 1997 - 00:00:00 CDT