Redo log file 관리 II - 추가 Redo log 멤버를 '/u01/app/oracle/disk2/'에 추가

HighLighter 2012. 12. 27. 12:44

-- Redo log file 관리 II - 추가 Redo log 멤버를 '/u01/app/oracle/disk2/'에 추가
-- 실전 오라클 백업과 복구(생능출판사, 서진수 지음), p.122
-- /u01/app/oracle/disk1/redo01_a.log, redo02_a.log, redo03_a.log
-- /u01/app/oracle/disk2/redo01_b.log, redo02_b.log, redo03_b.log

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

SQL> alter database add logfile member
'/u01/app/oracle/disk2/redo01_b.log' to group 1;

SQL> alter database add logfile member
'/u01/app/oracle/disk2/redo02_b.log' to group 2;

SQL> alter database add logfile member
'/u01/app/oracle/disk2/redo03_b.log' to group 3;

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

    GROUP# MEMBER                                                     MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
         1 /u01/app/oracle/disk1/redo01_a.log                         50 NO     INACTIVE
         1 /u01/app/oracle/disk2/redo01_b.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk1/redo02_a.log                         50 NO     INACTIVE
         2 /u01/app/oracle/disk2/redo02_b.log                         50 NO     INACTIVE
         3 /u01/app/oracle/disk1/redo03_a.log                         50 NO     CURRENT
         3 /u01/app/oracle/disk2/redo03_b.log                         50 NO     CURRENT