Logo Background

Oracle Core Dump

  • By on January 15, 2009 | No Comments

    Question: Can any one tell me about the contents of cdump directory in my server which consumes lot of space. The contents are not readable format. Will deleting this core dump files affect the database.

    Answer: The cdump is one of the background file destinations for your Oracle instance. Generally, cdump stores the core dumps created by other Oracle errors. You will notice that Oracle creates a directory within cdump and puts the core file in that sub directory.

    There will be a corresponding trace file in either bdump or udump (check the number within the name of the file and the timestamps for correlation). Usually, although not always, cdump are caused by internal Oracle errors. You should be sending these to Oracle support.

    SQL> SELECT * FROM v$parameter
    WHERE name IN ('user_dump_dest','background_dump_dest','core_dump_dest');

    In any case, it does not hurt the database to delete these files. You can examine these files in Unix with commands such as “strings -a” although only Oracle support would know how to interpret it all.

    Look in your bdump, cdump, and udump directories for trace files. Also check the alert_{SID}.log file. These should contain further information for you to use in debugging.

    If you get a core dump, it sounds likely that there is an ORA-600 internal error. Perhaps a corrupt data block or db_writer problem. Regardless, the files described above should give you guidance.

    » SRVCTL Oracle Database Command
Leave a Comment