I need to understand if data guard can be setup between AIX -Based machine running Oracle 11R2 and Exadata X2-2 running the same version. I want to migrate to exadata using data guard.
Thanks in advance.
Edited by: user5651301 on Jul 31, 2012 8:40 AM
Since AIX on a POWER processor is big-endian and a Linux-based Exadata database node is little-endian, the data blocks are physically different. This means that you cannot use an Oracle Data Guard physical standby. However you can use logical replication like Streams, or GoldenGate (thanks to robinsc for pointing out that even Data Guard SQL apply won't work here).
Edited by: Marc Fielding on Jul 31, 2012 6:38 PM
Can you share some of the configs you're using for datapump? One thing in particular to look for is if you're using doing it in parallel, and if you're using network links.
Other options to improve performance might involve using direct-load inserts over database links (though parallelization is a bit trickier here), or using something like Steams or GoldenGate for continuous logical replication, reducing any actual downtime period.
Hi Marc even logical standby would have an issue with creation of the inital standby database wouldn't it ? there is a mos note on heterogenous logical standbys
Data Guard Support for Heterogeneous Primary and Logical Standbys in Same Data Guard Configuration [ID 1085687.1]
AIX can act as primary only for AIX and not for intel x86_64 so no migration to exadata via logical standby. Golden gate may be the only way to accomplish this in this fashion ( i.e via log mining).
Good point robinsc... I keep thinking that a logical standby runs based on streams, but there are definitely limitations, and one of them is crossing endian boundaries.
I wouldn't overlook streams as an option here either.