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

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

Received on Thu Oct 26 2006 - 01:16:47 CDT