Skip to main content

How to Easily Approach and Circumvent Data Block Corruptions in Oracle

Corruption manifests itself in an Oracle database in primarily two forms. An Oracle data block may contain an invalid header or the contents of the block could be logically inconsistent. In both the above cases, you might face terrible loss of information, including application and user data, Oracle control information, etc. Oracle provides you a comprehensive list of solutions to deal with such instances. You can configure different parameters ('DB_BLOCK_CHECKING', 'DB_BLOCK_CHECKSUM', etc.) on your database to detect corruption. The Oracle Recovery Manager (RMAN) enables you to implement a database backup and recovery plan. However, if these methods fail to work, you can use third-party Oracle recovery software to recover your lost or damaged database objects.
For instance, when you start Oracle, you may receive the following error:
'ORA-01092: ORACLE Instance terminated. Disconnected forced'
If you examine your alert log at this stage, you may encounter a few more errors:
'ORA-01578: ORACLE data block corrupted (file # 1, block # 57371)'
Or
'ORA-01110: data file 1: 'G:\ORACLE\PRODUCT\10.1.0\ORADATA\HRDEV\SYSTEM01.DBF''
The error reveals occurrence of a possible block corruption in your Oracle database that has resulted in an unexpected shutdown of the Oracle instance. This is generally caused due to various factors, such as bad permissions, missing data files, or OS related issues, etc.
In order to confirm about block corruption, you should run the external command-line utility 'DB_VERIFY' on the suspected file. If the output shows errors in the same page locations, you can try to fix corruption using any of the given methods:

  • You can try to drop and recreate the damaged object, if you are not worried about data loss. You can get back all your lost data from the external sources. To identify which objects are corrupt, run the following query:

'select tablespace_name, segment_type, owner,
segment_name
from dba_extents
where file_id =
and between block_id AND block_id + blocks-1'
This query maps the physical file location to the corrupt objects.

  • Restoring data from backup is a more reliable way to get back everything stored in all good blocks inside the file.
  • You should leave 'DBMS_REPAIR' as the last resort to deal with block corruption. It can help you identify and repair corruption in your Oracle database.

If you again see the same errors on your database, you should take help of professional Oracle database recovery software. These tools efficiently repair corrupt DBF files to restore all damaged or inaccessible database objects, such as tables, views, procedures, triggers, functions, etc. They search for Oracle databases in your system and allow you perform a selective recovery of database components.

Popular posts from this blog

IT EMPLOYEE HEALTH ISSUES

An increasing number of IT professionals have been finding it difficult to handle emotional stress, according to experts. An ‘occupational hazard,' the stress related to work needs to be addressed without delay, they emphasise.

“Coping with stress and striving for mental health welfare should be a matter of concern for all and not treated simply as a lifestyle problem of the ‘IT phenomenon',” says Nithya Chandrasekaran, a consultant physician for many IT companies in the city. Post-recession, employees feel pressured to perform well.

Regular occupational problems such as wrist problems due to constant handling of the mouse, slip disc and eye fatigue are common now, but handling stress that arises owing to fear of losing job or to cope with the increasing competition, affects the employee's performance, eventually, taking a major toll on his health, doctors explain.

The project that K. Balajee (29) was handling was pulled off after six months of its inception. Currently ma…

Internet Safety Tips and Rules

Why is it important to stay safe online?

Most of us are ‘connected’ via our laptops, mobile phones, tablets or personal computer. The potential for the internet to be a valuable and a fun resource for entertainment, making friends, keeping in touch and learning is huge. But if you use the internet, you could be at risk of illegal activity or abuse - be it bullying, fraud or something more serious. Unlike seeing someone face to face, on the net, people aren't always what they first seem.

In the same way you learn about safety when you leave the house, it is important to learn how to stay safe online. These are skills that will stay with you for life.



Internet Safety Tips for Kids and Teens
1. Spend time having fun with your parents online and helping them understand technology!
2. Never post your personal information, such as a cell phone number, home number, home address, or your location on any social networking site or through mobile apps like Snapchat or Instagram.
3. Never me…

Cyber Crime

Cyber Crime is a fast-growing area of crime.More and more criminals are exploiting the speed, convenience and anonymity of the Internet to commit a diverse range of criminal activities that know no borders, either physical or virtual, cause serious harm and pose very real threats to victims worldwide.

What is the Cyber Crime? Cyber crime encompasses any criminal act dealing with computers and networks (called hacking).  Additionally, cyber crime also includes traditional crimes conducted through the Internet.  For example; hate crimes, telemarketing and Internet fraud, identity theft, and credit card account thefts are considered to be cyber crimes when the illegal activities are committed through the use of a computer and the Internet.

Identity theft
Identity theft and fraud is one of the most common types of cyber crime. The term Identity Theft is used, when a person purports to be some other person, with a view to creating a fraud for financial gains. When this is done online on the…