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

  • From: "David Barbour" <david.barbour1@xxxxxxxxx>
  • To: "Mason Loring Bliss" <mason@xxxxxxxxxxx>
  • Date: Thu, 18 Oct 2007 14:17:10 -0400

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@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@r3drci01>find ./ -name *mrp*
./saptrace/background/dr1_mrp0_4211090.trc

orapr1@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@r3drci01>cd saptrace/background/

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




On 10/18/07, Mason Loring Bliss <mason@xxxxxxxxxxx> 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
>

Other related posts: