flashback database to guaranteed restore point
873960Jul 7 2011 — edited Jul 7 2011Hi,
i would like to do a test and flashback my database to a guaranteed restore point.
Do i need to configure the database parameters db_recovery_file_dest_size and db_recovery_file_dest?
or i just need to perform these steps:
CREATE RESTORE POINT before_update GUARANTEE FLASHBACK DATABASE;
do some test and then go back :
SHUTDOWN IMMEDIATE
STARTUP MOUNT
FLASHBACK DATABASE TO RESTORE POINT 'BEFORE_UPDATE';
...
ALTER DATABASE OPEN RESETLOGS;
thanks