| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
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:
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmb ackp.htm#447612
For more information on these techniques.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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?
-Mark
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
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 anarchivelog file, I need to confirm that.
Thank you.
-- ---------------------------------------- http://www.oracleboliviaspecialists.com/ Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 10 years of experience from Oracle 7 to Oracle10g and developer6i
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 11 2006 - 15:49:04 CDT
 |
 |