Oracle Database 12c: Advanced Administration — Question 40

Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

Answer options

• A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
• B. Optional destinations cannot use the fast recovery area.
• C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
• D. These settings work only if log__archive_min_succeed_dest is set to a value of 4.

Correct answer: A

Explanation

The correct answer, A, indicates that if an archived log file cannot be created in any specified destination, the online redo log cannot be overwritten, ensuring data integrity. Option B is incorrect because optional destinations can still utilize the fast recovery area. Option C is misleading as it specifically limits the overwrite condition to log_archive_dest_4, while A encompasses all destinations. Option D is incorrect as these settings can function without a specific value set for log__archive_min_succeed_dest.