Recover deleted rows from a table from archive logs?

[Snonck]

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

For example, say you have a database with archive logging turned off.
You create a table and populate it with records. You then reset the logs
and place the database in archivelog mode.

Then you

delete from table;

commit;

Is the necessary information in the archive logs such that you can
reconstruct the deleted rows from the table?

[Steven Patterson]

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.

[Snonck]

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.

Post by Steven Patterson
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.