Oracle on Raw device informations

[sumit]

Guys any informations please!!

[tamilselvan]

Question:
Is that possible? I mean on an existing database, on unix file
system, can I create another instance on Raw device?

Ans: Yes, it is possible.

2. Once the divoce will be ready, I would like to create a database running oracle 9i database creation script. ( create database ...)

Question: Is there any change required for those scripts?

Ans: No change is required.

3. I have to create few Locally managed tablespace on that new instance.

Question: Any changes to create those tablespaces?
Ans: No change is needed.

4. I will take few exports for unix file system database and import the same to Raw device instance.

Question: Any issue on that?
Ans : No issue.

5. I might add few more disks later.

Question: Any issue to add few more raw devices in future when database in oroduction.

Ans: You are not going to add the disks, the vendor who supplied the disks is going to add new disks. Don't worry.

DO NOT WORRY ABOUT RAW DEVICES. The only diff is: raw device is precreated. You get the name before even you create tablespace. Just attach those names to tablespace.

Tamil

Tamil

[hacketta1]

I recently became a raw device newbie, and thought I'd add the following:

You better have your storage planning/forecasting nailed. No resizing of a raw device like a cooked file system datafile.

I'm sure this is correct if you're not using a logical volume manager and this is what stmongo was talking about. But, if you are using an LVM you can probably resize a raw logical volume on the fly and then resize the datafile. I do this on HP-UX all the time. You might want to find out if this is possible in your set-up as it'll make life much easier. Appreciate you weren't asking about this, but thought it'd be useful to know if you weren't already aware of this.

Austin