We have a 3.5TB data warehouse running on 220.127.116.11 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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.