Re: Flashback Database NEWBIE - 10g - Going to setup one for first time

From: Stalin <stalinsk_at_gmail.com>
Date: Fri, 15 Mar 2013 21:46:54 -0700
Message-Id: <7D82B395-096F-4284-908C-46731879AB81_at_gmail.com>

That restriction have been lifted with 11g. You don't need to put the DB in mount mode to take restore point anymore.

Stalin

On Mar 14, 2013, at 7:50 AM, Herring Dave - dherri <Dave.Herring_at_acxiom.com> wrote:

> Chris,
>
> Be careful with your guaranteed restore points - make sure to only create them when the database is in mount status. This is true at least for 10.2.0.2. I'm not sure if the doc explicily says this but we found that when creating guaranteed restore points when the database is open, flashback logs can get dropped automatically by the database when under space pressure.
>
> We perform flashback database operations multiple times per week for various systems and developed a script to handle the entire process, including emails at various stages of progress and cleanup of unnecessary archive logs. Let me know if you'd like to see a copy.
>
> Dave Herring
> DBA
>
> Acxiom Corporation
> EML dave.herring_at_acxiom.com
> TEL +1 630.944.4762
> 3333 Finley, Downers Grove, IL 60515, U.S.A
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Mar 16 2013 - 05:46:54 CET