ORACLE RAC--裸设备的创建配置
<P><BR> 裸设备 </P><P> </P>
<P> 裸设备,也叫裸分区(原始分区),是一种没有经过格式化,不被Unix通过文件系统来读取的非凡字符设备。 <BR> 它由应用程序负责对它进行读写操作。不经过文件系统的缓冲。</P>
<P> </P>
<P> 我们可以将oracle得表空间直接建立在裸设备上,提高读写速度</P>
<P> create tablespace sale_ts datafile '/dev/raw/raw1' <BR> size 20000m <BR> autoextend on next 100m maxsize unlimited <BR> extent management local <BR> segment space management auto;</P>
<P><BR>1.#/sbin/fdisk /dev/sdb <BR> 50M <BR>ora1,partprobe --立即生效 <BR> <BR>2.#vi /etc/sysconfig/rawdevices --编辑文件,建立映射 <BR> /dev/raw/raw1 /dev/sdb1 <BR>#/etc/init.d/rawdevices restart --重启服务(redhat 5之前的版本) <BR> <BR>or <BR> <BR>3.#raw /dev/raw/raw1 /dev/sdb1 <BR> 保存在/etc/rc.local中,重启后还会生效 <BR> <BR>or <BR>4. udev <BR>redhat5: <BR> vi /etc/udev/rules.d/60-raw.rules <BR> ACTION=="add", KERNEL=="sde", RUN+="/bin/raw /dev/raw/raw1 %N" <BR> ... <BR> vi /etc/rc.local (修改权限) <BR> reboot </P>
<P><BR> /etc/udev/rules.d/60-raw.rules <BR> 添加如下几句,其他的也可以类推 <BR> ACTION=="add", KERNEL=="xvdb1", RUN+="/bin/raw /dev/raw/raw1 %N" <BR> ACTION=="add", KERNEL=="xvdb2", RUN+="/bin/raw /dev/raw/raw2 %N" <BR> ACTION=="add", KERNEL=="raw*", WNER=="oracle", GROUP=="oinstall", MODE=="0664"</P>
<P><BR> </P>
<P><BR> create tablespace sale_ts datafile '/dev/sdb1' size 20m ; <BR> <BR> </P>
<P> 只要/dev/raw/raw1,/dev/sdb1是oracle.dba属主,以上写法都可以.</P>
<P> </P>
<P>SQL> select name from v$datafile <BR> 2 union all <BR> 3 select name from v$controlfile <BR> 4 union all <BR> 5 select name from v$tempfile;</P>
<P>NAME <BR>-------------------- <BR>/dev/raw/raw8 <BR>/dev/raw/raw10 <BR>/dev/raw/raw9 <BR>/dev/raw/raw12 <BR>/dev/raw/raw2 <BR>/dev/raw/raw3 <BR>/dev/raw/raw4 <BR>/dev/raw/raw11</P>
<P>8 rows selected.</P>
<P>SQL> select * from v$logfile;</P>
<P> GROUP# STATUS TYPE MEMBER IS_ <BR>---------- ---------- ------- -------------------- --- <BR> 3 STALE ONLINE /dev/raw/raw7 NO <BR> 2 ONLINE /dev/raw/raw6 NO <BR> 1 ONLINE /dev/raw/raw5 NO</P>
<P><BR>SQL> show parameter pfile</P>
<P>NAME TYPE VALUE <BR>------------------------------------ ----------- ------------------------------ <BR>spfile string /dev/raw/raw1</P>
页:
[1]