Oracle 10g - FlashBack restore point

Posted on 2014-07-14
Last Modified: 2014-09-05

Sorry for the newbie question.

I will create a flashback restore point using the following instructions:

      Sqlplus /nolog
      Conn / as sysdba
      shutdown abort
      startup mount
      alter database flashback on;
      create restore point restore_1;
      alter database open;

The DB is in archive mode and the destination of the flashback has enough space.

My question is: after I finish the DB activity should I run the :


Or the restore point will expire automatically? Should I consider using the guarantee option? (I saw that it can consume a lot of disk space... not sure how much more)...

Question by:joaotelles
    LVL 34

    Accepted Solution

    If you drop the restore point, the space used for it will be freed up quickly.  Otherwise, yes, it will expire automatically sooner or later, but exactly when will depend on how many transactions are happening in your database and on how large your UNDO tablespace is and on how many archived redo logs you keep on disk.

    Author Comment

    Tks for the reply. SO I think I will drop because I need the restore point to be available only for a few hours. I guess it will not expire before this right?

    Author Comment

    Also to create the restore point, do I need to be in the mount state?

    I mean, if the flashback is already enabled,  and the DB is opened, is it ok to create the restore point?
    LVL 34

    Assisted Solution

    by:Mark Geerlings
    I haven't actually tried to use that feature, and I haven't read the documentation on it lately.   I say try it with the DB open.  If that is not allowed, Oracle will give you an error.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now