|
|
IOTN :: Field Book :: ORACLE 
|
|
create diskgroup data1 normal redundancy failgroup fg1 disk
|
|
최길호
[LIST]
|
2021-09-28 20:36:10, 조회 : 310 |
Disk LUN 용량은 같아야 좋다 [ 2T 이상은 호환 문제가 있다. ]
kfod disks=all
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 819200 MB /dev/sda root disk
2: 1024 MB /dev/sdb root disk
3: 1024 MB /dev/sdc root disk
4: 1024 MB /dev/sdd root disk
5: 1024 MB /dev/sde root disk
6: 1024 MB /dev/sdf root disk
7: 1024 MB /dev/sdg root disk
8: 1024 MB /dev/sdh root disk
9: 1024 MB /dev/sdi root disk
10: 1024 MB /dev/sdj root disk
11: 1024 MB /dev/sdk root disk
12: 1024 MB /dev/sdl root disk
13: 1024 MB /dev/sdm root disk
14: 1024 MB /dev/sdn root disk
15: 1024 MB /dev/sdo root disk
16: 1024 MB /dev/sdp root disk
17: 1024 MB /dev/sdq root disk
18: 1024 MB /dev/sdr root disk
19: 1024 MB /dev/sds root disk
20: 1024 MB /dev/sdt root disk
21: 1024 MB /dev/sdu root disk
drop DISKGROUP data;
CREATE DISKGROUP data NORMAL REDUNDANCY
FAILGROUP fg1 DISK
'/dev/sdb',
'/dev/sdc',
'/dev/sdd',
'/dev/sde',
'/dev/sdf',
'/dev/sdg',
'/dev/sdh',
'/dev/sdi'
FAILGROUP fg2 DISK
'/dev/sdj',
'/dev/sdk',
'/dev/sdl',
'/dev/sdm',
'/dev/sdn',
'/dev/sdo',
'/dev/sdp',
'/dev/sdq';
col name for a20
col path for a10
col label for a20
set lines 200 pages 200
col compatibility for a20
col database_compatibility for a20
select name,compatibility,database_compatibility from v$asm_diskgroup;
NAME COMPATIBILITY DATABASE_COMPATIBILI
-------------------- -------------------- --------------------
GRID 19.0.0.0.0 10.1.0.0.0
DATA 11.2.0.2.0 10.1.0.0.0
-- alter diskgroup data set attribute 'compatible.asm'='19.0.0.0.0';
select name,path,LABEL,total_mb,failgroup from v$asm_disk order by PATH;
NAME PATH LABEL TOTAL_MB FAILGROUP
-------------------- ---------- -------------------- ---------- ------------------------------
/dev/sda 0
DATA_0000 /dev/sdb 1024 FG1
DATA_0001 /dev/sdc 1024 FG1
DATA_0002 /dev/sdd 1024 FG1
DATA_0003 /dev/sde 1024 FG1
DATA_0004 /dev/sdf 1024 FG1
DATA_0005 /dev/sdg 1024 FG1
DATA_0006 /dev/sdh 1024 FG1
DATA_0007 /dev/sdi 1024 FG1
DATA_0008 /dev/sdj 1024 FG2
DATA_0009 /dev/sdk 1024 FG2
DATA_0010 /dev/sdl 1024 FG2
DATA_0011 /dev/sdm 1024 FG2
DATA_0012 /dev/sdn 1024 FG2
DATA_0013 /dev/sdo 1024 FG2
DATA_0014 /dev/sdp 1024 FG2
DATA_0015 /dev/sdq 1024 FG2
/dev/sdr 0
GRID_0000 /dev/sds 1024 GRID1
GRID_0001 /dev/sdt 1024 GRID2
GRID_0002 /dev/sdu 1024 GRID3
select name,trunc(total_mb/1024) "Size (GB)",trunc(free_mb/1024) "Free (GB)",
trunc(usable_file_mb/1024) "Usable (GB)",state,type from v$asm_diskgroup;
NAME Size (GB) Free (GB) Usable (GB) STATE TYPE
-------------------- ---------- ---------- ----------- ----------- ------
GRID 3 2 0 MOUNTED NORMAL
DATA 16 15 6 MOUNTED NORMAL
alter diskgroup grid add FAILGROUP GRID4 DISK '/dev/sdr';
NAME PATH LABEL TOTAL_MB FAILGROUP
-------------------- ---------- -------------------- ---------- ------------------------------
GRID_0003 /dev/sdr 1024 GRID4
GRID_0000 /dev/sds 1024 GRID1
GRID_0001 /dev/sdt 1024 GRID2
GRID_0002 /dev/sdu 1024 GRID3
select name,trunc(total_mb/1024) "Size (GB)",trunc(free_mb/1024) "Free (GB)",
trunc(usable_file_mb/1024) "Usable (GB)",state,type from v$asm_diskgroup;
NAME Size (GB) Free (GB) Usable (GB) STATE TYPE
-------------------- ---------- ---------- ----------- ----------- ------
GRID 4 3 1 MOUNTED NORMAL
DATA 16 15 6 MOUNTED NORMAL
https://docs.oracle.com/database/121/OSTMG/GUID-CF8EC329-446D-4A7B-B252-76AC9F40CA45.htm#OSTMG94132
ASMCMD remap명령은 디스크에 다양한 불량 섹터가 존재하고 Oracle ASM 또는 데이터베이스 I/O 전에 수정해야 하는 상황을 해결하기 위해 도입되었습니다.
기본적으로 Oracle ASM은 디스크가 오프라인 상태가 된 후 disk_repair_time 내에 디스크를 삭제합니다.
DISK_REPAIR_TIME 디스크를 복구하고 다시 온라인 상태로 만드는 시간 간격을 지정하여 삭제 작업을 지연 하도록 디스크 그룹 속성을 설정할 수 있습니다 .
시간은 분( m또는 M) 또는 시간( h또는 H) 단위로 지정할 수 있습니다.
단위를 생략하면 기본 단위는 시간입니다. DISK_REPAIR_TIME디스크 그룹 속성 만 설정할 수 있습니다
ALTER DISKGROUP data SET ATTRIBUTE 'disk_repair_time' = '4.5h' -- 19c 12.0h [ default ]
ALTER DISKGROUP data SET ATTRIBUTE 'disk_repair_time' = '270m'
col name for a30
col value for a30
select group_number,name,value from v$asm_attribute where name like 'comp%' or name like 'disk%' or name like '%fail%' ;
GROUP_NUMBER NAME VALUE
------------ ------------------------------ ------------------------------
1 disk_repair_time 12.0h
1 failgroup_repair_time 24.0h
1 compatible.asm 19.0.0.0.0
1 compatible.rdbms 10.1.0.0.0
다음 예에서는 디스크를 DATA_001오프라인으로 전환하고 5분 후에 삭제합니다.
ALTER DISKGROUP data OFFLINE DISK DATA_001 DROP AFTER 5m;
다음 예에서는 디스크를 DATA_001오프라인으로 전환하고 로 지정된 시간 DISK_REPAIR_TIME이 경과 한 후 삭제합니다 .
ALTER DISKGROUP data OFFLINE DISK DATA_001;
이 예에서는 장애 그룹의 모든 디스크를 FG2오프라인으로 전환하고 에서 지정한 시간 DISK_REPAIR_TIME이 지나면 삭제합니다.
DROP AFTER절 을 사용한 경우 지정된 시간 후에 디스크가 삭제됩니다.
ALTER DISKGROUP data OFFLINE DISKS IN FAILGROUP FG2;
ALTER DISKGROUP data ONLINE DISKS IN FAILGROUP FG2;
ALTER DISKGROUP data ONLINE DISK DATA_001;
ALTER DISKGROUP data ONLINE ALL;
SELECT GROUP_NUMBER, PASS, STATE FROM V$ASM_OPERATION;
GROUP_NUMBER PASS STAT
------------ --------- ----
1 RESYNC RUN
https://docs.oracle.com/database/121/OSTMG/GUID-C0EF42F0-4C35-4ACA-AF10-FA98A952B244.htm#OSTMG10047
-- 빠른 Disk 우선 Option
alter system reset asm_preferred_read_failure_groups sid='*';
alter system set ASM_PREFERRED_READ_FAILURE_GROUPS='data.fg1' sid='*';
drop DISKGROUP data;
CREATE DISKGROUP data1 NORMAL REDUNDANCY
FAILGROUP fg1 DISK
'/dev/sdb',
'/dev/sdc',
'/dev/sdd',
'/dev/sde'
FAILGROUP fg2 DISK
'/dev/sdf',
'/dev/sdg',
'/dev/sdh',
'/dev/sdi';
CREATE DISKGROUP data2 NORMAL REDUNDANCY
FAILGROUP fg1 DISK
'/dev/sdj',
'/dev/sdk',
'/dev/sdl',
'/dev/sdm'
FAILGROUP fg2 DISK
'/dev/sdn',
'/dev/sdo',
'/dev/sdp',
'/dev/sdq';
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
-------------------- ---------- ---------- ---------- ---------- ------- ------------ --------
/dev/sda 0 CLOSED CANDIDATE NORMAL
DATA1_0000 /dev/sdb 1024 FG1 CACHED MEMBER NORMAL
DATA1_0001 /dev/sdc 1024 FG1 CACHED MEMBER NORMAL
DATA1_0002 /dev/sdd 1024 FG1 CACHED MEMBER NORMAL
DATA1_0003 /dev/sde 1024 FG1 CACHED MEMBER NORMAL
DATA1_0004 /dev/sdf 1024 FG2 CACHED MEMBER NORMAL
DATA1_0005 /dev/sdg 1024 FG2 CACHED MEMBER NORMAL
DATA1_0006 /dev/sdh 1024 FG2 CACHED MEMBER NORMAL
DATA1_0007 /dev/sdi 1024 FG2 CACHED MEMBER NORMAL
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
GRID_0003 /dev/sdr 1024 GRID4 CACHED MEMBER NORMAL
GRID_0000 /dev/sds 1024 GRID1 CACHED MEMBER NORMAL
GRID_0001 /dev/sdt 1024 GRID2 CACHED MEMBER NORMAL
GRID_0002 /dev/sdu 1024 GRID3 CACHED MEMBER NORMAL
|
18.207.157.152
|
|
|
|
Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
08/10 