使用validate驗證資料檢查資料壞塊
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.
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部落格 ” ,連結:http://blog.itpub.net/29802484/viewspace-1995002/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mongoose使用validate驗證, 獲取自定義驗證資訊Go
- [20180306]資料塊檢查和.txt
- [20180306]資料塊檢查和2.txt
- 資料檢驗器
- 驗證ADG的壞塊檢測和自動修復
- Oracle資料庫壞塊典型案例分析Oracle資料庫
- jQuery Validate自定義驗證錯誤資訊jQuery
- 使用表單驗證,建立資料驗證層,Ajax 統一返回驗證錯誤資訊
- jQuery Validate驗證規則的使用jQuery
- jQuery Validate驗證規則使用演示jQuery
- Oracle資料庫壞塊典型案例擴充Oracle資料庫
- 驗證資料是否存在
- 表單資料驗證
- 溫習資料演算法—js滑塊驗證碼演算法JS
- 如何使用命令列工具檢查資料庫?命令列資料庫
- Oracle OCP(14):使用子查詢檢索資料Oracle
- 深度解析javaScript常見資料型別檢查校驗JavaScript資料型別
- 【資料庫資料恢復】Oracle資料庫檔案出現壞塊報錯的資料恢復案例資料庫資料恢復Oracle
- oracle 普通表空間資料檔案壞塊Oracle
- 使用SpringBoot進行優雅的資料驗證Spring Boot
- beego表達資料驗證Go
- MySQL資料庫健康檢查--MySQL巡檢MySql資料庫
- 使用nslookup檢視SSL安全證書域名驗證資訊
- thinkphp validate unique 資料庫欄位唯一性校驗PHP資料庫
- 一次ORACLE資料庫undo壞塊處理Oracle資料庫
- Validator | validate 驗證規則
- 如何驗證 elk 裡面的資料?
- 自定義react資料驗證元件React元件
- MSSQL資料庫健康檢查--SQL Server巡檢SQL資料庫Server
- 檢視 Laravel 查詢資料語句Laravel
- element-ui使用from表單驗證資料問題UI
- APEX 通過資料庫中使用者資訊驗證登陸資料庫
- jQuery Validate checkbox和radio驗證jQuery
- jquery.validate 表單驗證jQuery
- validate表單驗證外掛
- 資料庫檢視的使用資料庫
- MySQL中資料型別的驗證MySql資料型別
- jsonlint:python的json資料驗證庫JSONPython
- 有關資料驗證的原則