完整的步骤如下;
一、环境
1、源库
SQL> select * from v$version;#版本
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE10.2.0.2.0Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
SQL> show parameter compatible#兼容级别
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
compatible
string10.2.0.2.0
SQL> select t.PLATFORM_NAME from v$transportable_platform t , v$database d
2 where t.PLATFORM_NAME=d.PLATFORM_NAME;#平台硬件类型
PLATFORM_NAME
--------------------------------------------------------------------------------
Solaris Operating System (x86)
2、目标库
SQL> select * from v$version;#版本
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> show parameter compatible#兼容级别
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
compatible
string10.2.0.1.0
sql> select t.PLATFORM_NAMEfrom v$transportable_platform t , v$database d
where t.PLATFORM_NAME=d.PLATFORM_NAME;#兼容级别
PLATFORM_NAME
--------------------------------------------------------------------------------
Linux IA (32-bit)
二、源库上做表空间元数据导出,及数据文件转换
sql> alter tablespace ts1 read only;
导出ts1表空间元数据
expdp system/oracle directory=testdir transport_tablespaces=ts1 dumpfile=ts1.dmp version='10.2.0.1.0'
- 成功
将数据文件转换为和目标平台匹配的方式
rman> CONVERT TABLESPACE TS1
TO PLATFORM 'Linux IA (32-bit)'
DB_FILE_NAME_CONVERT
'/u01/app/oracle/oradata/ORCL3/datafile','/u01/app/oracle/backup'
PARALLELISM=2
将dump文件及数据文件传输到目标主机。
三、目标库进行表空间导入
$ impdp system/oracle directory=testdir dumpfile=ts1.dmp transport_datafiles='/u01/app/oracle/oradata/ORCL/datafile/ts1.dbf'
Copyright (c) 2003, 2005, Oracle.All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":system/******** directory=testdir dumpfile=ts1.dmp transport_datafiles=/u01/app/oracle/oradata/ORCL/datafile/ts1.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-00721: changes by release 10.2.0.2.0 cannot be used by release 10.2.0.1.0
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 14:28:00
仍然出这个错误。
感觉是从10.2.0.2到10.2.0.1小版本迁移不支持
|