Starting restore at 18-SEP-15 using channel ORA_DISK_1 skipping datafile 13; already restored to file /oradata/CDB/MYPDB1/system01.dbf skipping datafile 14; already restored to file /oradata/CDB/MYPDB1/sysaux01.dbf skipping datafile 15; already restored to file /oradata/CDB/MYPDB1/tbs_MYPDB1_01.dbf restore not done; all files read only, offline, or already restored Finished restore at 18-SEP-15 Starting recover at 18-SEP-15 using channel ORA_DISK_1 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='twsh' initialization parameters used for automatic instance: db_name=CDB db_unique_name=twsh_pitr_MYPDB1_CDB compatible=12.1.0.2.0 db_block_size=8192 db_files=200 diagnostic_dest=/oracle _system_trig_enabled=FALSE sga_target=2560M processes=200 db_create_file_dest=/oratmp log_archive_dest_1='location=/oratmp' enable_pluggable_database=true _clone_one_pdb_recovery=true #No auxiliary parameter file used starting up automatic instance CDB Oracle instance started Total System Global Area 2684354560 bytes Fixed Size 3714440 bytes Variable Size 654312056 bytes Database Buffers 2013265920 bytes Redo Buffers 13062144 bytes Automatic instance created contents of Memory Script: { # set requested point in time set until time "to_date('18-09-2015:08:50:00', 'DD-MM-YYYY:hh24:mi:ss')"; # restore the controlfile restore clone controlfile; # mount the controlfile sql clone 'alter database mount clone database'; } executing Memory Script executing command: SET until clause Starting restore at 18-SEP-15 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=191 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 /oracle/product/12.1.0.2/dbs/c-3858261253-20150918-00 channel ORA_AUX_DISK_1: piece handle=/oracle/product/12.1.0.2/dbs/c-3858261253-20150918-00 tag=TAG20150918T084835 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/oratmp/CDB/controlfile/o1_mf_bzqgo9fp_.ctl Finished restore at 18-SEP-15 sql statement: alter database mount clone database contents of Memory Script: { # set requested point in time set until time "to_date('18-09-2015:08:50:00', 'DD-MM-YYYY:hh24:mi:ss')"; # switch to valid datafilecopies switch clone datafile 13 to datafilecopy "/oradata/CDB/MYPDB1/system01.dbf"; switch clone datafile 14 to datafilecopy "/oradata/CDB/MYPDB1/sysaux01.dbf"; switch clone datafile 15 to datafilecopy "/oradata/CDB/MYPDB1/tbs_MYPDB1_01.dbf"; # 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 6 to new; # restore the tablespaces in the recovery set and the auxiliary set restore clone datafile 1, 5, 3, 6; switch clone datafile all; } executing Memory Script executing command: SET until clause datafile 13 switched to datafile copy input datafile copy RECID=1 STAMP=890731086 file name=/oradata/CDB/MYPDB1/system01.dbf datafile 14 switched to datafile copy input datafile copy RECID=2 STAMP=890731086 file name=/oradata/CDB/MYPDB1/sysaux01.dbf datafile 15 switched to datafile copy input datafile copy RECID=3 STAMP=890731086 file name=/oradata/CDB/MYPDB1/tbs_MYPDB1_01.dbf executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 18-SEP-15 using channel ORA_AUX_DISK_1 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 /oratmp/CDB/datafile/o1_mf_system_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00005 to /oratmp/CDB/datafile/o1_mf_undotbs1_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00003 to /oratmp/CDB/datafile/o1_mf_sysaux_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00006 to /oratmp/CDB/datafile/o1_mf_users_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /oratmp/Backup/bkpfull_svg_DB_on%_8907292970hqhesqh_1_1.bkp channel ORA_AUX_DISK_1: piece handle=/oratmp/Backup/bkpfull_svg_DB_on%_8907292970hqhesqh_1_1.bkp tag=TAG20150918T084817 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 Finished restore at 18-SEP-15 datafile 1 switched to datafile copy input datafile copy RECID=8 STAMP=890731102 file name=/oratmp/CDB/datafile/o1_mf_system_bzqgogyy_.dbf datafile 5 switched to datafile copy input datafile copy RECID=9 STAMP=890731102 file name=/oratmp/CDB/datafile/o1_mf_undotbs1_bzqgogyx_.dbf datafile 3 switched to datafile copy input datafile copy RECID=10 STAMP=890731102 file name=/oratmp/CDB/datafile/o1_mf_sysaux_bzqgogyz_.dbf datafile 6 switched to datafile copy input datafile copy RECID=11 STAMP=890731102 file name=/oratmp/CDB/datafile/o1_mf_users_bzqgogz0_.dbf contents of Memory Script: { # set requested point in time set until time "to_date('18-09-2015:08:50:00', 'DD-MM-YYYY: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 'MYPDB1' "alter database datafile 13 online"; sql clone 'MYPDB1' "alter database datafile 14 online"; sql clone 'MYPDB1' "alter database datafile 15 online"; sql clone "alter database datafile 6 online"; # recover pdb recover clone database tablespace "SYSTEM", "UNDOTBS1", "SYSAUX", "USERS" pluggable database 'MYPDB1' delete archivelog; sql clone 'alter database open read only'; plsql <>; plsql <>; # shutdown clone before import shutdown clone abort plsql <>>; } 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 13 online sql statement: alter database datafile 14 online sql statement: alter database datafile 15 online sql statement: alter database datafile 6 online Section Recover : Starting recover at 18-SEP-15 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 267 is already on disk as file /oradata/CDB/arch/1_267_890666181.dbf archived log for thread 1 with sequence 268 is already on disk as file /oradata/CDB/arch/1_268_890666181.dbf archived log file name=/oradata/CDB/arch/1_267_890666181.dbf thread=1 sequence=267 archived log file name=/oradata/CDB/arch/1_268_890666181.dbf thread=1 sequence=268 media recovery complete, elapsed time: 00:00:00 Finished recover at 18-SEP-15 sql statement: alter database open read only Oracle instance shut down Removing automatic instance Automatic instance removed auxiliary instance file /oratmp/CDB/datafile/o1_mf_sysaux_bzqgogyz_.dbf deleted auxiliary instance file /oratmp/CDB/controlfile/o1_mf_bzqgo9fp_.ctl deleted Finished recover at 18-SEP-15