반응형
1. 테스트 환경
DB명 : DRDBNEW
RAC1번 : rdb01d(192.168.0.31) 서버 내 DRDBNEW1 인스턴스
RAC2번 : rdb02d(192.168.0.32) 서버 내 DRDBNEW2 인스턴스
2. 현재 redo log 상태 확인
[2025-05-25:12:46:12][rdb01d]<SYS@DRDBNEW1>
col member for a56
col status for a15
select l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) "Size (MB)" from v$log l, v$logfile f where f.group# = l.group# order by 1,2;
GROUP# THREAD# MEMBER ARCHIVED STATUS Size (MB)
---------- ---------- -------------------------------------------------------- --------- --------------- ----------
1 1 +FRA1/DRDBNEW/ONLINELOG/group_1.257.1201396985 YES INACTIVE 200
1 1 +DATA1/DRDBNEW/ONLINELOG/group_1.263.1201396985 YES INACTIVE 200
2 1 +FRA1/DRDBNEW/ONLINELOG/group_2.258.1201396987 NO CURRENT 200
2 1 +DATA1/DRDBNEW/ONLINELOG/group_2.262.1201396987 NO CURRENT 200
3 2 +FRA1/DRDBNEW/ONLINELOG/group_3.259.1201396989 NO CURRENT 200
3 2 +DATA1/DRDBNEW/ONLINELOG/group_3.266.1201396989 NO CURRENT 200
4 2 +FRA1/DRDBNEW/ONLINELOG/group_4.260.1201396991 YES INACTIVE 200
4 2 +DATA1/DRDBNEW/ONLINELOG/group_4.267.1201396991 YES INACTIVE 200
11 1 +FRA1/DRDBNEW/ONLINELOG/group_11.304.1201396991 YES INACTIVE 200
11 1 +DATA1/DRDBNEW/ONLINELOG/group_11.277.1201396993 YES INACTIVE 200
12 2 +FRA1/DRDBNEW/ONLINELOG/group_12.314.1201396993 YES INACTIVE 200
12 2 +DATA1/DRDBNEW/ONLINELOG/group_12.280.1201396995 YES INACTIVE 200
12 rows selected.
Elapsed: 00:00:00.09--> 새로 추가하는 redo log는 group 15, 16, 17, 18을 사용을 사용할 것임
3. redo log 추가
--RAC1번
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 15 ('+DATA1','+FRA1') SIZE 200M;
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 16 ('+DATA1','+FRA1') SIZE 200M;
--RAC2번
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 17 ('+DATA1','+FRA1') SIZE 200M;
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 18 ('+DATA1','+FRA1') SIZE 200M;
4. redo log 그룹 삭제
--> 지금부터 redo log 그룹을 삭제하는 것도 해보겠음
col member for a56
col status for a15
select l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) "Size (MB)"
from v$log l, v$logfile f where f.group# = l.group# order by 1,2
;
GROUP# THREAD# MEMBER ARCHIVED STATUS Size (MB)
---------- ---------- -------------------------------------------------------- --------- --------------- ----------
1 1 +FRA1/DRDBNEW/ONLINELOG/group_1.257.1201396985 YES INACTIVE 200
1 1 +DATA1/DRDBNEW/ONLINELOG/group_1.263.1201396985 YES INACTIVE 200
2 1 +FRA1/DRDBNEW/ONLINELOG/group_2.258.1201396987 NO CURRENT 200
2 1 +DATA1/DRDBNEW/ONLINELOG/group_2.262.1201396987 NO CURRENT 200
3 2 +FRA1/DRDBNEW/ONLINELOG/group_3.259.1201396989 NO CURRENT 200
3 2 +DATA1/DRDBNEW/ONLINELOG/group_3.266.1201396989 NO CURRENT 200
4 2 +FRA1/DRDBNEW/ONLINELOG/group_4.260.1201396991 YES INACTIVE 200
4 2 +DATA1/DRDBNEW/ONLINELOG/group_4.267.1201396991 YES INACTIVE 200
11 1 +FRA1/DRDBNEW/ONLINELOG/group_11.304.1201396991 YES INACTIVE 200
11 1 +DATA1/DRDBNEW/ONLINELOG/group_11.277.1201396993 YES INACTIVE 200
12 2 +FRA1/DRDBNEW/ONLINELOG/group_12.314.1201396993 YES INACTIVE 200
12 2 +DATA1/DRDBNEW/ONLINELOG/group_12.280.1201396995 YES INACTIVE 200
15 1 +DATA1/DRDBNEW/ONLINELOG/group_15.286.1202043329 YES UNUSED 200
15 1 +FRA1/DRDBNEW/ONLINELOG/group_15.607.1202043333 YES UNUSED 200
16 1 +DATA1/DRDBNEW/ONLINELOG/group_16.287.1202043335 YES UNUSED 200
16 1 +FRA1/DRDBNEW/ONLINELOG/group_16.324.1202043335 YES UNUSED 200
17 2 +DATA1/DRDBNEW/ONLINELOG/group_17.288.1202043335 YES UNUSED 200
17 2 +FRA1/DRDBNEW/ONLINELOG/group_17.326.1202043337 YES UNUSED 200
18 2 +DATA1/DRDBNEW/ONLINELOG/group_18.289.1202043339 YES UNUSED 200
18 2 +FRA1/DRDBNEW/ONLINELOG/group_18.340.1202043339 YES UNUSED 200--> 지금부터 group 1과 3번을 drop할 것임
--> status가 current 혹은 active인 것을 날리면 큰일남
-- group 1번 날리기
[2025-05-25:12:46:12][rdb01d]<SYS@DRDBNEW1> alter database drop logfile group 1;
[2025-05-25:13:10:21][rdb02d]<SYS@DRDBNEW2> Alter system switch logfile;
[2025-05-25:13:10:21][rdb02d]<SYS@DRDBNEW2> alter system checkpoint;
--다시 확인
col member for a56
col status for a15
select l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) "Size (MB)"
from v$log l, v$logfile f where f.group# = l.group# order by 1,2
;
GROUP# THREAD# MEMBER ARCHIVED STATUS Size (MB)
---------- ---------- -------------------------------------------------------- --------- --------------- ----------
2 1 +FRA1/DRDBNEW/ONLINELOG/group_2.258.1201396987 NO CURRENT 200
2 1 +DATA1/DRDBNEW/ONLINELOG/group_2.262.1201396987 NO CURRENT 200
3 2 +FRA1/DRDBNEW/ONLINELOG/group_3.259.1201396989 YES INACTIVE 200
3 2 +DATA1/DRDBNEW/ONLINELOG/group_3.266.1201396989 YES INACTIVE 200
4 2 +FRA1/DRDBNEW/ONLINELOG/group_4.260.1201396991 YES INACTIVE 200
4 2 +DATA1/DRDBNEW/ONLINELOG/group_4.267.1201396991 YES INACTIVE 200
11 1 +FRA1/DRDBNEW/ONLINELOG/group_11.304.1201396991 YES INACTIVE 200
11 1 +DATA1/DRDBNEW/ONLINELOG/group_11.277.1201396993 YES INACTIVE 200
12 2 +FRA1/DRDBNEW/ONLINELOG/group_12.314.1201396993 YES INACTIVE 200
12 2 +DATA1/DRDBNEW/ONLINELOG/group_12.280.1201396995 YES INACTIVE 200
15 1 +DATA1/DRDBNEW/ONLINELOG/group_15.286.1202043329 YES INACTIVE 200
15 1 +FRA1/DRDBNEW/ONLINELOG/group_15.607.1202043333 YES INACTIVE 200
16 1 +DATA1/DRDBNEW/ONLINELOG/group_16.287.1202043335 YES INACTIVE 200
16 1 +FRA1/DRDBNEW/ONLINELOG/group_16.324.1202043335 YES INACTIVE 200
17 2 +DATA1/DRDBNEW/ONLINELOG/group_17.288.1202043335 NO CURRENT 200
17 2 +FRA1/DRDBNEW/ONLINELOG/group_17.326.1202043337 NO CURRENT 200
18 2 +DATA1/DRDBNEW/ONLINELOG/group_18.289.1202043339 YES INACTIVE 200
18 2 +FRA1/DRDBNEW/ONLINELOG/group_18.340.1202043339 YES INACTIVE 200
18 rows selected.--> status가 current 혹은 active인 것을 날리면 큰일남
-- group 3번 날리기
[2025-05-25:13:10:21][rdb02d]<SYS@DRDBNEW2> alter database drop logfile group 3;
--> ASM에 있는 실제 redo log 파일까지 날라감
반응형
'Oracle > RAC' 카테고리의 다른 글
| [2025-05-29] Interconnect Private IP 정보 변경(네트워크 인터페이스명 변경) (12cR2) (0) | 2025.07.13 |
|---|---|
| [2025-05-29] RAC환경에서 ORACLE LOCAL REGISTRY(OLR) 실습 (12cR2) (0) | 2025.07.13 |
| [2025-05-26] RAC환경에서 스캔 리스너 포트 설정 변경 (12cR2 기준) (1) | 2025.07.11 |
| [2025-05-25] 2 Node RAC 환경에서 drop database (12cR2) (1) | 2025.07.10 |
| [2025-05-25] 2 Node RAC 환경에서 Control File (컨트롤 파일) 다중화 실습 (RMAN 사용) (12cR2) (1) | 2025.07.09 |