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

 회원가입

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


  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 833
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 3969
Install and Config  create diskgroup data1 normal redundancy failgroup fg1 disk    최길호 2021/09/28 310
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 최길호