I have :
2 x Oracle 188.8.131.52 on AIX (5.3)
1 x Oracle 184.108.40.206 on AIX (5.3)
1 x Oracle 220.127.116.11 on Solaris (5.8)
These four databases are going to be moved from 4 different European countries to one country. The target architecture will be 18.104.22.168 on either RH or AIX. Each database is around 500GB. Lots of BLOBs.Yes I know about endian issues if we choose Red Hat Linux.
According to 419550.1, 733205.1, various searches and cruising around these forums, I have only one option for a 'direct' migration : EXP/IMP
There is also (and I'm unsure about the validity of this) the solution of having a machine with 10.2.0.5, copying the entire database to this machine (which has the same filesystem layout) and then doing a startup migrate. This is for the 22.214.171.124 and 126.96.36.199 databases. For the 188.8.131.52 databases the same person has proposed a startup migrate but pointing to 184.108.40.206 binaries. Like I said, I didn't know that this was possible.
Golden Gate has not yet been looked at.
Appreciate your ideas.
How much downtime can you afford ? For 220.127.116.11 and 18.104.22.168, the only option is export/import, unless you upgrade them to 22.214.171.124 first (assuming you will stay on the same OS )
If you are going to be switching OS's, the easiest and fastest method will likely be export/import.