About DATABASE

상태 확인

[root@arac1 dev]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARTEST.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
중 략
--------------------------------------------------------------------------------

디스크 그룹 파괴
[root@arac1 dev]# dd if=/dev/zero of=/dev/ARTEST/ARTESTLV count=1000
1000+0 records in
1000+0 records out
512000 bytes (512 kB) copied, 0.00114053 s, 449 MB/s

확인 - 오프라인 상태로 변경 됨
[+ASM1:/home/grid]> asmcmd
ASMCMD> ls
ARTEST/
CRS/
DATA/
FRA/
MGMT/
ASMCMD> cd artest
ASMCMD> ls

[root@arac1 ARTEST]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARTEST.dg
               OFFLINE OFFLINE      arac1                    STABLE
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       arac1                    STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       arac1                    169.254.51.97 192.16
                                                             8.0.111,STABLE
ora.arac1.vip
      1        ONLINE  ONLINE       arac1                    STABLE
ora.arac2.vip
      1        ONLINE  INTERMEDIATE arac1                    FAILED OVER,STABLE
ora.aracdb.db
      1        ONLINE  ONLINE       arac1                    Open,HOME=/u01/app/o
                                                             racle/product/12c/db
                                                             _1,STABLE
      2        OFFLINE OFFLINE                               STABLE
  

로 그
  
2024-02-22T11:16:08.730714+09:00
GMON dismounting group 1 at 27 for pid 44, osid 21554
2024-02-22T11:16:08.905072+09:00
System State dumped to trace file /u01/app/oracle/diag/asm/+asm/+ASM1/incident/incdir_214849/+ASM1_ora_21498_i214849.trc
2024-02-22T11:16:08.950506+09:00
ami_comp:dbgrip.c@16254:SQL> alter diskgroup ARTEST check
2024-02-22T11:16:09.156303+09:00
NOTE: cache deleting context for group ARTEST 1/0x47c6226f
2024-02-22T11:16:09.796926+09:00
NOTE: Disk ARTEST_0000 in mode 0x7f marked for de-assignment
2024-02-22T11:16:09.801824+09:00
SUCCESS: diskgroup ARTEST was dismounted
2024-02-22T11:16:09.802800+09:00
SUCCESS: alter diskgroup ARTEST dismount force /* ASM SERVER:1204167279 */
2024-02-22T11:16:09.805146+09:00
ami_comp:dbgrip.c@16254:ORA-15032: not all alterations performed
ami_comp:dbgrip.c@16254:ORA-15001: diskgroup "ARTEST" does not exist or is not mounted
ami_comp:dbgrip.c@16254:ORA-15001: diskgroup "1" does not exist or is not mounted
ami_comp:dbgrip.c@16254:
2024-02-22T11:16:09.805723+09:00
ami_comp:dbgrip.c@16254:ERROR: alter diskgroup ARTEST check
ami_comp:dbgrip.c@16254:Some DDE async actions failed or were cancelled
2024-02-22T11:16:09.813709+09:00
SUCCESS: ASM-initiated MANDATORY DISMOUNT of group ARTEST
2024-02-22T11:16:09.918350+09:00
NOTE: diskgroup resource ora.ARTEST.dg is offline



select group_number, name, state from v$asm_diskgroup;
GROUP_NUMBER NAME                     STATE
------------ ------------------------ ---------------------------------
           2 CRS                      MOUNTED
           3 DATA                     MOUNTED
           4 FRA                      MOUNTED
           5 MGMT                     MOUNTED


삭제 실패
SQL> drop diskgroup ARTEST force including contents
  2  ;
drop diskgroup ARTEST force including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ARTEST"

그냥 crs에서 삭제 한다. 오라클 문서 1478128.1
crsctl delete resource ora.ARTEST.dg

12.2.0.1 기준 아래 방법으로 해야 된다
srvctl remove diskgroup -g ARTEST -f

삭제 완료
[+ASM1:/home/grid]> srvctl remove diskgroup -g ARTEST -f
[+ASM1:/home/grid]> crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.CRS.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       arac1                    STABLE
ora.MGMT.dg
               ONLINE  ONLINE       arac1                    STABLE
ora.chad
               ONLINE  ONLINE       arac1                    STABLE
ora.net1.network
               ONLINE  ONLINE       arac1                    STABLE
ora.ons
               ONLINE  ONLINE       arac1                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      arac1                    STABLE

참조 : ORA-015039, ORA-15063: ASM Discovered An Insufficient Number Of Disks For Diskgroup (문서 ID 1478128.1)