Redo Log Group과 Member 관리

# 참조 : http://docs.oracle.com/cd/B28359_01/server.111/b28310/onlineredo003.htm

# 신규 redo log group 생성(default)

ALTER DATABASE ADD LOGFILE ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 4M ;

# 신규 redo log group 생성(group number 지정)

ALTER DATABASE ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 4M ;

# redo log member 추가

ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.rdo' TO GROUP 2;

# redo log 파일로 member  추가

ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2c.rdo' TO ('/oracle/dbs/log2a.rdo', '/oracle/dbs/log2b.rdo') ;