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).
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).

Reply via email to