Point-In-Time Recovery database : until time failed
ON PROD :
o 28/12 Backup full for data base
o 29/12 backup archivelog
o 30/12 backup control file to trace
On DEV server :o I restore control file
o I use until clause (i choose a date time , arbitrary, between start full backup and the end of archive log backup)
SET UNTIL TIME "to_date('2013-12-29:12:00:00','YYYY-MM-DD:HH24:MI:SS')";
o Restore
o recover database : The recover failed with error :
RMAN-03002: failure of recover command at 01/02/2014 16:47:15
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed