Re: Online creation/extension of Tablespaces possible??

Daniel Morgan wrote:

[snip]

> I mean't raw ... sorry about any poor choice of verbiage.
>
> And yes I've seen Oracle's slide show and it is not what I teach, it is
> not what Oracle system specialists on this continent advise, and is in
> my opinion preposterous.

If you're going to create a RAC database, you need two controlfiles, minimum. SYSTEM, two UNDO, TEMP and DATA, minimum. You need a *minimum* of 4 redo logs, assuming just a two-node RAC, times two because you multiplex them. You need an spfile. And you (probably) need a voting partition. That's 17 things to store, for the barest, simplest database with a minimum of multiplexing/safety features in just a two-node RAC.

If you aren't going to create 17 separate raw partitions to house that lot, I can't quite see how you're going to do it at all -short of implementing a cluster file system, obviously.

So it seems to me that a veritable plethora of raw partitions is an absolute *requirement* for a RAC on raw, not a preposterous configuration at all.  

> That said ... I don't see anything anywhere in my shop that has a 2GB
> limit other than Windows.

Bzzzt!! Well, that's a good 30% plus of the Oracle installed base, then, isn't it? (At least). Good convert to the Other Side though I may be, you can't just dismiss Windows like that. If it's true for Windows, it's true for a lot of people.

> I agree with sizing for backup/restore
> purposes.

Then we agree, which is the main thing.

> But who has anything in their data center that considers 2GB
> a size limit?

I'm not sure what that question means. I didn't mean to suggest that 2GB is an actual size limit. Merely that I would like to think of it as a *practical* limit in many circumstances. Of course, my opinion starts to change when your database starts nosing into the 100GB+ territory. But until then, 2GB is a sensible suggestion, I think.

Regards
HJR Received on Sun Sep 12 2004 - 14:08:57 CDT