We are planning to move our Oracle databases from AIX 6.1 to Oracle Linux 6.2
To reduce the downtime, we are thinking of setting up a dataguard (physical or logical) and do the switchover.
Have you performed this before?
Will you pls send me the steps?
If I understand the question correctly you should refer to this note :
Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]
I thinking no for the same reason.
When my shop moved from AIX to Linux we just install Oracle on Linux and patched it to the same level as the AIX. We created users, tablespaces, job etc in advance and then just used import/export to move the needed schema's. Data Pump make this much easier.
Do a schema(s) compare and switch when ready. But in any event I don't believe Data Guard can help you. You mostly have a migrate issue.
Please consider closing your question when complete.
h3. Oracle Database 10g & Multi-Terabyte Database Migration
h3. Incrementally Updating Transportable Tablespaces using RMAN
h3. Platform Migration Using Transportable Database Oracle Database 11g and 10g Release 2
Edited by: mseberg on Nov 13, 2012 6:31 PM
We are doing same - moving DB from AIX to Linux.
We have databases ranging from 1TB to 20TB.
So, export/import wont work directly.
we will have to use transport tablespace with the file conversion using RMAN.
We are trying to reduce / eliminate the downtime for critical databases.
Although the incremental TTS method looks great, it seems that it is presently only supported for Exadata as the target platform.
At least this MOS Note says so:
It contains an even more detailed description, by the way :)
"Don't believe it, test it!"