RE: Name of controlfile trace

If you are in unix under the korn shell, then execute the following:

cd <user_log>
ls -t | xargs grep -li "create control" | head -1

This will change directories to the <user_log> directory, list out the files in reverse order by create date, search the files for the "create controlfile" statement, and list out the first file with this matching text.

> -----Original Message-----
> From: Louis Avrami [SMTP:avramil_at_concentric.net]
> Sent: Monday, January 15, 2001 12:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Name of controlfile trace
>
>
> Hello all,
>
> I recall reading somewhere that there may be a way to determine
> the name of the trace file when a control file trace backup is
> created with the command:
>
> alter database backup controlfile to trace noresetlogs;
>
> I'm scripting a backup process, and I'd like to explictly grab
> a file and copy it to a backup location. As I said before, I
> thought I read somewhere that there might be some way to query
> the database to determine all or part of thetrace file name.
>
> If anyone knows, the info would be greatly appreciated.
>
> Thanks,
>
> Lou Avrami
>
> ----------------
> Sent from a WebBox - http://www.webbox.com
> FREE Web based Email, Files, Bookmarks, Calendar, People and
> Great Ways to Share them with Others!
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Louis Avrami
> INET: avramil_at_concentric.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jan 15 2001 - 13:36:05 CST