Re: 7.1.6 -> 7.3.4 -> 8.0.5

Hi Joe,

   Moving the controlfiles is very easy. Assume that u have only 2 controlfiles named /home/oracle/cf1.ctl and /home/oracle/cf2.ctl and you wish to move them to /home1/oracle/cf1.ctl and /home2/oracle/cf2.ctl.

   Follow the foll steps:

1. Check out where your controlfiles are by checking the v$controlfile view (login as SYS for this). Assume that u have only 2 controlfiles named /home/oracle/cf1.ctl and /home/oracle/cf2.ctl.
2. In your init.ora or config.ora file, locate an entry called CONTROL_FILES=/home/oracle/cf1.ctl, /home/oracle/cf2.ctl. These will correspond to the values you got in step 1.
3. Shutdown your database.
4. Copy one of the controlfiles from above into the new locations you want. Assume that you wish to move them to /home1/oracle/cf1.ctl and /home2/oracle/cf2.ctl eg : /home/oracle/cf1.ctl. Then copy one of the original controlfiles into the new destinations with the appropriate names.
5. Modify the entry in your parameter file to point to the new locations and the new files : CONTROL_FILES=/home1/oracle/cf1.ctl, /home2/oracle/cf2.ctl.
6. Start up your database and recheck the v$controlfile view.

   A word of advice, keep one copy of your controlfiles and logfiles outside the RAID array too, just in case something goes wrong in the Array especially if u have a hardware-based RAID system (I faced this once).

HTH,
Chetan
Bangalore, India

Joe M. wrote in message <7s8sv9$7r$1_at_nnrp1.deja.com>...
>Thanks, that worked and also git rid of my "cannot allocate new log"
>error. How do I go about moving the control files? I'm new at this but
>the person I took over from installed everything into /home/oracle. I
>am trying to move everything off the intenal drives and to the RAID
>array. Next I'm going to reinstall Oracle 7.1.6 on a seperate HP9000
>test system and practice the upgrade to 7.3.4 then 8.0.5.
>When I do perform the upgrade from 7.1.6->7.3.4->8.0.5 on my production
>box I plan to be OFA compliant (or as close as possible).
>
>
>Thanks again,
>JM
>
>In article <37E67B8B.D6988C88_at_excite.com>,
> Thiru <tmgn_at_excite.com> wrote:
>>
>> >Alter Database Add Logfile Group 4 'file path' size 32m;
>> will add a Redolog file . You can thus add files to handle your
>current
>> transaction with increased size and then drop the existing ( inactive)
>ones
>> with Smaller Size using
>> >Alter system switch logfile ; # this can be used to cycle the
>redo log
>> files
>> > Select * from v$log; # to show the status of the log
>groups
>> >Alter DAtabase drop logfile group 1;
>> etc
>>
>> The 'file path' may have a new location ..this will move U'r location
>of the
>> redo logs..
>>
>> Hope this helps..
>>
>> -Thiru
>>
>> "Joe M." wrote:
>>
>> > How do you add more or increase the size of the redo logs? Also, I
>have
>> > moved the location of some tablespaces to reduce contention but how
>do I
>> > move the location of the redo logs?
>> >
>> > Thanks,
>> > jm
>> >
>> > Sent via Deja.com http://www.deja.com/
>> > Share what you know. Learn what you don't.
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Sep 23 1999 - 00:12:47 CDT