Hi Dearest of Friends,

Can you help me what steps to do in migrating or upgrading a 10g DB?

This is the current scenario:

1. We have a TEST server 32bit Sunfire, and with 32bit rhel 4.6 OS, and with 32bit Oracle 10g DB (with instance name TEST).

2. We have a PROD server 64bit Sunfire, and with 64bit rhel 4.6 OS, and with 64bit Oracle 10g DB (with instance name PROD).

My question is, how do I migrate my TEST DB to PROD server?

Do I have to physically copy all .dbf (datafile,controlfile,logfile) of my TEST DB
to the PROD server and perform an upgrade using DBCA?

Please tell me if my concept is correct.


Thanks a lot

Krissy