Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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.Received on Thu Oct 05 2000 - 09:10:18 CDT
![]() |
![]() |