RMAN> recover database;

Starting recover at 12-MAY-12
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_1_7twq6shs_.arc
archived log for thread 1 with sequence 2 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_2_7twq7yw4_.arc
archived log for thread 1 with sequence 3 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_3_7twr47s1_.arc
archived log for thread 1 with sequence 4 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_4_7twrc1tp_.arc
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=416
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/0fnaq9om_1_1
channel ORA_DISK_1: piece handle=/home/oracle/backup/0fnaq9om_1_1 tag=TAG20120512T154110
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_416_7twrv8l9_.arc thread=1 sequence=416
archived log file name=/u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_1_7twq6shs_.arc thread=1 sequence=1
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_416_7twrv8l9_.arc RECID=364 STAMP=783105576
archived log file name=/u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_2_7twq7yw4_.arc thread=1 sequence=2
archived log file name=/u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_3_7twr47s1_.arc thread=1 sequence=3
archived log file name=/u01/app/oracle/fast_recovery_area/XE/archivelog/2012_05_12/o1_mf_1_4_7twrc1tp_.arc thread=1 sequence=4
unable to find archived log
archived log thread=1 sequence=5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/12/2012 17:19:39
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 5 and starting SCN of 13009448

RMAN>

RMAN> recover database until scn 12929406;

Starting recover at 12-MAY-12
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/12/2012 17:20:38
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/12/2012 17:21:13
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace '~' does not exist or of wrong type
Process ID: 5909
Session ID: 155 Serial number: 7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/12/2012 17:21:13
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace '~' does not exist or of wrong type
Process ID: 5909
Session ID: 155 Serial number: 7