RE: How to move a database from Solaris to Linux

Reinhold,

I am afraid export import is the only way to migrate the database from one Operating system to another operating Systems and oracle data files are not compatible across various operating systems (with a single exception of Solaris-HPUX)

If you are using Solaris (or HP UX) you can copy the data files to HP UX( to Solaris if you use HP) and recreate the control files and you can open the database. I don't know Oracle Support's stand on this type of migration.

I am developing a tool which will do the migration from one operating system to another operating system (Basically it will read block by block and write to the another operating system file format) and you can copy (or binary FTP) the file to the target operating system and recreate the control file and you are set to go

I don't have much experience in DB/2 and I can not comment about that compatibility issues in DB/2. But different operating systems uses different file formats to store the data and oracle also has to follow the rules to read/write the data files in those operating systems.

If you have after interconnect (read GB n/w) you can copy the tables over dblink and this will be much faster than conventional export and Import. I don't have the exact figures .. but this will reduce the downtime if you have faster interconnect.

Why don't you file an enhancement request with oracle seeking this ? :-)

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

-----Original Message-----
Wagner
Sent: Thursday, September 20, 2001 1:00 AM To: Multiple recipients of list ORACLE-L

Christopher,

i don't consider Solaris and Linux as different OS. IMO they are at least similar if not equal from the DBMS point of view. I don't see any reason why the data files should be different on Solaris, Linux or any other UNIX OS.

I know from DB/2 that the data files are binary compatible on all OS and I can't believe that's not true for Oracle.

regards

Reinhold

Christopher Spence wrote:

> You cannot move data files from one OS to a different one due to the
> differences in how they write to files.
>
> Import and Export is generally the accepted way to do this.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax: (707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
>
> -----Original Message-----
> Sent: Wednesday, September 19, 2001 12:47 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi all,
>
> we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux.
> We tried a simple restore of the database files from the last offline
> backup (tape) as we did it many times between equal systems.
>
> After creating the new control file on the target system the database
> could not be started, becaue Oracle thinks that the system data file
> isn't really a data file!
>
> This means i have to do an export/import! I assume an export time of
> round about 10 hrs. Is there any easier way?
>
> TIA
>
> Reinhold Wagner
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reinhold Wagner
  INET: rwagner_at_zeunastaerker.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).