DBPITR recovery issues with RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed start until time

-- Please note correct set of backup is must for recovery.. no backup means no recovery..

 list incarnation;



List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       ORCL     1452601228       PARENT  1          07-07-2014 05:38:47

2       2       ORCL     1452601228       PARENT  1594143    09-10-2016 22:34:55

3       3       ORCL     1452601228       CURRENT 1755910    10-10-2016 00:01:34



RMAN> reset database to incarnation 2;



database reset to incarnation 2






list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORCL     1452601228       PARENT  1          07-07-2014 05:38:47
2       2       ORCL     1452601228       CURRENT 1594143    09-10-2016 22:34:55
3       3       ORCL     1452601228       ORPHAN  1755910    10-10-2016 00:01:34

RUN
{
SHUTDOWN IMMEDIATE;
startup mount;
RESTORE DATABASE;
RECOVER DATABASE UNTIL TIME "TO_DATE('09-10-2016 23:40:00','DD-MM-YYYY HH24:MI:SS')" ;
alter database open resetlogs;
alter pluggable database all open;
}

----Problem:



RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 10/10/2016 09:13:27

ORA-00283: recovery session canceled due to errors

RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed

 start until time '2016/10/09 23:40:00' using backup controlfile

ORA-00283: recovery session canceled due to errors

ORA-19912: cannot recover to target incarnation 2



RMAN>

RMAN>





-----Solution:



list backup of controlfile;







 ls -ltr /u01/app/oracle/fast_recovery_area/ORCL/autobackup_bkp/2016_10_09/o1_mf_s_924824392_czpfxrrv_.bkp

-rw-r----- 1 oracle dba 18055168 Oct  9 23:39 /u01/app/oracle/fast_recovery_area/ORCL/autobackup_bkp/2016_10_09/o1_mf_s_924824392_czpfxrrv_.bkp



---Check the nearest control file  that we need to restore it first and restore db.





restore controlfile from '/u01/app/oracle/fast_recovery_area/ORCL/autobackup_bkp/2016_10_09/o1_mf_s_924824392_czpfxrrv_.bkp';

alter database mount;

RESTORE DATABASE;

RECOVER DATABASE UNTIL TIME "TO_DATE('09-10-2016 23:40:00','DD-MM-YYYY HH24:MI:SS')" ;

alter database open resetlogs;

alter pluggable database all open;