Oracle/MySQL 관련 게시판

Oracle/MySQL 관련 게시판

2002/09/25(17:07) from 211.169.72.154
작성자 : 강줄기 (jkkang65@hanmail.net)	조회수 : 4071 , 줄수 : 52

[Oracle] 로그파일 추가, 삭제, 변경하기

1. 추가

SVRMGR> select * from v$log;
GROUP#     THREAD#    SEQUENCE# BYTES      MEMBERS    ARC STATUS           FIRST_CHAN FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ---------- ---------
        1          1         45     204800          1 NO CURRENT               25693 25-SEP-02
        2          1         44     204800          1 NO INACTIVE               5626 25-SEP-02

SVRMGR> select * from v$logfile;
GROUP#     STATUS MEMBER
---------- ------- --------------------------------------------------------------------------------
        1         /oracle/app/oracle/product/8.1.7/oradata/ORA817/log1a.rdo
        2 STALE   /oracle/app/oracle/product/8.1.7/oradata/ORA817/log2a.rdo
2 rows selected.
SVRMGR> alter database add logfile member '/oracle/app/oracle/product/8.1.7/oradata/ORA817_BK/log1b.rdo' To group 1;
Statement processed.

SVRMGR> select * from v$logfile;
GROUP#     STATUS MEMBER
---------- ------- --------------------------------------------------------------------------------
        1         /oracle/app/oracle/product/8.1.7/oradata/ORA817/log1a.rdo
        2 STALE   /oracle/app/oracle/product/8.1.7/oradata/ORA817/log2a.rdo
        1 INVALID /oracle/app/oracle/product/8.1.7/oradata/ORA817_BK/log1b.rdo
3 rows selected.

SVRMGR> alter database add logfile member '/oracle/app/oracle/product/8.1.7/oradata/ORA817_BK/log2b.rdo' to group 2;
Statement processed.

SVRMGR> select * from v$logfile;
GROUP#     STATUS MEMBER
---------- ------- --------------------------------------------------------------------------------
        1         /oracle/app/oracle/product/8.1.7/oradata/ORA817/log1a.rdo
        2 STALE   /oracle/app/oracle/product/8.1.7/oradata/ORA817/log2a.rdo
        1 INVALID /oracle/app/oracle/product/8.1.7/oradata/ORA817_BK/log1b.rdo
        2 INVALID /oracle/app/oracle/product/8.1.7/oradata/ORA817_BK/log2b.rdo
4 rows selected.

2. 삭제

SVRMGR> alter database ORA817
    2> drop logfile member '/oracle/app/oracle/product/8.1.7/oradata/ORA817_BK/log2b.rdo';

3. 변경

SVRMGR> alter database ORA817
    2> rename file '/oracle/app/oracle/product/8.1.7/oradata/ORA817/log2a.rdo' to '/oracle/app/oracle/product/8.1.7/oradata
/ORA817/log3a.rdo'
    3> ;