Database migration-Linux-32 to Linux-64 (10.2.0.4)

Database migration: Linux-32 to Linux-64 (10.2.0.4)

Database migration: Linux-32 to Linux-64 (10.2.0.4)

I. Environment Description

Source database:

Operating System: LINUX 32-bit

Database: Oracle 10.2.0.4.0 32-bit

Target database:

Operating System: LINUX 64-bit

Database: ORACLE 10.2.0.4.0 64-bit

Ii. operation instructions

Cross-platform transmission using RMAN

Export:

1. startup open read only;

2. Check whether cross-platform conversion is supported

Set serveroutput on;DeclareDb_ready Boolean;BeginDb_ready:=dbms_tdb.check_db('Linux x86 64-bit',2);If(db_ready) thenDbms_output.put_line('support');ElseDbms_output.put_line('nosupport');End if;End;

3. Check whether external objects exist.

DeclareExternal Boolean;BeginExternal:=dbms_tdb.check_external;End;

4. Perform full-database conversion in RMAN

Convert database new database 'micsregr' -- (set the Instance name MICSREGR here) Transport script. '/u02/app/oracle/oradata/MICSREGR/rmandata/tsconv. SQL 'To platform. 'linux x86 64-bit 'db _ file_name_convert '/u02/app/oracle/oradata/MICSREGR/''/u02/RMAN/';

Note that the following error is reported:/u02/app/oracle/oradata/MICSREGR/must be added with/; otherwise, an OMF error is reported.

/U02/RMAN/a must be added with a to distinguish it from the OMF file of the source database.

ORA-01276: Cannot add file/u02/app/oracle/oradata/MICSREGR/rmandata/o1_mf_system_4c720cx5_.dbf.  File has an Oracle Managed Files file name.

5. Set the database to read write

Startup open read write;

The above is the database migration-Linux-32 to Linux-64 (10.2.0.4) content, more relevant content please pay attention to PHP Chinese Network (www.php1.cn )!