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: Michael Fontana <>
Date: Wed, 11 Oct 2006 16:49:04 -0400
Message-ID: <>

 I would use RMAN to validate logs if running Oracle 9i or later.  

There is also away to assure validity of the logs at the time they are written with init.ora parameters, but if I know what you're getting at, you'd probably also like to assure
they are complete and valid after being archived. RMAN does a great job of this. In fact, you could have RMAN do the job without actually backing up the logs.    

I would review: ackp.htm#447612  

For more information on these techniques.    

[] On Behalf Of Daniel W. Fink
Sent: Wednesday, October 11, 2006 3:21 PM To: Oracle-L Freelists
Subject: Re: Please How can I verify corruption in an archivelog

It has been a few releases since I had to use the command...

ALTER SYSTEM DUMP LOGFILE 'filename'; will dump the contents of the named file (it can be an archived log). If I recall correctly, it reads each redo entry using the same code that is used for recovery. I have used it to validate logs and to demonstrate corruption due to a bug.

Dan Fink

Bobak, Mark wrote:

        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

	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
Received on Wed Oct 11 2006 - 15:49:04 CDT

Original text of this message