RMAN使用备份按时间点传输表空间(10)

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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/6f0e541c5be09521da9fe30f738be130.html