-bash-3.2$ rman Recovery Manager: Release 10.2.0.1.0 - Production on Mon Mar 7 12:08:23 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. RMAN> set dbid=2564640337 connect target / RMAN> RMAN> executing command: SET DBID RMAN> connected to target database: (not mounted) RMAN> restore controlfile from '/dumps/XE/c-2564640337-20110303-00'; Starting restore at 07-MAR-11 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=34 devtype=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output filename=/usr/lib/oracle/xe/oradata/XE/control.dbf Finished restore at 07-MAR-11 RMAN> set controlfile autobackup format for device type disk to '/dumps/XE/%F'; executing command: SET CONTROLFILE AUTOBACKUP FORMAT RMAN> alter database mount; database mounted released channel: ORA_DISK_1 RMAN> run { set until time "TO_DATE('24/02/2011/15/00', 'DD/MM/YYYY/HH24/MI')"; restore database; recover database; } 2> 3> 4> 5> executing command: SET until clause Starting restore at 07-MAR-11 Starting implicit crosscheck backup at 07-MAR-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=34 devtype=DISK Crosschecked 10 objects Finished implicit crosscheck backup at 07-MAR-11 Starting implicit crosscheck copy at 07-MAR-11 using channel ORA_DISK_1 Finished implicit crosscheck copy at 07-MAR-11 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_06/o1_mf_1_3_6q7t2ytq_.arc File Name: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_05/o1_mf_1_1_6q53xmw7_.arc File Name: /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_05/o1_mf_1_2_6q55oz51_.arc using channel ORA_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/07/2011 12:09:31 RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time RMAN> RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 XE 2564640337 PARENT 1 31-JAN-06 2 2 XE 2564640337 PARENT 393626 07-APR-09 3 3 XE 2564640337 CURRENT 144510135 05-MAR-11 RMAN> reset database to incarnation 2; RMAN> database reset to incarnation 2 RMAN> run { set until time "TO_DATE('24/02/2011/15/00', 'DD/MM/YYYY/HH24/MI')"; restore database; recover database; } RMAN> 2> 3> 4> 5> executing command: SET until clause Starting restore at 07-MAR-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /usr/lib/oracle/xe/oradata/XE/system.dbf restoring datafile 00002 to /usr/lib/oracle/xe/oradata/XE/undo.dbf restoring datafile 00003 to /usr/lib/oracle/xe/oradata/XE/sysaux.dbf restoring datafile 00004 to /usr/lib/oracle/xe/oradata/XE/users.dbf channel ORA_DISK_1: reading from backup piece /dumps/XE/20110220_XE_1655_1_743565616 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110220_XE_1655_1_743565616 tag=TAG20110220T020016 channel ORA_DISK_1: restore complete, elapsed time: 00:04:46 Finished restore at 07-MAR-11 Starting recover at 07-MAR-11 using channel ORA_DISK_1 starting media recovery channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1774 channel ORA_DISK_1: reading from backup piece /dumps/XE/20110220_XE_1657_1_743566016 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110220_XE_1657_1_743566016 tag=TAG20110220T020656 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1774_6qbh5qx8_.arc thread=1 sequence=1774 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1774_6qbh5qx8_.arc recid=1772 stamp=745157688 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1775 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1776 channel ORA_DISK_1: reading from backup piece /dumps/XE/20110221_XE_1659_1_743652007 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110221_XE_1659_1_743652007 tag=TAG20110221T020006 channel ORA_DISK_1: restore complete, elapsed time: 00:00:08 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1775_6qbh5td7_.arc thread=1 sequence=1775 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1775_6qbh5td7_.arc recid=1774 stamp=745157695 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1776_6qbh5tk1_.arc thread=1 sequence=1776 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1776_6qbh5tk1_.arc recid=1773 stamp=745157692 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1777 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1778 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1779 channel ORA_DISK_1: reading from backup piece /dumps/XE/20110222_XE_1661_1_743738407 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110222_XE_1661_1_743738407 tag=TAG20110222T020007 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1777_6qbh69gs_.arc thread=1 sequence=1777 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1777_6qbh69gs_.arc recid=1776 stamp=745157715 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1778_6qbh69nh_.arc thread=1 sequence=1778 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1778_6qbh69nh_.arc recid=1777 stamp=745157715 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1779_6qbh69qh_.arc thread=1 sequence=1779 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1779_6qbh69qh_.arc recid=1775 stamp=745157709 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1780 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1781 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1782 channel ORA_DISK_1: reading from backup piece /dumps/XE/20110223_XE_1663_1_743824808 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110223_XE_1663_1_743824808 tag=TAG20110223T020007 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1780_6qbh7d7h_.arc thread=1 sequence=1780 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1780_6qbh7d7h_.arc recid=1779 stamp=745157752 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1781_6qbh7dom_.arc thread=1 sequence=1781 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1781_6qbh7dom_.arc recid=1780 stamp=745157752 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1782_6qbh7drp_.arc thread=1 sequence=1782 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1782_6qbh7drp_.arc recid=1778 stamp=745157750 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1783 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1784 channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1785 channel ORA_DISK_1: reading from backup piece /dumps/XE/20110224_XE_1665_1_743911208 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110224_XE_1665_1_743911208 tag=TAG20110224T020007 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1783_6qbh8jn7_.arc thread=1 sequence=1783 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1783_6qbh8jn7_.arc recid=1783 stamp=745157788 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1784_6qbh8j5c_.arc thread=1 sequence=1784 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1784_6qbh8j5c_.arc recid=1782 stamp=745157788 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1785_6qbh8jpz_.arc thread=1 sequence=1785 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1785_6qbh8jpz_.arc recid=1781 stamp=745157785 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=1786 channel ORA_DISK_1: reading from backup piece /dumps/XE/20110225_XE_1667_1_743997609 channel ORA_DISK_1: restored backup piece 1 piece handle=/dumps/XE/20110225_XE_1667_1_743997609 tag=TAG20110225T020009 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1786_6qbh9q3n_.arc thread=1 sequence=1786 channel default: deleting archive log(s) archive log filename=/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog/2011_03_07/o1_mf_1_1786_6qbh9q3n_.arc recid=1784 stamp=745157825 media recovery complete, elapsed time: 00:00:09 Finished recover at 07-MAR-11 RMAN>