Re: Golden Gate Replication from a Physical Standby
Date: Fri, 10 Apr 2015 17:53:51 +0200
Message-ID: <CAJ2-Qb_vj8rc483Mozqg8oJRx=caHJzE3QsZm0vbGi_hwxeXcg_at_mail.gmail.com>
Hi
I have done a few zero down time migration using OGG. OK, they were not zero minute but it took me probably 5 minutes to migrate for example a 5TB database from 9.2.0.8 to 11.2.0.4.
The extract was against primary database, in you case where you want to extract from a standby database you can use ALO as Job suggested if you pretend using classic extract but if your source is RAC I would recommened you to use integrated extract, in that case ALO is not supported but you can configure Downstream Mining which does support Integrated Extract.
Regards
On Fri, Apr 10, 2015 at 3:59 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
> In the medium to long term we are going to need to convert a large
> instance on AIX to Linux x86_64. My research indicates that we can use
> golden gate to accomplish this with minimum down time, and run the
> replication from the physical standby.
>
> Has any one been through this process? Or can they point me to some
> documentation for the process? I think I have the basic steps in mind, but
> this will be my first implementation with Golden Gate, so right now I dont
> even know what I dont know about this process.
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 10 2015 - 17:53:51 CEST