Re: Disable flashback in either shutdown or nomount mode?

Are you saying that the instance is creating a flashback log before it is mounted?

How did you come to the conclusion that it is the log creation causing the wait?

Seth Miller

On Tuesday, October 7, 2014, Don Seiler <don_at_seiler.us> wrote:

> Good evening,
>
> Part of my staging/dev refresh process involves taking an image copy
> backup of prod datafiles and controlfiles and firing up a new instance from
> them. The first thing I do when mounting the new database is to turn off
> flashback. However recently we're seeing that the time to mount takes
> almost 40 minutes while the instance creates a new flashback log. Seems
> silly to have to wait for this when we plan to disable it right away anyway.
>
> Is there a way to disable flashback database without having to mount? I'm
> guessing the worst case scenario is having to create a trace of the
> controlfile and create a new one with flashback disabled.
>
> Don.
>
> --
> Don Seiler
> http://www.seiler.us
>

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