Re: Working with the Control Files

In article <uOO3QqqLAHA.330_at_net025s>,
  "Reinier" <Reinier_Dickhout_at_hetnet.nl> wrote:
> I'm not totally sure on this one, but if you could copy it then
 definitly
> not when the database is up and running. If you change the location
 of the
> control-file you have to change the initSID.ora since there's where
 the
> location of your control-files is described. The control-file itself,
> contains among other things the location of database- and redolog
 files, so
> you don't want to move these without altering your control files the
 right
> way (which is the ORACLE-ALTER way)
>
> Hope this answers your question.
>
> Reinier.
>
> Keth <kslaton_at_newsguy.com> wrote in message
> news:hnpntsokb8k1bfj62uenb8nia60no80l50_at_4ax.com...
> > 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
>
>

Copying the control file or files would NOT change their location as far as Oracle is concerned since the original files would remain in their original locations.

As far as I know the control file is not "human-readable"; issue an 'alter database backup controlfile to trace;' command and read the generated trace file, found in the location defined by 'user_dump_dest' in your init<SID>.ora file (or query v$parameter for the value). This is probably the closest you will come to a "human-readable" control file.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.