Re: Moving an Oracle 7 installation

Duh! Brain dead this morning - I mentioned the controlfile was opened at mount stage and then said nomount, which is clearly incorrect. Thanks for picking this up.

Pete

gollum_at_image.dk wrote:

> Correction:
>
> The database needs to be mounted, since we are modifying the
> contents of the controlfile, ie.
>
> SVRMGR> connect internal
> SVRMGR> startup mount
> SVRMGR> alter database rename file....;
>
> Another approach more suitable for lots of datafiles is
> to create a new controlfile, ie.
>
> SVRMGR> connect internal
> SVRMGR> startup mount
> SVRMGR> alter database backup controlfile to trace;
>
> find and edit the generated trace-file in user_dump_dest,
> so that the file locations are correct (and remember to
> remove the trace header), shutdown the instance and
> simply run the trace-file, ie.
>
> SVRMGR> shutdown (immediate)
> SVRMGR> @<trace-file>
>
> Cheers,
> Jesper
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 03-09-99, 17:59:11, Pete Sharman <psharman_at_us.oracle.com> wrote
> regarding Re: Moving an Oracle 7 installation:
>
> > Stephan
>
> > Oracle stores the location of the datafiles and redo logs in the
> control
> > file. The control file is opened at the mount stage, and the location
> of
> > the files checked at the open stage. So what you need to do is this:
>
> > startup nomount;
> > alter database rename file 'old_file_location_and_name' to
> > 'new_file_location_and_name';
>
> > for each file (check the syntax in the SQL Reference manual - I'm
> typing off
> > the top of my head here).
>
> > HTH.
>
> > Pete
>
> > Stephan Marwedel wrote:
>
> > > Hi,
> > >
> > > I want to move an existing Oracle 7 installation on AIX
> > > (/usr/local/oracle) from to another filesystem (/opt/oracle). What
> must
> > > I change in the configuration do achive this? I changed the init.ora
> for
> > > my instance and all startup variables for the oracle dba user, but the
> > > server stills complains about a missing database file (.dbf), which is
> > > seems to search for in the old location:
> > >
> > > SVRMGR> startup
> > > ORACLE instance started.
> > > Total System Global Area 4938876 bytes
> > > Fixed Size 48124 bytes
> > > Variable Size 4055168 bytes
> > > Database Buffers 819200 bytes
> > > Redo Buffers 16384 bytes
> > > Database mounted.
> > > ORA-01157: cannot identify data file 1 - file not found
> > > ORA-01110: data file 1: '/usr/local/oracle/dbs/systTC_ORA2.dbf'
> > >
> > > So far I only got the server up again by linking the new location the
> > > the old.
> > >
> > > Any hints?
> > >
> > > Thanks in advance.
> > >
> > > Stephan
> > >
> > > --
> > > --------------------------------------------------
> > > Stephan Marwedel, Object Technology Group
> > > THALES Communication GmbH, Hamburg, Germany
> > > Email: marwedel_at_thales.de
> > > Web: http://www.thales.de
> > >
> > > -> This message was created 100% Micro$oft free <-
> > > --------------------------------------------------

Received on Fri Sep 03 1999 - 14:45:00 CDT