ORA-19600: input file is datafile-copy 11 (+DATAGROUP1/rhys/datafile/undotbs1.257.836735137)
ORA-19601: output file is datafile 3 (+DATAGROUP1)
channel ch2: piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag=TAG20140113T100212
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 00:00:35
failover to previous backup
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00001 to +DATAGROUP1/rhys/datafile/system.257.833999503
channel ch1: restoring datafile 00002 to +DATAGROUP1/rhys/datafile/sysaux.256.833999647
channel ch1: restoring datafile 00003 to +DATAGROUP1/rhys/datafile/undotbs1.308.836771963
channel ch1: reading from backup piece +DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737
channel ch1: piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag=TAG20140113T100212
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:03:25
Finished restore at 13-JAN-14
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
released channel: ch5
released channel: ch6
RMAN>
RMAN>
RMAN>
RMAN>
Starting recover at 13-JAN-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK
starting media recovery
archived log for thread 1 with sequence 16 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.275.836735655
archived log for thread 1 with sequence 17 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_17.260.836735657
archived log for thread 1 with sequence 18 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_18.261.836735659
archived log for thread 1 with sequence 1 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_1.305.836751051
archived log for thread 1 with sequence 2 is already on disk as file +DATAGROUP1/rhys/onlinelog/group_2.286.833999961
archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.275.836735655 thread=1 sequence=16
archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_17.260.836735657 thread=1 sequence=17
archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_18.261.836735659 thread=1 sequence=18
archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_1.305.836751051 thread=1 sequence=1
archived log file name=+DATAGROUP1/rhys/onlinelog/group_2.286.833999961 thread=1 sequence=2
media recovery complete, elapsed time: 00:00:59
Finished recover at 13-JAN-14
RMAN> exit
Recovery Manager complete.
[oracle@oracle-one ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 13 20:48:36 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLO