Fix Corrupt Block

Posted on 2012-08-16
Medium Priority
Last Modified: 2012-08-17
Looking at my OEM i see there is a corrupt block, datafile 17, block 7 from July 29.  I have a backup from July 18 and archive logs from then until now.  How do I proceed getting rid of the corrupt block?
Question by:xoxomos
  • 2

Author Comment

ID: 38302952
We only keep 1 day of RMAN backup so that would be backup of data as it was yesterday.

Author Comment

ID: 38302953
Backup from JUly 18 is cold backup of os files.

Assisted Solution

by:Chakravarthi Ayyala
Chakravarthi Ayyala earned 600 total points
ID: 38303125
What is the version of this database?
Do you try to check whether the corrupted block belongs to a table or index?
If it is table, did you try "analyze table ... validate structure" ?
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 600 total points
ID: 38304516
>>We only keep 1 day of RMAN backup

I hope this event makes you reevaluate your backup/recovery plan?

To help fix your corruption I would contact Oracle Support.  They would be able to help you recover if possible.

There is a good thread on block corruption on asktom.  There is a lot of information in there on how to locate what is corrupt.  You might get lucky and it is on an index or a table that you can easily recover from.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month14 days, 13 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question