Re: Help: Moving Control Files

On Wed, 11 Dec 1996 16:01:47 GMT, Gary Meyers <gmeyers_at_arco.com> wrote:

>Particulars: Solaris 2.5, Sparcstation 20, Oracle v7.2.3.0.0
>
>I need to move 2 of my 3 control files.
>(Following the Oracle 7 Server Administrators Guide)
>After shutting down the
>database and exiting SQL*DBA, I copied 2 of my 3 control files to
>new locations, renamed the originals, and changed the control file
>locations in configprod.ora (which is, of course, pointed to by
>initprod.ora, "prod" being the SID)
>
>I restarted the instance (which came up fine). Then in sqlplus, I said
>
>select * from dba_data_files;
>
>and get:
>SQL> select * from dba_data_files;
>ERROR:
>ORA-00210: cannot open control file
>'/export/edwardd01/oracle/data/prod/cntrl2prod.cntl'
>ORA-07368: sfofi: open error, unable to open database file.
>SVR4 Error: 2: No such file or directory
>
>
>The pathname above is my OLD pathname, and IS NOT what's in
>configprod.ora.
>
>I can find no ref. in the manuals regarding renaming the control file
>in the database--only OS renames/moves are indicated, as well as the
>changes in configSID.ora.
>
>Any help is appreciated.

Hi Gary,

I believe you have to put the logfiles first offline. Received on Thu Dec 19 1996 - 00:00:00 CST