Installation guide

5.10 Database Migration

Review the following sections if you want to migrate Oracle Database 10g release

2 database from Linux x86 to Linux x86-64:

■ Migrating Single Instance Database from Linux x86 to Linux x86-64

■ Migrating Oracle RAC Database from Linux x86 to Linux x86-64

5.10.1 Migrating Single Instance Database from Linux x86 to Linux x86-64

To migrate Oracle 10g release 2 single instance database from Linux x86 to Linux

x86-64, complete the following procedure:

1. To protect the existing database 10g release 2 against any failures during the

migration, ensure that you take a complete backup of the database on Linux

x86-64 system.

2. To create a control file that helps file after the migration, run the following

SQL command from the SQL prompt on the Linux x86 system:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

This command saves the control file information to a trace file in the UDUMP

directory. The control file information is similar to the following where

ia32lnx_path is the location of the Linux x86 Oracle home:

CREATE CONTROLFILE REUSE DATABASE "SAMPLE" NORESETLOGS

NOARCHIVELOG

MAXLOGFILES 32

MAXLOGMEMBERS 2

MAXDATAFILES 32

MAXINSTANCES 1

MAXLOGHISTORY 112

LOGFILE GROUP 1 '/ia32lnx_path/oradata/eegp22/redo01.log' 25M,

GROUP 2 '/ia32lnx_path/oradata/eegp22/redo02.log' 25M

DATAFILE '/ia32lnx_path/oradata/eegp22/system01.dbf',

'/ia32lnx_path/oradata/eegp22/sysaux01.dbf',

'/ia32lnx_path/oradata/eegp22/users01.dbf',

'/ia32lnx_path/oradata/eegp22/undotbs01.dbf'

CHARACTER SET WE8DEC;

3. Perform a clean Oracle database shutdown.

SQL> SHUTDOWN IMMEDIATE

4. Copy the database files to the Linux x86-64 system.

5. In a new Oracle home, install the Oracle 10g release 2 software for Linux

x86-64.

6. Copy the Oracle initialization parameter file (initsid.ora) to the new

Oracle home. Change any Oracle home path references to use the new Oracle

home path on the Linux x86-64 system.

7. Start up the database using SQL commands similar to the following example

where lnx_x86-64_path is the location of the Linux x86-64 Oracle home:

SQL> STARTUP NOMOUNT;

CREATE CONTROLFILE REUSE DATABASE "EEGP102" NORESETLOGS

MAXLOGFILES 32

MAXLOGMEMBERS 2

MAXDATAFILES 32