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

From: Snonck <snonck_at_snog.com>
Date: Thu, 26 Oct 2006 18:32:40 +1000
Message-ID: <45407262$0$5108$afc38c87@news.optusnet.com.au>

sybrandb wrote:
>
> On Oct 26, 8:55 am, Snonck <sno..._at_snog.com> wrote:

>> 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?

>
> The purpose of archivelog is to be capable to recover from crash, so to
> roll forward already committed transactions that are no longer there.
> Oracle uses it's own code to accomplish this.
> In 8i this has been made public by using the logminer facility, in 9i
> and higher you can flashback the table before the event.
> The flashback mechanism relies on archive logs.
> In all versions you can use the dbms_logmnr package.
> For further info either see the online documentation at
> http://tahiti.oracle.com
> or Morgans library at http://www.psoug.org/reference .
>

So back to my original question, is it possible to recover the table using only the archive logs? Received on Thu Oct 26 2006 - 03:32:40 CDT