ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q64(RESETLOGS&LOG_ARCHIVE_FORMAT)

Oracle OCP 1Z0 053 Q64(RESETLOGS&LOG_ARCHIVE_FORMAT)

原创 Oracle 作者:abstractcyj 时间:2016-04-04 13:18:55 0 删除 编辑
64.You performed an incomplete recovery and opened the database with the RESETLOGS option. The
LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the
archived redo log files, created in an earlier incarnation of the database, is true?
A. The archived redo log files will be overwritten.
B. The archived redo log files are deleted automatically.
C. The archived redo log files should be moved to some other location.
D. The archived redo log files are still maintained because the file names are unique.
Answer: D

RESETLOGS之后,LOG SEQUENCE NUMBER被重置,

归档日志文件格式中各个符号的意思是:

%t thread number
%s log sequence number
%r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database

归档日志文件按照这个规则产生的时候,文件名是唯一的。所以,不可能被覆盖。
也不会被自动删除或者移动到另外的位置。


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2074965/ ,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091628