Re: Need help locating correct trace file.

Howard is correct.

Richard Sutherland

Howard J. Rogers <howardjr_at_www.com> wrote in message news:3a6a3e5b_at_news.iprimus.com.au...
>
> "Richard Sutherland" <rvsutherland_at_yahoo.com> wrote in message
> news:t6ke0f695m1bb7_at_corp.supernews.com...
> > You have missed the obvious. Try
> >
> > BACKUP CONTROL FILE TO '/my_dir/my_control_file.sql' ;
> >
> > Richard Sutherland
>
>
> I just tested this. It took all of 15 seconds, and my first hunch was
> right: it doesn't work. the command to backup to a fully-qualified path
 and
> filename results in a *binary* copy of the Control File, not a trace
> script -regardless of what you attempt to call the thing.
>
> Sticking a ".sql" at the end does not a sql script make.
>
> Did you not test this before posting?
>
> HJR
>
>
>
> >
> > <afairch_at_phaedo.com> wrote in message
 news:949ut9$pkq$1_at_nnrp1.deja.com...
> > > I need help with a script that I am writing to move and rename a
> > > database. The script currently uses sqlplus to do a "backup control
> > > file to trace" and then uses the trace file that was created.
> > >
> > > The trace file that is created is named something lide ora_PID.trc,
> > > where PID is the process id of the process that created the file. I
> > > originally thought that would be the sqlplus pid, but it appears that
 a
> > > new process is spawned to write the trace file. Does anyone know a
> > > simple and more importantly reliable way to determine what process
 that
> > > is. My fallback plan is to make some educated guesses based on the
 date
> > > and time stamp on the file, but that does leave more room for error
> > > than I would like.
> > >
> > > some (hopefully) helpful information:
> > > Oracle version: 8.1.6
> > > OS: Solaris 2.6 (SunOS 5.6)
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks,
> > >
> > > Anthony
> > > afairch_at_phaedo.com
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
>
Received on Sun Jan 21 2001 - 09:46:33 CST