Oh, good. So long as I wasn't missing something.
Cheers,
HJR
"Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message
news:3D35F7E7.E521DFA2_at_BACKSIESearthlink.net...
> 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:12:34 CDT
