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 - 10:59:11 CDT