Home -> Usenet -> comp.databases.oracle -> Re: Recover deleted rows from a table from archive logs?

Re: Recover deleted rows from a table from archive logs?

From: Steven Patterson <S.R.Patterson_at_soton.ac.uk>
Date: Thu, 26 Oct 2006 07:16:47 +0100
Message-ID: <Pine.GSO.4.53.0610260713590.25599_at_aspen.sucs.soton.ac.uk> 






On Oct 26, 2006 at 8:53am Snonck wrote:


S> Is is possible to recover deleted rows from a table from archive logs?



Typically not, as the archivelogs need only record (and, as I understand
it, DO only record) the rowid of the deleted row - when rolling forward
(as the archivelogs are intended to be used) this is all the information
you need about the transaction.



Your options for recovery (you probably already know this) would be Oracle
Flashback, if you're in time, or a point-in-time recovery of the database
to a separate instance, and export of the table.



S.

-- 
Steven Patterson, MSci (Hons), Oracle Certified Professional


Received on Thu Oct 26 2006 - 08:16:47 CEST












Original text of this message