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

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 .

-- 
Sybrand Bakker
Senior Oracle DBA