? EXPDP> Starting "SYS"."TSPITR_EXP_DDfe":?

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT

? EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK

? EXPDP> Master table "SYS"."TSPITR_EXP_DDfe" successfully loaded/unloaded

? EXPDP> ******************************************************************************

? EXPDP> Dump file set for SYS.TSPITR_EXP_DDfe is:

? EXPDP>? /extend/oradata/aux/tspitr_DDfe_54026.dmp

? EXPDP> ******************************************************************************

? EXPDP> Datafiles required for transportable tablespace TESTTBL:

? EXPDP>? /u01/app/oradata/ORA11G/datafile/o1_mf_testtbl_br48h8wp_.dbf

? EXPDP> Job "SYS"."TSPITR_EXP_DDfe" successfully completed at Thu Jun 18 13:54:10 2015 elapsed 0 00:01:13

Export completed

--关闭虚拟实例

contents of Memory Script:

{

# shutdown clone before import

shutdown clone immediate

# drop target tablespaces before importing them back

sql 'drop tablespace? TESTTBL including contents keep datafiles cascade constraints';

}

executing Memory Script

database closed

database dismounted

Oracle instance shut down

--把原来的表空间删除掉

sql statement: drop tablespace? TESTTBL including contents keep datafiles cascade constraints

--恢复导入数据

Performing import of metadata...

? IMPDP> Master table "SYS"."TSPITR_IMP_DDfe" successfully loaded/unloaded

? IMPDP> Starting "SYS"."TSPITR_IMP_DDfe":?

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT

? IMPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK

? IMPDP> Job "SYS"."TSPITR_IMP_DDfe" successfully completed at Thu Jun 18 13:54:54 2015 elapsed 0 00:00:10

Import completed

--第三部分脚本，恢复表空间

contents of Memory Script:

{

# make read write and offline the imported tablespaces

sql 'alter tablespace? TESTTBL read write';

sql 'alter tablespace? TESTTBL offline';

# enable autobackups after TSPITR is finished

sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';

}

executing Memory Script

sql statement: alter tablespace? TESTTBL read write

sql statement: alter tablespace? TESTTBL offline

sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;

Removing automatic instance

Automatic instance removed

auxiliary instance file /extend/oradata/aux/ORA11G/datafile/o1_mf_temp_br4q4ojl_.tmp deleted

auxiliary instance file /extend/oradata/aux/ORA11G/onlinelog/o1_mf_4_br4q4j17_.log deleted

auxiliary instance file /extend/oradata/aux/ORA11G/onlinelog/o1_mf_3_br4q4ghl_.log deleted

auxiliary instance file /extend/oradata/aux/ORA11G/onlinelog/o1_mf_2_br4q4dt5_.log deleted