ASM’ e yeni bir diskgroup Ekleme ;
Yeni bir disk eklemek için kullanabileeğimiz olan (statusu candidate) disklerimizi listemek için ;
SQL> Column name format a20;
SQL> Column header_status format a20;
SQL> Column path format a30;
SQL> SELECT name, header_status, path FROM V$ASM_DISK;
NAME HEADER_STATUS PATH
——————– ——————– ——————————
FORMER /dev/mapper/rac-asm002p1
CANDIDATE /dev/mapper/rac-asm004p1
CANDIDATE /dev/mapper/rac-asm003p1
REDO2_0000 MEMBER /dev/mapper/rac-asm007p1
REDO1_0000 MEMBER /dev/mapper/rac-asm006p1
ARCH1_0000 MEMBER /dev/mapper/rac-asm005p1
DATA1_0000 MEMBER /dev/mapper/rac-asm001p1
7 rows selected.
sorgusundan faydalanabiliriz.
/dev/mapper/rac-asm002p1 id’ li diskimizi ASM altında ayri bir disk group olarak tanımlayalım.
SQL> CREATE DISKGROUP DATA2 EXTERNAL REDUNDANCY DISK ‘/dev/mapper/rac-asm002p1’
2 ATTRIBUTE ‘au_size’=’1M’,
3 ‘compatible.asm’ = ‘11.2’,
4 ‘compatible.rdbms’ = ‘11.2’,
5 ‘compatible.advm’ = ‘11.2’;
Diskgroup created.
Biz bu işlemi yaparken Alert log’a aşağıdaki gibi logların yazıldığını görürsünüz;
SQL> CREATE DISKGROUP DATA2 EXTERNAL REDUNDANCY DISK ‘/dev/mapper/rac-asm002p1’
ATTRIBUTE ‘au_size’=’1M’,
‘compatible.asm’ = ‘11.2’,
‘compatible.rdbms’ = ‘11.2’,
‘compatible.advm’ = ‘11.2’
NOTE: Assigning number (5,0) to disk (/dev/mapper/rac-asm002p1)
NOTE: initializing header on grp 5 disk DATA2_0000
NOTE: initiating PST update: grp = 5
Sat May 16 13:50:58 2015
GMON updating group 5 at 44 for pid 29, osid 29919
NOTE: group DATA2: initial PST location: disk 0000 (PST copy 0)
NOTE: PST update grp = 5 completed successfully
NOTE: cache registered group DATA2 number=5 incarn=0xedb85cf0
NOTE: cache began mount (first) of group DATA2 number=5 incarn=0xedb85cf0
NOTE: cache opening disk 0 of grp 5: DATA2_0000 path:/dev/mapper/rac-asm002p1
Sat May 16 13:50:58 2015
* allocate domain 5, invalid = TRUE
kjbdomatt send to inst 2
Sat May 16 13:50:59 2015
NOTE: attached to recovery domain 5
NOTE: cache creating group 5/0xEDB85CF0 (DATA2)
NOTE: cache mounting group 5/0xEDB85CF0 (DATA2) succeeded
NOTE: allocating F1X0 on grp 5 disk DATA2_0000
NOTE: Created Used Space Directory for 1 threads
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting (clean) group 5/0xEDB85CF0 (DATA2)
NOTE: messaging CKPT to quiesce pins Unix process pid: 29919, image: oracle@trracora01t (TNS V1-V3)
NOTE: lgwr not being msg’d to dismount
kjbdomdet send to inst 2
detach from dom 5, sending detach message to inst 2
freeing rdom 5
NOTE: detached from domain 5
NOTE: cache dismounted group 5/0xEDB85CF0 (DATA2)
GMON dismounting group 5 at 45 for pid 29, osid 29919
GMON dismounting group 5 at 46 for pid 29, osid 29919
NOTE: Disk DATA2_0000 in mode 0x7e marked for de-assignment
SUCCESS: diskgroup DATA2 was created
NOTE: cache deleting context for group DATA2 5/0xedb85cf0
NOTE: cache registered group DATA2 number=5 incarn=0xf6e85cf2
NOTE: cache began mount (first) of group DATA2 number=5 incarn=0xf6e85cf2
NOTE: Assigning number (5,0) to disk (/dev/mapper/rac-asm002p1)
NOTE: GMON heartbeating for grp 5
GMON querying group 5 at 49 for pid 29, osid 29919
NOTE: cache opening disk 0 of grp 5: DATA2_0000 path:/dev/mapper/rac-asm002p1
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 5/0xF6E85CF2 (DATA2)
* allocate domain 5, invalid = TRUE
kjbdomatt send to inst 2
NOTE: attached to recovery domain 5
NOTE: cache recovered group 5 to fcn 0.0
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Sat May 16 13:51:06 2015
NOTE: LGWR attempting to mount thread 1 for diskgroup 5 (DATA2)
NOTE: LGWR found thread 1 closed at ABA 0.10750
NOTE: LGWR mounted thread 1 for diskgroup 5 (DATA2)
NOTE: LGWR opening thread 1 at fcn 0.0 ABA 2.0
NOTE: setting 11.2 start ABA for group DATA2 thread 1 to 2.0
NOTE: cache mounting group 5/0xF6E85CF2 (DATA2) succeeded
NOTE: cache ending mount (success) of group DATA2 number=5 incarn=0xf6e85cf2
Sat May 16 13:51:06 2015
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 5
SUCCESS: diskgroup DATA2 was mounted
SUCCESS: CREATE DISKGROUP DATA2 EXTERNAL REDUNDANCY DISK ‘/dev/mapper/rac-asm002p1’
ATTRIBUTE ‘au_size’=’1M’,
‘compatible.asm’ = ‘11.2’,
‘compatible.rdbms’ = ‘11.2’,
‘compatible.advm’ = ‘11.2’
Sat May 16 13:51:06 2015
NOTE: diskgroup resource ora.DATA2.dg is online
Fail group vermedğimiz için bununla ilgili bir error var ama zaten bunu vermesini bekliyorduk.
Disklere tekrar baktığımız da artık bu diskide ASM altında kullanılabilir olarak görebiliriz ;
SQL> SELECT name, header_status, path FROM V$ASM_DISK;
NAME HEADER_STATUS PATH
——————– ——————– ——————————
CANDIDATE /dev/mapper/rac-asm004p1
CANDIDATE /dev/mapper/rac-asm003p1
REDO2_0000 MEMBER /dev/mapper/rac-asm007p1
REDO1_0000 MEMBER /dev/mapper/rac-asm006p1
ARCH1_0000 MEMBER /dev/mapper/rac-asm005p1
DATA2_0000 MEMBER /dev/mapper/rac-asm002p1
DATA1_0000 MEMBER /dev/mapper/rac-asm001p1
7 rows selected.
SQL>
