RAID

[Quoted] Hi there,

[Quoted] I am new on DBA stuff. I read DBA Handbook by Kevin Loney. It says that some database file should be at the different disks. My questions are:

[Quoted] [Quoted] 1). Does the 'different disks' here mean the different PHYSICAL disks? [Quoted] or just different logical volumes? Our company's old database put different database file in different logical volumes (not necessarily the different physical disks), I am wondering if that violates the OFA rules?

[Quoted] [Quoted] 2). My first thought of above question was 'physical disks'. It makes sense to me that if the two different tablespaces are at two different physical disks, the RW heads of two disks won't interfere each other, so the performance is improved. However, is this still true for RAID disks?

[Quoted] [Quoted] For example, I have five RAID5 hard disks u1~u5. I create DATA [Quoted] tablespace in u1, INDEX tablespace in u2. However, when data in DATA are stored into hard drive, it will be striped into different drives according to RAID. Same thing happens to INDEX data. In this case, won't the data in DATA and data in INDEX be mixed up? How can we dedicate the whole disk to DATA tablespace under RAID environment?

[Quoted] [Quoted] Thank you in advance! Have a nice day (night).

Brian Yan Received on Mon Oct 05 1998 - 00:00:00 CEST