052-219(新增70题2018)
You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally.
Which statement in this scenario is true?
A. The database crashes.
B. The DBA needs to re-create the file.
C. The file gets re-created automatically.
D. The file gets restored automatically from the last backup.
E. The DBA needs to perform a complete database recovery.
F. The DBA needs to perform an incomplete database recovery.
Answer: C
实验:
SQL> show parameter background_dump_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace --进入目录删除alert_orcl.log alter tablespace test1 offline; alter tablespace test1 online; --alert_orcl.log自动生成了 Tue Mar 20 02:15:07 2018 alter tablespace test1 offline Completed: alter tablespace test1 offline alter tablespace test1 online Completed: alter tablespace test1 online
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步