High Level Steps For Database Migration From Windows to Linux Using RMAN

High Level Steps For Database Migration From Windows to Linux Using RMAN

Source database: Windows Server 2008 (11.2.0.1)
Target database: Oracle Linux 5.7  (11.2.0.1)

1) Before starting the migration make sure 11g database binary already installed on the linux server.

2) Perform the pre-checks on windows server.
-check the database version on source and target both should be same.
-check platform compatibility between source and target.
NOTE: ENDIAN_FORMAT for both OS should be same
-check the location and status of datafiles, controlfiles and redolog files.
-check the invalid objects.
-create the pfile.
-create the necessary directories for storing the migration files.

3) Backup the database

4) Shutdown the database.

5) Startup the database in read only.
-startup mount.
-alter database open read only;

6) Check database readiness for transport from Windows to Linux.

7) Check if there are any external objects.

8) Connect rman and prepare the convert script.
-convert database new database 'ORCL' transport script 'C:\mig\transport.sql' db_file_name_convert 'C:\app\admin\oradata\DELL' 'C:\mig' to platform 'Linux IA (64-bit)';
-At the end of the script it will give a message:
Run SQL script C:\MIG\TRANSPORT.SQL on the target platform to create database
To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platform
To change the internal database identifier, use DBNEWID Utility
Finished conversion at source.

9) Prepare the target server.

10) Copy the migrated files from source to target.
-create the necessary directories and place the CRD files onto the folder.
-set the ENV of 11g linux home.
-prepare the pfile of 11ghome.

11) Modify the highlighted in Transport Script as per your Requiremt.
-Read the script, as it has all instruction for Migrating Database.

12) Run TRANSPORT.SQL Script.
-sqlplus / as sysdba
-Connected to an idle instance.
-SQL> @TRANSPORT.SQL
-Database Migration Has Completed

13) Perform post steps.