Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback !

RE: Rollback !

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 28 Aug 2002 22:50:00 -0800
Message-ID: <F001.004C224E.20020828225000@fatcity.com>


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:DWILLIAMS_at_LIFETOUCH.COM]
> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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
> chao_ping_at_vip.163.com
>
>
> ======= 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: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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).
Received on Thu Aug 29 2002 - 01:50:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US