Re: er, 'interesting' new 9i feature

Ah, sorry, I see what I wrote was confusing. I normally just check the timestamp of the backup controlfile command from the alertlog and match it up to the right *.trc in UDUMP. That or just grep for 'create controlfile' in UDUMP and sort by time. But that's only because I'm usually doing this well after the fact. In other words, my typical scenario is:

• take yesterday's backup (our hotbackup scripts include a backup controlfile to trace at the end) and copy it to another host
• go to primary host, dig through alert.log looking for timestamp when backup controlfile statement was executed at the end of the hotbackup along with the sequence number of the logfile containing the changes from the hotbackup
• go to udump and find the appropriate *.trc file
• get the needed archive to the target host (restore from tape if need be)
• copy the trc file to the target host and change the names as needed to reflect new database name and filesystem names
• rebuild, recover, resetlogs

Now that you mention it, I suppose I could grab the spid in the hotbackup script and record that for posterity, but, well, maybe one of these days in all my free time... ;)

Regards,
Sean

"Howard J. Rogers" wrote:
>
> 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
> >
Received on Wed Jul 17 2002 - 18:04:07 CDT