RMAN跨小版本跨平台与字节序传输表空间 - 数据库编程

949517_TS-TEST_FNO-7_3bq349vo
-rwxrwxrwx? ? 1 oracle? dba? ? ? ? ? 98304 Mar 30 12:42 tspitr_test.dmp

8.将要被传输的表空间附加到目标数据库中
[IBMP740-1:oracle:/yb_oradata]$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 30 11:31:47 2015

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user tspitr identified by "tspitr";

User created.

SQL> grant dba,connect,resource to tspitr;

Grant succeeded.

SQL> create user test identified by "test";

User created.

SQL> grant dba,connect,resource to test;

Grant succeeded.

SQL> create or replace directory test_dump as '/yb_oradata/transport';

Directory created.

SQL> grant read,write on directory test_dump to public;

Grant succeeded.

[IBMP740-1:oracle]$impdp system/system directory=test_dump dumpfile=tspitr_test.dmp transport_datafiles=/yb_oradata/data_D-TEST_I-2168949517_TS-TEST_FNO-7_3bq349vo,/yb_oradata/data_D-TEST_I-2168949517_TS-TSPITR_FNO-6_3aq349v8

Import: Release 10.2.0.4.0 - 64bit Production on Monday, 30 March, 2015 11:45:48

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":? system/******** directory=test_dump dumpfile=tspitr_test.dmp transport_datafiles=/yb_oradata/transport/data_D-TEST_I-2168949517_TS-TEST_FNO-7_3bq349vo,/yb_oradata/transport/data_D-TEST_I-2168949517_TS-TSPITR_FNO-6_3aq349v8
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-00721: changes by release 10.2.0.5.0 cannot be used by release 10.2.0.3.0

Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 11:45:53

出错原因是因为源数据库的compatible=10.2.0.5.0,目标数据库的compatible=10.2.0.3.0这里在导出使用version=10.2.0.3.0导出元数据后再执行导出也是同样会报这个错误，因为这里不是逻辑导出，而是传输表空间，所以version参数不起作用。所以想修改源数据库的compatible参数为10.2.0.3.0,但在10g以后,compatible参数只能增大不能减少。
SQL> show parameter compatible

NAME TYPE VALUE
?------------------------------------ ----------- ------------------------------
?compatible string 10.2.0.5.0

SQL> alter system set compatible='10.2.0.3.0' scope=spfile;

System altered.

SQL> shutdown immediate
?Database closed.
?Database dismounted.
?ORACLE instance shut down.
?SQL> startup
?ORACLE instance started.

Total System Global Area 167772160 bytes
?Fixed Size 1272600 bytes
?Variable Size 109053160 bytes
?Database Buffers 54525952 bytes
?Redo Buffers 2920448 bytes
?ORA-00201: control file version 10.2.0.5.0 incompatible with ORACLE version
?10.2.0.3.0
?ORA-00202: control file: '/u01/app/oracle/oradata/test/control01.ctl'

在将源数据库的compatible参数修改为10.2.0.3.0后无法启动数据库。

--------------------------------------推荐阅读 --------------------------------------

--------------------------------------分割线 --------------------------------------

RMAN跨小版本跨平台与字节序传输表空间(三)