使用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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 檢查資料塊損壞(Block Corruption)BloC
- 怎樣檢查資料庫壞塊(DBV)資料庫
- 【dbv】使用dbv工具檢驗資料檔案是否有壞塊
- 使用dbv和RMAN檢查資料檔案中的壞塊
- oracle檢查資料庫是否有壞塊的命令Oracle資料庫
- Struts2教程4:使用validate方法驗證資料
- oracle 資料庫中壞塊概念和檢查指令碼Oracle資料庫指令碼
- 11g rman validate驗證資料庫資料庫
- Oracle約束enable validate時資料檢查Oracle
- 【exp】快速檢測資料檔案壞塊
- Oracle資料庫壞塊(corruption)-物理壞塊Oracle資料庫
- 關於表的資料塊驗證 DUMP 工具 使用
- Oracle資料庫啟動過程驗證檢查點SCNOracle資料庫
- 檢查 oracle 壞塊Oracle
- 資料庫壞塊處理資料庫
- 資料所在的資料塊實驗
- 修復損壞的資料塊
- Oracle資料庫壞塊修復Oracle資料庫
- ORA-01578(資料塊損壞)跳過壞塊
- 資料塊損壞ORA-1578(發現損壞塊)
- Oracle資料庫壞塊典型案例分析Oracle資料庫
- 跳過Oracle資料庫壞塊方法Oracle資料庫
- ORACLE中修復資料塊損壞Oracle
- 修復資料庫壞塊之五資料庫
- 修復資料庫壞塊之四資料庫
- 修復資料庫壞塊之三資料庫
- 修復資料庫壞塊之二資料庫
- 修復資料庫壞塊之一資料庫
- DB健康檢查使用RDA收集資料
- [20150929]檢查資料塊.txt
- 驗證資料是否存在
- 表單資料驗證
- 驗證ADG的壞塊檢測和自動修復
- 溫習資料演算法—js滑塊驗證碼演算法JS
- 資料庫配置檢查資料庫
- Oracle資料庫壞塊典型案例擴充Oracle資料庫
- ora_01578 資料庫壞塊資料庫
- 資料庫壞塊解決案例一則資料庫