| Oracle is an RDBMS (Relational Database | | | | argument is set as TRUE, Oracle carries out a |
| Management System), developed and marketed by | | | | walk-through of the data in database block for |
| Oracle Corporation. It has a major presence in | | | | checking whether it's self-consistent or not. This block |
| database computing. It stores all your valuable data in | | | | checking process may add 1 to 10% overhead to |
| the DBF file. The DBF file contains all Oracle database | | | | server. This settings is recommended only if you can |
| objects, such as tables, reports, forms, macros, views, | | | | accept the overhead. |
| constraints, triggers, stored procedures, and more. If | | | | DBMS_REPAIR- It enables you to find and fix |
| any of these database objects or the entire database | | | | database corruption. This process needs two |
| gets damaged, you can not access your valuable data | | | | administration Oracle database tables for holding the |
| from it. In such circumstances, Oracle Database | | | | list of damaged blocks and the index keys which point |
| Recovery software are required to extract data from | | | | to those damaged blocks. |
| the database. | | | | In case, none of the above methods can repair and |
| In order to overcome DBF corruption, Oracle offers a | | | | restore damaged database table, you need to restore |
| number of methods to detect and repair data files. | | | | the table from current backup. However, if the backup |
| These options include: | | | | is either corrupted or not available, you need to Repair |
| DBVerify- It is an external command-line utility, which | | | | Oracle Database using third-party solutions. |
| enables you to validate offline data files of Oracle | | | | You can recover damaged DBF file in a quick and |
| database. In addition to the offline data files, you can | | | | effective way using DBF Recovery software. The |
| also use this utility for checking validity of the backup | | | | applications are incorporated with advanced and |
| data files. | | | | powerful scanning techniques to ensure absolute |
| | | | recovery in all cases of DBF file corruption. |
| ANALYZE .. VALIDATE STRUCTURE- It is used to | | | | You can Repair Oracle Database on your own using |
| verify every single data block in the analyzed object. If | | | | these applications, as they have simple and rich |
| this tool finds any corruption, rows are added to | | | | graphical user interface. With read-only and |
| INVALID_ROWS table. | | | | non-destructive conduct, these applications preserve |
| DB_BLOCK_CHECKING- If DB_BLOCK_CHECKING | | | | integrity of your data. |