BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6608 Full 7.02M DISK 00:00:01 2015-03-26 20:33:46
BP Key: 6622 Status: AVAILABLE Compressed: NO Tag: TAG20150326T203229
Piece Name: /u02/ora_test875392425_1011
Control File Included: Ckp SCN: 1145304 Ckp time: 2015-03-26 20:33:45
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
6658 2.50K DISK 00:00:01 2015-03-26 20:33:49
BP Key: 6660 Status: AVAILABLE Compressed: NO Tag: TAG20150326T203348
Piece Name: /u02/ora_test875392428_1021
List of Archived Logs in backup set 6658
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 80 1145259 2015-03-26 20:32:19 1145307 2015-03-26 20:33:47
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6689 Full 7.05M DISK 00:00:01 2015-03-26 20:33:52
BP Key: 6691 Status: AVAILABLE Compressed: NO Tag: TAG20150326T203351
Piece Name: /u02/c-2168949517-20150326-07
Control File Included: Ckp SCN: 1145329 Ckp time: 2015-03-26 20:33:51
SPFILE Included: Modification time: 2015-03-26 19:31:13
4.在这里指定了auxiliary destination子句让RMAN使用缺省值来管理辅助实例。只指定必须的选项。Oracle建议transport tablespace命令使用辅助目录秋简化辅助实例文件的管理。下面来执transport tablespace命令来传输tspitr,test两个表空间:
RMAN> transport tablespace "TSPITR","TEST" tablespace destination '/u02/transport' auxiliary destination '/u02/transport' until time "to_date('2015-03-27 16:48:29','yyyy-mm-dd hh24:mi:ss')";
Creating automatic instance, with SID='wkgj'
initialization parameters used for automatic instance:
db_name=TEST
compatible=10.2.0.5.0
db_block_size=8192
db_files=200
db_unique_name=tspitr_TEST_wkgj
sga_target=180M
processes=50
#No auxiliary parameter file used
db_create_file_dest=/u02/transport
control_files=/u02/transport/cntrl_tspitr_TEST_wkgj.f
starting up automatic instance TEST
Oracle instance started
Total System Global Area 188743680 bytes
Fixed Size 1272720 bytes
Variable Size 62915696 bytes
Database Buffers 121634816 bytes
Redo Buffers 2920448 bytes
Automatic instance created
contents of Memory Script:
{
# set the until clause
set until time "to_date('2015-03-27 16:48:29','yyyy-mm-dd hh24:mi:ss')";
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# avoid unnecessary autobackups for structural changes during TSPITR
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
# resync catalog after controlfile restore
resync catalog;
}
executing Memory Script
executing command: SET until clause
Starting restore at 27-MAR-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=47 devtype=DISK