Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
auxiliary instance file /u02/transport/cntrl_tspitr_TEST_wkgj.f deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/datafile/o1_mf_system_bkblqy42_.dbf deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/datafile/o1_mf_undotbs1_bkblqy5h_.dbf deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/datafile/o1_mf_sysaux_bkblqy4h_.dbf deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/datafile/o1_mf_temp_bkblv2ot_.tmp deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/onlinelog/o1_mf_1_bkbltlnc_.log deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/onlinelog/o1_mf_2_bkbltp71_.log deleted
auxiliary instance file /u02/transport/TSPITR_TEST_WKGJ/onlinelog/o1_mf_3_bkbltt75_.log deleted
5.将步骤4生成的传输表空间的数据文件tspitr01.dbf,test01.dbf和Data Pump导出文件dmpfile拷贝到目标主机上的/u02目录中
[oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u02/transport/tspitr01.dbf /u02
oracle@192.168.56.2's password:
tspitr01.dbf 100% 100MB 7.1MB/s 00:14
[oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u02/transport/test01.dbf /u02
oracle@192.168.56.2's password:
test01.dbf 100% 10MB 10.0MB/s 00:00
[oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u02/transport/dmpfile.dmp /u02
oracle@192.168.56.2's password:
dmpfile.dmp 100% 96KB 96.0KB/s 00:00
[oracle@jingyong1 u02]$ ls -lrt
total 112876
-rw-r----- 1 oracle oinstall 104865792 Mar 27 17:54 tspitr01.dbf
-rw-r----- 1 oracle oinstall 10493952 Mar 27 18:22 test01.dbf
-rw-r----- 1 oracle oinstall 98304 Mar 27 18:22 dmpfile.dmp
6.在目录主机上创建相关用户及Data Pump目录并将表空间附加到目标数据库中
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 directory mytest as '/u02';
Directory created.
SQL> grant read,write on directory mytest to public;
Grant succeeded.