ITPub博客

首页 > 数据库 > Oracle > linux4.7 使用lvm创建裸设备搭建oracle9i

linux4.7 使用lvm创建裸设备搭建oracle9i

原创 Oracle 作者:Data_TigerLiu 时间:2016-07-05 14:59:56 0 删除 编辑
注:本文只从配置裸设备讲起
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/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: DBA_2PC_PENDING问题
请登录后发表评论 登录
全部评论

注册时间:2016-05-20

  • 博文量
    27
  • 访问量
    30515