I would like to devise a recommended plan for the following:
1. Oracle 10gR2 database is currently on Windows Server 2003.
2. Required to Upgrade the database to 11gR2.
3. Migrate the database to Linux Platform.
Could you please share some ideas and any recommended paths to this work?
Please and thanks!
I suggest you to break the task into two.
1) Version upgrade from 10gR2 to 11gR2 on Windows 2003
2) After Successful Version upgrade, Migrate the 11gR2 database from Windows 2003 to Linux.
Before upgrading your Production database. Upgrade & Migrate a copy of Production database, and test all your exisiting applications with upgraded database.
N.B.: To earn a good reputation on forums, and if you want that your questions will be answered timely. Kindly adopt the habit of marking your questions closed as soon as you get the answer. and be courteous to the people who trying to help.
What is your downtime window? How big is your database? Are you looking for the simplest possible approach (which would generally involve a substantial amount of downtime)? Or are you looking to minimize downtime at the risk of making the upgrade and migration process much more complicated?
We will be looking at the possibility of both options when it comes to downtime.
First is a dev env with Ora 10gr2 on WIN2003 TO Linux Ora 11gr2 (downtime OK).
Next is prod migrate/upgrade then setting up Ora DataGuard (physical standby) with minimal downtime.
The easiest method is to perform and export / import - http://docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm
I would recommend you use the same process for both Production and Dev databases. Pl respond to Justin's other questions - size and downtime will be factors that will determine your approach