http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2896]
PostgreSQL [103]
기타정보 [150]
운영체제 [583]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
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


  LIST

제목 작성자 작성일 조회
Install and Config  ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk    최길호 2021/10/07 288
Troubleshoot  sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found    최길호 2021/10/06 692
Troubleshoot  19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9   최길호 2021/10/05 889
Troubleshoot  ORA-12609: TNS: Receive timeout occurred    최길호 2021/10/03 1009
Troubleshoot  EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp    최길호 2021/10/02 796
Troubleshoot  grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축    최길호 2021/10/01 834
Troubleshoot  ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT    최길호 2021/09/30 277
Admin  alter table add column large table [ 11gR2 부터 빠르다 ]    최길호 2021/09/29 261
Troubleshoot  ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1    최길호 2021/09/29 486
Troubleshoot  alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk    최길호 2021/09/28 3970
Install and Config  create diskgroup data1 normal redundancy failgroup fg1 disk    최길호 2021/09/28 311
Troubleshoot  [INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.    최길호 2021/09/28 292
Troubleshoot  PRVG-11095 : The TCP system call "connect" failed with error "113"    최길호 2021/09/28 342
Troubleshoot  ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]    최길호 2021/09/25 346
Install and Config  ORA-24247: network access denied by access control list (ACL)    최길호 2021/09/24 315
Troubleshoot  ORA-12805 Parallel Query Server Died    최길호 2021/09/23 370

    목록보기   이전페이지   다음페이지 [1][2][3][4][5][6] 7 [8][9][10]..[145]   [다음 10개]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
08/10
[운영체제]
mobaxterm Remote desktop (RDP,....
by 최길호
08/09
[ORACLE]
ORA-12521 listener does not cu....
by 최길호
08/08
[ORACLE]
ogg save table DML total count....
by 최길호