Oracle OCP 1Z0 053 Q618(LOG_ARCHIVE_DEST&Mandatory)

618.You want to set the following initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 =
'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch'
LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch
MANDATORY'
Identify the statement that correctly describes this setting.
A. The MANDATORY location must be a flash recovery area.
B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the
fourth destination.
Answer: D

當指定了mandatory, 並且這個destination不可寫時， 線上重做日誌檔案不允許被覆蓋

官方文件：http://docs.oracle.com/cd/E11882_01/server.112/e41134/log_arch_dest_param.htm#SBYDB01111

If MANDATORY is not specified, then, by default, the destination is considered to be optional.

At least one destination must succeed, even if all destinations are optional. If archiving to an optional destination fails, the online redo log file is still available for reuse and may be overwritten eventually. However, if the archival operation of a mandatory destination fails, online redo log files cannot be overwritten.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2075942/，如需轉載，請註明出處，否則將追究法律責任。