Flashback Database vrs Point in Time Recovery
JimboAug 7 2012 — edited Aug 8 2012Q1. What's the difference between a PITR and Flashback Database ? I am aware that PITR is obviously an older process than Flashback DB. Both seem to achieve the same thing albeit PITR seems to involve a restore followed by recovery ( i.e. a move backwards then a roll forward ) whereas Flashback DB seems to just involve moving backwards. ? On that basis is flashback database generally quicker ?
It looks to me as if PITR is useful when you have file corruption / loss whereas Flashback Database is better for rolling back prior to some user initiated error ( eg drop of a table etc - though you could use the Recycle bin to sort that ).
PITR can correct user error as well but it looks as if that would be a slower process
Thoughts ?
thanks,
Jim