Need help locating correct trace file.

From: <afairch_at_phaedo.com>
Date: Fri, 19 Jan 2001 17:52:46 GMT
Message-ID: <949ut9$pkq$1@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 Fri Jan 19 2001 - 11:52:46 CST