RAID != backup
It seems a lot of people, IT sysadmins in particular, have the attitude that because they have a RAID, they don't need to be quite so careful to keep their data backed up to off-line storage. In reality, it is quite the opposite. RAID's tend to be configured with drives from the same manufacturing batch, which means that when there is a drive failure, there are likely to be more than one drive going south for the winter. Bang! That was nice data while it lasted! :-(
So, after 30 years in the business of designing, building, and deploying large-scale enterprise critical systems for major manufacturers, my opinion is this.
1. Use RAID 5/10 for read-mostly performance. If you want write-mostly performance, go to the fastest devices you can find with the widest I/O channels and skip the RAID cruft.
2. Keep all critical data backed up on a regular (daily) basis.
3. Keep database transaction logs on devices apart from the actual data storage.
4. Make bit-image copies of system drives both before and after you do significant OS or application code updates/upgrades. If things go south with the system/boot devices, you can restore to the last known good configuration. If the update/upgrade fails, then you can revert to the image that existed just before you updated.
5. Plan for failure. Hardware fails. Software has bugs. This is life - live with it! But don't assume because something works today that it will work tomorrow.
I spent years designing and implementing the MES used to run most 300mm semiconductor fabs around the world. One of our major design elements was that the system be resilient to failure. NOT to be fault-tolerant, but fault-resilient. Provide means for automatic fail-over when software fails, computers fail, disc drives fail, controllers fail, networks fail. As a result, these systems run 24x365 with 6-sigma+ reliability. That's a bit less than 1 hour per year of unplanned down time (at 6-sigma reliability). FWIW, 1 hour of down time in a 300mm semiconductor fab is several million USD. So, let's just say that 6 sigma is not good enough... :-)