ORA-15041: diskgroup "RECO01" space exhausted

원인 : ASM 디스크영역 중 RECO와 관련된 영역의 용량이 없어서 생기는 현상

조치 : diskgroup에 disk를 추가하거나 아카이브,백업 삭제 

 

crsctl stat -t 내용

Stuck Archiver라고 보임.

ora.dbarac.db
      1        ONLINE  INTERMEDIATE dbarac1                  Stuck Archiver,HOME=
                                                             /oracle/db/product/1
                                                             2.2.0,STABLE
      2        ONLINE  INTERMEDIATE dbarac2                  Stuck Archiver,HOME=
                                                             /oracle/db/product/1
                                                             2.2.0,STABLE

 

Alert log 내용

ORA-15041: diskgroup "DG_RECO01" space exhausted
ARC0: Error 19504 Creating archive log file to '+DG_RECO01'
krsd_check_stuck_arch: stuck archiver: insufficient local LADs
krsd_check_stuck_arch: stuck archiver condition declared

 

아카이브 삭제.

RMAN > delete archivelog all completed before 'sysdate -30';

...생략
3931    2    1393    A 18-NOV-22
        Name: +DG_RECO01/DBARAC/ARCHIVELOG/2022_11_19/thread_2_seq_1393.452.1121148489

3934    2    1394    A 19-NOV-22
        Name: +DG_RECO01/DBARAC/ARCHIVELOG/2022_11_19/thread_2_seq_1394.447.1121206601


Do you really want to delete the above objects (enter YES or NO)? yes

...생략
archived log file name=+DG_RECO01/DBARAC/ARCHIVELOG/2022_11_19/thread_2_seq_1394.447.1121206601 RECID=3934 STAMP=1121206601
Deleted 223 objects

삭제 후 용량확인

SQL> select name,state,total_mb,free_mb from v$asm_diskgroup
where name='DG_RECO01';

NAME                           STATE       TOTAL_MB         FREE_MB        
------------------------------ ----------- ---------------- -------------- 
DG_RECO01                      CONNECTED             102400          71869

 

crsctl stat res -t

원래상태인 OPEN으로 변경된것을 확인하였습니다.

ora.dbarac.db
      1        ONLINE  ONLINE       dbarac1                  Open,HOME=/oracle/db
                                                             /product/12.2.0,STAB
                                                             LE
      2        ONLINE  ONLINE       dbarac2                  Open,HOME=/oracle/db
                                                             /product/12.2.0,STAB
                                                             LE

끝