473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Recover deleted rows from a table from archive logs?

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
2 11415
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Grant | last post by:
Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis
2
by: senthiltsj | last post by:
hi two days before arount 20,000 rows are manuly deleted, is there any way to recover it back. We have backup, that is 10 days old, Is there any way to recover only that 20,000 rows, Plz help...
1
by: nevsoft | last post by:
Hello I have Oracle 10.2.0.1 on Solaris 10g. I want to make level0 incremental backup every night and level1 incremental backup during the day. Each level0 backup will be copied over network...
4
by: =?Utf-8?B?cmFuZHkxMjAw?= | last post by:
I'm working in Visual Studio 2005 and C#. I have a DataTable with many rows. The user can delete a row. After the row is deleted, I'd like to column values for the deleted row, but any attempt to...
0
by: Snonck | last post by:
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...
3
by: Kofa | last post by:
Hi, we have an application which uses online backups, so archive logging is a requirement. We have a small/moderate size database (a few hundred megabytes isn't much by today's standards) with...
1
by: dbquest | last post by:
Hi, Is there a way to recover the deleted rows? We do have a backup but not for all the rows that got deleted. Appreciate some quick help on this. Thanks.
5
by: daitaravi2002 | last post by:
Dear All, I am new to this Forum, what my prob in ORACLE 8I i have primary database i am trying to put all the data in test database which was not in network for that i am using archive logs. ...
0
by: victor deng | last post by:
I find the following url which says: "The log must be an archive log so that the log file will not be reused by the source database before the Capture program can read the log." ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.