joel garry wrote:
> hpuxrac wrote:
>> Noghri64 wrote:
>>> We run 9i.
>>> I've just been doing some reading about 10g and the Flashback
>>> technology. Sounds like this could do the trick. Anybody have
>>> experience with Flashback?
>> The 10g flashback features are all over the place and include being
>> able to move a whole database back to table level modifications etc.
>>
>> There's a whole bunch of different options and choices. Maybe they
>> will be able to meet your demands but you need to clarify exactly what
>> your expectations are.
>>
>> There's an Oracle Database 10g "High Availability" book by Hart and
>> Jesse that might be worth picking up. Also a new 10g RMAN book by
>> Freeman and Hart.
>>
>> Plus of course all the free documentation at http://tahiti.oracle.com
>
> 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.
>
> jg
> --
> @home.com is bogus.
> "...the Sarbanes-Oxley (SOX) law is *not* technical (if it were, the
> drafters would have known not to give the central point related to
> information technology section number 404)." - Robert Slade
>
We currently run a smallish maybe 130gb OLTP database 20-50gb redo a day
and have used flashback logs in the past to protect us through batch
loads of new data (not that we didn't trust the developers of the batch
routines or anything <vbg>). We don't rely on flashback query though.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Tue Dec 19 2006 - 00:46:31 CST
