How to Detect and Fix Table Corruption in Oracle?
Submitted By:
williumdavid
Rating:
(Not rated) (
Rate It)
Share:
By Email
Visit
Description
Oracle is an RDBMS (Relational Database Management System), developed and marketed by Oracle Corporation. It has a major presence in database computing. It stores all your valuable data in the DBF file. The DBF file contains all Oracle database objects, such as tables, reports, forms, macros, views, constraints, triggers, stored procedures, and more. If any of these database objects or the entire database gets damaged, you can not access your valuable data from it. In such circumstances, Oracle Database Recovery software are required to extract data from the database.
In order to overcome DBF corruption, Oracle offers a number of methods to detect and repair data files. These options include:
DBVerify- It is an external command-line utility, which enables you to validate offline data files of Oracle database. In addition to the offline data files, you can also use this utility for checking validity of the backup data files.
ANALYZE .. VALIDATE STRUCTURE- It is used to verify every single data block in the analyzed object. If this tool finds any corruption, rows are added to INVALID_ROWS table.
DB_BLOCK_CHECKING- If DB_BLOCK_CHECKING argument is set as TRUE, Oracle carries out a walk-through of the data in database block for checking whether it's self-consistent or not. This block checking process may add 1 to 10% overhead to server. This settings is recommended only if you can accept the overhead.
DBMS_REPAIR- It enables you to find and fix database corruption. This process needs two administration Oracle database tables for holding the list of damaged blocks and the index keys which point to those damaged blocks.
Comments (0)
Add Your Rating
