Multiple choice technology databases

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

Oracle automatically creates a new alert log file when it doesn't exist or has been deleted. You don't need to manually create it or restore from backup. The instance will regenerate it automatically when it needs to write alerts. Changing BACKGROUND_DUMP_DEST only affects location, not creation.

Keep practicing — related questions