Database Migration Question
Posted on 2006-11-12
We have a 3.5TB data warehouse running on 22.214.171.124 and are now planning to migrate to a two node Oracle 10gR2 RAC with ASM (New Storage). The migration strategy we have in mind is:
1) Upgrade current 9i single instance database to 10gR2 single instance database.
2) Migrate 10g single instance database to a 10gR2 dual node RAC with ASM using either
(i) RMAN duplicate command
(ii) Data pump.
Now what I would like to ask is can some please highlight the pros and cons of above mentioned migration methods.