ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 628

Oracle 11G OCP 1Z0-053 628

原创 Oracle 作者:LuiseDalian 时间:2014-11-12 07:41:16 0 删除 编辑
(628)The database is running in the ARCHIVELOG mode.It has three redo log groups with one member each.

One of the redo log groups has become corrupted.

You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Which action should you perform immediately after using this command?

A. You should perform a log switch

B. You should make a backup of the database

C. You should switch the database to the NONARCHIVELOG mode

D. You should shut down the database instance and perform a complete database recovery

答案:(B)

解析:

执行的命令是重新创建日志组3,而且没有产生归档,那么就出现了归档不连续的情况,如果这个时候数据库损坏,是无法做完全恢复的。

因此要做一次备份,但是备份的类型没有具体的要求,如果前面有增量备份,此时做一个增量备份就可以了,无需一定要做一个完全的数据库备份

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

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6040856