Re: Standby database looking for old archive
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: katpopins21@xxxxxxxxx
- Date: Mon, 25 Feb 2008 15:04:38 -0500
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>
>
>
Other related posts:
