Multiple choice technology programming languages

The junior DBA of your organization has accidentally deleted the alert log file. What will you do to create new alert log file?

  1. Create the new text file as ALERT.log

  2. You have to recover the alert log file from the valid backup.

  3. No action required. The file will be created automatically by the instance.

  4. Change the value for the BACKGROUND_DUMP_DEST parameter.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The alert log file is automatically recreated by the Oracle instance if it's deleted. There's no manual action required - the instance will create a new file on the next startup or when it needs to write to the alert log. You don't need to recover from backup or change initialization parameters. The BACKGROUND_DUMP_DEST parameter (or DIAGNOSTIC_DEST in newer versions) determines the location but doesn't affect automatic creation.

Keep practicing — related questions