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

557.What will be the result of the following configuration?

Log_archive_dest_1=location=c:\oracle\arch\mydb

Log_archive_dest_2=location=z:\oracle\arch\mydb

A. An error will occur during database startup because the second parameter is not valid.

B. An error will occur during database startup since you are trying to create archived redo logs in two

different locations.

C. Archived redo logs will be created in two different locations by the ARCH process.

D. Archived redo logs will be created in two different locations by the LGWR process.

E. Neither parameter setting is valid, so the database will not start up.

Answer: C

答案解析：

因为设置有两个路径，

LOG_ARCHIVE_DEST_n           ---使用LOG_ARCHIVE_DEST_n参数定义多个归档路径

LOG_ARCHIVE_DEST_n    参数定义多个归档路径，使用初始化参数LOG_ARCHIVE_DEST_n配置归档位置时,可以在归档位置上指定OPTIONAL或MANDATORY选项.指定MANDATORY选项时,可以设置REOPEN属性。

OPTIONAL:该选项是默认选项.使用该选项时,无论归档是否成功,都可以覆盖重做日志。

MANDATORY:强制归档.使用该选项时,只有在归档成功之后,重做日志才能被覆盖。

REOPEN:该属性用于指定重新归档的时间间隔,默认值为300秒,必须跟在MANDATORY后。

LOG_ARCHIVE_MIN_SUCCEED_DEST   参数控制本地归档的最小成功个数

设定有两个路径，就会在各个路径上产生两份归档。