Re: coping the control file

The 'alter datbase backup controlfile to trace' command is the way to go if you want a readable controlfile. What you get in the trace catalog is a "create database" command which includes references to all the redologs and datafiles with reuse clauses. Try it and look - no harm done by this ;-) A good idea is to do this every time you change the phy. state of your database (eg. adding a new datafile).
You use this script if you need to create a new set of controlfiles. If your goal is to dublicate the existing controlfile to gain security through redundance - shutdown the DB and copy the controlfile to a new phy. disk and insert the path into the control_file line of init<SID>.ora and then restart the db.

Hope this helps you
Lehmann

"Atta ur-Rehman" <atta707_at_my-deja.com> wrote in message news:8rgvkq$975$1_at_nnrp1.deja.com...
> if by system maintenance you mean the full database 'cold backup' then
> you copy the control file to the back media along with your data and
> redo log files when you've shut down you instance.
>
> if you want to be able to recreate a lost control file you'd use
> the 'alter datbase backup controlfile to trace' command and save the
> resultant output as script to recreate the control file if you lose all
> the multiplexed control files.
>
> and if you're running NT, you won't be able to copy the control file
> while your database is open, that's a sharing voilatoin for NT. I'm not
> really sure about UNIX.
>
>
> In article <mqontssg1s7siqd6dj7k4t322q0opu3vuk_at_4ax.com>,
> Keth Slaton <kslaton_at_newsguy.com> wrote:
> > Could there ever be a competent newbe question? Oh well
> >
> > My question is this when working with control files I understand that
> > I must use the alter database command to create a human readable text
> > file. But would it be possible to just copy the file from one
> > directory to another? Oh and would I need to do this durning system
> > maintenance or could I copy the file at anytime.
> >
> > Thanks in advance
> >
>
> --
>
> getting the meanin' of data...
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 05 2000 - 02:03:15 CDT