| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: EXP from AIX and IMP in HP possible?
Comments inline.
Kevin Brand wrote:
> So, you're saying that if I were to ftp a regular file, or read the data
> from a raw device and place either in the same "type" of file/device from
> hpux 11 to 10.2 or vice-versa, that those files would be corrupt somehow.
> That the transfer itself across differing versions or platforms (UNIX) would
> mix up the bits or otherwise muck up the data?
No, not at all. My apologies for not being clear enough. What I meant was that there are some OS releases (and remember my example was from memory, so please check this one for HP) where an upgrade of the OS WILL require a rebuild of the database. The datafiles that are created under an earlier release of the OS are sometimes binary incompatible with the later release. This is something that is completely outside Oracle's control. It simply has something to do with how files are created and read at the OS level.
> Yes I agree that a binary executable file from hpux 11 ( compiled on 11 )
> will probably not run on 10.2, if they are indeed NOT binary compatible, but
> the contents of the file remain the same across versions ( if simply moved
> there from one to the other ), not matter what. That's why 10.2 will
> complain.
Agreed, the contents will stay the same, but the headers of the files may not.
> It is my understanding that the content of an Oracle datafile has nothing to
> do with how it is stored and that it is standard per version across
> platforms. If you simply read the file or raw device, starting with the
> Oracle header, and take this to another platform, it will look and feel
> exactly the same ( to the Oracle background processes ), regardless of how
> that storage is implemented at the OS level.
No, definitely not. Oracle database files are created by the OS the database runs on. You simply can't take a file off a Sequent box for example, and expect it to run on a VMS box, or for that matter off a Sequent and onto another flavour of Unix (say HP). The headers of the datafiles are binary incompatible. The only way you can do this is to export the data, binary ftp it, then import it.
> How else would software companies be able to produce reliable redo log
> sniffers and other neat, datafile based tools for Oracle that run across
> many supported platforms? They certainly couldn't go through the long
> reverse-engineering procedure for each platform.
That's what they have to do. It's what Oracle itself has to do with porting from one platform to another. It's why there is a delay between the initial release (on Sun) and the port to another platform. If the OS's are similar (say different Unix OS's) the porting time is generally fairly minor (I think the last release was separated by a couple of weeks, for example).
HTH. Pete
> Granted, I've not tried this, however it would not be very difficult to
> test.
>
> Anybody want to take that on?
>
> -Kevin
> --
>
> remove the x for an email reply
> Pete Sharman wrote in message <371608EC.F8F9D98E_at_us.oracle.com>...
> >Steve
> >
> >You're correct, the only way this is supported is from the same OS to the
> same OS.
> >There are even issues sometimes with that (for example, from memory the
> files are
> >binary incompatible between HP-UX 10.2 and 11), so it has to be copied from
> the
> >same release of the OS to the same release of the OS.
> >
> >HTH.
> >
> >Pete
> >
> >Steve Phelan wrote:
> >
> >> Hmm.. I too have done this on the *same* platform, but I have my doubts
> between
> >> platforms, and I've never heard Oracle say anything like this is
> supported.
> >> Still, anyone tried it? Does it actually work?
> >>
> >> Steve Phelan.
> >>
> >> Kevin Brand wrote:
> >>
> >> > Actually, you can copy the datafiles themselves from one platform to
> >> > another, skipping any local LVM headers. Use dd for raw on UNIX or
> just
> >> > copy the files from the filesystem.
> >> >
> >> > Once you have all the files in the proper place, including copies of
> the
> >> > controlfiles and redo logs, and assuming that you don't want to change
> file
> >> > names or path names, its just like starting up after a cold backup.
> >> >
> >> > I use something like this from AIX to AIX, but it should also work from
> HP
> >> > to AIX or vice-versa ( adjusting for the differing LVM methodologies
> from
> >> > one to the other ).
> >> >
> >> > On the host where you want to create the copy database, execute:
> >> >
> >> > remsh host_where_db_lives 'dd if=/dev/raw_device bs=8192000 | gzip -5'
> |
> >> > gzip -d |dd of=/dev/my_new_logical_device bs=8192000
> >> >
> >> > note: the quotes above are very important.
> >> >
> >> > This assumes you are trusted as oracle between these two hosts and that
> you
> >> > have a sub 100Mbs LAN or are sending across a WAN. Otherwise, you may
> not
> >> > want to filter everything through gzip.
> >> >
> >> > Be very careful with this because you can easily wipe out your "good"
> >> > database. In fact, I wouldn't recommend doing this at all. You should
> go
> >> > ahead and use exp/imp, as this is much easier.
> >> >
> >> > -Kevin
> >> >
> >> > --
> >> >
> >> > remove the x for an email reply
> >> > katincic_at_access.net.au wrote in message
> <3711E049.9642E443_at_access.net.au>...
> >> > >Hi Stefano,
> >> > >
> >> > >it is possible and it is the only way to transfer database from one
> >> > platform to
> >> > >another
> >> > >(I mean Exp/Imp). Just be sure to ftp the dump file (from one machine
> to
> >> > >another)
> >> > >in binary mode.
> >> > >Cheers,
> >> > >
> >> > >Maya
> >> > >
> >> > >Stefano Unternaehrer wrote:
> >> > >
> >> > >> Hi all.
> >> > >> Is it possible to export a schema from a Oracle Database
> >> > >> running on an AIX server and import the file on HP-UX,
> >> > >> where the same Oracle RDBMS version is running?
> >> > >> Something to do or to take care?
> >> > >>
> >> > >> PLEASE: also send me your reply as message.
> >> > >> Thank you!
> >> > >> Stefano
> >> > >
> >
> >--
> >
> >
> >Regards
> >
> >Pete
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >Peter Sharman Email: psharman_at_us.oracle.com
> >WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> >Worldwide Internal Services Education (650)607 0109 (local)
> >San Francisco
> >
> >SQL> select standard_disclaimer, witty_remark
> > 2 from company_requirements;
> >
> >Opinions are mine and do not necessarily reflect those of Oracle
> >Corporation
> >
> >"Controlling application 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
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> >
--
Regards
Pete
Peter Sharman Email: psharman_at_us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)San Francisco
SQL> select standard_disclaimer, witty_remark 2 from company_requirements;
Opinions are mine and do not necessarily reflect those of Oracle Corporation
"Controlling application 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
Received on Mon Apr 19 1999 - 11:06:32 CDT
 |
 |