RE: Please How can I verify corruption in an archivelog
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <juancarlosreyesp@xxxxxxxxx>, "Oracle-L Freelists" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 11 Oct 2006 14:38:53 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
----------------------------------------
http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
10 years of experience from Oracle 7 to Oracle10g and developer 6i
Other related posts:
