Oracleasm添加磁盘组

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

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)

利用Oracle threshold(度量阀值)监控表空间

在Oracle库存模块中进行帐龄分析