We are using Oracle 19 on windows.
We want to do some testing with a small team about a processing in application in a day, -backend is oracle database, it is a test environment.
We would like to create 3 normal restore points not guaranteed restore points during the day, and then do some tests, if failed we want to restore the database to the restore points. do we need to turn on flashback database on?
if so, could you help to write some commands sample starting from turn on the pre-requisite, and then create the normal restore point, and later restore the database to the normal restore point? Can I also do the restore while the database is open? I guess not.
While we do the testing, do we need to initiate backup for the database in order to use the restore point? or we don't need to do the backup during the day but still can use restore point?
Thanks,