Home / Oracle DBA / ALERT LOG & OTHER TRACE FILES

ALERT LOG & OTHER TRACE FILES

ALERT LOG & OTHER TRACE FILES

  1. Alert log is the monitoring file which records following information useful for DBA in diagnosing the errors in the database
    1. All oracle related errors
    2. Every startup and shutdown timestamp
    3. Non-default parameters
    4. Archivelog generation information
    5. Checkpoint information (optional) etc.
  1. Alert log file will only specifies error message in brief, but it will point to a file which will have more information about the error. These are called trace files.
  1. Trace files are of 3 types – background trace files, core trace files and user trace files.
  1. If any background process fails to perform, it will throw error and a trace file will be generated (called background trace files) in ORACLE_HOME/admin/SID/bdump location.
  1. For all operating system related errors with oracle, trace files will be generated (called core trace files) in ORACLE_HOME/admin/SID/cdump location.
  1. For all user related errors, trace files (called user trace files) will be generated in ORACLE_HOME/admin/SID/udump location.
  1. The default location of these files can be changed by defining following parameters
    1. BACKGROUND_DUMP_DEST
    2. CORE_DUMP_DEST
    3. USER_DUMP_DEST
Note: The above 3 parameters are replaced with a single parameter DIAG_DEST in oracle 11g.
Read More:
SMON’s instance recovery with example
COMPONENTS OF ORACLE DATABASE ARCHITECTURE
LOGICAL STRUCTURES OF DATABASE
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe