applies to specified Point-in-TimeList of tablespaces expected to have UNDOsegmentsTablespace SYSTEMTablespace UNDOTBS1Creating automatic instance, withSID='AnDs'initialization parameters used forautomatic instance:db_name=ORCLdb_unique_name=AnDs_pitr_ORCLcompatible=12.1.0.0.0db_block_size=8192db_files=200sga_target=1Gprocesses=80diagnostic_dest=/u01/app/oracledb_create_file_dest=/tmp/backupslog_archive_dest_1='location=/tmp/backups'#No auxiliary parameter file usedstarting up automatic instance ORCLOracle instance startedTotal System Global Area 1068937216 bytesFixed Size 2296576 bytesVariable Size 281019648 bytesDatabase Buffers 780140544 bytesRedo Buffers 5480448 bytesAutomatic instance createdcontents of Memory Script:{# set requested point in timeset until scn 1829704;# restore the controlfilerestore clone controlfile;# mount the controlfilesql clone 'alter database mount clonedatabase';# archive current online logsql 'alter system archive log current';}executing Memory Scriptexecuting command: SET until clauseStarting restore at 20-JUN-14allocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=75 devicetype=DISKchannel ORA_AUX_DISK_1: starting datafilebackup set restorechannel ORA_AUX_DISK_1: restoring controlfilechannel ORA_AUX_DISK_1: reading frombackup piece /u01/app/oracle/12c/db/dbs/0apba9s8_1_1channel ORA_AUX_DISK_1: piecehandle=/u01/app/oracle/12c/db/dbs/0apba9s8_1_1 tag=TAG20140620T104101channel ORA_AUX_DISK_1: restored backuppiece 1channel ORA_AUX_DISK_1: restore complete,elapsed time: 00:00:01output filename=/tmp/backups/ORCL/controlfile/o1_mf_9t8hnfd6_.ctlFinished restore at 20-JUN-14sql statement: alter database mount clonedatabasesql statement: alter system archive logcurrentcontents of Memory Script:{# set requested point in timeset until scn 1829704;# set destinations for recovery set andauxiliary set datafilesset newname for clone datafile 1 to new;set newname for clone datafile 4 to new;set newname for clone datafile 3 to new;set newname for clone tempfile 1 to new;# switch all tempfilesswitch clone tempfile all;# restore the tablespaces in the recoveryset and the auxiliary setrestore clone datafile 1, 4, 3;switch clone datafile all;}executing Memory Scriptexecuting command: SET until clauseexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMErenamed tempfile 1 to /tmp/backups/ORCL/datafile/o1_mf_temp_%u_.tmpin control fileStarting restore at 20-JUN-14using channel ORA_AUX_DISK_1channel ORA_AUX_DISK_1: starting datafilebackup set restorechannel ORA_AUX_DISK_1: specifyingdatafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile00001 to /tmp/backups/ORCL/datafile/o1_mf_system_%u_.dbfchannel ORA_AUX_DISK_1: restoring datafile00004 to /tmp/backups/ORCL/datafile/o1_mf_undotbs1_%u_.dbfchannel ORA_AUX_DISK_1: restoring datafile00003 to /tmp/backups/ORCL/datafile/o1_mf_sysaux_%u_.dbfchannel ORA_AUX_DISK_1: reading frombackup piece /u01/app/oracle/12c/db/dbs/09pba9pt_1_1channel ORA_AUX_DISK_1: piecehandle=/u01/app/oracle/12c/db/dbs/09pba9pt_1_1 tag=TAG20140620T104101channel ORA_AUX_DISK_1: restored backuppiece 1channel ORA_AUX_DISK_1: restore complete,elapsed time: 00:01:05Finished restore at 20-JUN-14datafile 1 switched to datafile copyinput datafile copy RECID=4STAMP=850734121 file name=/tmp/backups/ORCL/datafile/o1_mf_system_9t8hnr58_.dbfdatafile 4 switched to datafile copyinput datafile copy RECID=5STAMP=850734121 filename=/tmp/backups/ORCL/datafile/o1_mf_undotbs1_9t8hnr6n_.dbfdatafile 3 switched to datafile copyinput datafile copy RECID=6STAMP=850734121 file name=/tmp/backups/ORCL/datafile/o1_mf_sysaux_9t8hnr6h_.dbfcontents of Memory Script:{# set requested point in timeset until scn 1829704;# online the datafiles restored orswitchedsql clone "alter databasedatafile 1 online";sql clone "alter databasedatafile 4 online";sql clone "alter databasedatafile 3 online";# recover and open database read onlyrecover clone database tablespace "SYSTEM", "UNDOTBS1","SYSAUX";sql clone 'alter database open read only';}executing Memory Scriptexecuting command: SET until clausesql statement: alter databasedatafile 1 onlinesql statement: alter databasedatafile 4 onlinesql statement: alter databasedatafile 3 onlineStarting recover at 20-JUN-14using channel ORA_AUX_DISK_1starting media recoveryarchived log for thread 1 with sequence 14is already on disk as file /u01/app/oracle/12c/db/dbs/arch/1_14_847989067.dbfarchived log filename=/u01/app/oracle/12c/db/dbs/arch/1_14_847989067.dbf thread=1 sequence=14media recovery complete, elapsed time:00:00:01Finished recover at 20-JUN-14sql statement: alter database open readonlycontents of Memory Script:{ sql clone "create spfile from memory"; shutdown clone immediate; startup clone nomount; sqlclone "alter system set control_files = ''/tmp/backups/ORCL/controlfile/o1_mf_9t8hnfd6_.ctl'' comment= ''RMAN set'' scope=spfile"; shutdown clone immediate; startup clone nomount;# mount databasesql clone 'alter database mount clonedatabase';}executing Memory Scriptsql statement: create spfile from memorydatabase closeddatabase dismountedOracle instance shut downconnected to auxiliary database (notstarted)Oracle instance startedTotal System Global Area 1068937216 bytesFixed Size 2296576 bytesVariable Size 285213952 bytesDatabase Buffers 775946240 bytesRedo Buffers 5480448 bytessql statement: alter system set control_files = ''/tmp/backups/ORCL/controlfile/o1_mf_9t8hnfd6_.ctl''comment= ''RMAN set'' scope=spfileOracle instance shut downconnected to auxiliary database (notstarted)Oracle instance startedTotal System Global Area 1068937216