Oracle 10g - FlashBack restore point

Hi,

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 :

DROP RESTORE POINT restore_1;

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)...

Tks,
Joao
joaotellesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
joaotellesAuthor Commented:
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?
0
joaotellesAuthor Commented:
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?
0
Mark GeerlingsDatabase AdministratorCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.