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 >