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: Can you copy datafiles from one OS to another?

Re: Can you copy datafiles from one OS to another?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 23 Sep 1999 06:38:06 -0700
Message-ID: <37EA2D3E.9029A5A6@us.oracle.com>


Unless the OS's are binary compatible, you cannot copy the files from one system to another. So in general you can't copy from one OS to another, and sometimes (depending on the changes at the OS level) you can't copy from one version of a particular OS to a newer version of the same OS.

HTH. Pete

Martin Hepworth wrote:

> A Hairy Old Man wrote:
> >
> > Hello all,
> >
> > This came out of a discussion I had with another Oracle techie over a
> > beer (uhmm.... Ok, over several beers) so I don't even know if it
> > makes sense.
> >
> > Anyway, is it possible to copy datafiles from one OS say Unix to NT or
> > VMS and rebuild an instance? If so, what are the constraints?
> >
> > We were guessing that it could only be tables and indexes as opposed
> > to system, rollbacks, redologs, etc. and maybe only among same cpu
> > systems with same file block factor. But again, we were pretty much
> > blasted.
> >
> > Any comments are very welcomed, as well as some pain killers : )
>
> Hi
> If you want to do this then 'replicate' your DB rather than copying
> files around, which could lead to internal datatype problems ie do both
> CPUS have the same endianess/word size....
>
> Martin


Received on Thu Sep 23 1999 - 08:38:06 CDT

Original text of this message

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