We help IT Professionals succeed at work.

Fix Corrupt Block

xoxomos
xoxomos asked
on
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?
Comment
Watch Question

Author

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

Author

Commented:
Backup from JUly 18 is cold backup of os files.
Chakravarthi AyyalaDatabase Administrator
CERTIFIED EXPERT
Commented:
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" ?
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
>>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.

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:17309849622925

Explore More ContentExplore courses, solutions, and other research materials related to this topic.