Re: location of text control file if not found in user_dump_dest?

From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Tue, 23 Mar 2010 09:57:07 -0700
Message-ID: <eee76b6f1003230957n3a861aafy3dea27994c2b49a0_at_mail.gmail.com>

Was the controlfile trace written successfully to /qaora/app/oracle/product/9/
>
> rdbms/log?

On Mon, Mar 22, 2010 at 2:25 PM, Roger Xu <wellmetus_at_gmail.com> wrote:

> SQL> alter database backup controlfile to trace;
>
> Database altered.
>
> SQL> oradebug setmypid
> Statement processed.
> SQL> oradebug tracefile_name
> /qaora/app/oracle/product/9/rdbms/log/qadon_ora_6552.trc
>
> SQL> !echo $ORACLE_HOME
> /qaora/app/oracle/product/9
>
> SQL> show parameter dump
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> background_core_dump string partial
> background_dump_dest string /qadon/oradata/qadon/bdump
> core_dump_dest string /qadon/oradata/qadon/cdump
> max_dump_file_size string 10240
> shadow_core_dump string partial
> user_dump_dest string /qadon/oradata/qadon/udump
> SQL> show parameter diag_dest
> SQL> show parameter diag
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 -
> 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.8.0 - Production
> $
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 23 2010 - 11:57:07 CDT