Thursday, March 7, 2013

Avoid Backup Database with corrupted Archivelog


Corrupt block seq: 34229 blocknum=1.
Bad header found during deleting archived log
Data in bad block - seq:0. bno:0. time:0
beg:0 cks:0
calculated check value: 0

No need for Oracle DBA to tell you there's corruption , usually this error indicate that archivelog is corrupted in our case Archivelog number 34229.

To Solve this problem :

1- Check Validate for this archivelog
 RMAN> validate archvielog sequence 34229;
 2 - Now to avoid this error , you should delete archivelog on Os level.
3 -
RMAN > crosscheck archivelog all;
DELETE EXPIRED ARCHIVELOG sequence 34229;
Then Backup database.

 Thank you
Osama Mustafa

1 comment:

  1. Hi I used recover iphone contacts , photos,SMS, Contacts & More Files Lost from iPhone 4S/5 with a simple way. For the tips here rightly explain how to recover iphone deleted text messages with a helpful.
    Successful business

    ReplyDelete