Oracle asm 添加磁盘组

php中文网

发布时间：2016-06-07 16:56:28

1534人浏览过

来源于php中文网

原创

1、创建裸设备引用# ls -l /dev/rlvtest crw-rw---- 1 oracle dba 44, 7 Mar 05 03:52 /dev/rlvtest2、添加磁盘组

oracle asm 添加磁盘组

[日期：2010-03-04] 来源：itspace.javaeye.com 作者：itspace [字体：]

1、创建裸设备

引用
# ls -l /dev/rlvtest
crw-rw---- 1 Oracle dba 44, 7 Mar 05 03:52 /dev/rlvtest

2、添加磁盘组

引用
SQL> create diskgroup grouptest disk '/dev/rlvtest';
create diskgroup grouptest disk '/dev/rlvtest'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rlvtest' matches no disks
ORA-15014: location '/dev/rlvtest' is not in the discovery set
解决办法：
SQL> alter system set asm_diskstring='/dev/rasmlv*','/dev/rlvtest';

System altered.

SQL> show parameter disk

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups                       string      ASMDISK
asm_diskstring                       string      /dev/rasmlv*, /dev/rlvtest
disk_asynch_io                       boolean     TRUE

KGOGOMALL

主要功能：无限级分类，可自由调整分类位置，商品可在各分类间自由转移；商品组合：可以为每种商品添加多种选项，方便顾客购买选择，比如：一件衣服顾客可以选择款式、花色、大小等，笔记本电脑，可以有cpu、内存、显示屏、硬盘等等扩展属性；会员分级功能，会员积分功能。可根据会员积分自行设定用户组，管理员可自行定义会员获得积分的方式：按订单总金额或者按单个商品给予积分；按照商品类别查看热卖、特价，允

下载

SQL> create diskgroup grouptest disk '/dev/rlvtest';
create diskgroup grouptest disk '/dev/rlvtest'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 2 failure groups, discovered only 1

解决办法：
SQL> create diskgroup grouptest external redundancy disk '/dev/rlvtest';

Diskgroup created.

3、后台日志显示

引用
SQL> create diskgroup grouptest external redundancy disk '/dev/rlvtest'
Fri Mar 5 03:57:11 2010
NOTE: initializing header on grp 2 disk GROUPTEST_0000
Fri Mar 5 03:57:11 2010
NOTE: PST update: grp = 2
Fri Mar 5 03:57:11 2010
NOTE: group GROUPTEST: initial PST locations: disk 0000 (PST copy 0)
Fri Mar 5 03:57:11 2010
NOTE: cache registered group GROUPTEST number=2 incarn=0xb2c6d2d4
NOTE: cache opening disk 0 of grp 2: GROUPTEST_0000 path:/dev/rlvtest
NOTE: cache creating group 2/0xB2C6D2D4 (GROUPTEST)
NOTE: cache mounting group 2/0xB2C6D2D4 (GROUPTEST) succeeded
NOTE: allocating F1X0 on grp 2 disk GROUPTEST_0000
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting group 2/0xB2C6D2D4 (GROUPTEST)
SUCCESS: diskgroup GROUPTEST was created
NOTE: cache registered group GROUPTEST number=2 incarn=0xd866d2d7
Fri Mar 5 03:57:17 2010
NOTE: Hbeat: instance first (grp 2)
Fri Mar 5 03:57:22 2010
NOTE: start heartbeating (grp 2)
NOTE: cache opening disk 0 of grp 2: GROUPTEST_0000 path:/dev/rlvtest
Fri Mar 5 03:57:22 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache mounting (first) group 2/0xD866D2D7 (GROUPTEST)
NOTE: cache recovered group 2 to fcn 0.0
Fri Mar 5 03:57:22 2010
NOTE: opening chunk 1 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Fri Mar 5 03:57:22 2010
NOTE: cache mounting group 2/0xD866D2D7 (GROUPTEST) succeeded
SUCCESS: diskgroup GROUPTEST was mounted
Fri Mar 5 03:57:23 2010
NOTE: recovering COD for group 2/0xd866d2d7 (GROUPTEST)
SUCCESS: completed COD recovery for group 2/0xd866d2d7 (GROUPTEST)