1Z0-052 · Question #57
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on…
The correct answer is C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash. When the Flash Recovery Area (FRA) is configured and LOG_ARCHIVE_DEST_1 is not explicitly set, Oracle automatically uses the FRA as the archive log destination. No manual destination configuration is needed.
Question
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?
Options
- AArchiving will be disabled because the destination for the redo log files is missing
- BThe database instance will shut down and the error details will be logged in the alert log file
- CArchiving will be enabled and the destination for the archived redo log file will be set to the Flash
- DArchiving will be enabled and the location for the archive redo log file will be created in the default
How the community answered
(23 responses)- A9% (2)
- B13% (3)
- C74% (17)
- D4% (1)
Why each option
When the Flash Recovery Area (FRA) is configured and LOG_ARCHIVE_DEST_1 is not explicitly set, Oracle automatically uses the FRA as the archive log destination. No manual destination configuration is needed.
Archiving is not disabled when LOG_ARCHIVE_DEST_1 is unset because Oracle falls back to the FRA as an implicit archive destination.
Oracle does not shut down the instance over a missing LOG_ARCHIVE_DEST_1; it silently uses the FRA instead and logs no shutdown-level error.
Oracle's automatic archiving mechanism checks for an explicitly configured LOG_ARCHIVE_DEST_1 parameter first. When that parameter is absent but a Flash Recovery Area is configured via DB_RECOVERY_FILE_DEST, Oracle automatically redirects archived redo logs to the FRA, enabling archiving without any manual destination setting.
The fallback location is specifically the configured FRA (DB_RECOVERY_FILE_DEST), not a generic OS default directory.
Concept tested: Flash Recovery Area as default archive log destination
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-db-archivelog.html
Topics
Community Discussion
No community discussion yet for this question.