1Z0-052 · Question #237
You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario…
The correct answer is C. The file gets re-created automatically. When an Oracle alert log file is deleted while the database is running, Oracle automatically recreates it the next time a message needs to be written. No DBA intervention or recovery is required.
Question
You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?
Options
- AThe database crashes.
- BThe DBA needs to re-create the file.
- CThe file gets re-created automatically.
- DThe file gets restored automatically from the last backup.
- EThe DBA needs to perform a complete database recovery.
- FThe DBA needs to perform an incomplete database recovery.
How the community answered
(25 responses)- B4% (1)
- C92% (23)
- D4% (1)
Why each option
When an Oracle alert log file is deleted while the database is running, Oracle automatically recreates it the next time a message needs to be written. No DBA intervention or recovery is required.
The alert log is a diagnostic file, not a structural database file, so its absence does not affect database availability or cause a crash.
Manual recreation is unnecessary because Oracle's diagnostic framework automatically regenerates the alert log on the next write attempt.
Oracle's alert log is not a file the instance holds open with an exclusive lock. When the next background event or error triggers a write to the alert log, Oracle detects the file is missing and recreates it automatically in the same ADR (Automatic Diagnostic Repository) location, resuming normal logging without any downtime or manual action.
Oracle does not restore the alert log from RMAN or any other backup mechanism - it simply creates a new empty file.
Complete database recovery is reserved for lost or corrupted datafiles or redo logs, not for a missing diagnostic log file.
Incomplete (point-in-time) recovery is irrelevant here because the alert log contains diagnostic messages, not transactional data that must be rolled back to a prior point.
Concept tested: Oracle alert log automatic recreation behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html
Topics
Community Discussion
No community discussion yet for this question.