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…

Hide Files or Folders Using Command Prompt

Hide Files or Folders Using Command Prompt This is my second instructable. This one is totally different from my previous post...
In this esteemed instructable i'll be guiding you to hide a folder by using cmd.. Even the folder option method won't be able to track the hidden folder

You'll need
1. Windows based operating system
Step 1: Run Command Prompt and Basic Text Commands There are several methods to run cmd.. Some of them are listed below

1. Start -> Run -> Cmd
2. Starrt -> Program Files -> Accessories - > Command Prompt

Command Prompt is a newer version of Dos and other os similar to that.. In order to fulfill your needs to hide a folder you must atleast know some basic commands ...

Cd - navigates through a folder
Md - creates a folder
Dir - Directory list
Attrib - provides with various attrib features
Step 2: Hide d targeted folder Alright, it's time to hide the folder

Presuming that I have a folder named Secret in F:\ Drive
Here are the steps to do

First of all n…

Computer Server

Server A server is a computer that provides data to other computers. It may serve data to systems on a local area network (LAN) or a wide area network (WAN) over the Internet.

Many types of servers exist, including web servers, mail servers, and file servers. Each type runs software specific to the purpose of the server. For example, a Web server may run Apache HTTP Server or Microsoft IIS, which both provide access to websites over the Internet. A mail server may run a program like Exim or iMail, which provides SMTP services for sending and receiving email. A file server might use Samba or the operating system's built-in file sharing services to share files over a network.

While server software is specific to the type of server, the hardware is not as important. In fact, a regular desktop computers can be turned into a server by adding the appropriate software. For example, a computer connected to a home network can be designated as a file server, print server, or …