Re: Rename Controlfiles?

Rolf,

I never tried to rename and move the controlfiles before. But I think this will work:

1. backup the controlfile to trace
2. shutdown the database
3. do a cold backup on the database
4. copy the controlfile to the target location with the name you want
5. edit the controlfile and make sure that it point to the directory that you want
6. open the database.

Please do make a backup of your database before you move the controlfiles around. Just in case.

Winnie

Rolf Hauck wrote in message <35DAC56F.1D0F0625_at_datenrevision.de>...
>Hi,
>I'm preparing for a re-installation of my Operating System, together
>with a changed File System Layout. This will include a change of all the
>filenames of our databases. I know about renaming datafiles. But the
>controlfiles also will change their path. Is it safe to just move them
>to the new location and change the names in the init.ora?
>
>This is Ora 7.3.2 on Digital Unix 3.2 (moving to 4.0).
>
>Rolf
Received on Wed Aug 19 1998 - 22:21:35 CDT