Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> re corrupted online redo logs and archivelogs -- was RE: PTC

re corrupted online redo logs and archivelogs -- was RE: PTC

From: Hemant K Chitale <>
Date: Thu, 14 Aug 2003 07:24:29 -0800
Message-ID: <>

Oh yes, do please inform people of the need to keep multiple backup sets ! I did see that the online redo log file and the last two archive logs plus two datafiles in the last online backup set were bad -- this happened as the I/O controller had "errors" while the Hot Backup to disk was running. These files hadn't yet gone to the tape as all I/O to the disk was "suspended".

I had to recover the database till the last good archive log.


At 06:59 AM 14-08-03 -0800, you wrote:
> Corrupted archivelogs. Interesting. Just yesterday I was trying to point
>out to someone on this list that having only weekly backups can leave you
>vulnerable to this sort of thing. Not that it is the end of the world, I've
>had production systems in that configuration, but the business users need to
>understand the vulnerability. I'm not sure if I was completely convincing.
>Dennis Williams
>Lifetouch, Inc.
> <>
>-----Original Message-----
>Sent: Thursday, August 14, 2003 12:44 AM
>To: Multiple recipients of list ORACLE-L
>I do have PTC Windchill running at my site.
>The first thing I did when the database was "handed over
>to IT Operations" was to switch to ARCHIVELOG.
>[A year later, we had some problem with the I/O controller
>which corrupted the online archivelog file and also
>some of the files in the HotBackup-to-Disk. I had
>to restore the database from the previous night's
>backup and reapply the archivelogs till the last good
>archivelog. Potentially, we lost some data !]

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is :

Please see the official ORACLE-L FAQ:
Author: Hemant K Chitale

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 14 2003 - 10:24:29 CDT

Original text of this message