Friday, December 27, 2013

How to Protect Silent Data Corruption in Oracle database?

Silent data corruption occurs during writing to disk drives, it is one of the most common areas in which data corruption occurs. There are mainly two types of disk drive related corruption occurs, first is the latent sector errors and second is the silent data corruption.

Latent sector errors occur due to the malfunctioning of a physical disk drive and can only be detected by Error Correcting Code (ECC) or Cyclic Redundancy Checks (CRC) in the input/output path. It can be corrected automatically by the ECC or CRC.

Silent data corruption can happen without any caution so that it can be defined as the thrashing of data resulting from inadvertent administrative action or module failure. When an invalid data is written or read rather than due to failed input/output process then this error occurs. This error is very difficult to detect without using end-to-end integrity checking. When this kind of error occurs without the knowledge of the application or the database administrator then it is known as silent database corruption. It is very rare error and can go hidden for a long interval of time, so it is very dangerous error because it can silently affect the stored data and also the database. 

How to protect database from this error?

Database can be protected from this error by applying the data integrity protection. Through this method we can detect and protect our database from the silent data loss. But sometimes it can also get fail to detect this kind of error then data loss occurs. To detect this error and repair it without losing any data you can apply any third party oracle database error repair tool

This tool is specially designed to fix and protect your database from silent data corruption. This tool can also use to recover and restore deleted data or data from corrupted oracle database. It is very easy to use so that one can use and protect their database and stored data from the unwanted errors.

0 comments:

Post a Comment