Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
Thanks again for the help.
As I indicated in the original posting, the create database script worked on raw devices if controlled by the AIX LVM. BUT, for some reason is not doing this if I use Raw devices controlled by the Vertias VM (vxvm).
Question:
The database that you built a month ago with AIX was
it using the Veritas raw devices instead of the AIX raw devices?
(I only get it to work with Veritas if I play a trick, the hard way,
by renaming the database files to the veritas raw devices,
alter database rename datafile '/../../system01.dbf' to
'/dev/vx/rdsk/oradg/system01'
but this should not be the case)
Thanks in advance,
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1063634151.940389_at_yasure...
> A. Fuentes wrote:
>
> >Daniel,
> >
> >Thanks for your reply.
> >
> >Actually, /dev/vx/rdsk/oradg/system1, /dev/vx/rdsk/oradg/log1,
> >/dev/vx/rdsk/oradg/log2,
> >etc are SEPARATE volumes!. system1, log1, log2, etc are the names of the
> >volumes
> >(Not the names of the files to be loaded in the volume or partition).
oradg
> >is the Veritas
> >disk group.
> >
> >So all the issues of the original posting still aply.
> >
> >
> >
> I built an AIX 5L database a month ago on raw devices. Here's an edited
> version of my create script that may help.
>
> CREATE DATABASE xxx
> MAXINSTANCES 1
> MAXLOGHISTORY 1
> MAXLOGFILES 5
> MAXLOGMEMBERS 3
> MAXDATAFILES 100
> CHARACTER SET UTF8
> NATIONAL CHARACTER SET UTF8
> DATAFILE '/opt/oracle/diskmap/system-disk1/' SIZE 300M
> AUTOEXTEND ON NEXT 10240K MAX SIZE UNLIMITED
> DEFAULT TEMPORARY TABLESPACE "TEMP"
> TEMPFILE '/opt/oracle/diskmap/temp-disk2/' SIZE 10240M
> AUTOEXTEND OFF
> UNDO TABLESPACE "UNDOTBS1"
> DATAFILE '/opt/oracle/dismap/undo1-disk3/' SIZE 16777200K -- esential
> sizing for a 16GB raw partition
> AUTOEXTEND OFF
> LOGFILE
> GROUP 1 ('/opt/oracle/diskmap/log1a-disk20/'
> '/opt/oracle/diskmap/log1b-disk21/') SIZE 10240M,
> GROUP 1 ('/opt/oracle/diskmap/log1c-disk22/'
> '/opt/oracle/diskmap/log1d-disk23/') SIZE 10240M;
>
> And be sure to use STARTUP NOMOUNT before executing the script.
>
> HTH
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Sep 15 2003 - 20:17:53 CDT