RE: Name of controlfile trace

>
> 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;

This is platform specefic. The following sql is for sun. (sid_ora_#.trc - Linux is ora_#.trc) Just change the format of the result for your platform. The query should be the same.

select

      a.value ||
        '/' ||
      lower(d.name) ||
        '_ora_' ||
      b.spid ||
        '.trc' as file_name
    from
      v$parameter a,
      v$process b,
      v$session c,
      v$database d
    where
          a.name='user_dump_dest'
      and b.addr=c.paddr
      and c.type='USER'
      and c.audsid=userenv('SESSIONID')

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom Received on Mon Jan 15 2001 - 12:47:16 CST