Re: location of text control file if not found in user_dump_dest?
- From: Madhu Sreeram <madhusreeram@xxxxxxxxx>
- To: wellmetus@xxxxxxxxx
- Date: Thu, 18 Mar 2010 15:23:43 -0500
On Thu, Mar 18, 2010 at 2:41 PM, Roger Xu <wellmetus@xxxxxxxxx> wrote:
> This is a 9i database:
>
> SQL> show parameter user_dump_dest
>
>
>
> NAME TYPE VALUE
>
> ------------------------------------ -----------
> ------------------------------
>
> user_dump_dest string /qadon/oradata/qadon/udump
>
> SQL> alter database backup controlfile to trace;
>
>
>
> Database altered.
>
>
>
> SQL> !ls -l /qadon/oradata/qadon/udump
>
> total 0
>
>
>
> SQL>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Try looking in the bdump (for Shared server that's where it would be). Also
make sure the udump has free space in the mount point.
If the version is 9.2 or greater you can provide the file location as in:
alter database backup controlfile to trace as
'/path_of_a_directory/filename.sql';
-Madhu Sreeram
Other related posts:
