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: copy database from oracle 9 to 8.1.7

Re: copy database from oracle 9 to 8.1.7

From: <sybrandb_at_yahoo.com>
Date: 10 Nov 2004 04:29:34 -0800
Message-ID: <a1d154f4.0411100429.62bac1fe@posting.google.com>


yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0411092002.55c00c35_at_posting.google.com>...
> Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<cmaf9n$fc6$1_at_news.BelWue.DE>...
> > Neil Cudd wrote:
> > [...]
> >
> > >>>Please advise.
> > >>
> > >>Er, what advise would you like? Do what you are told and follow the upgrade
> > >>steps described in the guide for upgrading to Oracle 9.x.
> > >>
> > >>This all assumes that you use the same OS, of course.
> > >>
> > >>Cheers,
> > >>Holger
> > >
> > >
> > > It's also worth noting that when upgrading fron 8i to 9i, there are
> > > preparatory steps e.g checking for enough system tablespace space and
> > > setting up rollback segments, that has to be done before begining the
> > > upgrade - hence prior to the backup on the 8i system ...
> >
> > Sure. That's why I recommended to follow the steps in the Migration Guide.
> > OK, maybe I should have said that reading the Guide *prior* to any action
> > on behalf of the OP is in order, but then I also assume that when one is
> > aware that there is such a thing as a Migration Guide, one actively uses
> > the grey mass between one's ears and reads it.
> >
> > Not how many people work, I realise ;-()
> >
> > Cheers,
> >
> > Holger
>
> how about the below?
>
> I have a SAP 4.6C on oracle 8.1.7, hpux 11.0 on system A. I have taken
> a fbackup of all the necessary filesystems. Now, if on system B, hpux
> 11.0, with the same newly created filesystems, will a frecover gives
> exactly the same system A?

Just follow up the recommendations by Holger, and don't try to 'experiment' You'll need to read that migration guide anyway. If you don't want to read the migration guide, then don't ask advise.

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Nov 10 2004 - 06:29:34 CST

Original text of this message

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