Re: RMAN Archive Log

On Sep 10, 12:39 pm, sybra..._at_hccnet.nl wrote:
> On Wed, 10 Sep 2008 10:29:40 -0700 (PDT), e..._at_chicagorsvp.com wrote:
>
> >Hi,
>
> >We put our database into archive log mode.  It has been that way for a
> >day.  We also modified our init.ora file to set the destination and
> >file name format.
>
> >When we run RMAN, it looks in the oracle home and also for a totally
> >different file name with a totally different sequence number.  We set
> >the location in RMAN with no luck.......
>
> >We are on 10g R2 and using the control file rather than the recovery
> >catalog......
>
> >Any thoughts?  Do I need to shutdown and re-open with resetlogs???
>
> RMAN only looks in the catalog whether it is located in the
> controlfile or in the catalog database doesn't matter.
>
> In short: you only state 'It doesn't work' without any evidence.
> You can not expect accurate responses.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

So what you are saying is that because we turned on archiving again, and did NOT open the database resetlogs, it is looking into the control file for the FIRST known archive log it has, which was from weeks ago.......

And, the way around this is to shutdown and re-open

resetlogs....................