Performing multiple flashback database commands with 2 restore points
Hello,
I have a requirement in QA testing to take a BEFORE application upgrade guaranteed point in a multi TB 10g (10.2.0.5) database; perform the application upgrade and load test, then take an AFTER application upgrade guaranteed restore point. At this point the database is flashed back to the BEFORE guaranteed restore point to prove the flashback would work as a recovery means - however, upon performing this event, the AFTER application upgrade guaranteed restore point would be 'lost' and there is presumably no means to flashback the database ahead to the AFTER application upgrade restore point without re-applying the application
I have a requirement in QA testing to take a BEFORE application upgrade guaranteed point in a multi TB 10g (10.2.0.5) database; perform the application upgrade and load test, then take an AFTER application upgrade guaranteed restore point. At this point the database is flashed back to the BEFORE guaranteed restore point to prove the flashback would work as a recovery means - however, upon performing this event, the AFTER application upgrade guaranteed restore point would be 'lost' and there is presumably no means to flashback the database ahead to the AFTER application upgrade restore point without re-applying the application
1