Redo log 장애 - 1개의 member가 삭제되는 장애가 발생하는 경우

Redo log 장애 - 1개의 member가 삭제되는 장애가 발생하는 경우

# 처리 순서

1. redo log file 상태 확인

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

/

2. alert log에서 에러 확인

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/dbms/oracle/product/oradata/SOLEXTDEV/redo01_a.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

3. 에러가 발생한 redo log file memeber 삭제

alter database drop logfile member '/dbms/oracle/product/oradata/SOLEXTDEV/redo01_a.log' ;

4. 신규 redo log file memeber 추가

alter database add logfile member '/dbms/oracle/product/oradata/SOLEXTDEV/redo01_a.log' to group 1 ;

5. redo log file 상태 확인

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

오라클 백업과 복구(서진수 저) 중에서 ...