Hi guys,

My company is planning to migrate one of 9i standalone DB to the new 10g RAC cluster. Due to the size of the standalone DB is big (120+ Gig) and large outage window is not possible. Hope you can guide and advise me the proper approache.

If I use IMP/EXP, it is not possible as it may take more than one or two days to finish the migration.

Do you guys know any proper procedure for this migration?

I have the following idea, but not sure whether it is possible.

1. Build the 10g RAC (CRS, Software and NEW RAC DB) on the clusters first.
2. cold backup the 9i DB to the new Cluster hosts.
3. Upgrade the cloned 9i DB to 10g standalone DB first (with Diff ORACLE_HOME location)
4. Use expdp and impdp to do schema TRANSPORTABLE TABLESPACE to the newly build 10g RAC.

If you have any best suggestions, please advise. Thank You so much.

Regards,
vbeer