Merlin128 wrote:Is this stand-alone ASM? or RAC? If it is RAC, Then you must use something for SHARED STORAGE - like SAN. I am not a fan of RAC on Windows but that is your call. ASM works best when 1) you use the entire device, 2) you have MULTIPLE devices , 3) you adequately protect your data. With either of your proposals, you are playing Russian Roulette with a loaded and chambered 9mm. The outcome will not be pretty.
I've been told to remove the database ASM drives from our company SAN..
SAN has 3 ASM partitions:
TS (tablespaces) 420GB Used
FRA (Flashback Recovery / RMAN) 515GB Used
REDO (Redo Logs) 10GB Used
currently 945GB Total Used (system has been active 1 year)
anticipated growth over the next 7 years will total 5TB in ASM
I have purchased new servers to load the database on
These are Windows 2008 R2 with 8TB available storage after raid 5 array
I am considering
Windows C: drive with oracle install and expdp_export folder to be 3TB
ASM partition for Tablespaces (TS) to be 2.5TB
ASM partition for flash/RMAN/REDO (FRA) to be 2.5TB
my question is.. should I leave the two ASM partitions seperate..
or could I just use 1 ASM partion for everything: Tablespaces, Flash, RMAN, REDO