Home » RDBMS Server » Performance Tuning » redo files are on raid 5 ? why ?
redo files are on raid 5 ? why ? [message #192875] Thu, 14 September 2006 01:08 Go to next message
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 ??
Re: redo files are on raid 5 ? why ? [message #192972 is a reply to message #192875] Thu, 14 September 2006 07:32 Go to previous messageGo to next message
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

Re: redo files are on raid 5 ? why ? [message #193015 is a reply to message #192875] Thu, 14 September 2006 09:49 Go to previous messageGo to next message
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".
Re: redo files are on raid 5 ? why ? [message #194068 is a reply to message #193015] Wed, 20 September 2006 12:36 Go to previous messageGo to next message
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,.

Re: redo files are on raid 5 ? why ? [message #194069 is a reply to message #194068] Wed, 20 September 2006 12:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

Re: redo files are on raid 5 ? why ? [message #194076 is a reply to message #194069] Wed, 20 September 2006 13:38 Go to previous message
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.
Previous Topic: REPORT BASED ON 2 VIEWS
Next Topic: data purging from database
Goto Forum:
  


Current Time: Sat Dec 10 10:52:08 CST 2016

Total time taken to generate the page: 0.09889 seconds