RE: Undelete Record

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" <kirti.deshpande_at_verizon.com> 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" <pgro_at_bgs.ac.uk> 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: kirti.deshpande_at_verizon.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).