Re: Moving and upgrading DB at the same time

On Apr 28, 12:35 am, Rick Denoire <100.17..._at_germanynet.de> wrote:
> In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv.
> Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux
> Ent. Ed. V 4 64 bit) I will move all files of the shut down DB to a
> new server where the target version of Oracle is istalled and take
> care that datafile paths on the new server are the same as on the old
> one (no need to rename anything in the controlfile of the cold copy).
>
> Since on the new server only the new Version of Oracle is installed,
> the only thing I can do is just upgrade the DB copy without being able
> to open it in order to check that everything is all right.
>
> May I assume that there won't be any platform related issues?
> I just don't know if this switch is considered a platform change.
> After all, both Linux boxes are rather different versions of Redhat
> (running on Intel hardware).
>
> Even if there is no platform issue, which are going to be the pits and
> falls?
>
> I would like to avoid exp/imp because for a schemawise transfer I
> would need to precreate users with all privileges, tablespaces, etc.
> Full exp/imp is not adequate when going to a different version of
> Oracle.
>
> Thanks in advance
>
> Rick Denoire

I think RMAN is your friend here.

Cheers.

Carlos. Received on Mon Apr 28 2008 - 02:19:51 CDT