다른 명령
AWS REDO 로그 사이즈 변경
- 128MB 로그 파일을 512MB로 변경하기
현재 로그 확인
/* Query V$LOG to see the logs. */ /* You start with 4 logs of 128 MB each. */
select GROUP#, BYTES, STATUS from V$LOG;
GROUP# BYTES STATUS ---------- ---------- ---------------- 1 134217728 INACTIVE 2 134217728 CURRENT 3 134217728 INACTIVE 4 134217728 INACTIVE
로그파일 추가(512MB)
/* Add four new logs that are each 512 MB */
AWS >>>> exec rdsadmin.rdsadmin_util.add_logfile(bytes => 536870912); exec rdsadmin.rdsadmin_util.add_logfile(bytes => 536870912); exec rdsadmin.rdsadmin_util.add_logfile(bytes => 536870912); exec rdsadmin.rdsadmin_util.add_logfile(bytes => 536870912);
- 오라클 명령
-- 그룹추가
alter database add logfile group 4
'/app/oracle/oradata/testdb/redo04_a.log' size 5M ;
-- 멤버추가
alter database add logfile member
'/app/oracle/oradata/testdb/redo04_b.log' to group 4 ;
/* Query V$LOG to see the logs. */ /* Now there are 8 logs. */
select GROUP#, BYTES, STATUS from V$LOG;
GROUP# BYTES STATUS ---------- ---------- ---------------- 1 134217728 INACTIVE 2 134217728 CURRENT 3 134217728 INACTIVE 4 134217728 INACTIVE 5 536870912 UNUSED 6 536870912 UNUSED 7 536870912 UNUSED 8 536870912 UNUSED
128MB사이즈 로그 파일 삭제
/* Drop each inactive log using the group number. */ /* 2번은 사용중이므로 삭제 불가 */
AWS >>>> exec rdsadmin.rdsadmin_util.drop_logfile(grp => 1); exec rdsadmin.rdsadmin_util.drop_logfile(grp => 3); exec rdsadmin.rdsadmin_util.drop_logfile(grp => 4);
--멤버 삭제
alter database drop logfile member
'/app/oracle/oradata/testdb/redo04_b.log' ;
-- 그룹삭제
alter database drop logfile group 4;
/* Query V$LOG to see the logs. */ /* Now there are 5 logs. */
select GROUP#, BYTES, STATUS from V$LOG;
GROUP# BYTES STATUS ---------- ---------- ---------------- 2 134217728 CURRENT 5 536870912 UNUSED 6 536870912 UNUSED 7 536870912 UNUSED 8 536870912 UNUSED
/* Switch logs so that group 2 is no longer current. */
스위치 로그 발생
AWS >>>> exec rdsadmin.rdsadmin_util.switch_logfile;
alter system switch logfile;
/* Query V$LOG to see the logs. */ /* Now one of the new logs is current. */
SQL>select GROUP#, BYTES, STATUS from V$LOG;
GROUP# BYTES STATUS ---------- ---------- ---------------- 2 134217728 ACTIVE 5 536870912 CURRENT 6 536870912 UNUSED 7 536870912 UNUSED 8 536870912 UNUSED
체크포인트 발생
/* Issue a checkpoint to clear log 2. */
AWS >>>> exec rdsadmin.rdsadmin_util.checkpoint;
alter system checkpoint;
/* Query V$LOG to see the logs. */ /* Now the final original log is inactive. */
select GROUP#, BYTES, STATUS from V$LOG;
GROUP# BYTES STATUS ---------- ---------- ---------------- 2 134217728 INACTIVE 5 536870912 CURRENT 6 536870912 UNUSED 7 536870912 UNUSED 8 536870912 UNUSED
- Drop the final inactive log.
AWS >>>> exec rdsadmin.rdsadmin_util.drop_logfile(grp => 2);
/* Query V$LOG to see the logs. */ /* Now there are four 512 MB logs. */
select GROUP#, BYTES, STATUS from V$LOG;
GROUP# BYTES STATUS ---------- ---------- ---------------- 5 536870912 CURRENT 6 536870912 UNUSED 7 536870912 UNUSED 8 536870912 UNUSED