Hello Mario,
Wednesday, November 5, 2008, 7:25:06 PM, you wrote:
>
My co-workers and I are trying to find out if anyone out there is running
production Oracle on. We currently have a project in which we have a SAN
divided into 51 86.9GB luns (performance). Oracle has been setup on 18 or so
partitions and using SVM would be a logistical nightmare as far as management
goes.
Has anyone had any good dealings with Oracle on ZFS and, if so, what issues did
you run into.
I have deployed several Oracle databases on ZFS.
You need to do basic tuning, like matching ZFS''s recordsize to db_block
size in Oracle, disable cache flushes on zfs or configure a disk array to ignore
them,
disable atime updates, limit ARC size, disable vdev prefetch, etc. Basically I
tend to use standard set of tunables for Oracle on ZFS. You can find most of it
in ZFS Evil Tuning Guide.
It is useful to create a pool with several datasets for: archivelogs, redologs,
indexes, tablespaces, binaries.
The benefit is that you can set-up different recordsize for datasets containing
tablespaces and indexes.
The other useful thing is to regularly do hotbackups by utilizing zfs snapshots
and keep last one or last couple of them. Usually it''s very quick to
create a hotbackup that way (2-10s) and depending on the environment you could
do them on hourly basis for example. This is of course additional to any other
backup method like rman.
When I consolidate several Oracle databases on one box or a cluster I tend to
dedicate a separate pool to each Oracle instance - that way not only you keep
them more separated so they have less means to impact each other, it''s
easier to diagnose any problems but also you have an option to independently
fail over each instance in a cluster environment.
Disk/storage management with zfs is a pure joy :)
I haven''t deployed a production Oracle utilizing ZFS built-in
compression (yet) but I did it on test/dev platforms. Depending on your
environment it could ba beneficial to do so. I deployed other products like
LDAP, MySQL, etc. on ZFS using built-in compression to actually get better
performance.
ZFS is also very helpful for dev environments when you have several Oracle (and
other applications) each in its own Solaris zone, where each zone is on a
separate zfs dataset (with some sub-datasets). You can put all of them on one
zfs pool and then use quota, reservation to manage storage allocation - really
helpful.
--
Best regards,
Robert Milkowski mailto:milek@task.gda.pl
http://milek.blogspot.com
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss