Re: Trace about backup controlfile

Very weird indeed.
The system process identifier (spid) should get included in the trace file name.
You can find the spid by the following query select spid
from v$session s, v$process p
where p.addr = s.padd
and s.audsid = userenv('sessionid')

(As sys doesn't use the auditing sid, you'll need to replace that by terminal when running as sys)

Doing so, you could at least verify whether it generates a trace file at all.

Hth,

Sybrand Bakker, Oracle DBA

"chuan zhang" <chuan_at_asiaonline.net> wrote in message news:gwh55.54$397.8715382_at_news.interact.net.au...
> Hi All,
>
> I run into a very simple but strange problem.
>
> When I used "alter database backup controlfile to trace". There is no
 trace
> generated under UDUMP. I checked all the files under BDUM and CDUMP, I
 don't
> get the trace file either.
>
> 1. I have set up the initial parameters like following in the
> initvantive.ora:
>
> "background_dump_dest = /opt/oracle/815/admin/vantive/bdump
> core_dump_dest = /opt/oracle/815/admin/vantive/cdump
> user_dump_dest = /opt/oracle/815/admin/vantive/udump"
>
> 2. I have enable the DB into automatically Archive and archive mode.
>
> Any clues about this would be much appreciated.
>
> Chuan Zhang
>
> Asia Online Co.
> Canberra, Australia,
>
>
>
Received on Sun Jun 25 2000 - 00:00:00 CDT