Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

flashback database to guaranteed restore point

873960Jul 7 2011 — edited Jul 7 2011
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2011
Added on Jul 7 2011
4 comments
551 views