Re: Need help with oracle 9i

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 3 Feb 2005 14:11:35 +0100
Message-ID: <ctt7u5$vso$1@nntp.fujitsu-siemens.com>

"Frank van Bortel" <fvanbortel_at_netscape.net> schrieb im Newsbeitrag news:ctrhla$jvb$1_at_news5.zwoll1.ov.home.nl...
> fitzjarrell_at_cox.net wrote:
> [snip!]
>
> >
> > LogMiner might be of use to you, as DML and DDL is recorded in the redo
> > logs. Otherwise you'll need a recent export of the database to
> > restore what you've lost.
> >
> >
> > David Fitzjarrell
> >
> But that would be virtually undoable, as you would need to
> go back to the time, the actual 'create or replace procedure...'
> was issued, wouldn't it?

AFAIK, if all the stuff is still in the undo buffer you ought to be able to do an export from, say, fifteen minutes ago. However that only works with undoable stuff. which is dml. No idea whether ddl or schema deletion is undoable.

The other thing would be a point in time recovery on a separate system. This requires a backup from before you deleted all stuff and the archived logs until the time you want to recover to. If you've never done this before you should contact oracle win the form of a TAR. They will be happy to help you out.

Lots of Greetings!
Volker Received on Thu Feb 03 2005 - 07:11:35 CST