Restoring, if datafile was added during backup

Backup
STARTED AT: [2013-10-17 06:25:21 UTC]
DONE AT  : [2013-10-17 18:31:21 UTC]


New datafiles added
FILE# CREATION_TIME
162 10/17/2013 3:08:54 PM
161 10/17/2013 2:49:48 PM
160 10/17/2013 2:48:05 PM
159 10/17/2013 2:45:46 PM
158 10/17/2013 2:44:09 PM
157 10/17/2013 2:41:24 PM
156 10/11/2012 6:29:26 PM
155 10/02/2012 7:42:29 PM
154 10/02/2012 7:00:39 PM



The restore datafile from TAG incr0_DBNAME_131017_062729 doesn’t work.

->restore database from tag 'incr0_DBNAME_131017_062729';

Starting restore at 19-OCT-2013 02:32:08

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/19/2013 02:32:28
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 162 found to restore
RMAN-06023: no backup or copy of datafile 161 found to restore
RMAN-06023: no backup or copy of datafile 160 found to restore
RMAN-06023: no backup or copy of datafile 159 found to restore
RMAN-06023: no backup or copy of datafile 158 found to restore
RMAN-06023: no backup or copy of datafile 157 found to restore



The set until time to end of backup doesn’t work either.

->Set Until Time '17-Oct-2013 18:31:21';
->Restore Database;

Starting restore at 19-OCT-2013 03:20:17

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/19/2013 03:20:36
RMAN-06085: must use SET NEWNAME command to restore datafile 157

Recovery Manager complete.




But set until time to begin of backup works.


#use begin backup time
->Set Until Time '17-Oct-2013 06:25:21';
->Restore Database;


… works fine ….