Since Flashback is so good can this be an alternative to restore database? My use case is database setup is done. Testing started and after 2 days came to know there is issue in some batch and this has corrupted the data. So, here I want to restore the DB back to 2 days before. This I can easily achieve with Flashback.
Assuming Enable Row Movement is true for most of the important tables. Is there anyway to Flashback whole database without worrying about row movement enable?
Does enabling row movement cause more memory?
Does Flashback as such needs more memory? Means of my DB is day 700 MB so I need 1400MB if I wanna use Flashback?