Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please How can I verify corruption in an archivelog

RE: Please How can I verify corruption in an archivelog

From: Bobak, Mark <>
Date: Wed, 11 Oct 2006 14:38:53 -0400
Message-ID: <>

Not that I'm aware of, no.  

Way back when we were on Sequent Dynix/ptx (don't remember the Dynix/ptx version, but it was back in Oracle 8.0.5 days), we actually ran into a really bizarre bug that caused archive log corruption. So, every archive log generated needed to be validated. Our DBA at the time (I was but a lowly developer back then), set up a way to validate archive logs by creating a standby database, but with only the basic SYSTEM and UNDO tablespaces. You don't need a full copy of your source database, if you don't care about keeping instances in sync. So, he set up a minimal standby database, and as archive logs came off the primary, we applied them to the standby, to validate they were not corrupt. If one came up corrupt, we knew we were at risk and had to schedule another full backup ASAP. This went on for several weeks, until the bug was resolved.  

So, if you have a large or indefinite number of archive logs to validate, doing something like the above ought to work.  

If you're just talking about checking a single log, what I describe is probably not worth the effort to set up.  

Can you tell us more about your situation?  


PS Remember this fun time in your career, Riyaj?? ;-) And I know Kevin remembers this too, as he worked for Sequent at the time!  


Mark J. Bobak

Senior Oracle Architect

ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005  

[] On Behalf Of Juan Carlos Reyes Pacheco
Sent: Wednesday, October 11, 2006 12:36 PM To: Oracle-L Freelists
Subject: Please How can I verify corruption in an archivelog

Please, is there a utility to check the corruption in an archivelog file, I need to confirm that.  

Thank you.


Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

-- Received on Wed Oct 11 2006 - 13:38:53 CDT

Original text of this message