5 forms of Oracle Corruption
In Oracle databases, corruption in its broadest sense is incorrect information - information that Oracle did not expect to find. This condition can exist in memory, in data blocks, or in the data dictionary, giving rise to the five forms of corruption:
Memory (HEAP) corruption
Block corruption
Dictionary corruption
Undo corruption
Redo corruption
HEAP corruption occurs when a piece of memory is overwritten and this can be caused by an Oracle Bug, an O/S overwrite, or by an application. The code that overwrites the memory usually does not fail because it has been successful in writing to memory. It is the code that is looking for the overwritten memory that fails later.
Block corruption occurs when a data block contains inconsistent information. Oracle data blocks have a number of internal checks to verify the consistency of the block, and when one of these checks fail, a corruption is detected. The corruption may be on disk, or may be trapped in memory and never written to disk. Block corruptions are mostly caused by O/S problems.
The data dictionary is a set of tables that Oracle uses to store metadata about the database. Referential integrity between the tables is maintained by the Oracle code, not by any constraints between the tables. If the integrity between the tables becomes inconsistent, this is known as data dictionary corruption. These can be caused by Oracle bugs or O/S problems as well.
Undo corruption is corruption in an undo segment, and this is usually caused by block corruptions in the undo tablespace.
Redo corruption is corruption in a redo online or archived log, usually caused by O/S problems.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/38542/viewspace-980777/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [翻譯]-Detect And Repair Corruption in an Oracle DatabaseAIOracleDatabase
- Oracle資料庫壞塊(corruption)-物理壞塊Oracle資料庫
- oracle判斷block corruption的依據是啥?OracleBloC
- Checking for Oracle archive log corruption [ID 1268590.1]OracleHive
- Oracle 隱含引數 : _allow_resetlogs_corruptionOracle
- Tap Forms 5 for Mac(資料管理軟體)ORMMac
- block corruption typeBloC
- oracle Forms Builder常用函式 (轉載)OracleORMUI函式
- Oracle EBS - Forms Servlet與Socket模式比較OracleORMServlet模式
- Adding List Item Element At Runtime In Oracle FormsOracleORM
- forms元件ORM元件
- Oracle EBS R12.1.1 system09.dbf file corruption BugOracle
- Oracle OCP 1Z0 053 Q178(Redo Log Corruption)Oracle
- DISPLAY_ITEM built-in in Oracle D2k FormsUIOracleORM
- Django forms元件DjangoORM元件
- HTML 22 - FormsHTMLORM
- .Net 5中Windows Forms執行時的新功能(翻譯)WindowsORM
- ASM DISK HEADER CORRUPTION & REPAIRASMHeaderAI
- 常見corruption block總結BloC
- 測試FORMS SERVERORMServer
- Forms Personalization in Oracle Apps R12 Example: Zoom Functionality(轉)ORMOracleAPPOOMFunction
- Master Note for Handling Oracle Database Corruption Issues [ID 1088018.1]ASTOracleDatabase
- Xamarin.Forms教程開發Xamarin.Forms應用程式需要的工具ORM
- C/C++ 恨透了 double free or corruptionC++
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- 檢查資料塊損壞(Block Corruption)BloC
- [Django高階之forms元件]DjangoORM元件
- 缺少歸檔日誌,ORACLE資料庫恢復使用_allow_resetlogs_corruption引數Oracle資料庫
- 從v$database_block_corruption 刪除資料DatabaseBloC
- Summary For Forcing The Database Open With `_ALLOW_RESETLOGS_CORRUPTION`Database
- 【Xamarin.Forms 3】頁面型別ORM型別
- Xamarin.Forms Views介紹(五)ORMView
- Windows Forms的ApplicationContext 類WindowsORMAPPContext
- Windows Forms 的AxHost 類介紹WindowsORM
- Windows Forms 的CacheVirtualItemsEventArgs 類介紹WindowsORM
- 11g Active Standby Database Automatic Block Corruption RepairDatabaseBloCAI
- Xamarin.Forms Shell基礎教程(1)ORM
- @angular/forms 原始碼解析之 ValidatorsAngularORM原始碼