How many control files on one volume?
Hello,
Another question has rissen in my mind:
We have a RAID5-SAN. There is only one huge volume where all data remains. Also the control files. When databases are created, Oracle creates 3 control files in the same directory. It doesn't matter where those files are, because when the volume fails, everything fails.
Question: Because we only have one volume, is it safe to only create two control files?
I ask this, because performance will decrease when the number of control files increase and vice versa.
Creating only one, would be best (performance wise), but I think that's a bit tricky!
A penny for your thoughts...
Re: How many control files on one volume?
Quote:
Originally posted by efrijters
Question: Because we only have one volume, is it safe to only create two control files?
Sure. However, I would put one copy of the control file on another disk even if it is local to the box.
Quote:
I ask this, because performance will decrease when the number of control files increase and vice versa. Creating only one, would be best (performance wise), but I think that's a bit tricky!
Is this a question or a statement? Any performance degradation (very little) is well worth the safety you get by putting another copy of your control file on another physical disk.
Quote:
A penny for your thoughts...
I accept paypal if that's convenient... ;)
Re: Re: How many control files on one volume?
Quote:
Is this a question or a statement? Any performance degradation (very little) is well worth the safety you get by putting another copy of your control file on another physical disk.
I've never heard of any performance degradation due to control files. The only thing that comes to my mind that would cause any degradation (if any) would be if you're using RMAN and storing RMAN's repository information in the control files. And, the only thing about that is your control files will get bigger.
Now mirroring Redo logs on a SAN enviornment now that's a different story. let the games begin.