测试平台：window->linux

windows：

验证表空间是否是自包含：

SQL> exec dbms_tts.transport_set_check('mary',true);
PL/SQL 过程已成功完成。

SQL> SELECT * FROM TRANSPORT_SET_VIOLATIONS;

no rows selected

SQL> col platform_name for a40
SQL> select * from V$TRANSPORTABLE_PLATFORM. ;

PLATFORM_ID PLATFORM_NAME                            ENDIAN_FORMAT
----------- ---------------------------------------- --------------
          1 Solaris[tm] OE (32-bit)                  Big
          2 Solaris[tm] OE (64-bit)                  Big
          7 Microsoft Windows IA (32-bit)            Little
         10 Linux IA (32-bit)                        Little
          6 AIX-Based Systems (64-bit)               Big
          3 HP-UX (64-bit)                           Big
          5 HP Tru64 UNIX                            Little
          4 HP-UX IA (64-bit)                        Big
         11 Linux IA (64-bit)                        Little
         15 HP Open VMS                              Little
          8 Microsoft Windows IA (64-bit)            Little
          9 IBM zSeries Based Linux                  Big
         13 Linux 64-bit for AMD                     Little
         16 Apple Mac OS                             Big
         12 Microsoft Windows 64-bit for AMD         Little
         17 Solaris Operating System (x86)           Little
         18 IBM Power Based Linux                    Big

17 rows selected.

表空间置为只读：

SQL> alter tablespace mary read only;
表空间已更改。

C:\>expdp system/sysby dumpfile=mary.dmp directory=expdir transport_tablespaces=mary

Export: Release 10.2.0.1.0 - Production on 星期五, 14 8月, 2009 17:12:27

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
启动 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** dumpfile=mary.dmp
directory=expdir transport_tablespaces=mary
处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
处理对象类型 TRANSPORTABLE_EXPORT/TABLE
处理对象类型 TRANSPORTABLE_EXPORT/TABLE_STATISTICS
处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
已成功加载/卸载了主表 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"
******************************************************************************
SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 的转储文件集为:
D:\ORACLE\PRODUCT\DIRECTORIES\MARY.DMP
作业 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" 已于 17:12:38 成功完成

RMAN> convert tablespace mary to platform. 'Linux IA (32-bit)' format 'c:\%U.bak';
启动 backup 于 14-8月 -09
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 启动数据文件转换
输入数据文件 fno=00006 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\MARY.DBF
已转换的数据文件 = C:\DATA_D-ORCL_I-1216038192_TS-MARY_FNO-6_1KKMMC8T.BAK
通道 ORA_DISK_1: 数据文件转换完毕, 经过时间: 00:00:01
完成 backup 于 14-8月 -09

ftp传输DATA_D-ORCL_I-1216038192_TS-MARY_FNO-6_1KKMMC8T.BAK和mary.dmp文件到LINUX相应目录

Linux：

RMAN> convert datafile '/utils/DATA_D-ORCL_I-1216038192_TS-MARY_FNO-6_1KKMMC8T.BAK' db_file_name_convert '/utils/DATA_D-ORCL_I-1216038192_TS-MARY_FNO-6_1KKMMC8T.BAK','/u01/app/oracle/oradata/orcl/mary.dbf';
Starting backup at 14-AUG-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input filename=/utils/DATA_D-ORCL_I-1216038192_TS-MARY_FNO-6_1KKMMC8T.BAK
converted datafile=/u01/app/oracle/oradata/orcl/mary.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
Finished backup at 14-AUG-09

$ impdp system/sys dumpfile=MARY.DMP directory=dpdata transport_datafiles='/u01/app/oracle/oradata/orcl/mary.dbf'

Import: Release 10.2.0.1.0 - Production on Friday, 14 August, 2009 11:20:04

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/******** dumpfile=MARY.DMP directory=dpdata transport_datafiles=/u01/app/oracle/oradata/orcl/mary.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 11:20:55

ITPub博客

10g跨平台传输表空间

最新文章