oracle 10g使用裸設(shè)備建實(shí)例

1、雖然oracle 11g已經(jīng)發(fā)布了很多年了，不過世界主流的數(shù)據(jù)庫(kù)仍然是10g。為什么？穩(wěn)定。雖然11g以后已不支持裸設(shè)備這種存儲(chǔ)了（自家ASM是王道），不過對(duì)于10g之前，尤其生產(chǎn)環(huán)境或RAC下，裸設(shè)備是首選，甚至是不二選擇。具體裸設(shè)備的特點(diǎn)大家可以去百度下，這里我就不詳細(xì)說下。當(dāng)然不止oracle，其他的數(shù)據(jù)庫(kù)，在非windows環(huán)境下，生產(chǎn)環(huán)境基本都是用裸設(shè)備的。I/O性能提高20-40%，設(shè)備成本低廉，性能效果明顯。下面直接帖步驟：一、劃分磁盤/dev/sba做linux及oracle軟件的磁盤，另加一個(gè)/dev/sdb做裸設(shè)備。當(dāng)然裸設(shè)備劃分好之后，大小不能再變的。實(shí)例各個(gè)文件的大小劃

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二、為裸設(shè)備建立映射關(guān)系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"四、授權(quán)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五、建立鏈接關(guān)系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 /