Re: Help: Moving Control Files

Erik Oosterling writes:

> 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.

No. It must be another error, probably usersided.

If the instance experiences problems with a control file it definitely doesn't start. So far as I know, the init.ora is the only place to change, if one wants to rename a controlfile. The platform I have tested it is SunOS 4.1.3_U1 Oracle7 Server Release 7.2.2.3. No problems with renaming. I did the following steps.

1. Change initSID.ora, replace the old names
2. shutdown the instance
3. mv the files at SunOS
4. startup the instance
5. select * from dba_data_files;

Works, locally and remote. With sqldba and sqlplus. Theory == Praxis Perhaps, you did something more, Gary?

Stephan Witt

<stephan.witt_at_beusen.de>  | "beusen" Software+Systeme GmbH
fon: +49 30 549932-62     | Landsberger Allee 392
fax: +49 30 549932-21     | 12861 Berlin
---------------------------------------------------------------