bytesFixed Size 2296576 bytesVariable Size 285213952 bytesDatabase Buffers 775946240 bytesRedo Buffers 5480448 bytessql statement: alter database mount clonedatabasecontents of Memory Script:{# set requested point in timeset until scn 1829704;# set destinations for recovery set andauxiliary set datafilesset newname for datafile 6 to new;# restore the tablespaces in the recoveryset and the auxiliary setrestore clone datafile 6;switch clone datafile all;}executing Memory Scriptexecuting command: SET until clauseexecuting command: SET NEWNAMEStarting restore at 20-JUN-14allocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=15 devicetype=DISKchannel ORA_AUX_DISK_1: starting datafilebackup set restorechannel ORA_AUX_DISK_1: specifyingdatafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile00006 to /tmp/backups/ANDS_PITR_ORCL/datafile/o1_mf_users_%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:00:01Finished restore at 20-JUN-14datafile 6 switched to datafile copyinput datafile copy RECID=8STAMP=850734155 filename=/tmp/backups/ANDS_PITR_ORCL/datafile/o1_mf_users_9t8hqts5_.dbfcontents of Memory Script:{# set requested point in timeset until scn 1829704;# online the datafiles restored orswitchedsql clone "alter databasedatafile 6 online";# recover and open resetlogsrecover clone database tablespace "USERS", "SYSTEM","UNDOTBS1", "SYSAUX" delete archivelog;alter clone database open resetlogs;}executing Memory Scriptexecuting command: SET until clausesql statement: alter databasedatafile 6 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:00Finished recover at 20-JUN-14database openedcontents of Memory Script:{# create directory for datapump importsql "create or replace directoryTSPITR_DIROBJ_DPDIR as ''/tmp/backups''";# create directory for datapump exportsql clone "create or replacedirectory TSPITR_DIROBJ_DPDIR as ''/tmp/backups''";}executing Memory Scriptsql statement: create or replace directoryTSPITR_DIROBJ_DPDIR as ''/tmp/backups''sql statement: create or replace directoryTSPITR_DIROBJ_DPDIR as ''/tmp/backups''Performing export of tables... EXPDP> Starting "SYS"."TSPITR_EXP_AnDs_bzdv": EXPDP> Estimate in progress using BLOCKS method... EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA EXPDP> Total estimation using BLOCKS method: 64 KB EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE EXPDP> Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX EXPDP> Processing object typeTABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT EXPDP> Processing object typeTABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS EXPDP> Processing object typeTABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT EXPDP> Processing object typeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER EXPDP> . . exported "SCOTT"."EMP" 8.757 KB 14 rows EXPDP> Master table "SYS"."TSPITR_EXP_AnDs_bzdv"successfully loaded/unloaded EXPDP>****************************************************************************** EXPDP> Dump file set for SYS.TSPITR_EXP_AnDs_bzdv is: EXPDP> /tmp/backups/tspitr_AnDs_17140.dmp EXPDP> Job "SYS"."TSPITR_EXP_AnDs_bzdv"successfully completed at Fri Jun 20 11:03:32 2014 elapsed 0 00:00:31Export completedcontents of Memory Script:{# shutdown clone before importshutdown clone abort}executing Memory ScriptOracle instance shut downPerforming import of tables... IMPDP> Master table "SYS"."TSPITR_IMP_AnDs_lryn"successfully loaded/unloaded IMPDP> Starting "SYS"."TSPITR_IMP_AnDs_lryn": IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA IMPDP> . . imported "SCOTT"."EMP" 8.757 KB 14 rows IMPDP> Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX IMPDP> Processing object typeTABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT IMPDP> Processing object typeTABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS IMPDP> Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT IMPDP> Processing object typeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER IMPDP> Job "SYS"."TSPITR_IMP_AnDs_lryn"successfully completed at Fri Jun 20 11:04:00 2014 elapsed 0 00:00:22Import completedRemoving automatic instanceAutomatic instance removedauxiliary instance file/tmp/backups/ORCL/datafile/o1_mf_temp_9t8hpvlf_.tmp deletedauxiliary instance file/tmp/backups/ANDS_PITR_ORCL/onlinelog/o1_mf_3_9t8hr0xc_.log deletedauxiliary instance file/tmp/backups/ANDS_PITR_ORCL/onlinelog/o1_mf_2_9t8hqyrr_.log deletedauxiliary instance file/tmp/backups/ANDS_PITR_ORCL/onlinelog/o1_mf_1_9t8hqx0p_.log deletedauxiliary instance file/tmp/backups/ANDS_PITR_ORCL/datafile/o1_mf_users_9t8hqts5_.dbf deletedauxiliary instance file/tmp/backups/ORCL/datafile/o1_mf_sysaux_9t8hnr6h_.dbf deletedauxiliary instance file/tmp/backups/ORCL/datafile/o1_mf_undotbs1_9t8hnr6n_.dbf deletedauxiliary instance file /tmp/backups/ORCL/datafile/o1_mf_system_9t8hnr58_.dbfdeletedauxiliary instance file/tmp/backups/ORCL/controlfile/o1_mf_9t8hnfd6_.ctl deletedauxiliary instance filetspitr_AnDs_17140.dmp deletedFinished recover at 20-JUN-14 7. Voltar o parametro "standby_file_management" para AUTO.SQL> alter system setstandby_file_management=auto scope=both;System altered.8. Ativar o processo de "recover" no banco de dadosStandby.SQL> alter database recover managedstandby database disconnect from session;Database altered.7. Verificando a tabela restaurada.[oracle@ora12ctmp]$ sqlplus scott/tigerSQL*Plus:Release 12.1.0.1.0 Production on Fri Jun 20 11:24:24 2014Copyright(c) 1982, 2013, Oracle. All rightsreserved.LastSuccessful login time: