|
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, Á¶È¸ : 1,174 |

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 | 216.73.216.248
|
|
 |
Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
|
|
|