Re: Backup Strategy - Multiple schema database

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 15 Dec 2006 16:56:40 -0800
Message-ID: <1166230600.805531.268460@j72g2000cwa.googlegroups.com>

joel garry wrote:

> I don't have flashback experience, so I should probably keep my mouth
> shut, but I have the impression that it would be singularly difficult
> to have enough undo on a high-dml multiple client database to make
> anything more than a trivial amount of flashback consistently (or
> contractually) available. So I'm also curious what the largest
> production system anyone has worked on might be, actually using
> flashback.

Here's a link to a fairly short overview ...

http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm

As you can see, there are lots of variations and different types of "flashbacks". ( Sort of like my recollections of the Ann Arbor Blues and Jazz festivals but that's a different story ).

The flashback database piece uses a new type of log. If you don't setup and use those logs you can't use that capability.

Oracle is (kind of) using marketing terminology for the flashback phase but it reality there's a whole bunch of different things with the flashback name associated. Some use the recycle bin, some use undo, some use the flashback logs, etc. So when you ask "what the largest production system etc" ... it begs the question ... which flashback feature set are you referring to. Received on Fri Dec 15 2006 - 18:56:40 CST