Upgrade Oracle DBA 11g to Oracle Database 12c — Question 7

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 is A because it accurately reflects the behavior of the archiving process, where an online redo log cannot be overwritten if no archived log file can be created in any destination. Option B is incorrect as optional destinations can still use the fast recovery area. Option C is misleading since it only considers log_archive_dest_4, while A covers all destinations. Option D is also incorrect as the settings can work without a specific value set for log__archive_min_succeed_dest.