Re: coping the control file

Thank you for your reply's your assistance is greatly appreciated.

Keth

On Thu, 5 Oct 2000 09:03:15 +0200, "Lehmann" <Spaceboy_NOoneSPAM_at_hotmail.com> wrote:

>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 - 08:09:38 CDT