Add a disk group to Oracleasm

1. Create a bare device reference # ls-ldevrlvtestcrw-rw ---- 1108ledba44, 7Mar0503: 52devrlvtest2. Add a disk group

1. Create a bare device reference # ls-l/dev/rlvtest crw-rw ---- 1 oracle dba 44, 7 Mar 05/dev/rlvtest2. Add a disk group

Add a disk group to Oracle asm

[Date: 2010-03-04] Source: itspace.javaeye.com Author: itspace [Font:]

1. Create a bare Device

Reference
# Ls-l/dev/rlvtest
Crw-rw ---- 1 Oracle dba 44, 7 Mar 05/dev/rlvtest

2. Add a disk group

Reference
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
Solution:
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

Solution:
SQL> create diskgroup grouptest external redundancy disk '/dev/rlvtest ';

Diskgroup created.

3. Background log display

Reference
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: When at: 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)

0

Use Oracle threshold to monitor tablespaces

Perform aging analysis in the Oracle inventory module

,