Re: how to make redologs and RBSes on raw volumes?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 25 Jan 2000 20:48:07 +0800
Message-ID: <388D9B87.E27@yahoo.com>

chrisoc_at_ans.net wrote:
>
> I am new to raw volumes with Oracle. But I am lucky
> enough to have a large EMC disk subsystem on a big
> Sun server that has several 2 GB "slices" available
> and chowned to oracle.dba
>
> I have used a few of them already for large data warehouse
> tablespaces. How would I get redo log groups and
> rollback segments into some of these avalable and unused
> slices?
> I only know the syntax for cooked files, when you can give
> the size in MB and the filename you want.
>
> I cannot find this in my books. Each 2 GB slice of a larger
> disk is linked to a name under '/dev/rdsk' and I could
> of course get the whole thing allocated to an Oracle tablespace
> this way. But how to get a filespec or datafile-type name
> within that allocation has me headscratching.
>
> Chris O'Connor
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Same for log files...

alter database add logfile 'raw_device_name' size XXmb.

(slightly different syntax for log groups)

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jan 25 2000 - 06:48:07 CST