Re: Suggestions wanted ..

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 14 Mar 2005 16:44:43 GMT
Message-ID: <4235bed5.3440945117@localhost>

Here's a suggestion.

Don't upgrade all 3 things at once. If something goes broke, you won't know what it was.

Instead do the following
1) install same version of ora on new server 2) create a standby database (you might want to upgrade to 8.1.7.5 prior)
3) migrate via standby database (the actuall miigration should take you under few mins, stopping apps, changing tnsnames.ora files (or oracle name server), applying the last log, and changing db from standby to active
4) if all OK (after a few days), upgrade to 9i, which is like an hour of work

On 9 Mar 2005 09:06:44 -0800, "Ken" <kenneth.buzard_at_sunhealth.org> wrote:

>Any suggestions on how to reduce downtime to absolute minimum while
>migrating a 320 gig Oracle 8.1.7.1, AIX 4.3.3 IBM M80 to Oracle 9.2.0.5
>AIX 5.2 IBM P570. Upgrading Oracle Version, OS version, Hardware.
>Thanks for any suggestions.
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Mar 14 2005 - 10:44:43 CST