FreeLists / oracle-l / Re: Standby database looking for old archive

["Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>]

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@xxxxxxxxx> wrote:
>
> 1000% sure... I did this again just to be sure.
>
> *Roman Podshivalov <roman.podshivalov@xxxxxxxxx>* 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@xxxxxxxxx> 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@xxxxxxxx>* 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@xxxxxxxxxxxxx [mailto:
> > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Finn Jorgensen
> > *Sent:* Monday, February 25, 2008 11:12 AM
> > *To:* katpopins21@xxxxxxxxx
> > *Cc:* oracle-l@xxxxxxxxxxxxx
> > *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>
>
>