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.
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.
Explanation:
REDO LOG can not override the Mandatory Archive Log Destination(s) regardless the destination number.
https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346