And you may well use Logminer to determine what that exact point in time is (and then use tablespace point in time recovery to do the actual recovery).
Bruce Reardon -----Original Message----- Sent: Thursday, 29 August 2002 2:52 There is a way of undoing DDL and it is described in the RMAN manual. The solution is simple: recover the database to the point in time before the problematic DDL. > -----Original Message----- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 10:49 AM > > Alexandre - Thanks for posting the link. I read the document. > It describes > how to track the DDL statements. Unless I overlooked > something, it doesn't > say you can UNDO DDL. I think the reason was explained > earlier on this post, > that Oracle doesn't write any redo records. For example, in > the case of a > DROP TABLE statement, in order to undo that statement, Oracle > would have to > write the equivalent of a DELETE statement for each row. This could be > enormous if the table was large, and take a long time. Then > we DBAs would be > clamoring for a parameter that would bypass all that. I could > be wrong, > which is why I respond to issues like this. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Wednesday, August 28, 2002 6:13 AM > > For 9i: > http://otn.oracle.com/docs/products/oracle9i/doc_library/901_d > oc/server.901/ > a90117/logminer.htm#18681 > For 8i not sure. Has anyone tried DROP undo in 8i? (8i docs > are very poor on > LogMiner) > > Alexandre > ----- Original Message ----- > Sent: Wednesday, August 28, 2002 11:48 AM > Alexandre Gorbatchev, > > As far as i know, you cannot recover from drop using logmnr.It is > internal dml to data dictionary, maybe in 9i it will work, i > am not sure.But > in 8i, it won't work. > > > Regards > zhu chao > Eachnet DBA > 86-21-32174588-667 > [EMAIL PROTECTED] > > > ======= 2002-08-28 00:13:00 ,you wrote��======= > > >> 1.) Can we rollback a drop statement ? > >No. However, you can use Log Miner. > > > >Alexandre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
