Our redo log files reside in a directory on the NT server on which the database runs. This directory is backed up as part of our nightly server backups. Therefore, if this directory is wiped out for any reason, I can restore the redo log files from the nightly backup tape.
Originally posted by samdba
Now, my question is how to protect online Archive log files that are being generated on to the server? Currently, archive log files are generated on RAID-5 disk sets.
Suppose, something goes wrong with the hard drive or server, we will not have those archive log files that are created since last hot backup.
Having your archived log files on RAID5 is what is going to protect them from disk failure. Sure, if 2 drives in the RAID5 set die, you're screwed, but you have to weigh the costs of mirroring everything vs. the liklihood 2 drives will fail at the same time.