Re: How to restore lost objects after DROP USER?

On Mon, 14 Oct 2002 9:04:26 +0800, VVS wrote (in message <3DAA181A.4C159E7A_at_erols.com>):

> We have 817 EE on NT and one developer created a lot of procedures,
> functions and views. DB was not backuped and archived and export has not
> been done - our fault and we understand it. Sorry for this.
>
> Ok, now the story: another developer dropped this DB user and we lost
> everything: procedures, functions and views. The new database user with
> the same name was created and new schema was imported in this user, but
> all old objects are lost. We don't have export and backup and archive
> log files.
>
> The switch has occurred after user was dropped, the data has been
> overwritten and so I guess there is no way to use redo log files.
>
> Question: may we can restore this lost stuff from some other sources. We
> are looking for lost codes, not data. May be we can use the Shared Pool
> or any other things? Any idea will be appreciated.
>
> Is it possible to use Shared Pool or any Data Dictionary internal
> information to restore texts of the lost SQL and PL/SQL scripts executed
> in this DB before user was dropped? Not too many scripts are executed in
> this DB and the lost ones may still be in stack. I remember that Shared
> Pool (cash) should keep last executed scripts in order to improve
> performance. They probably are kept in some special format. Can we
> restore these scripts? Of course they also might be pushed out by Import
> that had been done after user was dropped.
>
> Thanks for your help,
>
> Victor
> slootsky_at_erols.com
>

if you had the database in archive mode and you have ALL the archive logs, you can re-create the database from scratch. or from any given backup point, then apply the archive logs.

see the recovery procedures. Received on Thu Oct 17 2002 - 23:59:59 CEST