Re: Minimizing downtime for 9i to 10g upgrade
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 12 Sep 2008 06:43:58 -0700
Message-ID: <1221227038.725279@bubbleator.drizzle.com>
>> 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
Date: Fri, 12 Sep 2008 06:43:58 -0700
Message-ID: <1221227038.725279@bubbleator.drizzle.com>
ganadeva_at_gmail.com wrote:
> 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
Depends on your database. Number of tablespaces and datafiles which you didn't mention. Number of tables. Size. Rows. OLTP or DW, etc. To answer the question of how big a house is requires you accurately describe the house.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Sep 12 2008 - 08:43:58 CDT