Wednesday , July 26 2017
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

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

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