ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-088

043-088

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-07 20:15:59 0 删除 编辑
88. You execute the following RMAN command in the order shown below:
BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;
What will these commands do?
A. Create a backup of the database and recover all corrupted blocks f
ound in the backup.
B. Run a backup validation and list all the logically corrupt blocks
as well as physically corrupt blocks in the database.
C. Run a backup validation to populate V$COPY_CORRUPTION view, and th
en list any corrupt blocks recorded in the view.
D. Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION vi
ew, and then repair any corrupt blocks recorded in the view.
E. Run a backup validation, repair any corrupt blocks found during th
e validation process, and then update V$DATABASE_BLOCK_CORRUPTION vie
w to indicate which corrupt blocks have been repaired.
Answer: D
backup validate database;
--检查所有数据文件是否存在坏块,并不执行实际备份, 这个时候,访问
v$database_block_corruption 可以看到详细的坏块的信息.
执行BLOCKRECOVER CORRUPTION LIST,会自动按V$DATABASE_BLOCK_CORRUPTION 进行修
复。V$DATABASE_BLOCK_CORRUPTION 视图显示当前损坏的数据库块的列表。
通过使用 CORRUPTION LIST 子句,可以恢复 V$DATABASE_BLOCK_CORRUPTION 中列出的
块。
BACKUP VALIDATE DATABASE
BLOCKRECOVER CORRUPTION LIST RESTORE UNTIL TIME 'sysdate – 10';
因为损坏块数量超过可接受的数量,所以要使用BACKUP VALIDATE DATABASE 这个命令
备份,在备份的同时会在备份操作期间填写V$DATABASE_BLOCK_CORRUPTION,然后再使用
CORRUPTION LIST 子句,可以恢复 V$DATABASE_BLOCK_CORRUPTION 中列出的块。

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

上一篇: 043-087
下一篇: 043-089
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203284