**************************************************************************
RAID Type of RAID Control Database Redo Log Archive
File File File log File
**************************************************************************
0 Striping Avoid* OK* Avoid* Avoid*
--------------------------------------------------------------------------------------
1 Shadowing OK OK Reco Reco
--------------------------------------------------------------------------------------
0+1 Striping +Shadowing OK Reco $ OK Avoid
--------------------------------------------------------------------------------------
3 Striping with OK Avoid & Avoid Avoid
Static Parity
--------------------------------------------------------------------------------------
5 Striping with OK Avoid & Avoid Avoid
Rotating Parity
--------------------------------------------------------------------------------------
* - RAID 0 does not provide any protection against failures. It requires a strong backup strategy.
$ - RAID 0+1 is recommended for database files because this avoids hot spots and gives the best possible performance during a disk failure. The disadvantage of RAID 0+1 is that it is a costly configuration.
& - When heavy write operation involves this datafile
Reco - Recommended
No comments:
Post a Comment