|Bookshelf Home | Contents | Index | PDF|
Mirror the transaction log to guarantee database recovery if a single device fails. You must mirror the instance home directory, if resources are available. Hardware or operating system mirroring generally provides the best performance.
Also, when redo logs are mirrored at the RAID storage system level (usually RAID1 or RAID0+1), there is usually no need to mirror them at the Oracle level, since the RAID controller assures that these volumes can always be recovered. Mirroring at the RAID level usually improves database performance (especially beneficial for read operation).
If you have the resources, you should mirror the Oracle control files as well. Otherwise, you can put the Oracle control files into a RAID 5 device, as it is not heavily accessed and disk performance is not a concern. The information it records, though, is very critical for the Oracle database. Any updates to the control file—for example, the current System Change Number (SCN) or transaction tables—ripple across all members of the control file specification.
|Deployment Planning Guide|