如何使用raw device构建Oracle数据库

• 数据库
• 构建
• 使用
• 如何
• Linux
• ln
• -s
• 文件
• or

1.分区

Device Boot Start End Blocks Id System

/dev/sde1 1 63 506016 83 Linux

/dev/sde2 64 126 506047+ 83 Linux

/dev/sde3 127 189 506047+ 83 Linux

/dev/sde4 190 1305 8964270 5 Extended

/dev/sde5 190 688 4008186 83 Linux

/dev/sde6 689 813 1004031 83 Linux

/dev/sde7 814 838 200781 83 Linux

/dev/sde8 839 854 128488+ 83 Linux

/dev/sde9 855 870 128488+ 83 Linux

/dev/sde10 871 886 128488+ 83 Linux

/dev/sde11 887 899 104391 83 Linux

/dev/sde12 900 912 104391 83 Linux

/dev/sde13 913 914 16033+ 83 Linux

/dev/sde14 915 916 16033+ 83 Linux

/dev/sde15 917 1305 3124611 83 Linux

2.写raw : vi /etc/sysconfig/rawdevices

/dev/raw/raw1 /dev/sde1

/dev/raw/raw2 /dev/sde2

/dev/raw/raw3 /dev/sde3

/dev/raw/raw4 /dev/sde5

/dev/raw/raw5 /dev/sde6

/dev/raw/raw6 /dev/sde7

/dev/raw/raw7 /dev/sde8

/dev/raw/raw8 /dev/sde9

/dev/raw/raw9 /dev/sde10

/dev/raw/raw10 /dev/sde11

/dev/raw/raw11 /dev/sde12

/dev/raw/raw12 /dev/sde13

/dev/raw/raw13 /dev/sde14

/dev/raw/raw14 /dev/sde15

# service rawdevices restart

3.连接文件

ln -s /dev/raw/raw1 /oracle/oradata/orcl/orcl_system_raw_512m

ln -s /dev/raw/raw2 /oracle/oradata/orcl/orcl_sysaux_raw_512m

ln -s /dev/raw/raw3 /oracle/oradata/orcl/orcl_undotbs_raw_512m

ln -s /dev/raw/raw4 /oracle/oradata/orcl/orcl_data1_raw_4096m

ln -s /dev/raw/raw5 /oracle/oradata/orcl/orcl_temp_raw_1024m

ln -s /dev/raw/raw6 /oracle/oradata/orcl/orcl_user_raw_200m

ln -s /dev/raw/raw7 /oracle/oradata/orcl/orcl_redo1_raw_120m

ln -s /dev/raw/raw8 /oracle/oradata/orcl/orcl_redo2_raw_120m

ln -s /dev/raw/raw9 /oracle/oradata/orcl/orcl_redo3_raw_120m

ln -s /dev/raw/raw10 /oracle/oradata/orcl/orcl_control1_raw_100m

ln -s /dev/raw/raw11 /oracle/oradata/orcl/orcl_control2_raw_100m

ln -s /dev/raw/raw12 /oracle/oradata/orcl/orcl_spfile_raw_5m

ln -s /dev/raw/raw13 /oracle/oradata/orcl/orcl_pwdfile_raw_5m

ln -s /dev/raw/raw14 /oracle/oradata/orcl/orcl_data2_raw_3000m

4.写RAW方式安装配置文件 vi orcl_raw.conf

system = /oracle/oradata/orcl/orcl_system_raw_512m

sysaux = /oracle/oradata/orcl/orcl_sysaux_raw_512m

undotbs1= /oracle/oradata/orcl/orcl_undotbs_raw_512m

data = /oracle/oradata/orcl/orcl_data1_raw_4096m

temp = /oracle/oradata/orcl/orcl_temp_raw_1024m

users = /oracle/oradata/orcl/orcl_user_raw_200m

redo1_1 = /oracle/oradata/orcl/orcl_redo1_raw_120m

redo1_2 = /oracle/oradata/orcl/orcl_redo2_raw_120m

redo1_3 = /oracle/oradata/orcl/orcl_redo3_raw_120m

control1= /oracle/oradata/orcl/orcl_control1_raw_100m

control2= /oracle/oradata/orcl/orcl_control2_raw_100m

spfile = /oracle/oradata/orcl/orcl_spfile_raw_5m

pwdfile = /oracle/oradata/orcl/orcl_pwdfile_raw_5m

5.dbca建库

注意：大家需要配置orcl_raw.conf文件，选文件系统时，选择orcl_raw.conf就可以了，此时dbca才可以使用对应的raw device。