Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with lost archive logs

Re: Problem with lost archive logs

From: joel garry <joel-garry_at_home.com>
Date: Fri, 31 Aug 2007 11:17:18 -0700
Message-ID: <1188584238.971695.306460@r23g2000prd.googlegroups.com>


On Aug 31, 7:43 am, vitalis..._at_gmail.com wrote:
> On Aug 31, 4:07 pm, joel garry <joel-ga..._at_home.com> wrote:
>
> > 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.
>
> OK. I feared RMAN might have "unfortunately" deleted the required
> archived log backups during the execution of 'delete obsolete' in your
> scenario.
>
> Does it complain about your datafile when you run "report
> unrecoverable;"?

No, I would guess because it is offline.

>
> > 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.
>
> Which incarnations? I can't see any resetlogs in your scenario.

The idea is to avoid resetlogs to keep the standby going. The normal answer to not being able to recover a db with this sort of file problem includes open resetlogs. There are lots of things that can't be done with normal advice if a standby is involved. Anything that avoids generating redo for performance and anything requiring a resetlogs are two major ones.

>
> Jerome

jg

--
@home.com is bogus.
What's in a name?  http://www.guardian.co.uk/worldlatest/story/0,,-6865184,00.html
Received on Fri Aug 31 2007 - 13:17:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US