Re: Wow, Man, Flashbacks!

Jonathan Lewis has found out that even 8i has flashback capabilities internally http://www.jlcomp.demon.co.uk/ch_01.html

Btw, in 10g there is a "guaranteed retention" option as well, that undo_retention time is forced instead of attempted.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 06, 2003 8:39 PM

> Actually, flashback is available regardless of the undo management
> configuration. Flashback requires use of the smon_scn_time table, which
> is populated with an scn -> time relationship every five minutes the
> instance is up. The table is restricted to a certain size (14400 entries
> IIRC) by the update logic, so the 5 days of flashback time is a result of
> the old records being 'aged' off the table.
>
> Using AUM increases the likelihood that a flashback query will succeed,
> but it is not a guarantee. The logic of block reuse in AUM should
> increase the retention of undo.
>
> Daniel Fink
>
> Melanie Caffrey wrote:
>
> > Yes, this is correct.
> >
> > Rollback segments cannot be used.
> >
> > --- Stephen Andert <StephenAndert_at_firsthealth.com>
> > wrote:
> > > Bambi,
> > >
> > > Are you using automatic undo management or manual?
> > > I think that
> > > flashback can only be used with auto.
> > >
> > > Stephen
> > >
> > > >>> bbellow_at_chi.navtech.com 11/06/03 10:04AM >>>
> > > Hi Folks!
> > >
> > > I got waylaid(?) when I got in this morning and
> > > these user dudes were
> > > talking about using flashbacks, and I was like
> > > "Woah! Dudes! Let's
> > > just
> > > chill on this for a couple of minutes". So, I went
> > > back to my desk
> > > and
> > > checked out a cool article on it...
> > >
> > >
> > http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp
> > >
> > >
> > > And it looks like it's like, killer, yknow? So, I
> > > was thinking "well,
> > > we've
> > > got sufficiently large undo segments for this, I
> > > don't see a problem
> > > with
> > > it" but that didn't sound terribly cool, and anyway,
> > > before I go
> > > willy-nilly
> > > saying this is the niftiest thing Oracle's done in
> > > years, I thought I
> > > would
> > > run it by you guys and see if anybody out there is
> > > running with
> > > flashbacks
> > > and whether there have been any problems with it.
> > >
> > > Yer far-out pal,
> > > Bambi.
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: Bellow, Bambi
> > > INET: bbellow_at_chi.navtech.com
> > >
> > > Fat City Network Services -- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> > > hosting services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: Stephen Andert
> > > INET: StephenAndert_at_firsthealth.com
> > >
> > > Fat City Network Services -- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> > > hosting services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> > __________________________________
> > Do you Yahoo!?
> > Protect your identity with Yahoo! Mail AddressGuard
> > http://antispam.yahoo.com/whatsnewfree
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Melanie Caffrey
> > INET: melanie_caffrey_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Daniel W. Fink
> INET: Daniel.Fink_at_Sun.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).