Re: How to move a databse from Solaris to Llinux

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).