1Z0-052 · Question #191
The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server: Which statement is true regarding the archived…
The correct answer is A. It will be created on the local file system. When LOG_ARCHIVE_DEST_1 specifies a local directory and no Flash Recovery Area is configured as an additional destination, archived redo log files are written exclusively to the local file system.
Question
The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:
Which statement is true regarding the archived redo log files?
Exhibit
Options
- AIt will be created on the local file system.
- BIt will be created only in the Flash Recovery Area.
- CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default
- DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location
How the community answered
(50 responses)- A78% (39)
- B6% (3)
- C12% (6)
- D4% (2)
Why each option
When LOG_ARCHIVE_DEST_1 specifies a local directory and no Flash Recovery Area is configured as an additional destination, archived redo log files are written exclusively to the local file system.
With LOG_ARCHIVE_DEST_1 pointing to a local filesystem path and no competing destination parameters or db_recovery_file_dest configured, Oracle writes all archived logs to that single local directory, satisfying the archiving requirement without involving a Flash Recovery Area or remote location.
Archived logs are written only to the Flash Recovery Area when db_recovery_file_dest is set and no explicit LOG_ARCHIVE_DEST_n parameters are defined; when LOG_ARCHIVE_DEST_1 is set to a local path, the FRA is not used unless also configured as a separate destination.
A second destination such as the Flash Recovery Area default location would only be active if db_recovery_file_dest were also set alongside LOG_ARCHIVE_DEST_1, which is not indicated by the given parameter configuration.
A second explicit location would require an additional LOG_ARCHIVE_DEST_n parameter to be configured; without that, only the single destination defined by LOG_ARCHIVE_DEST_1 is used.
Concept tested: Oracle ARCHIVELOG mode archive destination configuration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/LOG_ARCHIVE_DEST_n.html
Topics
Community Discussion
No community discussion yet for this question.
