Handling Online Redo Log Failures
I worked for a company that had just implemented an expensive database server with redundancy built into every component, or so I thought. The server was configured with RAID disks for all database files and the online redo log groups. The team was confident that there was minimal risk of failure with these disks.
Therefore, I decided not to multiplex the online redo log groups. A few days later, an inexpensive battery that maintained the cache for a disk controller failed. This caused corruption in the current online redo log group. As a result, the company lost data, experienced costly downtime, and ...