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. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
