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

Thanks for your reply.

I accidentally posted this question here instead of into comp.databases.oracle.server.

I have now moved the question into the above newsgroup as it is a little more livelier. I'm still trying to find out what the answer is as there seems to be a bit of discussion about it.

Steven Patterson wrote:
> 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.
Received on Thu Oct 26 2006 - 14:22:40 CEST