ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q618(LOG_ARCHIVE_DEST&Mandatory)

Oracle OCP 1Z0 053 Q618(LOG_ARCHIVE_DEST&Mandatory)

原创 Oracle 作者:abstractcyj 时间:2016-04-06 10:07:05 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    833352