Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upgrade exp/expdp issue

Karl NordquistMay 30 2012 — edited May 30 2012

Hi,

We are in the process of upgrading our 10.2.0.4 databases to 11.2.0.2. We are going from RAC to RAC. I have already upgraded many databases successfully with the exp/imp method. However I have run into a 10.2.0.4 database that is not relatively big that is so slow on the export method, that it is not feasible.

So I am tring the expdp/impdp method, and the expdp was completed in 45 minutes (not bad). I have been running the impdp for 21 hours, and it is still not complete. It says it is still EXECUTING.

Now I am thinking that I need to do something even more creative. I have a single node server, running 10.2.0.4 database on top of 10.2.0.4 ASM. I can move the database to this server, and try to install the 11.2.0.2 database software to see if I can upgrade in place, then migrate the database via RMAN. The question is, can an 11.2.0.2 database use or live on a 10.2.0.4 ASM?

I am also open to any suggestions on any ideas about how to expedite the exp or impdp processes. This database is a copy of a Peoplesoft database that is used for staging changes with the Stat product. It has 52,063 tables, 201 tablespaces, 26,297 views and it only takes up 17GB of space according to Cloud Control. The expdp file is only 2.4 GB.

Thank you for your time.

Regards

//Karl