Linux 5 下 oracle 裸设备

来源:互联网 发布:linux下安装oracle11g 编辑:程序博客网 时间:2024/05/16 08:35
Linux 下 oracle裸设备
一块物理盘或一个partition 都能创建一个 PV ,从而用于创建 VG
1、fdisk 创建了一个分区 /dev/sdb1
2、raw绑定
#raw /dev/raw/raw1 /dev/sdb1    //必须是 /dev/raw/rawX 的格式
3、绑定后生成一个文件/dev/raw/raw1 记录绑定的信息.如果不想要直接删除这个文件就行了.
在AS 4 中:
但是这个文件在os reboot之后就没有了.所以要把raw的信息记录到 /etc/sysconfig/rawdevices 文件中,
这样重启之后就能保留住raw的信息了.
格式:
/dev/raw/raw1 /dev/sdb1
在RHEL5中:
#vi /etc/udev/rules.d/60-raw.rules
# An example would be:
#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or (注意两个都要加,否则裸设备激活不了. 在RHEL5.2上,也激活不了。rhel5.3 没问题)
#   ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="2", RUN+="/bin/raw /dev/raw/raw2 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw1 %M %m"
ACTION=="add", KERNEL=="test/lvtest", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="test/lvtest1", RUN+="/bin/raw /dev/raw/raw2 %N"
######################
在系统中如果存在 AS4 中:/etc/sysconfig/rawdevices 格式的文件,那么可以用以下脚本生成上面格式。
#!/bin/sh
grep -v "^ *#" /etc/sysconfig/rawdevices | grep -v "^$" | while read dev major minor ; do
if [ -z "$minor" ]; then
   echo "ACTION==/"add/", KERNEL==/"${major##/dev/}/", RUN+=/"/usr/bin/raw $dev %N/""
else
   echo "ACTION==/"add/", ENV{MAJOR}==/"$major/", ENV{MINOR}==/"$minor/", RUN+=/"/usr/bin/raw $dev %M %m/""
fi
done

-------------------------------------------------------------------
oracle 中的裸设备的建立
1、对一个磁盘进行分区
#fdisk /dev/cciss/c0d0
作出一个分区 /dev/cciss/c0d0p8
2、创建一个PV
#pvcreate /dev/cciss/c0d0p8
3、创建一个VG
#vgcreate vgdata /dev/cciss/c0d0p8
4、创建一个LV
lvcreate -L 512M   -n systems_2g   vgdata
lvcreate -L 512M   -n users_512m   vgdata                
lvcreate -L 512M   -n temp_512m    vgdata
lvcreate -L 2048M -n undotbs1_2g vgdata
lvcreate -L 2048M -n undotbs2_2g vgdata
lvcreate -L 512M   -n cntrl1_512m vgdata
lvcreate -L 512M   -n cntrl2_512m vgdata
lvcreate -L 512M   -n cntrl3_512m vgdata
lvcreate -L 1024M -n log11_1g     vgdata
lvcreate -L 1024M -n log12_1g     vgdata
lvcreate -L 1024M -n log21_1g     vgdata
lvcreate -L 1024M -n log22_1g     vgdata
lvcreate -L 1024M -n log31_1g     vgdata
lvcreate -L 1024M -n log32_1g     vgdata
lvcreate -L 512M   -n spfile_512m vgdata
lvcreate -L 512M   -n indx_512m    vgdata
lvcreate -L 512M   -n tools_512m   vgdata
lvcreate -L 2048M -n sysaux_2g    vgdata
5、生成裸设备文件
raw /dev/raw/raw1    /dev/vgdata/systems_2g
raw /dev/raw/raw2    /dev/vgdata/users_512m
raw /dev/raw/raw3    /dev/vgdata/temp_512m
raw /dev/raw/raw4    /dev/vgdata/undotbs1_2g
raw /dev/raw/raw5    /dev/vgdata/undotbs2_2g
raw /dev/raw/raw6    /dev/vgdata/cntrl1_512m
raw /dev/raw/raw7    /dev/vgdata/cntrl2_512m
raw /dev/raw/raw8    /dev/vgdata/cntrl3_512m
raw /dev/raw/raw9    /dev/vgdata/log11_1g  
raw /dev/raw/raw10   /dev/vgdata/log12_1g  
raw /dev/raw/raw11   /dev/vgdata/log21_1g  
raw /dev/raw/raw12   /dev/vgdata/log22_1g  
raw /dev/raw/raw13   /dev/vgdata/log31_1g  
raw /dev/raw/raw14   /dev/vgdata/log32_1g  
raw /dev/raw/raw15   /dev/vgdata/spfile_512m
raw /dev/raw/raw16   /dev/vgdata/indx_512m
raw /dev/raw/raw17   /dev/vgdata/tools_512m
raw /dev/raw/raw18   /dev/vgdata/sysaux_2g
6、设置开机自动加载 裸设备
由于开机时,/dev/raw/rawX 就不存在,所以要通过 udevd damone (udevd -d 守护进程)
# vi /etc/udev/rules.d/60-raw.rules    (假如这种方法失效,那么5、生成裸设备文件 命令加到 rc.local 中执行)
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw1 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="2", RUN+="/bin/raw /dev/raw/raw2 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="3", RUN+="/bin/raw /dev/raw/raw3 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="4", RUN+="/bin/raw /dev/raw/raw4 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="5", RUN+="/bin/raw /dev/raw/raw5 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="6", RUN+="/bin/raw /dev/raw/raw6 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="7", RUN+="/bin/raw /dev/raw/raw7 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="8", RUN+="/bin/raw /dev/raw/raw8 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="9", RUN+="/bin/raw /dev/raw/raw9 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="10", RUN+="/bin/raw /dev/raw/raw10 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="11", RUN+="/bin/raw /dev/raw/raw11 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="12", RUN+="/bin/raw /dev/raw/raw12 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="13", RUN+="/bin/raw /dev/raw/raw13 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="14", RUN+="/bin/raw /dev/raw/raw14 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="15", RUN+="/bin/raw /dev/raw/raw15 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="16", RUN+="/bin/raw /dev/raw/raw16 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="17", RUN+="/bin/raw /dev/raw/raw17 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="18", RUN+="/bin/raw /dev/raw/raw18 %M %m"
ACTION=="add", KERNEL=="vgdata/systems_2g ", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="vgdata/users_512m", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="vgdata/temp_512m", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="vgdata/undotbs1_2g", RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="vgdata/undotbs2_2g", RUN+="/bin/raw /dev/raw/raw5 %N"
ACTION=="add", KERNEL=="vgdata/cntrl1_512m", RUN+="/bin/raw /dev/raw/raw6 %N"
ACTION=="add", KERNEL=="vgdata/cntrl2_512m", RUN+="/bin/raw /dev/raw/raw7 %N"
ACTION=="add", KERNEL=="vgdata/cntrl3_512m", RUN+="/bin/raw /dev/raw/raw8 %N"
ACTION=="add", KERNEL=="vgdata/log11_1g", RUN+="/bin/raw /dev/raw/raw9 %N"
ACTION=="add", KERNEL=="vgdata/log12_1g", RUN+="/bin/raw /dev/raw/raw10 %N"
ACTION=="add", KERNEL=="vgdata/log21_1g", RUN+="/bin/raw /dev/raw/raw11 %N"
ACTION=="add", KERNEL=="vgdata/log22_1g", RUN+="/bin/raw /dev/raw/raw12 %N"
ACTION=="add", KERNEL=="vgdata/log31_1g", RUN+="/bin/raw /dev/raw/raw13 %N"
ACTION=="add", KERNEL=="vgdata/log32_1g", RUN+="/bin/raw /dev/raw/raw14 %N"
ACTION=="add", KERNEL=="vgdata/spfile_512m", RUN+="/bin/raw /dev/raw/raw15 %N"
ACTION=="add", KERNEL=="vgdata/indx_512m", RUN+="/bin/raw /dev/raw/raw16 %N"
ACTION=="add", KERNEL=="vgdata/tools_512m", RUN+="/bin/raw /dev/raw/raw17 %N"
ACTION=="add", KERNEL=="vgdata/sysaux_2g ", RUN+="/bin/raw /dev/raw/raw18 %N"

7、#/etc/rc.local   启动文件修改
ln -s /dev/raw/raw1    /opt/oracle/oradata/hisdb/systems_2g
ln -s /dev/raw/raw2    /opt/oracle/oradata/hisdb/users_512m
ln -s /dev/raw/raw3    /opt/oracle/oradata/hisdb/temp_512m
ln -s /dev/raw/raw4    /opt/oracle/oradata/hisdb/undotbs1_2g
ln -s /dev/raw/raw5    /opt/oracle/oradata/hisdb/undotbs2_2g
ln -s /dev/raw/raw6    /opt/oracle/oradata/hisdb/cntrl1_512m
ln -s /dev/raw/raw7    /opt/oracle/oradata/hisdb/cntrl2_512m
ln -s /dev/raw/raw8    /opt/oracle/oradata/hisdb/cntrl3_512m
ln -s /dev/raw/raw9    /opt/oracle/oradata/hisdb/log11_1g  
ln -s /dev/raw/raw10   /opt/oracle/oradata/hisdb/log12_1g  
ln -s /dev/raw/raw11   /opt/oracle/oradata/hisdb/log21_1g  
ln -s /dev/raw/raw12   /opt/oracle/oradata/hisdb/log22_1g  
ln -s /dev/raw/raw13   /opt/oracle/oradata/hisdb/log31_1g  
ln -s /dev/raw/raw14   /opt/oracle/oradata/hisdb/log32_1g  
ln -s /dev/raw/raw15   /opt/oracle/oradata/hisdb/spfile_512m
ln -s /dev/raw/raw16   /opt/oracle/oradata/hisdb/indx_512m
ln -s /dev/raw/raw17   /opt/oracle/oradata/hisdb/tools_512m
ln -s /dev/raw/raw18   /opt/oracle/oradata/hisdb/sysaux_2g
chown oracle:dba /dev/raw/raw*
chown -R oracle:dba /dev/mapper
注意: 做完这些记得重启服务器验证rawdevices 是否加载成功
# raw -aq         是否输出 raw 信息
#ls -l /dev/raw/     是否存在,并且属主是否为oracle:oinstall
授权
chown -R oracle:dba /dev/mapper
修改配置文件/etc/udev/permissions.d/50-udev.permissions (但是发现系统里面没有这个文件,没办法做)
注释掉raw/*:root:disk:0660
添加新行raw/*:oracle:dba:0660

8、数据库建库前做一些相关修改
#vi .bash_profile 增加
#export DBCA_RAW_CONFIG=/home/oracle/raw.info
#vi /home/oracle/raw.info      建库的裸设备映射文件
system=/opt/oracle/oradata/hisdb/systems_2g
users=/opt/oracle/oradata/hisdb/users_512m
temp=/opt/oracle/oradata/hisdb/temp_512m
undotbs1=/opt/oracle/oradata/hisdb/undotbs1_2g
undotbs2=/opt/oracle/oradata/hisdb/undotbs2_2g
control1=/opt/oracle/oradata/hisdb/cntrl1_512m
control2=/opt/oracle/oradata/hisdb/cntrl2_512m
control3=/opt/oracle/oradata/hisdb/cntrl3_512m
redo1_1=/opt/oracle/oradata/hisdb/log11_1g  
redo1_2=/opt/oracle/oradata/hisdb/log12_1g  
redo2_1=/opt/oracle/oradata/hisdb/log21_1g  
redo2_2=/opt/oracle/oradata/hisdb/log22_1g  
redo3_1=/opt/oracle/oradata/hisdb/log31_1g  
redo3_2=/opt/oracle/oradata/hisdb/log32_1g  
spfile=/opt/oracle/oradata/hisdb/spfile_512m
indx=/opt/oracle/oradata/hisdb/indx_512m
tools=/opt/oracle/oradata/hisdb/tools_512m
sysaux=/opt/oracle/oradata/hisdb/sysaux_2g
原帖:http://hi.baidu.com/james_yulei/blog/item/ddc1e828b2916021d52af16b.html
原创粉丝点击