Re: Urgrent - Moving instances across machines - Help

are you sure you can just copy the files? have you tried to export/import the database?

Krishnan Ranganathan wrote:
>
> Hi
>
> I have to move an oracle instance across machines. Following are the steps
> I have done.
> 1. I created a database instance on sun-solaris. The datafiles were placed
> in a directory /export/02/data. The oracle version installed on the sun is
> 7.3.2.1.
> 2. I took a tar backup of the data directory and moved it to a another
> server ( HP-UX )
> 3. I exploded the tar file under /export/02 on the new server. I copied the
> respective
> init(ORACLE_SID).ora and the config(ORACLE_SID).ora from the sun box to
> HP-UX
> box under the $ORACLE_HOME/dbs directory.
> 4. I set the env variable ORACLE_SID to the same instance id as the solaris
> one.
> 5. On starting the instance using the svrmgrl ( The oracle instance on the
> HP-UX ) is
> 7.3.3, i got the error :
> ora-00205 - Error in identifying the control file.The control file
> names are there and the file permisions are OK. I do not understand this ?
> 6. I commented those control files which were not being identified and
> restarted the instance. Now i get the error message :
> ora - 00201 : Control file version incompatible with oracle version.
>
> I have 3 control files , 2 of them came with the error, unable to identify
Received on Tue Oct 07 1997 - 00:00:00 CDT