Re: Minimizing downtime for 9i to 10g upgrade

On Sep 12, 10:35 am, DA Morgan <damor..._at_psoug.org> wrote:
> Chuck wrote:
> > I need to upgrade a 9i database to 10g but the business unit cannot
> > tolerate any downtime. I've advised them the cleanest way is to upgrade
> > the db in place which takes about 90 minutes. They are uncomfortable
> > with that much down time. An exp/imp to a new 10g database would take
> > even longer.
>
> Why? you can do TB systems in seconds.
>
> First set up your 10g database.
> Then copy over all of the rows except for the last 24 hours.
>
> Then copy over all of the information not previously copied except for
> the last hour.
>
> Repeat for everything except the previous 2-5 minutes.
>
> Then switch them over. This is the few seconds.
>
> Then bring in that last five minutes worth of transactions which likely
> will never be missed in the minute or two it will take to capture them.
>
> This technique is aided by the use of partitioning and I highly
> recommend several practice runs to perfect your technique.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

what is the better utility for carrying out the copy based on time?

regards,
Ganadeva Received on Fri Sep 12 2008 - 03:33:44 CDT