Point in time recovery using restore point
Oracle RDBMS 11.2.0.2.RAC and Host RHEL 5.6
My dev application team iwant to test their application, and once that is done they want to recover to point in time. In my case they would do that after 9.0Am and once that is done they want the state of the database back to 9.0Am
What i am planning to do is:
create a restore point at 9.0Am and once application testing is done recover until restore point...But i was suggested not to do that way instead my Lead want me to use just recover until timestamp
I asked what is the difference in doing in my way,the answer i got is by using recover until restore point, the recover process cannot apply incremental level 1 backups and it just restores to a point of incremental level 0, it looked strange to me.
Am i missing something here? As far as i know u can use either of them.
Does really using restore point effects the restore process or does it have any impact on next incremental level 1 backup?