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.
Wrong!!!! Again….
Right answer is C
Why C if I may ask..
Apologize but this is the basic DBA, I do not know how they made a wrong answer for this simple question!
REDO LOG can not override the Mandatory Archive Log Destination(s) regardless the destination number.
Thanks Vonpire!
C. by default.
SQL> show parameter log_archive_min_succeed_dest
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_min_succeed_dest integer 1
SQL>
So C is right.
C
C
C https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346
C