{\rtf1\ansi\ansicpg1252\cocoartf1038\cocoasubrtf320
{\fonttbl\f0\fmodern\fcharset0 CourierNewPSMT;}
{\colortbl;\red255\green255\blue255;}
\margl1440\margr1440\vieww18740\viewh14060\viewkind0
\deftab720
\pard\pardeftab720\ri720

\f0\fs24 \cf0 Starting recover at 03-AUG-10\
using target database control file instead of recovery catalog\
allocated channel: ORA_DISK_1\
channel ORA_DISK_1: SID=56 device type=DISK\
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time\
\
List of tablespaces expected to have UNDO segments\
Tablespace SYSTEM\
Tablespace UNDOTBS1\
\
Creating automatic instance, with SID='Dvlf'\
\
initialization parameters used for automatic instance:\
db_name=D112D1\
db_unique_name=Dvlf_tspitr_D112D1\
compatible=11.2.0.0.0\
db_block_size=8192\
db_files=200\
sga_target=280M\
processes=50\
db_create_file_dest=/u01/oraux\
log_archive_dest_1='location=/u01/oraux'\
#No auxiliary parameter file used\
\
\
starting up automatic instance D112D1\
\
Oracle instance started\
\
Total System Global Area     292933632 bytes\
\
Fixed Size                     1336092 bytes\
Variable Size                100666596 bytes\
Database Buffers             184549376 bytes\
Redo Buffers                   6381568 bytes\
Automatic instance created\
\
\
List of tablespaces that have been dropped from the target database:\
Tablespace testts\
\
contents of Memory Script:\
\{\
# set requested point in time\
set until  time "to_date('08/03/2010 15:35:53','mm/dd/yyyy hh24:mi:ss')";\
# restore the controlfile\
restore clone controlfile;\
# mount the controlfile\
sql clone 'alter database mount clone database';\
# archive current online log \
sql 'alter system archive log current';\
# avoid unnecessary autobackups for structural changes during TSPITR\
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';\
\}\
executing Memory Script\
\
executing command: SET until clause\
\
Starting restore at 03-AUG-10\
allocated channel: ORA_AUX_DISK_1\
channel ORA_AUX_DISK_1: SID=59 device type=DISK\
\
channel ORA_AUX_DISK_1: starting datafile backup set restore\
channel ORA_AUX_DISK_1: restoring control file\
channel ORA_AUX_DISK_1: reading from backup piece +DATA/d112d1/autobackup/2010_08_03/n_726075136.310.726075137\
channel ORA_AUX_DISK_1: piece handle=+DATA/d112d1/autobackup/2010_08_03/n_726075136.310.726075137 tag=TAG20100803T153216\
channel ORA_AUX_DISK_1: restored backup piece 1\
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04\
output file name=/u01/oraux/D112D1/controlfile/o1_mf_65jw0wp9_.ctl\
Finished restore at 03-AUG-10\
\
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('08/03/2010 15:35:53','mm/dd/yyyy hh24:mi:ss')";\
# set destinations for recovery set and auxiliary set datafiles\
set newname for clone datafile  1 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  8 to \
 "/u01/oradata/testts_01.dbf";\
# switch all tempfiles\
switch clone tempfile all;\
# restore the tablespaces in the recovery set and the auxiliary set\
restore clone datafile  1, 3, 2, 8;\
switch clone datafile all;\
\}\
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\
\
renamed tempfile 1 to /u01/oraux/D112D1/datafile/o1_mf_temp_%u_.tmp in control file\
\
Starting restore at 03-AUG-10\
using channel ORA_AUX_DISK_1\
\
channel ORA_AUX_DISK_1: restoring datafile 00001\
input datafile copy RECID=5 STAMP=726066326 file name=/u01/oraback/data_D-D112D1_I-1718629572_TS-SYSTEM_FNO-1_0glkdp2t.dbf\
destination for restore of datafile 00001: /u01/oraux/D112D1/datafile/o1_mf_system_%u_.dbf\
channel ORA_AUX_DISK_1: copied datafile copy of datafile 00001\
output file name=/u01/oraux/D112D1/datafile/o1_mf_system_65jw15gs_.dbf RECID=13 STAMP=726075549\
channel ORA_AUX_DISK_1: restoring datafile 00003\
input datafile copy RECID=6 STAMP=726066362 file name=/u01/oraback/data_D-D112D1_I-1718629572_TS-UNDOTBS1_FNO-3_0hlkdp4u.dbf\
destination for restore of datafile 00003: /u01/oraux/D112D1/datafile/o1_mf_undotbs1_%u_.dbf\
channel ORA_AUX_DISK_1: copied datafile copy of datafile 00003\
output file name=/u01/oraux/D112D1/datafile/o1_mf_undotbs1_65jw36n4_.dbf RECID=14 STAMP=726075595\
channel ORA_AUX_DISK_1: restoring datafile 00002\
input datafile copy RECID=4 STAMP=726066263 file name=/u01/oraback/data_D-D112D1_I-1718629572_TS-SYSAUX_FNO-2_0elkdp0h.dbf\
destination for restore of datafile 00002: /u01/oraux/D112D1/datafile/o1_mf_sysaux_%u_.dbf\
channel ORA_AUX_DISK_1: copied datafile copy of datafile 00002\
output file name=/u01/oraux/D112D1/datafile/o1_mf_sysaux_65jw4mq5_.dbf RECID=15 STAMP=726075673\
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 00008 to /u01/oradata/testts_01.dbf\
channel ORA_AUX_DISK_1: reading from backup piece +DATA/d112d1/backupset/2010_08_03/nnndf0_tag20100803t153214_0.309.726075135\
channel ORA_AUX_DISK_1: piece handle=+DATA/d112d1/backupset/2010_08_03/nnndf0_tag20100803t153214_0.309.726075135 tag=TAG20100803T153214\
channel ORA_AUX_DISK_1: restored backup piece 1\
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01\
Finished restore at 03-AUG-10\
\
datafile 1 switched to datafile copy\
input datafile copy RECID=16 STAMP=726075680 file name=/u01/oraux/D112D1/datafile/o1_mf_system_65jw15gs_.dbf\
datafile 3 switched to datafile copy\
input datafile copy RECID=17 STAMP=726075680 file name=/u01/oraux/D112D1/datafile/o1_mf_undotbs1_65jw36n4_.dbf\
datafile 2 switched to datafile copy\
input datafile copy RECID=18 STAMP=726075680 file name=/u01/oraux/D112D1/datafile/o1_mf_sysaux_65jw4mq5_.dbf\
\
contents of Memory Script:\
\{\
# set requested point in time\
set until  time "to_date('08/03/2010 15:35:53','mm/dd/yyyy hh24:mi:ss')";\
# online the datafiles restored or switched\
sql clone "alter database datafile  1 online";\
sql clone "alter database datafile  3 online";\
sql clone "alter database datafile  2 online";\
sql clone "alter database datafile  8 online";\
# recover and open resetlogs\
recover clone database tablespace  "TESTTS", "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  3 online\
\
sql statement: alter database datafile  2 online\
\
sql statement: alter database datafile  8 online\
\
Starting recover at 03-AUG-10\
using channel ORA_AUX_DISK_1\
\
starting media recovery\
\
archived log for thread 1 with sequence 634 is already on disk as file +DATA/d112d1/archivelog/2010_08_03/thread_1_seq_634.302.726068261\
archived log for thread 1 with sequence 635 is already on disk as file +DATA/d112d1/archivelog/2010_08_03/thread_1_seq_635.308.726070587\
archived log for thread 1 with sequence 636 is already on disk as file +DATA/d112d1/archivelog/2010_08_03/thread_1_seq_636.311.726075491\
archived log file name=+DATA/d112d1/archivelog/2010_08_03/thread_1_seq_634.302.726068261 thread=1 sequence=634\
archived log file name=+DATA/d112d1/archivelog/2010_08_03/thread_1_seq_635.308.726070587 thread=1 sequence=635\
archived log file name=+DATA/d112d1/archivelog/2010_08_03/thread_1_seq_636.311.726075491 thread=1 sequence=636\
media recovery complete, elapsed time: 00:00:13\
Finished recover at 03-AUG-10\
\
database opened\
\
contents of Memory Script:\
\{\
# make read only the tablespace that will be exported\
sql clone 'alter tablespace  TESTTS read only';\
# create directory for datapump import\
sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''\
/u01/oraux''";\
# create directory for datapump export\
sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''\
/u01/oraux''";\
\}\
executing Memory Script\
\
sql statement: alter tablespace  TESTTS read only\
\
sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/oraux''\
\
sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/oraux''\
\
Performing export of metadata...\
   EXPDP> Starting "SYS"."TSPITR_EXP_Dvlf":  \
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK\
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE\
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK\
   EXPDP> Master table "SYS"."TSPITR_EXP_Dvlf" successfully loaded/unloaded\
   EXPDP> ******************************************************************************\
   EXPDP> Dump file set for SYS.TSPITR_EXP_Dvlf is:\
   EXPDP>   /u01/oraux/tspitr_Dvlf_10864.dmp\
   EXPDP> ******************************************************************************\
   EXPDP> Datafiles required for transportable tablespace TESTTS:\
   EXPDP>   /u01/oradata/testts_01.dbf\
   EXPDP> Job "SYS"."TSPITR_EXP_Dvlf" successfully completed at 15:45:25\
Export completed\
\
\
contents of Memory Script:\
\{\
# shutdown clone before import\
shutdown clone immediate\
\}\
executing Memory Script\
\
database closed\
database dismounted\
Oracle instance shut down\
\
Performing import of metadata...\
   IMPDP> Master table "SYS"."TSPITR_IMP_Dvlf" successfully loaded/unloaded\
   IMPDP> Starting "SYS"."TSPITR_IMP_Dvlf":  \
   IMPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK\
   IMPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE\
   IMPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK\
   IMPDP> Job "SYS"."TSPITR_IMP_Dvlf" successfully completed at 15:45:54\
Import completed\
\
\
contents of Memory Script:\
\{\
# make read write and offline the imported tablespaces\
sql 'alter tablespace  TESTTS read write';\
sql 'alter tablespace  TESTTS offline';\
# enable autobackups after TSPITR is finished\
sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';\
\}\
executing Memory Script\
\
sql statement: alter tablespace  TESTTS read write\
\
sql statement: alter tablespace  TESTTS offline\
\
sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;\
\
Removing automatic instance\
Automatic instance removed\
auxiliary instance file /u01/oraux/D112D1/datafile/o1_mf_temp_65jw7ybv_.tmp deleted\
auxiliary instance file /u01/oraux/D112D1/onlinelog/o1_mf_3_65jw7rvy_.log deleted\
auxiliary instance file /u01/oraux/D112D1/onlinelog/o1_mf_2_65jw7pk3_.log deleted\
auxiliary instance file /u01/oraux/D112D1/onlinelog/o1_mf_1_65jw7ndz_.log deleted\
auxiliary instance file /u01/oraux/D112D1/datafile/o1_mf_sysaux_65jw4mq5_.dbf deleted\
auxiliary instance file /u01/oraux/D112D1/datafile/o1_mf_undotbs1_65jw36n4_.dbf deleted\
auxiliary instance file /u01/oraux/D112D1/datafile/o1_mf_system_65jw15gs_.dbf deleted\
auxiliary instance file /u01/oraux/D112D1/controlfile/o1_mf_65jw0wp9_.ctl deleted\
Finished recover at 03-AUG-10\
\
RMAN> \
RMAN> **end-of-file**\
}