Oracle Database 11g: Administration I — Question 26

Your database is open in ARCHIVELOG mode.
is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place.

LOG_ARCHIVE_DEST -
What is the outcome?

Answer options

• A. The archivelog entries are made in the diagnostic destination and when space is available, new archivelogs are generated
• B. Obsolete backups are automatically deleted and new archivelogs are generated
• C. All active sessions hang until the database administrator (DBA) makes space available in the FRA
• D. No archivelogs are generated
• E. All active sessions are disconnected and their transactions rolled back

Correct answer: B

Explanation

The correct answer is B because when the FRA is full, Oracle automatically removes obsolete backups to create space for new archivelogs. Other options are incorrect as they suggest that sessions hang or are disconnected, or that archivelogs are written to diagnostic destinations, which is not the behavior when the FRA is full.