Re: Recovery problem

In article
<15652-3686BED6-285_at_newsd-271.iap.bryant.webtv. net>, kumarsa_at_webtv.net (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.

..

You can't restore backward, only forward. You need to start with backups of your files that were taken at or before the time to which you want to recover and log forward from there. The files you have now are not the versions you need in order to do this.

If you had a backup, you could fake an additional database, recover it to just before you dropped the tables, export them and import them into your real database.

My deepest sympathy!

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa