Re: Question about migration with goldengate
From: <fairlie.rego_at_gmail.com>
Date: Fri, 17 Jun 2016 07:36:49 +1000
Message-Id: <07A79167-2892-471E-A483-11DB3C5469A7_at_gmail.com>
>> On Mon, Jun 13, 2016 at 8:03 AM, nico torres <frasebook4_at_gmail.com> wrote:
>> Hi list,
>>
>> I need to migrate with almost 0 downtime (only downtime allowed is for application switchover), 2 databases from IBM aix with oracle 10G, to redhat linux Owith oracle 12C
>>
>> We are considering Goldengate for this matter.
>>
>> Oracle happens to have a whitepaper for this exact process, migratin ibm aix 10g to oracle linux 12c
>>
>> My question is, why is the staging area mandatory? I understand the whole process, but I wonder why does it imply you need that staging area?
>>
>>
>> The whitepaper in question:
>> http://www.oracle.com/technetwork/middleware/goldengate/overview/ggzerodowntimedatabaseupgrades-174928.pdf
>>
>> Thanks guys.
>
Date: Fri, 17 Jun 2016 07:36:49 +1000
Message-Id: <07A79167-2892-471E-A483-11DB3C5469A7_at_gmail.com>
I have used GG to reduce downtime during cross platform migrations from Solaris to Exadata (10g to 11g) and also to offer a fallback position ( post migration ) We had no major issues and were able to achieve the SLAs As long as you do not have data types which are not supported by Goldengate it should be fine
Thanks
Fairlie
Sent from my iPhone
> On 17 Jun 2016, at 3:06 AM, Jeff Chirco <backseatdba_at_gmail.com> wrote: > > Let us know how this process goes for you. I need to basically the same thing, going from 11g on Windows to 11g or 12c on Oracle Linux. We recently got Golden Gate to help with other stuff and for this reason. I am hoping it all will work smoothly. We have a database that runs many application from many different schemas. >
>> On Mon, Jun 13, 2016 at 8:03 AM, nico torres <frasebook4_at_gmail.com> wrote:
>> Hi list,
>>
>> I need to migrate with almost 0 downtime (only downtime allowed is for application switchover), 2 databases from IBM aix with oracle 10G, to redhat linux Owith oracle 12C
>>
>> We are considering Goldengate for this matter.
>>
>> Oracle happens to have a whitepaper for this exact process, migratin ibm aix 10g to oracle linux 12c
>>
>> My question is, why is the staging area mandatory? I understand the whole process, but I wonder why does it imply you need that staging area?
>>
>>
>> The whitepaper in question:
>> http://www.oracle.com/technetwork/middleware/goldengate/overview/ggzerodowntimedatabaseupgrades-174928.pdf
>>
>> Thanks guys.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 16 2016 - 23:36:49 CEST