Re: rman restore and recovery

Posted by ErmanArslansOracleBlog on Jun 22, 2018; 9:05am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/rman-restore-and-recovery-tp6236p6241.html

No need for confusions..
This error occurs when a file is ahead in time (SCN) than the stopping point of recovery.
This means you are trying to restore a file, which is ahaed of the database.. (its checkpoint change is ahaed, it is newer)
This file can not be recovered..
What needs to be done is ; Restoring this file from a previous backup and Reissuing the incomplete recovery

I didn't test it but consider a scenario like;

t1:You open your database and start working
t2:you do some log switches.
t3:You get a a full backup
t4:You continue working
t5:You get a backup of datafile x
t6:you lost datafile x
t7:you restored  the whole database from the backup you got at t3 + you restore the datafile x from the backup you got at t5
t8:you start recovering until time t4 --> This will cause ORA-01152 error. Recovery will complain about datafile x, which has checkpointed data ahead from the end point of your recovery.