ITPub博客

首页 > 数据库 > Oracle > 使用validate验证数据检查数据坏块

使用validate验证数据检查数据坏块

原创 Oracle 作者:zhangsharp20 时间:2016-02-26 11:32:40 0 删除 编辑
You can use the VALIDATE command to manually check for physical and logical 
corruptions in database files. This command performs the same types of checks as 
BACKUP VALIDATE, but VALIDATE can check a larger selection of objects. For 
example, you can validate individual blocks with the VALIDATE DATAFILE ... 
BLOCK command.
When validating whole files, RMAN checks every block of the input files. If the 
backup validation discovers previously unmarked corrupt blocks, then RMAN 
updates the V$DATABASE_BLOCK_CORRUPTION view with rows describing the 
corruptions.
Use VALIDATE BACKUPSET when you suspect that one or more backup pieces in a 
backup set are missing or have been damaged. This command checks every block in a 
backup set to ensure that the backup can be restored. If RMAN finds block corruption, 
then it issues an error and terminates the validation. The command VALIDATE 
BACKUPSET enables you to choose which backups to check, whereas the VALIDATE 
option of the RESTORE command lets RMAN choose.

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

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

注册时间:2014-08-12

  • 博文量
    382
  • 访问量
    801409