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 RESTORE POINT 'before_update';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of tranport tablespace command at 03/27/2015 20:42:53
RMAN-00600: internal error, arguments [5085] [point] [] [] []
出现RMAN-00600 internal error, arguments [5085] [point]，在MOS上有一篇关于这个错误的文章，是ORACLE的bug,请参考Bug 8571266 - RMAN TSPITR to restore point fails with RMAN-600 [5085] (Doc ID 8571266.8),说这个Bug在11.2.0.2中已经修复了。
--------------------------------------推荐阅读 --------------------------------------
--------------------------------------分割线 --------------------------------------