ORACLE DBA

Database Migration From Windows to Linux Using RMAN Alejandro Vargas Principal Support Consultant Oracle Advanced Customer Services 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 transp...

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......................................................

http://www.oracle.com/technology/products/database/asm/pdf/asm_10gr2_bestpractices%2009-07.pdf Thanks, Abdulmateen.

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...