ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q324

Oracle OCP 1Z0 053 Q324

原创 Oracle 作者:abstractcyj 时间:2016-04-03 15:08:52 0 删除 编辑
324.Your database is up and running and one of your three control files is accidentally erased. You start
RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)
A. The command restores only the missing control file.
B. The command restores all the control files.
C. The command fails because the database is running.
D. This is the correct way to address this problem.
E. This is not the correct way to address this problem.
Answer: CE


B与C实际上是矛盾的

RMAN> restore controlfile from autobackup;


Starting restore at 03-APR-16
using channel ORA_DISK_1


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2016 15:09:54
RMAN-06496: must use the TO clause when the database is mounted or open


恢复控制文件在要在nomount状态下恢复的,所以说这个不是一个正确的解决方法。
参考:http://blog.csdn.net/rlhua/article/details/17024779

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

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

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091629