Re: A couple archive log / sequence number questions...

Interesting. I've got two 10g standby databases and they both have the trace file (as does the 9.2.0.7 standby). They're not going to be on your primary, just the DBs in managed recovery. Are you running the managed recovery process? I use this file for several things - similar to what you're looking to do.

orapr1_at_r3drci01>ps -ef |grep mrp
  orapr1 3326274 4383002 0 14:12:11 pts/0 0:00 grep mrp   orapr1 4211090 1 0 Sep 23 - 463:08 ora_mrp0_DR1

orapr1_at_r3drci01>find ./ -name *mrp*
./saptrace/background/dr1_mrp0_4211090.trc

orapr1_at_r3drci01>tail -5 saptrace/background/dr1_mrp0_4211090.trc Media Recovery Log /oracle/PR1/oraarch/1_43215.dbf *** 2007-10-18 13:39:45.884
Media Recovery Log /oracle/PR1/oraarch/1_43216.dbf *** 2007-10-18 14:08:21.168
Media Recovery Log /oracle/PR1/oraarch/1_43217.dbf

orapr1_at_r3drci01>cd saptrace/background/

orapr1_at_r3drci01>cat *mrp* |grep dbf |tail -1 |cut -f5 -d / 1_43217.dbf

On 10/18/07, Mason Loring Bliss <mason_at_blisses.org> wrote:
>
> On Thu, Oct 18, 2007 at 01:55:11PM -0400, David Barbour wrote:
>
> > Check the managed recovery trace file. It'll be in your bdump directory
> and
> > look something like <SID>_mrp0_<PID>.trc
>
> I appear not to have that trace file, either on my master or my stand-bys.
> I'm running Oracle 10G... Also, searching, I was unable to see anything in
> my
> bdump directory that contained even vaguely recent sequence numbers.
>
> For now I'm just pulling the sequence number information out of the
> "recover
> database" output, but that seems a little inelegant.
>
> Thanks in advance for further clues!
>
> --
> Our enemies shall talk themselves to death, and we will bury them with
> their own confusion. We shall prevail! -- Apple, 1984
>

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