RE: Name of controlfile trace

..or if You want to do it with Sql*Plus (in Unix):

column value noprint new_value udump_dir

select value from v$parameter where name = 'user_dump_dest';

column proc noprint new_value trc_name

select a.spid proc from v$process a, v$session b where

        b.audsid = to_number(userenv('sessionid')) and
        a.addr = b.paddr;

alter database backup controlfile to trace noresetlogs;

! cp &udump_dir./ora_&trc_name..trc <file_name>

Br.
Jorma

> -----Original Message-----
> From: ext Elliott, Patrick [mailto:Patrick.Elliott_at_bestbuy.com]
> Sent: 15 January, 2001 21:35
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Elliott, Patrick
> INET: Patrick.Elliott_at_bestbuy.com
>
> 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
Received on Tue Jan 16 2001 - 06:34:15 CST