oracle数据磁盘添加,Oracle asm 添加磁盘组

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)