rman restore and recovery

[satish]

Dear Erman,

There was many confusions over the error here "http://dbakevin.blogspot.com/2012/06/real-meaning-and-simulate-ora-01152.html?m=1",while i was looking into the error,i cam across this link

could you please let us know in what scenarios,we get the error "ORA-01152: file was not restored from a sufficiently old backup,if possible with some scenarios

Thank you

[ErmanArslansOracleBlog]

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.

[satish]

As always,thanks erman...if i recover till t5 i will not face this error right?

is this error has relation with control file?

[ErmanArslansOracleBlog]

Yes.. (again, I didn't test it but I m expecting it to be so)