Re: Recovery problem

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Mon, 28 Dec 1998 12:53:27 -0800
Message-ID: <Pine.OSF.3.95.981228125016.24183B-100000@gonzo.wolfenet.com>

On Mon, 28 Dec 1998 jrlopez1_at_hotmail.com wrote:
>
> Try to recover to a point-in-time:
>
> SVRMGR> recover database until time '1998-11-27:14:00:00';
>
> kumarsa_at_webtv.net (Santhinathan Kumar) wrote:
> >
> > 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.

As you suspected, you cannot apply redologs for recovery unless you have a datafile copy from a point in time prior to the redolog you want to apply. In your case, you cannot apply old redologs to a completely up-to-date database.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Mon Dec 28 1998 - 14:53:27 CST