Register now or log in to join your professional community.
I would like to know recommendations from Senior storage/system administrators and expert DBAs especially. Thanks in advance for your serious comments.
Rizwan, to begin with, I would not recommend you to go with Oracle10g. Oracle is about to discontinue support of this version. Either go with Oracle11g R2 or12c R2, since R2 of12c is not available yet, but might be available soon enough.
In the newer versions, Oracle is heavily relieng on the use of ASM for storage. In fact, since the introduction of Grid Infrastructure in11g, even the voting and OCR devices are placed on ASM. With my personal experience, ASM is very stable and robust. In one scenario when I had to migrate from one SAN device to another, it was a seamless process, like plug and play.
I recommend that you implement onG as it is more reliable to run the new Grid infrastructure platform.
Don't go with10 G. Also the11g version11.2.0.1 is very buggy. Go with the very latest CRS version . You can run database of an older release but keep your CRS at the latest version. Oracle will no longer support10G CRS.
Also use only ASM as RAW file system is not supported on RAC by Oracle. If any problem comes in production environment pertaining to RAW, Oracle support will simply ask you to upgrade to ASM.
For ASM configuration, if you have oracle support access, give the search "ASM Master Note" in this you will find lot of best practice documents for RAC written by Oracle Experts.
Also follow best practice document for RAC setup on which ever platform that you are using.
For performance you can enable Jumbo Frames on your platform.
Raise a call to Oracle Support and verify with them that the platform, O.S combination on which you want to install RAC is certified by Oracle or not.
Hi, If you go for ASM - "Data" disks can be further distributed to control files, redo files, system and sysaux tablespaces and also datafiles, etc. for further redundancy. Mount points for storage has to be on "udev" mapping if you plan your OS is unix.
What is your Underlaying Storage System you currently use (i.e. SAN, NAS )
But in general you should have redundant (more than one) row disks for your voting & ocr disks.
for the data and FRA storage you better use ASM disks, redundancy is always prefered.
Disk sizes for Data, Archivelogs, FRA is totally dependant on your expected database size and future growth.
Hope this info is of some use. :-)
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.