1 AWS REDO 로그 사이즈 변경[편집]

128MB 로그 파일을 512MB로 변경하기

1.1 현재 로그 확인[편집]

/* 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

1.2 로그파일 추가(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

1.3 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. */

1.4 스위치 로그 발생[편집]

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

1.5 체크포인트 발생[편집]

/* 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

Redo aws 사이즈조정

DB CAFE

목차