Redo log file 구성 및 관리

log switch 및 checkpoint 명령

 

SQL> alter system switch logfile; <= 강제 로그 스위치 발생

SQL> alter system checkpoing; <- 강제 checkpoint 발생

 

SQL>select a.group#,a.member,b.bytes/1024/1024 MB,b.archived,b.sequence# "SEQ#", b.status
from v$logfile a,v$log b
where a.group# = b.group#
order by 1,2

 

 

redo log group 및 member 추가

 

SQL> alter database add logfile group 4

'/home/oracle/oradata/testdb/redo04_a.log' size 10m;

 

SQL> alter database add logfile member

'/home/oracle/oradata/testdb/redo04_b.log' to group 4;

 

redo log group 및 member 삭제

 

SQL> alter database drop logfile group 4;

 

SQL>alter database drop logfile member

'/home/oracle/oradata/testdb/redo04_b.log';

 

★ Redo 같은경우는 group이나 member 삭제 할경우 OS에서 수동으로 삭제해주어야한다