OraFAQ Forum: Performance Tuning » redo files are on raid 5 ? why ?

Home » RDBMS Server » Performance Tuning » redo files are on raid 5 ? why ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

redo files are on raid 5 ? why ? [message #192875]

Thu, 14 September 2006 01:08

tridentadm
Messages: 142
Registered: March 2006

Senior Member

why is it recommended to have redo log files to be stored on raid 5 disk sets. ??

what is the benefit ??

Report message to a moderator

Re: redo files are on raid 5 ? why ? [message #192972 is a reply to message #192875]

Thu, 14 September 2006 07:32

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

The log files are very much importent part of the database. In case the database failes you can recover the database through log files. These redo log files will be archived based on you database is in archivelog mode.

For protecting or any point of time do not loss the data people will setup the database in raid control systems.

Thanks,

Mohan Reddy G

Report message to a moderator

Re: redo files are on raid 5 ? why ? [message #193015 is a reply to message #192875]

Thu, 14 September 2006 09:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Not sure where you saw the recommendation to use RAID 5 for redo logs??

The docs specifically state "Avoiding the use of RAID 5 for redo logs".

Report message to a moderator

Re: redo files are on raid 5 ? why ? [message #194068 is a reply to message #193015]

Wed, 20 September 2006 12:36

tridentadm
Messages: 142
Registered: March 2006

Senior Member

ebrian wrote on Thu, 14 September 2006 20:19

The docs specifically state "Avoiding the use of RAID 5 for redo logs".

really ???
can you tell me where exactly its mentioned.

i would definately like to have a look ..

thx,.

Report message to a moderator

Re: redo files are on raid 5 ? why ? [message #194069 is a reply to message #194068]

Wed, 20 September 2006 12:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/iodesign.htm#sthref720

Quote:

8.2.3.2 Redo Log Files
.....
Avoiding the use of RAID 5 for redo logs.

Report message to a moderator

Re: redo files are on raid 5 ? why ? [message #194076 is a reply to message #194069]

Wed, 20 September 2006 13:38

jburnham
Messages: 3
Registered: September 2006
Location: Connecticut

Junior Member

I think that is because redo logs are write-intensive and very sequential. If you have a drive (preferrably striped drives) dedicated, then the drive heads don't have to move around as much and can efficiently stream the redo logs to the disk.

Report message to a moderator

Previous Topic:	REPORT BASED ON 2 VIEWS
Next Topic:	data purging from database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 13:38:22 CST 2024