|
|
IOTN :: Field Book :: ORACLE 
|
|
ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1
|
|
최길호
[LIST]
|
2021-09-29 01:01:34, 조회 : 486 |
create diskgroup data1 normal redundancy failgroup fg1 disk
http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=2949
조건: fail group fg2 장애시 추가 가능
alter diskgroup data add failgroup fg1 disk '/dev/sdk';
ORA-15411: Failure groups in disk group DATA have different number of disks.
조치:
alter diskgroup data
add failgroup fg1 disk '/dev/sdk' size 1024M
add failgroup fg2 disk '/dev/sdl' size 1024M ;
alter diskgroup data drop disk 'DATA_0000','DATA_0016';
SQL> alter diskgroup data drop disk 'DATA_0023','DATA_0015';
ORA-15032: not all alterations performed
ORA-15084: ASM disk "DATA_0015" is offline and cannot be dropped.
SQL> alter diskgroup data drop disk 'DATA_0023','DATA_0015' force;
Diskgroup altered.
SQL> alter diskgroup data offline disk DATA_0016;
ORA-15032: not all alterations performed
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
SQL> ALTER DISKGROUP data SET ATTRIBUTE 'compatible.rdbms'='11.1.0.0.0'; -- offline은 정상 복구 해야 작업 가능.
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.rdbms
ORA-15232: command requires all disks in diskgroup DATA to be online
SQL> ALTER DISKGROUP data drop DISK DATA_0016 force; -- drop force 옵션 가능
-- FG1은 정상, FG1 disk 제거 하려할때
SQL> ALTER DISKGROUP data drop DISK DATA_0000 force;
ORA-15066: offlining disk "DATA_0000" in group "DATA" may result in a data loss
-- 제거 불가 [ 제거 되면 데이터 손실 ]
set lines 200 pages 200
col path for a10
col label for a10
col failgroup for a10
select name,path,LABEL,total_mb,failgroup,MOUNT_STATUS,HEADER_STATUS,STATE from v$asm_disk order by PATH;
NAME PATH LABEL TOTAL_MB FAILGROUP MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
DATA2_0000 /dev/sdj 1024 FG1 CACHED MEMBER NORMAL
DATA2_0001 /dev/sdk 1024 FG1 CACHED MEMBER NORMAL
DATA2_0002 /dev/sdl 1024 FG1 CACHED MEMBER NORMAL
DATA2_0003 /dev/sdm 1024 FG1 CACHED MEMBER NORMAL
DATA2_0004 /dev/sdn 1024 FG2 CACHED MEMBER NORMAL
DATA2_0005 /dev/sdo 1024 FG2 CACHED MEMBER NORMAL
DATA2_0006 /dev/sdp 1024 FG2 CACHED MEMBER NORMAL
DATA2_0007 /dev/sdq 1024 FG2 CACHED MEMBER NORMAL
-- 장애 발생 fg1 group 모든 disk offline
alter diskgroup data2 offline disks in failgroup fg1;
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
ALTER DISKGROUP data2 SET ATTRIBUTE 'compatible.rdbms'='11.1.0.0.0';
alter diskgroup data2 offline disks in failgroup fg1;
NAME PATH LABEL TOTAL_MB FAILGROUP MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
/dev/sdj 0 CLOSED MEMBER NORMAL
/dev/sdk 0 CLOSED MEMBER NORMAL
/dev/sdl 0 CLOSED MEMBER NORMAL
/dev/sdm 0 CLOSED MEMBER NORMAL
DATA2_0004 /dev/sdn 1024 FG2 CACHED MEMBER NORMAL
DATA2_0005 /dev/sdo 1024 FG2 CACHED MEMBER NORMAL
DATA2_0006 /dev/sdp 1024 FG2 CACHED MEMBER NORMAL
DATA2_0007 /dev/sdq 1024 FG2 CACHED MEMBER NORMAL
DATA2_0001 1024 FG1 MISSING UNKNOWN NORMAL
DATA2_0000 1024 FG1 MISSING UNKNOWN NORMAL
DATA2_0003 1024 FG1 MISSING UNKNOWN NORMAL
DATA2_0002 1024 FG1 MISSING UNKNOWN NORMAL
-- offline 까지 하고 drop 하지는 않는다. drop은 필요 없어 보인다.
-- alter diskgroup data2 drop disks in failgroup fg1;
-- ORA-15084: ASM disk "DATA2_0000" is offline and cannot be dropped.
-- ALTER DISKGROUP data2 DROP DISKS IN FAILGROUP fg1 FORCE;
-- drop disks 하면 아래 처럼 변한다.
NAME PATH LABEL TOTAL_MB FAILGROUP MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
_DROPPED_0001_DATA2 1024 FG1 MISSING UNKNOWN FORCING
_DROPPED_0000_DATA2 1024 FG1 MISSING UNKNOWN FORCING
_DROPPED_0003_DATA2 1024 FG1 MISSING UNKNOWN FORCING
_DROPPED_0002_DATA2 1024 FG1 MISSING UNKNOWN FORCING
-- 복구 시도
ALTER DISKGROUP data2 add FAILGROUP fg1 DISK
'/dev/sdj' name DATA2_0000 ,
'/dev/sdk' name DATA2_0001 ,
'/dev/sdl' name DATA2_0002 ,
'/dev/sdm' name DATA2_0003 ;
ORA-15033: disk '/dev/sd?' belongs to diskgroup "DATA2"
-- HEADER_STATUS [ MEMBER => CANDIDATE ]
dd if=/dev/zero of=/dev/sdj skip=2 count=10 bs=8k
dd if=/dev/zero of=/dev/sdk skip=2 count=10 bs=8k
dd if=/dev/zero of=/dev/sdl skip=2 count=10 bs=8k
dd if=/dev/zero of=/dev/sdm skip=2 count=10 bs=8k
NAME PATH LABEL TOTAL_MB FAILGROUP MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
/dev/sdj 0 CLOSED CANDIDATE NORMAL
/dev/sdk 0 CLOSED CANDIDATE NORMAL
/dev/sdl 0 CLOSED CANDIDATE NORMAL
/dev/sdm 0 CLOSED CANDIDATE NORMAL
-- 재시도
ALTER DISKGROUP data2 add FAILGROUP fg1 DISK
'/dev/sdj' name DATA2_0000 ,
'/dev/sdk' name DATA2_0001 ,
'/dev/sdl' name DATA2_0002 ,
'/dev/sdm' name DATA2_0003 ;
NAME PATH LABEL TOTAL_MB FAILGROUP MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
DATA2_0000 /dev/sdj 1024 FG1 CACHED MEMBER NORMAL
DATA2_0001 /dev/sdk 1024 FG1 CACHED MEMBER NORMAL
DATA2_0002 /dev/sdl 1024 FG1 CACHED MEMBER NORMAL
DATA2_0003 /dev/sdm 1024 FG1 CACHED MEMBER NORMAL
-- 시간 지나면 사라진다. SQL> select * from V$ASM_OPERATION;
_DROPPED_0008_DATA2 1024 FG1 MISSING UNKNOWN FORCING
_DROPPED_0009_DATA2 1024 FG1 MISSING UNKNOWN FORCING
_DROPPED_0011_DATA2 1024 FG1 MISSING UNKNOWN FORCING
_DROPPED_0010_DATA2 1024 FG1 MISSING UNKNOWN FORCING
추가
복구 완료후 자동 dismount
SUCCESS: alter diskgroup DATA dismount force /* ASM SERVER:255235266 */
SQL> alter diskgroup data mount [ 수동 mount ]
SQL> /
select * from V$ASM_OPERATION
*
ERROR at line 1:
ORA-15130: diskgroup "DATA" is being dismounted
SQL> /
no rows selected
SQL>
node1 DB instance down 되지 않는다.
SQL> select inst_id,to_char(startup_time,'yyyy/mm/dd hh24:mi:ss') from gv$instance;
INST_ID TO_CHAR(STARTUP_TIM
---------- -------------------
1 2021/10/04 10:58:14
2 2021/10/04 10:58:03 |
18.207.157.152
|
|
|
|
Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
08/10 