By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,992 Members | 934 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,992 IT Pros & Developers. It's quick & easy.

Recover deleted rows from a table from archive logs?

P: n/a
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?
Oct 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Oct 26, 2006 at 8:53am Snonck wrote:
SIs 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
Oct 26 '06 #2

P: n/a
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:
SIs 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.
Oct 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.