Re: Recovery problem

From: John P. Higgins <jh33378_at_deere.com>
Date: Sun, 27 Dec 1998 20:25:05 -0600
Message-ID: <3686EC01.A294675C@deere.com>

Buy BMC's DB Log-Master for Oracle. You can use this to scan all the archived logs for every SQL statement ever applied to the tables. You can extract this into a SQL script. Then you can re-create the tables and use the extracted script to re-populate the tables.

Santhinathan Kumar wrote:

Hello,
I have a problem where in my database, I accidentally dropped two
tables.  I don't have ANY backups (neither hot nor cold) of the
database, but what I do have is the complete archivelog starting from
day 1. Is there a way I can use these logs to restore to a point just
before I dropped the two tables. Since I don't have a starting poing, I
don't know how I can do it. Won't the SCNs give me a problem if I tried
to do so using
'recover database until cancel using backup controlfile';

Please help! I am dealing with Production data!

S. A. Kumar

  Received on Sun Dec 27 1998 - 20:25:05 CST