Re: er, 'interesting' new 9i feature

I'm going to take that guilt back, by the way. I've just checked my alert log, and all I get is...

Wed Jul 17 14:56:38 2002
alter database backup controlfile to trace Completed: alter database backup controlfile to trace

...no indication of filename, process id or anything.

How did you hunt down the name of your trace file from the alert log again?

Regards
HJR "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:ah4ria$eri$1_at_lust.ihug.co.nz...
> The "AS" is pure gold dust, that's for sure.
>
> Interesting you used the alert log in the past.... I always tossed of a
>
> select p.spid
> from v$process p, v$session s
> where p.addr=s.paddr
> and s.username='SCOTT';
>
> ...to find out my number and got it from there. I never thought to check
the
> alert log (shuffles uncomfortably away looking very guilty).
>
> Regards
> HJR
>
> "Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message
> news:3D35EE1F.B1A37734_at_BACKSIESearthlink.net...
> >
> >
> > "Howard J. Rogers" wrote:
> > >
> > > True. I kinda meant, when one does the removal of 'no', one usually
> > > remembers to add the word 'resetlogs' lower down in the script too...
> like
> > > vegemite and toast, you wouldn't have the one without the other, and
I'd
> > > sort of expect anyone doing a resetlogs to know that. But fair enough,
> it
> > > *is* more than just two letters.
> >
> > Yeah - I think the big difference is the 'using backup controlfile'
> > which, if you accidentally used it after having carefully created your
> > controlfile NORESETLOGS, will force you to open resetlogs nonetheless.
> > Might be really bad if you've got stuff in the online redos that's
> > important. So there seems to be a method to the madness.
> >
> > > And that was going to be my next comment! (Beat me to the punch!).
> > > Exactly.... I dislike an immensely important script throwing up errors
> for
> > > no good reason at a critical time (ie, just when you're trying to
> recover
> > > all your control files).
> >
> > That's the worst feeling. Horrible. Even if it only lasts a few
> > seconds...
> >
> > On the other hand, I do really like the "AS" and "REUSE" additions to
> > the new syntax for backup controlfile to trace. Nice to be able to pick
> > the filenames instead of hunting down some CJDZSAZZXX123.trc from the
> > alertlog.
> >
> > Regards,
> > Sean
>
>
Received on Wed Jul 17 2002 - 17:40:59 CDT