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;

Declare

Db_ready Boolean;

Begin

Db_ready: = dbms_tdb.check_db ('linux x86 64-bit ', 2 );

If (db_ready) then

Dbms_output.put_line ('support ');

Else

Dbms_output.put_line ('nosupport ');

End if;

End;

3. Check whether external objects exist.

Declare

External Boolean;

Begin

External: = 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;

1 2 Next Page