Sunday , October 22 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

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

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