Need to migrate Oracle database 10g on Solaris10 M9000 server to Exadata Oracle 11g linux quater rack. The database size is 4TB.
What are the recommended method to do the migration.
Thanks & Regards
We've performed similar migrations using goldengate to minimize downtime. With this method, you don't have to worry about version or endian differences. Other options are export/import (unlikely with the size of the database), transient logical standby databases, and standard upgrade, backup, convert endian, restore method.
Migration from solaris to linux:
Miration best practices:
Since its cross platform you an have rman in use:
But oracle dont recommend to use physical migration on exadata becasuse this generally voilates the best practices on exadata.
Use following methods however if you have downtime available.
1) Transport tablespace (very convenient)
2) Data pump (easy to use)
3) Goldan gate
5) SQl loader
6) Logical standby database using rolling upgrade.