- Apache, PHP7 and Oracle 19c
- Oracle 19c Windows 64-bit Client Installation
- Oracle 19c Database Product Installation
- Oracle 19c GI Cluster Installation
Database Best Practice
There are some misconceptions with modern ASM. One huge one is mirroring is required.
Otherwise you can rely on your hardware SAN for mirroring. This both simplifies your ASM architecture and provides the optimal performance to ASM as a RAID type solution.
Here is what the 19c Oracle docs say on this:
Oracle ASM mirroring runs on the database server and Oracle recommends to off load this processing to the storage hardware RAID controller by using external redundancy .
Source of above here
Another misconception is that ASM mirroring will help you survive all disk issues. Nope! Do not rely on ASM exclusively for this. I have seen instances first hand where a vendor changed OS level properties and ALL the ASM disks were instantly corrupted requiring a complete RAC re-installation. Luckily I had a recent full database export and RMAN backup. ;-)