OCP-1Z0-053-V12.02-508题

508.You want to set the following Initialization parameters for your database Instance

LOG_ARCHIVE_DEBT_1 = ,,LOCATION=/disk1/arch

LOG_ARCHIVE_DBST_2 = ,,LOCATION=/disk2/arch

LOC_ARCHIVB DBST_3 = ,,LOCATION=/disk3/arch

LOG_ARCHIVE DBST_4 = ,,LOCATION=/disk3/arch

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

答案解析：

参考：618题：http://blog.youkuaiyun.com/rlhua/article/details/13998731

此题题意有问题，第四个路径应为LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'

如果两个路径相同，如题中3和4是一样的/disk3/arch，是不对的。

sys@TEST1107> alter system set log_archive_dest_1='LOCATION=/u01/rmanbak/d1';

System altered.

sys@TEST1107> alter system set log_archive_dest_2='LOCATION=/u01/rmanbak/d1';

alter system set log_archive_dest_2='LOCATION=/u01/rmanbak/d1'

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameter

LOG_ARCHIVE_DEST_1 destination