oracle: 裸设备(raw device)的表空间

linux下模拟个裸设备添加个数据文件.

[root@test1 orcl11r2]# dd if=/dev/zero of=raw_datafile bs=1024k count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.141889 s, 739 MB/s
[root@test1 orcl11r2]# chown oracle.oinstall raw_datafile
[root@test1 orcl11r2]# losetup /dev/loop1 raw_datafile
[root@test1 orcl11r2]# raw /dev/raw/raw1 /dev/loop1
/dev/raw/raw1:  bound to major 7, minor 1
[root@test1 orcl11r2]# chown oracle.oinstall /dev/raw/raw1

添加裸设备的数据文件:

SQL> alter tablespace users add datafile '/dev/raw/raw1' size 98m autoextend off;
Tablespace altered.