내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.3.0.0
에러 : ORA-15032, ORA-15017, ORA-15040
rac 설치 중 grid 설치, asmca 완료 후
dbca를 하지 않은 상태에서 db 및 서버를 종료 후 재기동했더니
ASM DATA영역이 잡히지 않음
asm diskgroup mount 명령시 아래 에러 발생
1 2 3 4 5 6 7 | SQL> alter diskgroup DATA mount; alter diskgroup DATA mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15017: diskgroup "DATA" cannot be mounted ORA-15040: diskgroup is incomplete |
asmcmd 확인
1 2 3 | $ asmcmd ASMCMD> ls OCR_VOTE/ |
OCR_VOTE영역만 나오고 DATA영역은 나오지 않음
상태확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | $ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE ora.chad ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE ora.net1.network ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE ora.ons ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 OFFLINE OFFLINE STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE oel19db1 STABLE ora.OCR_VOTE.dg(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE oel19db1 Started,STABLE 2 ONLINE ONLINE oel19db2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE oel19db1 STABLE ora.oel19db1.vip 1 ONLINE ONLINE oel19db1 STABLE ora.oel19db2.vip 1 ONLINE ONLINE oel19db2 STABLE ora.qosmserver 1 ONLINE ONLINE oel19db1 STABLE ora.scan1.vip 1 ONLINE ONLINE oel19db1 STABLE -------------------------------------------------------------------------------- |
DATA 가 OFFLINE 임
디스크 권한 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | $ oracleasm listdisks DATA01 OCR_VOTE1 OCR_VOTE2 OCR_VOTE3 $ ls -al /dev/19c/ total 0 drwxr-xr-x 2 oracle dba 120 Mar 10 20:39 . drwxr-xr-x 21 root root 3400 Mar 10 20:39 .. lrwxrwxrwx 1 oracle dba 7 Mar 10 20:39 DATA -> ../dm-5 lrwxrwxrwx 1 oracle dba 7 Mar 10 20:39 ocr_vote1 -> ../dm-2 lrwxrwxrwx 1 oracle dba 7 Mar 10 20:39 ocr_vote2 -> ../dm-3 lrwxrwxrwx 1 oracle dba 7 Mar 10 20:39 ocr_vote3 -> ../dm-4 $ ls -al /dev/oracleasm/disks/ total 0 drwxr-xr-x 1 root root 0 Mar 10 20:39 . drwxr-xr-x 4 root root 0 Mar 10 20:39 .. brw-rw---- 1 oracle dba 252, 5 Mar 10 20:39 DATA01 brw-rw---- 1 oracle dba 252, 2 Mar 10 22:41 OCR_VOTE1 brw-rw---- 1 oracle dba 252, 3 Mar 10 22:41 OCR_VOTE2 brw-rw---- 1 oracle dba 252, 4 Mar 10 22:41 OCR_VOTE3 |
asm_diskgroup 확인
1 2 3 4 5 6 7 8 | $ sqlplus / as sysasm SQL> select group_number,name,state,TOTAL_MB,FREE_MB from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ ------------------------------ ----------- ---------- ---------- 0 DATA DISMOUNTED 0 0 2 OCR_VOTE MOUNTED 3072 2108 |
DATA 영역이 용량도 나오지 않고 DISMOUNT 상태임
crs 재기동
1 2 | # crsctl stop crs # crsctl start crs |
crs 재기동 이후의 asm alert log 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | $ cd /ORA19/app/oracle/diag/asm/+asm/+ASM1/trace $ vi alert_+ASM1.log 2020-03-10T22:30:24.997111+09:00 ERROR: no read quorum in group: required 1, found 0 disks 2020-03-10T22:30:24.997859+09:00 NOTE: cache dismounting (clean) group 1/0x6FAA3532 (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 31148, image: oracle@oel19db1 (TNS V1-V3) NOTE: dbwr not being msg'd to dismount NOTE: LGWR not being messaged to dismount NOTE: cache dismounted group 1/0x6FAA3532 (DATA) NOTE: cache ending mount (fail) of group DATA number=1 incarn=0x6faa3532 NOTE: cache deleting context for group DATA 1/0x6faa3532 2020-03-10T22:30:25.055089+09:00 GMON dismounting group 1 at 2 for pid 35, osid 31148 2020-03-10T22:30:25.055344+09:00 NOTE: Disk DATA_0000 in mode 0x8 marked for de-assignment ERROR: diskgroup DATA was not mounted NOTE: Assigning number (2,1) to disk (/dev/oracleasm/disks/OCR_VOTE3) NOTE: Assigning number (2,2) to disk (/dev/oracleasm/disks/OCR_VOTE2) NOTE: Assigning number (2,0) to disk (/dev/oracleasm/disks/OCR_VOTE1) . . 2020-03-10T22:30:31.083267+09:00 NOTE: cache is mounting group OCR_VOTE created on 2020/03/04 07:49:54 NOTE: cache opening disk 0 of grp 2: OCR_VOTE_0000 path:/dev/oracleasm/disks/OCR_VOTE1 NOTE: 03/10/20 22:30:30 OCR_VOTE.F1X0 found on disk 0 au 10 fcn 0.0 datfmt 1 NOTE: cache opening disk 1 of grp 2: OCR_VOTE_0001 path:/dev/oracleasm/disks/OCR_VOTE3 NOTE: 03/10/20 22:30:30 OCR_VOTE.F1X0 found on disk 1 au 10 fcn 0.0 datfmt 1 NOTE: cache opening disk 2 of grp 2: OCR_VOTE_0002 path:/dev/oracleasm/disks/OCR_VOTE2 NOTE: 03/10/20 22:30:30 OCR_VOTE.F1X0 found on disk 2 au 10 fcn 0.0 datfmt 1 2020-03-10T22:30:31.083878+09:00 NOTE: cache mounting (first) normal redundancy group 2/0x6FBA3533 (OCR_VOTE) . . 2020-03-10T22:30:31.626479+09:00 ERROR: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:5:3} */ 2020-03-10T22:30:31.748423+09:00 WARNING: failed to online diskgroup resource ora.OCR_VOTE.dg (unable to communicate with CRSD/OHASD) . . 2020-03-10T22:34:13.469531+09:00 ERROR: no read quorum in group: required 1, found 0 disks |
DATA 영역이 mount 되지 않음
ERROR: no read quorum in group: required 1, found 0 disks
그룹에 읽기 쿼럼이 없음 : 필수 1, 디스크 0 개 발견이라는 내용이 반복됨
crs alert log 확인
1 2 3 4 5 6 | $ cd /ORA19/app/oracle/diag/crs/oel19db1/crs/trace $ vi alert.log ASM 검색 2020-03-10 20:40:33.083 [ORAROOTAGENT(6410)]CRS-5019: All OCR locations are on ASM disk groups [OCR_VOTE], and none of these disk groups are mounted. Details are at "(:CLSN00140:)" in "/ORA19/app/oracle/diag/crs/oel19db1/crs/trace/ohasd_orarootagent_root.trc". |
alert log 에 나와있는 trc 파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 | $ vi /ORA19/app/oracle/diag/crs/oel19db1/crs/trace/ohasd_orarootagent_root.trc ERROR 검색 2020-03-10 22:29:36.920 : CLSDADR:2102417152: [ ERROR] (:CLSD0023:)dynamic component [R1452749] mapped to [CLSDYNAM] 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} ID = [ora.crsd 1 1] Intermediate Timeout = [720000] 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} Added new resource: ora.crsd 1 1 to the agfw 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} Agent sending last reply for: RESOURCE_ADD[ora.crsd 1 1] ID 4356:156 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} Agent received the message: RESOURCE_ADD[ora.ctssd 1 1] ID 4356:157 2020-03-10 22:29:36.920 : CLSDADR:2102417152: [ ERROR] (:CLSD0023:)dynamic component [R3182807] mapped to [CLSDYNAM] 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} ID = [ora.ctssd 1 1] Intermediate Timeout = [0] 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} Added new resource: ora.ctssd 1 1 to the agfw 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} Agent sending last reply for: RESOURCE_ADD[ora.ctssd 1 1] ID 4356:157 2020-03-10 22:29:36.920 : AGFW:2102417152: [ INFO] {0:3:2} Agent received the message: RESOURCE_ADD[ora.diskmon 1 1] ID 4356:158 |
해결 방법 : oracleasm deletedisk 후 createdisk 후 asmca로 생성
oracleasm deletedisk 후 createdisk
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | 삭제 # oracleasm deletedisk DATA01 Clearing disk header: done Dropping disk: done 생성 # oracleasm createdisk DATA01 /dev/19c/DATA Writing disk header: done Instantiating disk: done 스캔 # oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM disks... Scanning system for ASM disks... 확인 # oracleasm listdisks DATA01 OCR_VOTE1 OCR_VOTE2 OCR_VOTE3 |
asmca 실행
1 | $ asmca |
create 선택
Disk 이름 및 redundancy 선택
생성 및 마운트된 DATA 디스크그룹 확인
종료
asm_diskgroup 확인
1 2 3 4 5 6 7 8 | $ sqlplus / as sysasm SQL> select group_number,name,state,TOTAL_MB,FREE_MB from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ ------------------------------ ----------- ---------- ---------- 2 OCR_VOTE MOUNTED 3072 2108 1 DATA MOUNTED 20480 20344 |
정상적으로 마운트되고 용량도 나옴
crs 상태 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | $ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE ora.chad ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE ora.net1.network ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE ora.ons ONLINE ONLINE oel19db1 STABLE ONLINE ONLINE oel19db2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 ONLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE oel19db1 STABLE ora.OCR_VOTE.dg(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE oel19db1 Started,STABLE 2 ONLINE ONLINE oel19db2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE oel19db1 STABLE 2 ONLINE ONLINE oel19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE oel19db1 STABLE ora.oel19db1.vip 1 ONLINE ONLINE oel19db1 STABLE ora.oel19db2.vip 1 ONLINE ONLINE oel19db2 STABLE ora.qosmserver 1 ONLINE ONLINE oel19db1 STABLE ora.scan1.vip 1 ONLINE ONLINE oel19db1 STABLE -------------------------------------------------------------------------------- |
DATA 모두 ONLINE
asmca 시 asm alert log
4번째 줄에서 생성구문이 실행됨
이후 일련의 과정을 거쳐
diskgroup DATA 이 생성완료됨
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 | $ cd /ORA19/app/oracle/diag/asm/+asm/+ASM1/trace $ vi alert_+ASM1.log 2020-03-11T01:37:07.611678+09:00 SQL> CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DATA01' SIZE 20480M ATTRIBUTE 'compatible.asm'='19.0.0.0','au_size'='4M' 2020-03-11T01:37:07.958198+09:00 NOTE: Assigning number (1,0) to disk (/dev/oracleasm/disks/DATA01) NOTE: initializing header (replicated) on grp 1 disk DATA_0000 NOTE: initializing header on grp 1 disk DATA_0000 2020-03-11T01:37:08.602573+09:00 NOTE: Disk 0 in group 1 is assigned fgnum=1 NOTE: initiating PST update: grp = 1 2020-03-11T01:37:08.605377+09:00 GMON updating group 1 at 16 for pid 35, osid 3128 NOTE: set version 0 for asmCompat 19.0.0.0.0 for group 1 NOTE: group DATA: initial PST location: disks 0000 2020-03-11T01:37:08.630481+09:00 NOTE: PST update grp = 1 completed successfully NOTE: cache registered group DATA 1/0xF18A3542 NOTE: cache began mount (first) of group DATA 1/0xF18A3542 NOTE: cache is mounting group DATA created on 2020/03/11 01:37:07 NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/oracleasm/disks/DATA01 2020-03-11T01:37:08.671749+09:00 * allocate domain 1, valid ? 0 kjbdomatt send to inst 2 2020-03-11T01:37:08.846444+09:00 NOTE: attached to recovery domain 1 2020-03-11T01:37:08.850482+09:00 NOTE: cache creating group 1/0xF18A3542 (DATA) NOTE: cache mounting group 1/0xF18A3542 (DATA) succeeded NOTE: allocating F1X0 (replicated) on grp 1 disk DATA_0000 NOTE: allocating F1X0 on grp 1 disk DATA_0000 NOTE: Created Used Space Directory for 1 threads NOTE: diskgroup must now be re-mounted prior to first use 2020-03-11T01:37:09.345565+09:00 NOTE: cache dismounting (clean) group 1/0xF18A3542 (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 3128, image: oracle@oel19db1 (TNS V1-V3) 2020-03-11T01:37:10.496737+09:00 NOTE: LGWR not being messaged to dismount 2020-03-11T01:37:10.595429+09:00 kjbdomdet send to inst 2 detach from dom 1, sending detach message to inst 2 freeing rdom 1 freeing the fusion rht of pdb 1 2020-03-11T01:37:10.709028+09:00 NOTE: detached from domain 1 2020-03-11T01:37:10.709475+09:00 NOTE: cache dismounted group 1/0xF18A3542 (DATA) 2020-03-11T01:37:10.760795+09:00 GMON dismounting group 1 at 17 for pid 35, osid 3128 GMON dismounting group 1 at 18 for pid 35, osid 3128 2020-03-11T01:37:10.770398+09:00 NOTE: Disk DATA_0000 in mode 0x7f marked for de-assignment SUCCESS: diskgroup DATA was created NOTE: cache deleting context for group DATA 1/0xf18a3542 NOTE: cache registered group DATA 1/0x050A3545 NOTE: cache began mount (first) of group DATA 1/0x050A3545 NOTE: Assigning number (1,0) to disk (/dev/oracleasm/disks/DATA01) 2020-03-11T01:37:10.979005+09:00 cluster guid (02a6256dfde0ef43ff767a6f39994c0b) generated for PST Hbeat for instance 1 2020-03-11T01:37:16.986126+09:00 NOTE: GMON heartbeating for grp 1 (DATA) GMON querying group 1 at 21 for pid 35, osid 3128 2020-03-11T01:37:16.988602+09:00 NOTE: cache is mounting group DATA created on 2020/03/11 01:37:07 NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/oracleasm/disks/DATA01 NOTE: 03/11/20 01:37:16 DATA.F1X0 found on disk 0 au 10 fcn 0.0 datfmt 1 2020-03-11T01:37:16.988871+09:00 NOTE: cache mounting (first) external redundancy group 1/0x050A3545 (DATA) 2020-03-11T01:37:17.118239+09:00 * allocate domain 1, valid ? 0 kjbdomatt send to inst 2 2020-03-11T01:37:17.196698+09:00 NOTE: attached to recovery domain 1 2020-03-11T01:37:17.212500+09:00 validate pdb 1, flags x4, valid 0, pdb flags x204 * validated domain 1, flags = 0x200 NOTE: cache recovered group 1 to fcn 0.0 NOTE: redo buffer size is 512 blocks (2105344 bytes) 2020-03-11T01:37:17.230633+09:00 NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA) NOTE: LGWR found thread 1 closed at ABA 0.11262 lock domain=0 inc#=0 instnum=0 NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA) NOTE: setting 11.2 start ABA for group DATA thread 1 to 2.0 2020-03-11T01:37:17.238446+09:00 NOTE: LGWR opened thread 1 (DATA) at fcn 0.0 ABA 2.0 lock domain=1 inc#=4 instnum=1 gx.incarn=84555077 mntstmp=2020/03/11 01:37:17.234000 2020-03-11T01:37:17.238685+09:00 NOTE: cache mounting group 1/0x050A3545 (DATA) succeeded NOTE: cache ending mount (success) of group DATA number=1 incarn=0x050a3545 2020-03-11T01:37:17.262081+09:00 NOTE: Instance updated compatible.asm to 19.0.0.0.0 for grp 1 (DATA). 2020-03-11T01:37:17.263025+09:00 NOTE: Instance updated compatible.asm to 19.0.0.0.0 for grp 1 (DATA). 2020-03-11T01:37:17.265644+09:00 NOTE: Instance updated compatible.rdbms to 10.1.0.0.0 for grp 1 (DATA). 2020-03-11T01:37:17.266111+09:00 NOTE: Instance updated compatible.rdbms to 10.1.0.0.0 for grp 1 (DATA). 2020-03-11T01:37:17.284379+09:00 SUCCESS: diskgroup DATA was mounted 2020-03-11T01:37:17.285775+09:00 SUCCESS: CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DATA01' SIZE 20480M ATTRIBUTE 'compatible.asm'='19.0.0.0','au_size'='4M' 2020-03-11T01:37:17.437021+09:00 NOTE: diskgroup resource ora.DATA.dg is online 2020-03-11T01:37:18.458972+09:00 NOTE: enlarging ACD to 2 threads for group 1/0x50a3545 (DATA) SUCCESS: ACD enlarged for group 1/0x50a3545 (DATA) |
그 외 시도한 방법
kfed repair 명령 시도
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | # kfed read /dev/oracleasm/disks/DATA01 | head -30 kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 0 ; 0x004: blk=0 kfbh.block.obj: 2147483648 ; 0x008: disk=0 kfbh.check: 1407290388 ; 0x00c: 0x53e18c14 kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfdhdb.driver.provstr: ORCLDISKDATA01 ; 0x000: length=14 kfdhdb.driver.reserved[0]: 1096040772 ; 0x008: 0x41544144 kfdhdb.driver.reserved[1]: 12592 ; 0x00c: 0x00003130 kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000 kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000 kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000 kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000 kfdhdb.compat: 318767104 ; 0x020: 0x13000000 kfdhdb.dsknum: 0 ; 0x024: 0x0000 kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER kfdhdb.dskname: DATA_0000 ; 0x028: length=9 kfdhdb.grpname: DATA ; 0x048: length=4 kfdhdb.fgname: DATA_0000 ; 0x068: length=9 kfdhdb.siteguid[0]: 0 ; 0x088: 0x00 kfdhdb.siteguid[1]: 0 ; 0x089: 0x00 kfdhdb.siteguid[2]: 0 ; 0x08a: 0x00 kfdhdb.siteguid[3]: 0 ; 0x08b: 0x00 kfdhdb.siteguid[4]: 0 ; 0x08c: 0x00 # kfed repair /dev/oracleasm/disks/DATA01 KFED-00320: invalid block num1 = [205], num2 = [1], error = [datfmt_kfbh] # kfed read /dev/oracleasm/disks/DATA01 | head -30 kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 0 ; 0x004: blk=0 kfbh.block.obj: 2147483648 ; 0x008: disk=0 kfbh.check: 1407290388 ; 0x00c: 0x53e18c14 kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfdhdb.driver.provstr: ORCLDISKDATA01 ; 0x000: length=14 kfdhdb.driver.reserved[0]: 1096040772 ; 0x008: 0x41544144 kfdhdb.driver.reserved[1]: 12592 ; 0x00c: 0x00003130 kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000 kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000 kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000 kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000 kfdhdb.compat: 318767104 ; 0x020: 0x13000000 kfdhdb.dsknum: 0 ; 0x024: 0x0000 kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER kfdhdb.dskname: DATA_0000 ; 0x028: length=9 kfdhdb.grpname: DATA ; 0x048: length=4 kfdhdb.fgname: DATA_0000 ; 0x068: length=9 kfdhdb.siteguid[0]: 0 ; 0x088: 0x00 kfdhdb.siteguid[1]: 0 ; 0x089: 0x00 kfdhdb.siteguid[2]: 0 ; 0x08a: 0x00 kfdhdb.siteguid[3]: 0 ; 0x08b: 0x00 kfdhdb.siteguid[4]: 0 ; 0x08c: 0x00 |
asm diskgroup mount 명령 실행
1 2 3 4 5 6 7 | SQL> alter diskgroup DATA mount; alter diskgroup DATA mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15017: diskgroup "DATA" cannot be mounted ORA-15040: diskgroup is incomplete |
똑같이 에러 발생함
원인 : DATA diskgroup의 문제
정확한 원인은 파악 불가
참조 : http://pauldbang.blogspot.com/2015/02/how-to-repair-disk-in-diskgroup.html