简言之:
1 控制文件放在 raid 5
2 在线重做日志文件、归档文件、临时文件放在 raid 1
3 数据文件放在 raid 0 1
参考:i/o tuning with different raid configurations [id 30286.1]
swap space can be used on raid devices without affecting oracle.
====================================================================================
raid type of raid control database redo log archive log
file file file file
====================================================================================
0 striping avoid* ok* avoid* avoid*
------------------------------------------------------------------------------------
1 shadowing ok ok recommended recommended
------------------------------------------------------------------------------------
0 1 striping ok recommended ok avoid
shadowing (1)
------------------------------------------------------------------------------------
3 striping with ok avoid avoid avoid
static parity (2)
------------------------------------------------------------------------------------
5 striping with ok avoid avoid avoid
rotating parity (2)
------------------------------------------------------------------------------------
* raid 0 does not provide any protection against failures. it requires a strong backup
strategy.
(1) 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.
(2) when heavy write operation involves this datafile
阅读(2393) | 评论(0) | 转发(0) |