Redo logs are extremely write intensive, and high bandwidth storage such as SSD are ideas for relieving I/O bottlenecks. Also, online redo logs should always be multiplexed, and RAID1 provides few additional benefits.
RAID
|
Type of Raid
|
Control File
|
Database File
|
Redo Log File
|
Archive Log File
|
0
|
Striping
|
Avoid
|
OK
|
Avoid
|
Avoid
|
1
|
Shadowing
|
Best
|
OK
|
Best
|
Best
|
1+0
|
Striping and Shadowing
|
OK
|
Best
|
Avoid
|
Avoid
|
3
|
Striping with static parity
|
OK
|
OK
|
Avoid
|
Avoid
|
5
|
Striping with rotating parity
|
OK
|
Best if RAID0-1 not available
|
Avoid
|
Avoid
|
RAID Recommendations (From MOSC NOTE: 45635.1)
No comments:
Post a Comment