datafile 5 switched to datafile copy

input datafile copy RECID=6 STAMP=882712324 file name=/extend/oradata/aux/ORA11G/datafile/o1_mf_system_br4q230g_.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=7 STAMP=882712324 file name=/extend/oradata/aux/ORA11G/datafile/o1_mf_undotbs1_br4q22z4_.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=8 STAMP=882712324 file name=/extend/oradata/aux/ORA11G/datafile/o1_mf_sysaux_br4q22yx_.dbf

--启动虚拟实例数据，完成恢复。

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')";

# online the datafiles restored or switched

sql clone "alter database datafile? 1 online";

sql clone "alter database datafile? 5 online";

sql clone "alter database datafile? 3 online";

sql clone "alter database datafile? 2 online";

sql clone "alter database datafile? 7 online";

# recover and open resetlogs

recover clone database tablespace? "TESTTBL", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;

alter clone database open resetlogs;

}

executing Memory Script

executing command: SET until clause

sql statement: alter database datafile? 1 online

sql statement: alter database datafile? 5 online

sql statement: alter database datafile? 3 online

sql statement: alter database datafile? 2 online

sql statement: alter database datafile? 7 online

Starting recover at 18-JUN-15

using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 17 is already on disk as file /u01/app/fast_recovery_area/ORA11G/archivelog/2015_06_18/o1_mf_1_17_br4pw26f_.arc

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=16

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

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

channel ORA_AUX_DISK_1: restored backup piece 1

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

archived log file name=/extend/oradata/aux/1_16_846081044.dbf thread=1 sequence=16

channel clone_default: deleting archived log(s)

archived log file name=/extend/oradata/aux/1_16_846081044.dbf RECID=27 STAMP=882712328

archived log file name=/u01/app/fast_recovery_area/ORA11G/archivelog/2015_06_18/o1_mf_1_17_br4pw26f_.arc thread=1 sequence=17

media recovery complete, elapsed time: 00:00:01

Finished recover at 18-JUN-15

database opened

--将表空间导出来

contents of Memory Script:

{

# make read only the tablespace that will be exported

sql clone 'alter tablespace? TESTTBL read only';

# create directory for datapump import

sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''

/extend/oradata/aux''";

# create directory for datapump export

sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''

/extend/oradata/aux''";

}

executing Memory Script

sql statement: alter tablespace? TESTTBL read only

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/extend/oradata/aux''

sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/extend/oradata/aux''