sql clone "alter database datafile? 1 online";
#online the datafiles restored or flipped
sql clone "alter database datafile? 2 online";
#online the datafiles restored or flipped
sql clone "alter database datafile? 3 online";
#online the datafiles restored or flipped
sql clone "alter database datafile? 6 online";
#online the datafiles restored or flipped
sql clone "alter database datafile? 7 online";
# make the controlfile point at the restored datafiles, then recover them
recover clone database tablespace? "TSPITR", "TEST", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
alter clone database open resetlogs;
# PLUG HERE the creation of a temporary tablespace if export fails due to lack
# of temporary space.
# For example in Unix these two lines would do that:
#sql clone "create tablespace aux_tspitr_tmp
#? ? ? ? ? datafile ''/tmp/aux_tspitr_tmp.dbf'' size 500K";
}
executing Memory Script
executing command: SET until clause
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 temporary file 1 to /u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_temp_%u_.tmp in control file
Starting restore at 28-MAR-15
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_system_%u_.dbf
restoring datafile 00002 to /u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_undotbs1_%u_.dbf
restoring datafile 00003 to /u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_sysaux_%u_.dbf
restoring datafile 00006 to /u02/transport/tspitr01.dbf
restoring datafile 00007 to /u02/transport/test01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875392350_1001
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u02/ora_test875392350_1001 tag=TAG20150326T203229
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:45
Finished restore at 28-MAR-15
datafile 1 switched to datafile copy
input datafile copy recid=22 stamp=875560079 filename=/u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_system_bkf2s69f_.dbf
datafile 2 switched to datafile copy
input datafile copy recid=23 stamp=875560079 filename=/u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_undotbs1_bkf2s6b2_.dbf
datafile 3 switched to datafile copy
input datafile copy recid=24 stamp=875560079 filename=/u02/transport/TSPITR_TEST_MEIB/datafile/o1_mf_sysaux_bkf2s69q_.dbf
datafile 6 switched to datafile copy
input datafile copy recid=25 stamp=875560079 filename=/u02/transport/tspitr01.dbf
datafile 7 switched to datafile copy
input datafile copy recid=26 stamp=875560079 filename=/u02/transport/test01.dbf
sql statement: alter database datafile? 1 online
sql statement: alter database datafile? 2 online
sql statement: alter database datafile? 3 online
sql statement: alter database datafile? 6 online
sql statement: alter database datafile? 7 online
Starting recover at 28-MAR-15
using channel ORA_AUX_DISK_1
starting media recovery
archive log thread 1 sequence 80 is already on disk as file /u02/1_80_870806981.dbf
archive log thread 1 sequence 81 is already on disk as file /u02/1_81_870806981.dbf
archive log thread 1 sequence 82 is already on disk as file /u02/1_82_870806981.dbf
archive