Re: Problem with lost archive logs

On Aug 31, 3:03 am, vitalis..._at_gmail.com wrote:
> On Aug 30, 10:45 pm, joel garry <joel-ga..._at_home.com> wrote:
>
> > If anybody knows a way out of this short of dropping the datafile and
> > redoing the backup/restore, my labor day weekend is all ears.
>
> AFAIK it is not possible.
>
> Out of curiosity, were these archived logs deleted by RMAN? Which
> command exactly?

No, they are deleted outside of RMAN. Each RMAN backup has at least the last 3 days worth of logs, but not every backup is kept. Not my recommended way of doing things, but it took major hardware failures of the standby storage plus several manual mistakes (while I was off galavanting through the giant redwoods) to get to this situation. It's not that bad of a situation since the primary production system only has a minor interruption coming because I have to drop and recreate the tablespace with the bogus offline file. And I charge by the half-hour :-) (I did make some mistakes too, one of which was not dealing with this bogus file as soon as I became aware of it - it didn't seem to be causing any issues :-O ).

I'm not entirely sure, but I think the newer versions of RMAN being able to restore across incarnations might have a way around this sort of problem. That doesn't help me this weekend.

jg

--
@home.com is bogus.
I want my flying car!  http://news.bbc.co.uk/1/hi/business/6970031.stm