Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<cm8el7$2fs$1_at_news.BelWue.DE>...
> yls177 wrote:
> > I am going to restore my PRD (8.1.7) to DEV (9). In my PRD, I have a
> > full offline backup scheduled in db13 to a DDS-4 tape. With this tape,
> > I am going to restore PRD to my DEV.
> >
> > 1) Remove all the DEV filesystems
> > 2) Create the PRD filesystems
> > 3) the command used to restore is "brrestore -b
> > <coded_timestamp>.<fid> -m full". This file <coded_timestamp>.<fid> is
> > tied to the same one with what is shown in the DB13 log.
> > 4) This will restore the complete PRD system. Problem is that this
> > restored system is a 8.1.7. But the one in DEV is 9 therefore the
> > binary is different. Hence I need to upgrade this current copy to PRD
> > by
> > a. upgrade the cloned 8.1.7 database to 9.2.0 by running
> > @?/rdbms/admin/u0801070.sql
> > 5) In note 592393, it wrote
> > "Switch from 8.1.7 to 9.x
> > After the copy, you must execute all of the upgrade steps
> > described in the
> > guide for upgrading to Oracle 9.x. "
> >
> > 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 ...
Received on Wed Nov 03 2004 - 04:24:21 CST
