Yes, I am aware of this hard limit (and how smon_scn_time table is maintained by Oracle ;) FBQ has its limitations. And it has some benefits. For an accidental mess up that is realized soon enough, FBQ may help.
- Kirti -----Original Message----- Sent: Friday, December 20, 2002 10:55 AM To: Multiple recipients of list ORACLE-L You can't depend on Flashback query for recovery. Even if the undo entries are not overwritten, there is a hard limit of retention. The maximum retention period is 5 days. Actually, the data could be retained for longer, but the SCN - Time map that allows for flashing back has a 5 day limit. -----Original Message----- Sent: Friday, December 20, 2002 8:35 AM To: Multiple recipients of list ORACLE-L and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up > properly, then flashback query can be the answer... > > - Kirti > > -----Original Message----- > Sent: Friday, December 20, 2002 5:04 AM > To: Multiple recipients of list ORACLE-L > > > the audit table works well, I've used it before and am implementing > it > now (after the fact, the code base "updated" orders incorrectly, I > was > told "we don't want audit tables" beforehand, now they are desperate) > > be careful with logminer, it's not intuitively obvious which > statement > is the one you want to recover and, if you do a lot of data refresh > (we > do a daily truncate and reload of a catalog schema) can give you LOTS > of records to go through -- in our case, 11 million records in two > days > of logs > > > --- "Robson, Peter" <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > Hi Listers, > > > > > > I have little problem : > > > > Hmmm, that may not be a little problem at all.... > > > > > how to undelete record that we've delete and commit so I can > > > restore again > > > in my data, thanks a lot. > > > > You can resort to conventional Oracle backup and recovery (other > folk > > will > > tell you all about that). > > > > But if you have important data tables, you can audit them > > individually. We > > have. We also have people who are liable to do just this sort of > > thing. > > Using our auditing approach, we can recover immediately, even after > a > > commit. Requires an audit table for each data table, with a > > pre-change > > trigger to capture each row before the DML statement. > > > > More details if you wish (after Christmas - I'm off!) > > > > peter > > edinburgh > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
