oracle g使用裸设备建实例

1、虽然oracle 11g已经发布了很多年了，不过世界主流的数据库仍然是10g。为什么？稳定。虽然11g以后已不支持裸设备这种存储了（自家ASM是王道），不过对于10g之前，尤其生产环境或RAC下，裸设备是首选，甚至是不二选择。具体裸设备的特点大家可以去百度下，这里我就不详细说下。当然不止oracle，其他的数据库，在非windows环境下，生产环境基本都是用裸设备的。I/O性能提高20-40%，设备成本低廉，性能效果明显。下面直接帖步骤：一、划分磁盘/dev/sba做linux及oracle软件的磁盘，另加一个/dev/sdb做裸设备。当然裸设备划分好之后，大小不能再变的。实例各个文件的大小划

2、分：Device Boot      Start         End      Blocks   Id  System/dev/sdb1               1      

3、60;    2       16033+  83  Linux/dev/sdb2               3           4       16065   8

4、3  Linux/dev/sdb3               5           6       16065   83  Linux/dev/sdb4        

5、0;      7        6527    52379932+   5  Extended/dev/sdb5               7          14 

6、0;     64228+  83  Linux/dev/sdb6              15          22       64228+  83  Linux/dev/sdb7    &#

7、160;         23          30       64228+  83  Linux/dev/sdb8              31      

8、60;  280     2008093+  83  Linux/dev/sdb9             281         530     2008093+  83  Linux/dev/sdb10    

9、60;       531         780     2008093+  83  Linux/dev/sdb11            781        1030    

10、 2008093+  83  Linux/dev/sdb12           1031        1280     2008093+  83  Linux/dev/sdb13           1281   &

11、#160;    1282       16033+  83  Linux/dev/sdb14           1283        6527    42130431   83  Linux二、为裸设备建立映射关系raw /dev/raw/raw1 /d

12、ev/sdb1raw /dev/raw/raw2 /dev/sdb2raw /dev/raw/raw3 /dev/sdb3raw /dev/raw/raw4 /dev/sdb5raw /dev/raw/raw5 /dev/sdb6raw /dev/raw/raw6 /dev/sdb7raw /dev/raw/raw7 /dev/sdb8raw /dev/raw/raw8 /dev/sdb9raw /dev/raw/raw9 /dev/sdb10raw /dev/raw/raw10 /dev/sdb11raw /dev/raw/raw11 /dev/sdb12raw /dev/raw/raw12

13、 /dev/sdb13raw /dev/raw/raw13 /dev/sdb14三、修改映射配制文件，防止重启无效vi /etc/sysconfig/rawdevices/dev/raw/raw1 /dev/sdb1/dev/raw/raw2 /dev/sdb2/dev/raw/raw3 /dev/sdb3/dev/raw/raw4 /dev/sdb5/dev/raw/raw5 /dev/sdb6/dev/raw/raw6 /dev/sdb7/dev/raw/raw7 /dev/sdb8/dev/raw/raw8 /dev/sdb9/dev/raw/raw9 /dev/sdb10/dev/ra

14、w/raw10 /dev/sdb11/dev/raw/raw11 /dev/sdb12/dev/raw/raw12 /dev/sdb13/dev/raw/raw13 /dev/sdb14vi /etc/udev/rules.d/60-raw.rulesACTION="add", KERNEL="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"ACTION="add", KERNEL="sdb2", RUN+="/bin/raw /dev/raw/raw2

15、%N"ACTION="add", KERNEL="sdb3", RUN+="/bin/raw /dev/raw/raw3 %N"ACTION="add", KERNEL="sdb5", RUN+="/bin/raw /dev/raw/raw4 %N"ACTION="add", KERNEL="sdb6", RUN+="/bin/raw /dev/raw/raw5 %N"ACTION="add&qu

16、ot;, KERNEL="sdb7", RUN+="/bin/raw /dev/raw/raw6 %N"ACTION="add", KERNEL="sdb8", RUN+="/bin/raw /dev/raw/raw7 %N"ACTION="add", KERNEL="sdb9", RUN+="/bin/raw /dev/raw/raw8 %N"ACTION="add", KERNEL="sdb10&quo

17、t;, RUN+="/bin/raw /dev/raw/raw9 %N"ACTION="add", KERNEL="sdb11", RUN+="/bin/raw /dev/raw/raw10 %N"ACTION="add", KERNEL="sdb12", RUN+="/bin/raw /dev/raw/raw11 %N"ACTION="add", KERNEL="sdb13", RUN+="/bin/ra

18、w /dev/raw/raw12 %N"ACTION="add", KERNEL="sdb14", RUN+="/bin/raw /dev/raw/raw13 %N"ACTION="add", KERNEL="raw*", WNER="oracle", GROUP="dba", MODE="0664"四、授权chmod 660 /dev/raw/raw1chown oracle:dba /dev/raw/raw1chmod 6

19、60 /dev/raw/raw2chown oracle:dba /dev/raw/raw2chmod 660 /dev/raw/raw3chown oracle:dba /dev/raw/raw3chmod 660 /dev/raw/raw4chown oracle:dba /dev/raw/raw4chmod 660 /dev/raw/raw5chown oracle:dba /dev/raw/raw5chmod 660 /dev/raw/raw6chown oracle:dba /dev/raw/raw6chmod 660 /dev/raw/raw7chown oracle:dba /d

20、ev/raw/raw7chmod 660 /dev/raw/raw8chown oracle:dba /dev/raw/raw8chmod 660 /dev/raw/raw9chown oracle:dba /dev/raw/raw9chmod 660 /dev/raw/raw10chown oracle:dba /dev/raw/raw10chmod 660 /dev/raw/raw11chown oracle:dba /dev/raw/raw11chmod 660 /dev/raw/raw12chown oracle:dba /dev/raw/raw12chmod 660 /dev/raw

21、/raw13chown oracle:dba /dev/raw/raw13五、建立链接关系ln -s /dev/raw/raw1 /u02/oradata/sm803/control01ln -s /dev/raw/raw2 /u02/oradata/sm803/control02ln -s /dev/raw/raw3 /u02/oradata/sm803/control03ln -s /dev/raw/raw4 /u02/oradata/sm803/redo01ln -s /dev/raw/raw5 /u02/oradata/sm803/redo02ln -s /dev/raw/raw6 /u02/oradata/sm803/redo03ln -s /dev/raw/raw7 /u02/oradata/sm803/systemln -s /dev/raw/raw8 /u02/oradata/sm803/sysauxln -s /dev/raw/raw9 /u02/oradata/sm803/undotbs1ln -s /dev/raw/raw10 /u02/oradata/sm803/templn -s /dev/raw/raw11 /u02/oradata/sm803/usersln -s /