[筆記]Oracle與RAID
From Metalink.
====================================================================================
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 Avoid 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來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/6906/viewspace-21663/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- software RAID 筆記AI筆記
- Oracle筆記-最佳化策略與工具Oracle筆記
- oracle筆記Oracle筆記
- oracle 筆記Oracle筆記
- CUUG筆記 ORACLE索引學習筆記筆記Oracle索引
- raid與lunAI
- 讀書筆記-高階owi與oracle效能調整-oracle internal筆記Oracle
- 主動筆記與被動筆記筆記
- oracle 學習筆記 (ORACLE NET )Oracle筆記
- oracle 筆記(續1)Oracle筆記
- ORACLE dataguar 配置筆記Oracle筆記
- Secrets of the Oracle Database筆記OracleDatabase筆記
- 【筆記】oracle xml (一)筆記OracleXML
- oracle學習筆記Oracle筆記
- oracle雜燴筆記Oracle筆記
- Oracle 常用SQL筆記OracleSQL筆記
- [oracle零碎筆記]oracle零碎筆記(持續更新…)Oracle筆記
- oracle筆記整理11——效能調優之oracle等待事件與表關聯Oracle筆記事件
- Oracle DBA學習日記筆記Oracle筆記
- 讀書筆記-高階owi與oracle效能調整-io筆記Oracle
- 讀書筆記-高階owi與oracle效能調整-segment筆記Oracle
- 讀書筆記-高階owi與oracle效能調整-transaction筆記Oracle
- 《自由與文化》筆記筆記
- oracle學習筆記《一》Oracle筆記
- Oracle學習筆記2Oracle筆記
- Oracle效能調整筆記Oracle筆記
- 讀ORACLE升級筆記Oracle筆記
- Oracle學習筆記1Oracle筆記
- Oracle RAC效能管理(筆記)Oracle筆記
- oracle o52 筆記Oracle筆記
- ORACLE dataguard學習筆記Oracle筆記
- 【筆記】oracle 優化器筆記Oracle優化
- oracle健康巡檢筆記Oracle筆記
- Oracle FlashBack 學習筆記Oracle筆記
- Oracle Sql優化筆記OracleSQL優化筆記
- Effective Oracle by Design筆記Oracle筆記
- ORACLE學習筆記(zt)Oracle筆記
- Oracle筆記 之 索引(index)Oracle筆記索引Index