Re: Oracle Upgrade 9.0 to 9.2

From: Goran <goran99_remove_at_yahoo.com>
Date: Thu, 18 Dec 2003 13:09:22 +0100
Message-ID: <brs5di$e0a$1@fegnews.vip.hr>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3fe1924c$0$13352$ed9e5944_at_reading.news.pipex.net...
> "Goran" <goran99_remove_at_yahoo.com> wrote in message
> news:brs29i$pho$1_at_fegnews.vip.hr...
> >
> > <sybrandb_at_yahoo.com> wrote in message
> > news:a1d154f4.0312180239.5161ac97_at_posting.google.com...
> > > "John Wood" <jwood_at_hotmail.com> wrote in message
> > news:<8IaEb.102405$bC.38876_at_clgrps13>...
> > > > I am running Oracle 9.0.1.4 on Window 2000 platform. I plan to
> upgrade
> > the
> > > > Oracle to 9.2.
> > > > I was told that in order to have clean upgrade, it is better to do a
> > full
> > > > export. Then delete the datafile in the older version, run the
> upgrade,
> > > > create the needed tablespace, then do the import.
> > > >
> > > > This way we will not see any odd problem.
> > > >
> > > > Please advise if this is true.
> > > >
> > > > Thanks.
> > > >
> > > > Jw.
> > >
> > > The best advise you can get is not from useless hearsay like the one
> > > you got, but by reading the upgrade manual.
> > >
> > > Sybrand Bakker
> > > Senior Oracle DBA
> >
> >
> > It seems that you either never performed an upgrade of a real database,
or
> > have been *very* lucky not to encounter any problems during or after the
> > upgrade...
> >
> >
> > Regards,
> > Goran Dokmanovic
> > Senior Database Administrator
> > VIPNet d.o.o
> > Zagreb, Croatia

>

> The chances that Sybrand has never done an upgrade for a real system are
> pretty much nil.
> For a 5gb database exp/imp is probably fine. For a 500gb or a 5TB database
> exp/imp might be somewhat less efficient than running the upgrade scripts.
> http://tinyurl.com/2hefg which is where Sybrand pointed the OP has a
pretty
> helpful discussion on when you might do what.

>
>

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

Hi,

Be sure that I studied the documentation for various versions thoroughly. But please note the following. The most recent issue regarding this matter is that a month ago we performed a test upgrade of 81740 >2TB dwh db to 92040 using v9 dbua on hpux. If the db were smaller than some 500GB, we wouldn't have even considered the upgrade, it would certainly be performed via exp/imp.
And we are not quite happy with the results; i wouldn't discuss the actual issues, as they are still beeing considered in some open TARs. Now we consider performing the test again, only this time using export-import.. the same way we performed that when we moved the particular db some two years ago from another OS to hpux. It will probably take more than a week.
Anyway, with some careful planning, actual downtime should be less than a day, because importing the static historical data can take place after the import of essential schemas...

Regards...
Goran Received on Thu Dec 18 2003 - 06:09:22 CST