News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle GoldenGate Tutorial 10- performing a zero downtime cross platform migration and 11g database upgrade

  • Posted by Gavin Soorma
  • On March 8, 2010
  • 3 Comments
  • 11g upgrade, cross platform transportable tablespace, GoldenGate, zero downtime migration

This note briefly describes the steps required to perform a cross platform database migration (AIX to Red Hat Linux) and also a database upgrade from 10g to 11g Release 2 which is attained with zero downtime using a combination of RMAN, Cross Platform TTS and GoldenGate to achieve the same.

You need to be logged in to see this part of the content. Please Login to access.
 

3 Comments

Shervin
  • Mar 7 2011
Hi, Have you ever tested enabling GG on physical standby DB ? I am tempting to belive capture does not work with Physical standby due to LOB fetching which requires DB access with some conditions and also adding trandata and ... Any thoughts ?
Vishal Desai
  • Mar 9 2011
There is an option to start replicat from certain commit sequence number.
Fairlie Rego
  • May 31 2011
Extract does not currently work from a physical standby. However there are plans I believe to enable this in the future but I have not got firm dates from the GG product development team

Leave Reply

Your email address will not be published. Required fields are marked *