注:本文只从配置裸设备讲起
1、fdisk /dev/sdb
n ---创建一个分区
p
fdisk /dev/sdb
t
2、创建一个pv
pvcreate /dev/sdb1
3、创建一个vg
vgcreate oradata /dev/sdb1
[root@db9i dev]# vgdisplay oradata
--- Volume group ---
VG Name oradata
System ID
Format lvm2
Metadata Areas 1
Metadata Sequence No 5
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 0
Open LV 0
Max PV 0
Cur PV 1
Act PV 1
VG Size 10.00 GB
PE Size 4.00 MB
Total PE 2559
Alloc PE / Size 0 / 0
Free PE / Size 2559 / 10.00 GB
VG UUID VYyq0M-ceMg-edUt-pgum-NKnT-4X8j-PNksv1
4、创建lv
lvcreate -L 8M -n lv_spfile oradata
lvcreate -L 20M -n lv_control01 oradata
lvcreate -L 20M -n lv_control02 oradata
lvcreate -L 50M -n lv_redo01 oradata
lvcreate -L 50M -n lv_redo02 oradata
lvcreate -L 50M -n lv_redo03 oradata
lvcreate -L 50M -n lv_redo04 oradata
lvcreate -L 500M -n lv_system01 oradata
lvcreate -L 500M -n lv_sysaux01 oradata
lvcreate -L 500M -n lv_users01 oradata
lvcreate -L 200M -n lv_undo01 oradata
lvcreate -L 200M -n lv_temp01 oradata
lvcreate -L 500M -n lv_cwmlite01 oradata
lvcreate -L 500M -n lv_drsys01 oradata
lvcreate -L 500M -n lv_example01 oradata
lvcreate -L 200M -n lv_indx01 oradata
lvcreate -L 200M -n lv_tools01 oradata
lvcreate -L 200M -n lv_xdb01 oradata
lvcreate -L 200M -n lv_odm01 oradata
5、创建裸设备
raw /dev/raw/raw1 /dev/oradata/lv_spfile
raw /dev/raw/raw2 /dev/oradata/lv_control01
raw /dev/raw/raw3 /dev/oradata/lv_control02
raw /dev/raw/raw4 /dev/oradata/lv_redo01
raw /dev/raw/raw5 /dev/oradata/lv_redo02
raw /dev/raw/raw6 /dev/oradata/lv_redo03
raw /dev/raw/raw7 /dev/oradata/lv_redo04
raw /dev/raw/raw8 /dev/oradata/lv_system01
raw /dev/raw/raw9 /dev/oradata/lv_sysaux01
raw /dev/raw/raw10 /dev/oradata/lv_users01
raw /dev/raw/raw11 /dev/oradata/lv_undo01
raw /dev/raw/raw12 /dev/oradata/lv_temp01
raw /dev/raw/raw13 /dev/oradata/lv_cwmlite01
raw /dev/raw/raw14 /dev/oradata/lv_drsys01
raw /dev/raw/raw15 /dev/oradata/lv_example01
raw /dev/raw/raw16 /dev/oradata/lv_indx01
raw /dev/raw/raw17 /dev/oradata/lv_tools01
raw /dev/raw/raw18 /dev/oradata/lv_xdb01
raw /dev/raw/raw19 /dev/oradata/lv_odm01
6、修改裸设备权限(注意!改后一定记着ls -l看一下)
cd /dev/raw/
chown oracle:oinstall *
chown 775 *
chown 775 /dev/raw/
chown oracle:oinstall /dev/raw/
7、将裸设备映射写入配置文件
vi /etc/sysconfig/rawdevices
/dev/raw/raw1 /dev/oradata/lv_spfile
/dev/raw/raw2 /dev/oradata/lv_control01
/dev/raw/raw3 /dev/oradata/lv_control02
/dev/raw/raw4 /dev/oradata/lv_redo01
/dev/raw/raw5 /dev/oradata/lv_redo02
/dev/raw/raw6 /dev/oradata/lv_redo03
/dev/raw/raw7 /dev/oradata/lv_redo04
/dev/raw/raw8 /dev/oradata/lv_system01
/dev/raw/raw9 /dev/oradata/lv_sysaux01
/dev/raw/raw10 /dev/oradata/lv_users01
/dev/raw/raw11 /dev/oradata/lv_undo01
/dev/raw/raw12 /dev/oradata/lv_temp01
/dev/raw/raw13 /dev/oradata/lv_cwmlite01
/dev/raw/raw14 /dev/oradata/lv_drsys01
/dev/raw/raw15 /dev/oradata/lv_example01
/dev/raw/raw16 /dev/oradata/lv_indx01
/dev/raw/raw17 /dev/oradata/lv_tools01
/dev/raw/raw18 /dev/oradata/lv_xdb01
/dev/raw/raw19 /dev/oradata/lv_odm01
8、创建数据文件存放目录
mkdir -p /oracle/oradata/rawdb/
chown -R oracle:oinstall /oracle/
chmod -R 775 /oracle/
chown oracle:oinstall /oracle
chmod 775 /oracle
9、使用oracle用户创建裸设备连接
ln -s /dev/raw/raw1 /oracle/oradata/rawdb/spfile
ln -s /dev/raw/raw2 /oracle/oradata/rawdb/control01.ctl
ln -s /dev/raw/raw3 /oracle/oradata/rawdb/control02.ctl
ln -s /dev/raw/raw4 /oracle/oradata/rawdb/redo01.log
ln -s /dev/raw/raw5 /oracle/oradata/rawdb/redo02.log
ln -s /dev/raw/raw6 /oracle/oradata/rawdb/redo03.log
ln -s /dev/raw/raw7 /oracle/oradata/rawdb/redo04.log
ln -s /dev/raw/raw8 /oracle/oradata/rawdb/system01.dbf
ln -s /dev/raw/raw9 /oracle/oradata/rawdb/sysaux01.dbf
ln -s /dev/raw/raw10 /oracle/oradata/rawdb/users01.dbf
ln -s /dev/raw/raw11 /oracle/oradata/rawdb/undo01.dbf
ln -s /dev/raw/raw12 /oracle/oradata/rawdb/temp01.dbf
ln -s /dev/raw/raw13 /oracle/oradata/rawdb/cwmlite01.dbf
ln -s /dev/raw/raw14 /oracle/oradata/rawdb/drsys01.dbf
ln -s /dev/raw/raw15 /oracle/oradata/rawdb/example01.dbf
ln -s /dev/raw/raw16 /oracle/oradata/rawdb/indx01.dbf
ln -s /dev/raw/raw17 /oracle/oradata/rawdb/tools01.dbf
ln -s /dev/raw/raw18 /oracle/oradata/rawdb/xdb01.dbf
ln -s /dev/raw/raw19 /oracle/oradata/rawdb/odm01.dbf
10、编写oracle使用裸设备的参数文件DBCA_RAW_CONFIG.txt
spfile=/oracle/oradata/rawdb/spfile
control01=/oracle/oradata/rawdb/control01.ctl
control02=/oracle/oradata/rawdb/control02.ctl
redo1_1=/oracle/oradata/rawdb/redo01.log
redo2_1=/oracle/oradata/rawdb/redo02.log
redo3_1=/oracle/oradata/rawdb/redo03.log
redo4_1=/oracle/oradata/rawdb/redo04.log
system=/oracle/oradata/rawdb/system01.dbf
sysaux=/oracle/oradata/rawdb/sysaux01.dbf
users=/oracle/oradata/rawdb/users01.dbf
undotbs1=/oracle/oradata/rawdb/undo01.dbf
temp=/oracle/oradata/rawdb/temp01.dbf
cwmlite=/oracle/oradata/rawdb/cwmlite01.dbf
drsys=/oracle/oradata/rawdb/drsys01.dbf
example=/oracle/oradata/rawdb/example01.dbf
indx=/oracle/oradata/rawdb/indx01.dbf
tools=/oracle/oradata/rawdb/tools01.dbf
xdb=/oracle/oradata/rawdb/xdb01.dbf
odm=/oracle/oradata/rawdb/odm01.dbf
11、将该文件加入oracle用户环境变量
[oracle@db9i ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0/db_1
export ORACLE_UNQNAME=rawdb9i
export ORACLE_SID=rawdb9i
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export LANG=y
export PATH
unset USERNAME
export DBCA_RAW_CONFIG=/oracle/DBCA_RAW_CONFIG.txt
12、dbca



来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31345818/viewspace-2121544/
,如需转载,请注明出处,否则将追究法律责任。