ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Redhat 下raw device建库介绍(ZT)

Redhat 下raw device建库介绍(ZT)

原创 Linux操作系统 作者:paulyibinyi 时间:2009-05-05 22:50:09 0 删除 编辑

Redhat 下raw device建库介绍:

1、 Vmware下先虚拟一块新的磁盘,大小选择6G;启动redhat;


2、 在redhat下可以查看新磁盘情况:fdisk –l

看到新加的硬盘信息为:

Disk /dev/sdb: 6442MB *****

3、 先对磁盘/dev/sdb进行分区:

fdisk /dev/sdb

m是查看帮助信息

n创建新的分区:(d是删除分区)

选择是primary partition(1-4), extended

分区partition号,开始磁盘柱面,结束磁盘柱面;

创建后,可以选择p,显示分区信息;

最后w,保存退出;

4、 创建pv(pvcreate / pvremove/ pvdisplay)

fdisk –l可以看到新的分区情况,此时可看到一个device boot: /dev/sdb1

pvcreate /dev/sdb1

5、 创建vg (vgcreate/ vgremove/ vgdisplay)

vgcreate oravg /dev/sdb1

6、 创建lv(lvcreate/ lvremove /lvdisplay)

注意创建LV时必须比在将来数据库使用时多分配出一些空间:

A、建库时文件大小如果与LV大小相同会报错;

B、LV不能自动扩展;

[root@liqlx4 ~]# lvdisplay

[root@liqlx4 ~]# lvcreate -L 10m -n lv_spfile oravg

Rounding up size to full physical extent 12.00 MB

Logical volume "lv_spfile" created

[root@liqlx4 ~]# lvcreate -L 50m -n lv_control1 oravg

Rounding up size to full physical extent 52.00 MB

Logical volume "lv_control1" created

[root@liqlx4 ~]# lvcreate -L 50m -n lv_control2 oravg

Rounding up size to full physical extent 52.00 MB

Logical volume "lv_control2" created

[root@liqlx4 ~]# lvcreate -L 210m -n lv_redo111 oravg

Rounding up size to full physical extent 212.00 MB

Logical volume "lv_redo111" created

[root@liqlx4 ~]# lvcreate -L 210m -n lv_redo121 oravg

Rounding up size to full physical extent 212.00 MB

Logical volume "lv_redo121" created

[root@liqlx4 ~]# lvcreate -L 210m -n lv_redo131 oravg

Rounding up size to full physical extent 212.00 MB

Logical volume "lv_redo131" created

[root@liqlx4 ~]# lvcreate -L 1036m -n lv_system1 oravg

Logical volume "lv_system1" created

[root@liqlx4 ~]# lvcreate -L 1036m -n lv_temp1 oravg

Logical volume "lv_temp1" created

[root@liqlx4 ~]# lvcreate -L 520m -n lv_user1 oravg

Logical volume "lv_user1" created

[root@liqlx4 ~]# lvcreate -L 396m -n lv_sysaux1 oravg

Logical volume "lv_sysaux1" created

[root@liqlx4 ~]# lvcreate -L 1036m -n lv_undotbs1 oravg

Logical volume "lv_undotbs1" created

[root@liqlx4 ~]#

7、 将lv绑定对应的raw设备:

[root@liqlx4 ~]# cd /dev/raw

bash: cd: /dev/raw: No such file or directory

[root@liqlx4 ~]# cd /dev

[root@liqlx4 dev]# ls raw

ls: raw: No such file or directory

[root@liqlx4 dev]# raw /dev/raw/raw1 /dev/oravg/lv_spfile

/dev/raw/raw1: bound to major 253, minor 0

[root@liqlx4 dev]# ls raw

raw1

[root@liqlx4 dev]# pwd

/dev

[root@liqlx4 dev]# cd raw

[root@liqlx4 raw]# ls

raw1

[root@liqlx4 raw]# pwd

/dev/raw

[root@liqlx4 raw]#

[root@liqlx4 raw]# raw /dev/raw/raw2 /dev/oravg/lv_control1

/dev/raw/raw2: bound to major 253, minor 1

[root@liqlx4 raw]# raw /dev/raw/raw3 /dev/oravg/lv_control2

/dev/raw/raw3: bound to major 253, minor 2

[root@liqlx4 raw]# raw /dev/raw/raw4 /dev/oravg/lv_redo111

/dev/raw/raw4: bound to major 253, minor 3

[root@liqlx4 raw]# raw /dev/raw/raw5 /dev/oravg/lv_redo121

/dev/raw/raw5: bound to major 253, minor 4

[root@liqlx4 raw]# raw /dev/raw/raw6 /dev/oravg/lv_redo131

/dev/raw/raw6: bound to major 253, minor 5

[root@liqlx4 raw]# raw /dev/raw/raw7 /dev/oravg/lv_system1

/dev/raw/raw7: bound to major 253, minor 6

[root@liqlx4 raw]# raw /dev/raw/raw8 /dev/oravg/lv_temp1

/dev/raw/raw8: bound to major 253, minor 7

[root@liqlx4 raw]# raw /dev/raw/raw9 /dev/oravg/lv_user1

/dev/raw/raw9: bound to major 253, minor 8

[root@liqlx4 raw]# raw /dev/raw/raw10 /dev/oravg/lv_sysaux1

/dev/raw/raw10: bound to major 253, minor 9

[root@liqlx4 raw]# raw /dev/raw/raw11 /dev/oravg/lv_undotbs1

/dev/raw/raw11: bound to major 253, minor 10

8、 配置系统自动加载裸设备:

[root@liqlx4 raw]# cd /etc/sysconfig

[root@liqlx4 sysconfig]# vi rawdevices

/dev/raw/raw1 /dev/oravg/lv_spfile

/dev/raw/raw2 /dev/oravg/lv_control1

/dev/raw/raw3 /dev/oravg/lv_control2

/dev/raw/raw4 /dev/oravg/lv_redo111

/dev/raw/raw5 /dev/oravg/lv_redo121

/dev/raw/raw6 /dev/oravg/lv_redo131

/dev/raw/raw7 /dev/oravg/lv_system1

/dev/raw/raw8 /dev/oravg/lv_temp1

/dev/raw/raw9 /dev/oravg/lv_user1

/dev/raw/raw10 /dev/oravg/lv_sysaux1

/dev/raw/raw11 /dev/oravg/lv_undotbs1


9、 将相应RAW授权给ORACLE用户:

chown –R oracle:oinstall /dev/raw/*

chmod 777 /dev/raw/*

配置自动授权:

[root@liqlx4 rc.d]# pwd

/etc/rc.d

[root@liqlx4 rc.d]# vi rc.local

chown -R oracle:oinstall /dev/raw/*

chmod 777 /dev/raw/*


10、编写ORACLE裸设备配置文件,DBCA得到建库脚本:

创建DBCA 裸设备的dbca_raw_config配置文件:

控制文件信息:


数据文件信息:


选择生成脚本:

 

脚本生成完毕:


[oracle@liqlx4 dbs]$ pwd

/u01/app/oracle/product/ora10g/dbs

[oracle@liqlx4 dbs]$ vi dbca_raw_config

spfile=/dev/raw/raw1

control1=/dev/raw/raw2

control2=/dev/raw/raw3

redo1_1=/dev/raw/raw4

redo2_1=/dev/raw/raw5

redo3_1=/dev/raw/raw6

system=/dev/raw/raw7

temp=/dev/raw/raw8

users=/dev/raw/raw9

sysaux=/dev/raw/raw10

undotbs1=/dev/raw/raw11


dbca得到建库脚本;

11、运行建库脚本:

cd $ORACLE_BASE/admin/lx4raw10g/scripts

sh lx4raw10g.sh

12、进入数据库查看数据库状态是否正常:

Sqlplus “/ as sysdba”

SPFILE文件:

SQL> show parameter pfile;


NAME TYPE

------------------------------------ ----------------------

VALUE

------------------------------

spfile string

/dev/raw/raw1

控制文件:

SQL> select name from v$controlfile;


NAME

--------------------------------------------------------------------------------

/dev/raw/raw2

/dev/raw/raw3


SQL> select member from v$logfile order by group#;


MEMBER

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/dev/raw/raw4

/dev/raw/raw5

/dev/raw/raw6


数据表空间:

TABLESPACE_NAME FILE_NAME

--------------- ------------------------------

SYSAUX /dev/raw/raw10

UNDOTBS1 /dev/raw/raw11

SYSTEM /dev/raw/raw7

USERS /dev/raw/raw9


临时表空间:

TABLESPACE_NAME FILE_NAME

--------------- ------------------------------

TEMP /dev/raw/raw8


至此,裸设备全库创建完毕,状态正常。

 

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

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    903
  • 访问量
    6607125