ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 042-090

042-090

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-15 04:04:34 0 删除 编辑
90. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.
Which command would you execute to proceed further?
A) RECOVER LOGFILE BLOCK GROUP 2;
B) ALTER DATABASE DROP LOGFILE GROUP 2;
C) ALTER DATABASE CLEAR LOGFILE GROUP 2;
D) ALTER DATABASE RECOVER LOGFILE GROUP 2;
E) ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
答案:E
没有归档的日志直接clear是不能清除掉的,须加上unarchived,而且该日志组应该也不能是current和active的

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

上一篇: 042-088
下一篇: 042-090
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214031