Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copying a DB from NT to Linux occurs a ORA-01516

Re: Copying a DB from NT to Linux occurs a ORA-01516

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Tue, 21 Aug 2001 14:43:59 -0700
Message-ID: <UKAg7.144$8x6.31199@inet16.us.oracle.com>


Just because you can mount the database doesn't mean a thing. When Oracle does a STARTUP MOUNT, all it does is open the control file - it doesn't attempt to access the datafiles themselves. Niall is in fact correct. The datafiles are NOT useful, because Linux and NT files are different binary beasties. There is no way to copy files from one OS to another and start the database. You will need to export the NT database and import it into the Linux one after doing a binary ftp of the dump file.

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"Kristian Kalweit" <k.kalweit_at_gmx.de> wrote in message
news:9ltmnb$eav$1_at_newsread2.nexgo.de...

> But I can mount the database so, the control files doesn't seem to be
> corrupt. Are the binary data between Linux and NT Oracle Version
different?
> Both are intel systems so I think there are no problems how the data are
> stored.
>
> Regards,
>
> Kristian.
>
>
>
Received on Tue Aug 21 2001 - 16:43:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US