Skip to main content

Migration of 10g database from Windows to Linux using RMAN

Database Migration From Windows to Linux Using RMAN
1/32

INDEX
SUMMARY........................................................................................................................................................................2
The Windows Database....................................................................................................................................................3
List of Steps Needed to Complete the Migration................................................................................................................4
1. Check platform compatibility between source and target OS.........................................................................................5
2. Start the database in read only mode............................................................................................................................6
3. Check database readiness for transport from Windows to Linux...................................................................................7
4. Check if there are any external objects.........................................................................................................................8
5. Using the RMAN CONVERT DATABASE Command.....................................................................................................9
6. Copy Converted Datafiles, Generated Transport Script and Parameter File to the Linux............................................11
7. Edit init.ora for new database......................................................................................................................................13
8. Edit The Transport Script.............................................................................................................................................16
9. Execute the Transport Script.......................................................................................................................................21
10. Change database identifier........................................................................................................................................27
11. Check database integrity...........................................................................................................................................31
End of Report...............................................................................................................................................................32

Comments

Popular posts from this blog

Restoring rman backups.

C:\Documents and Settings\201910>sqlplus sys/mysecretpassword as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Wed Nov 12 14:32:28 2008 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- C:\AUG\SYSTEM.DBF C:\AUG\UNDOTBS1.DBF C:\AUG\SYSAUX.DBF C:\AUG\USERS.DBF SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> create spfile from pfile; File created. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string...