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

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.

Hemant

At 06:59 AM 14-08-03 -0800, you wrote:
>Hemant
> 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
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
>
>
>-----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 : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).