Re: Recovery problem

Santhinathan,

Try to recover to a point-in-time:

SVRMGR> recover database until time '1998-11-27:14:00:00';

This is if you want to recover til a certain time of day. This is a point-in-recovery. The date format 'YYYY-MM-DD:HH24:MI:SS'. If you Company can't purchase any tools to make you job easier, than go and purchase the Oracle7 / "Oracle8 DBA HandBook for Oracle Press and look in Chapter 10 Optimal Backup and Recovery Procedures". This book has help me in the past on many occasion.

Good Luck

Juan R. Lopez

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. 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 28 1998 - 11:57:24 CST