#RAC ASM Redo Logfile duplicate
|
#REDO LOG Check |
|
SQL> select INST_ID, GROUP#,THREAD#,MEMBERS,STATUS,BYTES/1024/1024 from gv$log |
|
INST_ID GROUP# STATUS TYPE MEMBER IS_ CON_ID ---------- ---------- ------- ------- ------------------------------ --- ---------- 1 2 ONLINE +DATA/CDBRAC/ONLINELOG/group_2.296.958489161 NO 0 1 1 ONLINE +DATA/CDBRAC/ONLINELOG/group_1.297.958489161 NO 0 1 3 ONLINE +DATA/CDBRAC/ONLINELOG/group_3.293.958489337 NO 0 1 4 ONLINE +DATA/CDBRAC/ONLINELOG/group_4.292.958489337 NO 0 2 2 ONLINE +DATA/CDBRAC/ONLINELOG/group_2.296.958489161 NO 0 2 1 ONLINE +DATA/CDBRAC/ONLINELOG/group_1.297.958489161 NO 0 2 3 ONLINE +DATA/CDBRAC/ONLINELOG/group_3.293.958489337 NO 0 2 4 ONLINE +DATA/CDBRAC/ONLINELOG/group_4.292.958489337 NO 0 |
|
SQL> elect INST_ID,GROUP#,THREAD#,MEMBERS,STATUS,BYTES/1024/1024 from gv$log order by INST_ID,THREAD# THREAD# |
|
INST_ID GROUP# THREAD# MEMBERS STATUS BYTES/1024/1024 ---------- ---------- ---------- ---------- ---------------- --------------- --------------- 1 1 1 1 CURRENT 200 1 2 1 1 UNUSED 200 1 3 2 1 CURRENT 200 1 4 2 1 UNUSED 200 2 1 1 1 CURRENT 200 2 2 1 1 UNUSED 200 2 3 2 1 CURRENT 200 2 4 2 1 UNUSED 200 |
|
#REDO LOGFILE CREATION |
|
#NODE 1 |
|
alter system switch logfile; ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 1 alter system switch logfile; ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 2 alter system switch logfile; ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 3 alter system switch logfile; ALTER DATABASE ADD LOGFILE MEMBER '+DATA' TO GROUP 4 alter system switch logfile; |
|
#Delete SQL ALTER DATABASE DROP LOGFILE MEMBER '/+DATA/CDBRAC/ONLINELOG/group_2 .296.958489161' |
|
#NODE 1 |
|
SQL> select * from gv$logfile; |
|
INST_ID GROUP# STATUS TYPE MEMBER IS_ CON_ID ---------- ---------- ------- ------- ------------------------------ --- ---------- 1 2 ONLINE +DATA/CDBRAC/ONLINELOG/group_2.296.958489161 NO 0 1 1 ONLINE +DATA/CDBRAC/ONLINELOG/group_1.297.958489161 NO 0 1 3 ONLINE +DATA/CDBRAC/ONLINELOG/group_3.293.958489337 NO 0 1 4 ONLINE +DATA/CDBRAC/ONLINELOG/group_4.292.958489337 NO 0 1 1 ONLINE +DATA/CDBRAC/ONLINELOG/group_1.304.958493001 NO 0 1 4 ONLINE +DATA/CDBRAC/ONLINELOG/group_4.305.958493129 NO 0 1 3 ONLINE +DATA/CDBRAC/ONLINELOG/group_3.306.958493199 NO 0 1 2 ONLINE +DATA/CDBRAC/ONLINELOG/group_2.307.958493263 NO 0 2 2 ONLINE +DATA/CDBRAC/ONLINELOG/group_2.296.958489161 NO 0 2 1 ONLINE +DATA/CDBRAC/ONLINELOG/group_1.297.958489161 NO 0 2 3 ONLINE +DATA/CDBRAC/ONLINELOG/group_3.293.958489337 NO 0 2 4 ONLINE +DATA/CDBRAC/ONLINELOG/group_4.292.958489337 NO 0 2 1 ONLINE +DATA/CDBRAC/ONLINELOG/group_1.304.958493001 NO 0 2 4 ONLINE +DATA/CDBRAC/ONLINELOG/group_4.305.958493129 NO 0 2 3 ONLINE +DATA/CDBRAC/ONLINELOG/group_3.306.958493199 NO 0 2 2 ONLINE +DATA/CDBRAC/ONLINELOG/group_2.307.958493263 NO 0 |
|
SQL> select INST_ID, GROUP#,THREAD#,MEMBERS,STATUS,BYTES/1024/1024 from gv$log order by INST_ID,THREAD#; |
|
INST_ID GROUP# THREAD# MEMBERS STATUS BYTES/1024/1024 ---------- ---------- ---------- ---------- ---------------- --------------- --------------- 1 1 1 2 INACTIVE 200 1 2 1 2 CURRENT 200 1 3 2 2 CURRENT 200 1 4 2 2 INACTIVE 200 2 1 1 2 INACTIVE 200 2 2 1 2 CURRENT 200 2 3 2 2 CURRENT 200 2 4 2 2 INACTIVE 200 |
'Oracle > Oracle DBMS(RAC)' 카테고리의 다른 글
| Oracle RAC SCM0 프로세스 CPU 사용률 이슈 (0) | 2022.07.05 |
|---|---|
| Oracle RAC VIP Relocate (오라클 RAC VIP 수동 재 할당) (0) | 2022.03.07 |
| RAC ASM Control file duplication(ASM 컨트롤파일 이중화) (0) | 2017.10.31 |
댓글