Redo log file 관리 II - 추가 Redo log 멤버를 '/u01/app/oracle/disk2/'에 추가
개발 및 관리/Oracle 9i, 10g, 11g, 12c, 19c 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
GROUP# MEMBER MB ARCHIV STATUS
---------- -------------------------------------------------- ---------- ------ ----------------------------
1 /u01/app/oracle/disk1/redo01_a.log 50 NO INACTIVE
2 /u01/app/oracle/disk1/redo02_a.log 50 NO INACTIVE
3 /u01/app/oracle/disk1/redo03_a.log 50 NO CURRENT
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
'개발 및 관리 > Oracle 9i, 10g, 11g, 12c, 19c' 카테고리의 다른 글
temporary tablespace 관리 방법 (0) | 2012.12.27 |
---|---|
undo tablespace 관리 방법 (0) | 2012.12.27 |
Control file과 Redo log file 관리 (0) | 2012.12.27 |
Redo log file 관리 방법 (0) | 2012.12.27 |
ORA-00346, ORA-00340 Error (0) | 2012.12.27 |