1개의 멤버가 삭제되는 장애 발생
SYS>startup
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1344616 bytes
Variable Size 293604248 bytes
Database Buffers 121634816 bytes
Redo Buffers 6086656 bytes
Database mounted.
Database opened.
log.sql 파일 내용
SYS>!vi log.sql
set line 200
col group# for 999
col mb for 999
col member for a45
col seq# for 999
col status for a8
col arc for a5
SELECT a.group#,a.member,b.bytes /1024/1024 MB, b.sequence# "SEQ#", b.status,
b.archived "ARC"
FROM v$logfile a,v$log b
where a.group#=b.group#
order by 1,2
/
SYS>!vi log.sql
SYS>@log
GROUP# MEMBER MB SEQ# STATUS ARC
------ --------------------------------------------- ---- ---- -------- -----
1 /data/temp7/redo01_a.log 5 57 CURRENT NO
1 /data/temp7/redo01_b.log 5 57 CURRENT NO
2 /data/temp7/redo02_a.log 5 56 INACTIVE YES
2 /data/temp7/redo02_b.log 5 56 INACTIVE YES
redo01_a.log 삭제
[oracle@localhost ~]$ rm -f /data/temp7/redo01_a.log
[oracle@localhost ~]$ ls -al /data/temp7/*.log
-rw-r----- 1 oracle oinstall 5243392 Nov 6 02:49 /data/temp7/redo01_b.log
-rw-r----- 1 oracle oinstall 5243392 Nov 6 02:46 /data/temp7/redo02_a.log
-rw-r----- 1 oracle oinstall 5243392 Nov 6 02:46 /data/temp7/redo02_b.log
[oracle@localhost ~]$ exit
exit
SYS>alter system switch logfile;
System altered.
SYS>/
System altered.
SYS>/
System altered.
SYS>/
System altered.
파일을 지웠지만 있다고 나옴
SYS>@log
GROUP# MEMBER MB SEQ# STATUS ARC
------ --------------------------------------------- ---- ---- -------- -----
1 /data/temp7/redo01_a.log 5 61 CURRENT NO
1 /data/temp7/redo01_b.log 5 61 CURRENT NO
2 /data/temp7/redo02_a.log 5 60 INACTIVE YES
2 /data/temp7/redo02_b.log 5 60 INACTIVE YES
정확한 장애내용은 alert log 파일을 열어 확인
[oracle@localhost ~]$ vi $ORACLE_BASE/diag/rdbms/testdb/testdb/trace/alert_testdb.log
...생략
Errors in file /app/oracle/diag/rdbms/testdb/testdb/trace/testdb_arc1_7763.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/data/temp7/redo01_a.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
...생략
장애가 확인 된 멤버는 삭제 후 다시 생성하면 됨
SYS>@log
GROUP# MEMBER MB SEQ# STATUS ARC
------ --------------------------------------------- ---- ---- -------- -----
1 /data/temp7/redo01_a.log 5 61 CURRENT NO
1 /data/temp7/redo01_b.log 5 61 CURRENT NO
2 /data/temp7/redo02_a.log 5 60 INACTIVE YES
2 /data/temp7/redo02_b.log 5 60 INACTIVE YES
SYS>alter system switch logfile;
System altered.
SYS>@log
GROUP# MEMBER MB SEQ# STATUS ARC
------ --------------------------------------------- ---- ---- -------- -----
1 /data/temp7/redo01_a.log 5 61 ACTIVE YES
1 /data/temp7/redo01_b.log 5 61 ACTIVE YES
2 /data/temp7/redo02_a.log 5 62 CURRENT NO
2 /data/temp7/redo02_b.log 5 62 CURRENT NO
SYS>alter database drop logfile member
2 '/data/temp7/redo01_a.log';
Database altered.
SYS>@log
GROUP# MEMBER MB SEQ# STATUS ARC
------ --------------------------------------------- ---- ---- -------- -----
1 /data/temp7/redo01_b.log 5 61 ACTIVE YES
2 /data/temp7/redo02_a.log 5 62 CURRENT NO
2 /data/temp7/redo02_b.log 5 62 CURRENT NO
SYS>alter database add logfile member
2 '/data/temp7/redo01_a.log' to group 1;
Database altered.
SYS>@log
GROUP# MEMBER MB SEQ# STATUS ARC
------ --------------------------------------------- ---- ---- -------- -----
1 /data/temp7/redo01_a.log 5 61 INACTIVE YES
1 /data/temp7/redo01_b.log 5 61 INACTIVE YES
2 /data/temp7/redo02_a.log 5 62 CURRENT NO
2 /data/temp7/redo02_b.log 5 62 CURRENT NO
