cdump,bdump,etc
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: cdump,bdump,etc

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    78
    Can any one remind me of the default location for udump,cdump and bdump on unix?

  2. #2
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    $ORACLE_HOME/admin/SID/bdump
    $ORACLE_HOME/admin/SID/cdump
    $ORACLE_HOME/admin/SID/udump

  3. #3
    Join Date
    Mar 2001
    Posts
    78
    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

  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink

    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.

  5. #5
    Join Date
    Nov 2000
    Posts
    344
    select name, value from v$parameter
    where name like '%dump%'

    this will show it to you...

  6. #6
    Join Date
    Sep 2000
    Posts
    23
    or just use the unix find command.....

  7. #7
    Join Date
    Mar 2001
    Posts
    78
    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.

  8. #8
    Join Date
    Nov 2000
    Posts
    344
    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
  •  


Click Here to Expand Forum to Full Width