we are planning to migrate 10g oracle database from windows 2008 server to 11gR2 rhel 5 ..
target database version on windows
SQL> select * from v$version;
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
can someone provide the document how to migrate the data from one platform to other..
There are too many variables to answer that question. How big is your database?
How much downtime can you take during the cut over? You can use exp/imp,
expdp/impdp, transportable table spaces with either of the previous two options.
Knowing that you are running the base release of 10gR2 doesn't provide much information.
That is an eternity for that little data. You should install and patch Oracle to the correct release on the new server, create a new database with all of the table spaces that you need, the correct SGA size, setup RMAN backups on the new database, create all of the users that you need with the correct privileges. And then use data pump to get a full export of the schemas that you need and import that into the new database. If you want it to be really fast and you have enterprise Oracle you can add compress=all and parallel=5 to shrink the export size and make it uber fast. Like instead of taking 20 minutes to migrate your data you might be able to migrate you data in 5 minutes. Do a few test migrations, test the Linux version of the database and schedule you migration. You should need less than 2 hours of downtime.
Backup and database with RMAN and restore to the new server with RMAN. This is the best case scenario as far as migrating the database is concerned. You might want to look at using RMAN to migrate from 32 bit to 64 bit software. Also migrating with a warm backup will mean that you don't need to apply any redo, so you can just do a startup upgrade and run the upgrade scripts to upgrade the database to the new version.
created the "pfile.ora"
created the same directory structure
i took rman backup from the source db(old).. i am unable to connect to rman on the target (new) ..can you help me how to set the env variables on windows ..