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).
>
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: wisernet100_at_yahoo.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).
Received on Fri Dec 20 2002 - 09:34:49 CST