Re: migration

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 13 Jun 2006 09:38:43 -0700
Message-ID: <1150216727.421402@bubbleator.drizzle.com>

dd wrote:

> I think that I wrote in post that the customer doesn't wont to upgrade 
> version of database, because of problems with existing applications. The 
> problem is also that solution must by supported from Oracle (and some great 
> tools like Quest SharePlex are not supported). That means that (because I 
> have some 8.1.7 and some 9.2.6) the only solution is export import.
> That's the reason why are we searcing for people with some expirience on 
> similar projects.
> Thanks,
> Dubravka
> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
> news:1150129430.611570_at_bubbleator.drizzle.com...

>> tralaala wrote:
>>> I have the following problem:
>>> The problem is to tranfer the whole database, SIZE cca 500Gb - 3,5TB ,
>>> with minimum or NO downtime, if possible.
>>>
>>> From server: HP-UX with Oracle database server 8.x and 9.x
>>>
>>> To server: IBM_AIX with Oracle database server 8.x and 9.x (no DB
>>> upgrade)
>>>
>>> We have 15 critical Oracle DB servers
>>>
>>> II would love to know approximate downtime for this operation for a
>>> database of this size.
>>>
>>> We are searching for some people (companies) with expirience on similar
>>> cases who are willing to join our team.
>>>
>>> Thanks in advance for your response
>>>
>>> Best regards,
>>>
>>> dubravka.dulcic_at_combis.hr
>> How can we tell you downtime when we don't know the method you are
>> going to use, the transfer speed of your network, or anything else
>> about your operations.
>>
>> In 10g I would expect to do it with essentially zero downtime.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

Please don't top-post.

With 9.2.0.6 look into using transportable tablespaces. Your downtime should be essentially zero.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jun 13 2006 - 11:38:43 CDT