Re: coping the control file

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.