-
Can any one remind me of the default location for udump,cdump and bdump on unix?
-
$ORACLE_HOME/admin/SID/bdump
$ORACLE_HOME/admin/SID/cdump
$ORACLE_HOME/admin/SID/udump
-
It did not work.
$ cd $ORACLE_HOME/admin/VTDB/udump
ksh: /u08/ora8/oracle/product/8.1.7/admin/VTDB/udump: not found.
NOTE: VTDB is the name of the SID/DATABASE
It's not specified in my initVTDB.ora file neither so the default should work
-
Log into your database and do show parameters. This will tell you what user_dump_dest, core_dump_dest and background_dump_dest are set to.
-
select name, value from v$parameter
where name like '%dump%'
this will show it to you...
-
or just use the unix find command.....
-
select name, value from v$parameter where name like '%dump%';
NAME VALUE
-------------------- -------------
shadow_core_dump full
background_core_dump full
background_dump_dest ?/rdbms/log
user_dump_dest ?/rdbms/log
max_dump_file_size 10240
core_dump_dest ?/dbs
The background_dump_dest, background_core_dump is giving me the location of the alert file. That is not what I want.
$ORACLE_HOME/rdbms/log is where the alert file is located. Everything there starts with alert_SID.log or alert_SID_*****.log and tracle files that end with the extension trc. I want to locate the udump,cdump,ect.
-
bdump is specified by background dump dest.
cdump is specified by core dump dest.
udump is specified by user dump dest.
Whatever is showing is what Oracle is using for these
directories. No exceptions. If you don't believe me,
try 'alter database backup controlfile to trace' and see
where the file shows up.
If you want to change these, you can do it in the init.ora
file and then restart you database.
-John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|