channel ORA_AUX_DISK_1: piece handle=/u01/app/fast_recovery_area/ORA11G/autobackup/2015_06_18/o1_mf_s_882701042_br4d3m3c_.bkp tag=TAG20150618T104402

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02

output file name=/extend/oradata/aux/ORA11G/controlfile/o1_mf_br4q1v2o_.ctl

Finished restore at 18-JUN-15

sql statement: alter database mount clone database

sql statement: alter system archive log current

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

contents of Memory Script:

{

# set requested point in time

set until? time "to_date('2015-06-18 10:51:19','yyyy-mm-dd hh24:mi:ss')";

plsql <<<-- tspitr_2

declare

? sqlstatement? ? ? varchar2(512);

? offline_not_needed exception;

? pragma exception_init(offline_not_needed, -01539);

begin

? sqlstatement := 'alter tablespace '||? 'TESTTBL' ||' offline immediate';

? krmicd.writeMsg(6162, sqlstatement);

? krmicd.execSql(sqlstatement);

exception

? when offline_not_needed then

? ? null;

end; >>>;

# set destinations for recovery set and auxiliary set datafiles

set newname for clone datafile? 1 to new;

set newname for clone datafile? 5 to new;

set newname for clone datafile? 3 to new;

set newname for clone datafile? 2 to new;

set newname for clone tempfile? 1 to new;

set newname for datafile? 7 to?

?"/u01/app/oradata/ORA11G/datafile/o1_mf_testtbl_br48h8wp_.dbf";

# switch all tempfiles

switch clone tempfile all;

# restore the tablespaces in the recovery set and the auxiliary set

restore clone datafile? 1, 5, 3, 2, 7;

switch clone datafile all;

}

executing Memory Script

executing command: SET until clause

sql statement: alter tablespace TESTTBL offline immediate

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /extend/oradata/aux/ORA11G/datafile/o1_mf_temp_%u_.tmp in control file

Starting restore at 18-JUN-15

using channel ORA_AUX_DISK_1

--只恢复system, sysaux, undo和目标testtbl表空间。

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /extend/oradata/aux/ORA11G/datafile/o1_mf_system_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00005 to /extend/oradata/aux/ORA11G/datafile/o1_mf_system_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /extend/oradata/aux/ORA11G/datafile/o1_mf_undotbs1_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00002 to /extend/oradata/aux/ORA11G/datafile/o1_mf_sysaux_%u_.dbf

channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oradata/ORA11G/datafile/o1_mf_testtbl_br48h8wp_.dbf

channel ORA_AUX_DISK_1: reading from backup piece /u01/app/fast_recovery_area/ORA11G/backupset/2015_06_18/o1_mf_nnndf_TAG20150618T104315_br4d23ty_.bkp

channel ORA_AUX_DISK_1: piece handle=/u01/app/fast_recovery_area/ORA11G/backupset/2015_06_18/o1_mf_nnndf_TAG20150618T104315_br4d23ty_.bkp tag=TAG20150618T104315

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05

Finished restore at 18-JUN-15

datafile 1 switched to datafile copy