Re: Need help locating correct trace file.

"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 Sat Jan 20 2001 - 19:42:22 CST