Multiple choice technology databases

You have determined that the archiving was not successful in on of the destinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?

  1. USER_DUMP_DEST

  2. CORE_DUMP_DEST

  3. ALERT_LOG_DEST

  4. BACKGROUND_DUMP_DEST

  5. ALERT_DUMP_DEST

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The BACKGROUND_DUMP_DEST initialization parameter specifies the directory location for background process trace files, including the alert log (alert_.log). The alert log contains diagnostic information about database operations, errors, and archiving issues. USER_DUMP_DEST is for server process traces, CORE_DUMP_DEST for core dumps.