advise wanted for multi-terabytes filesystems

From: Rob De Langhe (rob.delanghe@telindus.be)
Date: Fri Apr 23 2004 - 03:16:37 EDT


Hi,
 
we have a pair of (Solaris-9) Oracle-servers connected via FCAL to EMC
storage, with RAID-5 LUNs from that storage array managed by Veritas Volume
Manager on the hosts.
 
On these LUNs, we have create filesystems to hold the Oracle files. One of
them, that contains the actual data-files, is mounted as "/oraAdb" with some
subdirectories for each database instance :
 
/oraAdb/instanceA
/oraAdb/instanceB
and so on
 
This filesystem is created using plain Solaris-command ("newfs -i 65536 -f
8192 /dev/vx/rdsk/..."), so no Veritas-Filesystem is used.
The option "logging" is used in "/etc/vfstab" to have it journalling its
changes.
 
Since our database will grow from (currently) 1 TB to approx 14 TB, I was
wondering how I should keep this stable : is it recommended/safe practice to
keep all the Oracle-DBF files on a single, therefor multi-terabyte
filesystem (mount on "/oraAdb") ?
What if the server crashes suddenly : is it sufficient/safe to have the
"logging" option so that a FSCK will not take days to complete ?
Are there any Solaris limits we will hit when growing this filesystem to is
max capacity ?
 
Or should we split the Oracle-DBF files over multiple -say 1TB capacity-
filesystems, and just add more of these filesystems ?
 
TIA for any suggestions and/or experiences.
 
Rob

Visit us at the Telecom cITy Fair - The largest IT Fair in Belgium!
25, 26, 27 May - Brussels Expo

Get your free tickets here!
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:28:31 EDT