Oracle 8.1.7 and VA7410

[Katie Hadji]

Looking for recommendation on best practice using rp5400 and VA7410 (Oracle8.1.7.Financial System).
Number of mount points, configuration or any other info is greatly appreciated.

[Eugeny Brychkov]

Hello Katie,
regards from storage section of ITRC horum ;o)
For perfomance reason configure VA in AutoRAID mode with normal resilency and create LUNs so they take ~80% of available capacity in each Redundancy Group. Do not forget, when setting LVM paths, that LUNs within RG1 should have primary path through VA controller 1 but LUNs within RG2 through C2. And make sure everything in SAN in fabric login mode.
Sorry it's not exactly you wanted, but your question will be answered by Oracle skilled people
Eugeny

[Julio Yamawaki]

Hi,

We configured Oracle 8.1.7 with VA 7410 and segmented VA 7410 with many LUNs with 10 to 16 MB. We changed LV size to 8 MB. Also, we made a distributed LVM using -D option.
We use our DB in 8 kB blocks and we created a big LVOL with all datafiles inside.

[Steven E. Protter]

Data recommendations Oracle 8.1.7.4, works for other releases as well.

Data should be its own mountpoint preferably on its own disk if you have localdisk.

It should be Raid 10, if on disk array or Mirror/ux 1 to 1 mirror if local disk.

Have a nice sized area at least 25% as big as data for archive logs. Keep a backup of the control file there as well. If your transaction volume is higher, bump up the ratio.

Keep at least a Gigabyte for control files and logs.

Best Oracle practice involves two or three copies of control files.

If you can afford it RAID 10 works best.

Have the Oracle executables in a mountpoint away from the previously mentioned filesystems. They can share the same disk with other application executables on your system.

SEP

[mghosalk]

Steven,
Isnt it true that one cannot configure RAID 01 on a VA74xx

-Mandar