Re: Standby database looking for old archive

Mount it and do:

select name, status, recover, fuzzy, CHECKPOINT_CHANGE#, CHECKPOINT_TIME from v$datafile_header;

Check if you see anything worth investigating....

--romas

On 2/25/08, kathy duret <katpopins21_at_yahoo.com> wrote:
>
> 1000% sure... I did this again just to be sure.
>
> *Roman Podshivalov <roman.podshivalov_at_gmail.com>* wrote:
>
> Kathy,
>
> Are you 100% sure you've generated and transferred new copy of standby
> control file(s) ? And restarted standby instance after you did that ?
>
> --romas
>
>
> On 2/25/08, kathy duret <katpopins21_at_yahoo.com> wrote:
> >
> > Yes I ended the backup mode after the file was completed.
> >
> > The current archives are all there. It is calling an archive from weeks
> > ago
> > which is not there.
> >
> > K
> >
> > *"Mark W. Farnham" <mwf_at_rsiz.com>* wrote:
> >
> > In exactly the same spirit as Finn, did you ship the log you need after
> > you ended backup mode, er, um, you don't actually write that you ended
> > backup mode and physical recovery cannot complete until a log from after the
> > end backup is applied.
> >
> > ------------------------------
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] *On Behalf Of *Finn Jorgensen
> > *Sent:* Monday, February 25, 2008 11:12 AM
> > *To:* katpopins21_at_yahoo.com
> > *Cc:* oracle-l_at_freelists.org
> > *Subject:* Re: Standby database looking for old archive
> >
> > kathy,
> >
> > You don't say this, so I'm going to ask. After you put the tablespaces
> > in hot backup mode and copied them over, did you also copy over archive logs
> > since putting the tablespaces in backup mode up until after you took them
> > back out of backup mode and applied them to the standby? (I know it's
> > obvious, but sometimes....)
> >
> > Finn
> >
> >
> > <snip>
> >
> >
> >
> > ------------------------------
> > Never miss a thing. Make Yahoo your homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
> >
>
>
> ------------------------------
> Never miss a thing. Make Yahoo your homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
>
>

--
http://www.freelists.org/webpage/oracle-l