Re: Urgrent - Moving instances across machines - Help

Are you trying to move an Oracle instance from HP-UX to SUN-Solaris? If so, what you are doing may not be a smart thing to do. You are moving the files that were created in HP-UX to SUN-Solaris which is a different OS.
If you would like to make a clean move, do a full database export and then do a full database import.

If you still want to try the datafile scenario you mentioned, here is the procedure that I usually follow.

Connect as a DBA into the database you are planning to move and do "alter database backup controlfile to trace". The above statement will generate a readable controlfile in your ORA_DUMP directories.

Shut the database down move all the datafiles listed in the readable controlfile, configuration files (init files) and the redo logs, including the controlfile to your new location or system.

Check your configuration files to see if you have any hard coded paths that are referencing your previous configuration and change them appropriately.

Edit the readable contrilfile to point it to the new location of datafiles. Go to svrmgrl and run the new readable controlfile script. That will start the database up.

Good Luck,
  Kittu.

Krishnan Ranganathan (kaa_at_criinc.com) 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 Wed Oct 01 1997 - 00:00:00 CDT