Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup control file to trace. can't find the trace file
I know the format of the trace file. my problem is I can't find any
trace file in the user_dump_dest directory.
I found that it actually go to $ORACLE_HOME/rdbms/log. how to set it to
user_dump_dest ?
The Oracle version i use is 804
In article <80guoc$2sq$1_at_pheidippides.axion.bt.co.uk>,
"Neil" <plums_at_bigfoot.com> wrote:
> As well as the advice given by John, the file you are looking for is
> typically named (on Unix)
> as <SID>_ora_<pid>.trc
>
> where SID is the oracle sid of the database for which the trace is
being
> produced, and pid is the process id of the process that created the
file.
>
> HTH
>
> NeilC
> yewpc_at_rnd.celcom.com.my wrote in message <80g640
$sj$1_at_nnrp1.deja.com>...
> >Hi eveyone,
> >
> >I encounter a problem in one of my HP server.
> >When I issue "alter database backup controlfile to trace;"
> >the statement processed sucessfully but
> >I can't find the control trace file in the user_dump_dest.
> >nither in background_dump_dest or core_dump_dest.
> >Can anyone tell me what is wrong ? Is there any thing i need to set ?
> >Please help one this. I need the control file to replicate a few more
> >databases.
> >Thank you
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 15 1999 - 21:22:42 CST
![]() |
![]() |