Re: use logminer to recover dropped table
Date: Wed, 25 Jan 2012 20:55:02 +0200
Message-ID: <CA+UC=5FPubt0k0uiwA_RuwyqjmU2ibj3i5s+xjN3x9izeZdgQA_at_mail.gmail.com>
The data of the table won't be written into redo when you drop a table so you can't recover it with log miner.
Is the recycle bin enabled? If so you can recover the table from there assuming it hasn't been over written.
Harel
On Wed, Jan 25, 2012 at 7:57 PM, sundar mahadevan < sundarmahadevan82_at_gmail.com> wrote:
> Hi Folks,
> Good day. yesterday i dropped a table accidentally on staging database
> (11gSE1 Rel 2 on SLES 10 on no archive log mode and no flash recovery
> enabled) and we do not have any backups to recover. Even though the data
> could be recreated, I tried to save the hassle for the developers. I tried
> to use log miner to see if i can somehow recover the sql statements. The
> table name that was dropped was ABCD_20120101. I was able to see only the
> command as drop table ABCD_20120101. Could someone shed some light on
> recovering ddl (drop table) with logminer. I did go through the
> documentation and googled it, but pretty much they all link to the oracle
> support notes which does not address my case. Supplemental logging was off
> when that table was dropped. Does it have any effect on recreating the
> dropped table? Thanks in advance.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 25 2012 - 12:55:02 CST