RE: Oracle's ASSM
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>
- Date: Tue, 13 Sep 2005 10:33:13 -0400
Niall,
OK, I asked a very general question and got some very general
answers. Not bad considering. Here are the specifics:
We're thinking of moving from dedicated database instances, with the
plethora of management problems associated therein to a couple of RAC
environments for fault tolerance (IE server failure) and load balancing
among the servers as the basics. Oracle is telling us that ASM or OMF
whichever you like is a mandatory part thereof. This poses a number of
problems. First of which is damanagement which wants a change control
form every time a data file does an auto extend. And a number of
tablespaces that we don not want extending because we put data therein
that is to be archived off to CDROM, consequently it's necessary for the
process loading these tablespaces to error out every once in a while.
Now I've never been an advocate of anything new that Oracle pops out of
the factory until it's had some filed experience, read that as Not in
it's first version. And I'm very skeptical of not knowing what is in
what tablespace, especially when a hot disk pops up. We've used
stripping and raid in the past with some really undesirable side
effects, like mass writes taking forever and having to add more devices
than we have to extend a mount point, and the resulting device additions
to all of our Business Continuation Volumes. Basically trying that
again is a definite no-no around here. True everyone says disk is
cheap, unless you don't have them available.
_____
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Tuesday, September 13, 2005 3:28 AM
To: Goulet, Dick
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle's ASSM
On 9/12/05, Goulet, Dick <DGoulet@xxxxxxxx> wrote:
Quick question, is anyone out there using Oracle's Automated
System
Storage Management software for production databases?
I think you mean ASM - Automatic Storage Management, not ASSM -
Automatic Segment Space Management. ASM is the one with a different
instance to manage physical storage of data. If you do mean this then
yes we are using it in RAC environment (10gSE so its mandated). Seems
to work reasonably well so far.
Not the
tablespace level stuff, but the create a mount point & let
Oracle decide
the file names, etc...
technically wouldn't that be Oracle Managed Files or OMF? You can do
this on a plain file system quite simply since (IIRC 9i Release 1).
I'm interested in knowing if your using it with
a single instance database or a RAC system or both.
See above.
Dick Goulet
Senior Oracle DBA
Oracle Certified DBA
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
