use logminer to recover dropped table
From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Wed, 25 Jan 2012 12:57:50 -0500
Message-ID: <CADmQEr5T2Jb5sHgx6JzB-uqb-UCm8Yz4ZyjHuGhCkMr=d1gG1Q_at_mail.gmail.com>
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.
Date: Wed, 25 Jan 2012 12:57:50 -0500
Message-ID: <CADmQEr5T2Jb5sHgx6JzB-uqb-UCm8Yz4ZyjHuGhCkMr=d1gG1Q_at_mail.gmail.com>
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-lReceived on Wed Jan 25 2012 - 11:57:50 CST