SUNDB Redo Log 파일의 경로 변경
SYSDBA 계정으로 접속하여 DATABASE를 종료
gSQL> \connect as sysdba gSQL> \shutdown immediate; Shutdown success gSQL> gSQL> |
DATABASE를 MOUNT 상태로 startup
gSQL> \startup mount gSQL> gSQL> select * from v$instance; RELEASE_VERSION STARTUP_TIME INSTANCE_STATUS DATA_ACCESS_MODE ------------------------------------- -------------------------- --------------- ---------------- Release Mercury.2.2.1 revision(14629) 2015-03-31 13:37:34.361397 MOUNTED NONE 1 row selected. gSQL> |
현재의 Redo 로그 파일을 조회 (현재는 0~3번 까지 4개의 GROUP이 존재한다)
gSQL> select * from v$logfile; GROUP_ID FILE_NAME GROUP_STATE FILE_SEQ FILE_SIZE -------- ----------------------------------------------------------- ----------- -------- --------- 0 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_0_0.log CURRENT 4 104857600 1 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_1_0.log INACTIVE 1 104857600 2 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_2_0.log INACTIVE 2 104857600 3 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_3_0.log INACTIVE 3 104857600 4 rows selected. gSQL> |
group 4 를 추가해 본다. (기존 경로가 아닌 새로운 경로에 추가)
gSQL> alter database add logfile group 4 ('/home/sunje/sundb/sundb_mercury/sundb_data/db/redo_4_0.log') size 15m; Database altered. gSQL> select * from v$logfile; GROUP_ID FILE_NAME GROUP_STATE FILE_SEQ FILE_SIZE -------- ----------------------------------------------------------- ----------- -------- --------- 0 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_0_0.log CURRENT 4 104857600 4 /home/sunje/sundb/sundb_mercury/sundb_data/db/redo_4_0.log UNUSED -1 15728640 1 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_1_0.log INACTIVE 1 104857600 2 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_2_0.log INACTIVE 2 104857600 3 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_3_0.log INACTIVE 3 104857600 5 rows selected. gSQL> alter system switch logfile; System altered. gSQL> select * from v$logfile; GROUP_ID FILE_NAME GROUP_STATE FILE_SEQ FILE_SIZE -------- ----------------------------------------------------------- ----------- -------- --------- 0 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_0_0.log ACTIVE 4 104857600 4 /home/sunje/sundb/sundb_mercury/sundb_data/db/redo_4_0.log CURRENT 5 15728640 1 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_1_0.log INACTIVE 1 104857600 2 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_2_0.log INACTIVE 2 104857600 3 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_3_0.log INACTIVE 3 104857600 5 rows selected. |
기존 Redo 로그파일인 3번을 삭제한다.
gSQL> alter database drop logfile group 3; Database altered. gSQL> gSQL> select * from v$logfile; GROUP_ID FILE_NAME GROUP_STATE FILE_SEQ FILE_SIZE -------- ----------------------------------------------------------- ----------- -------- --------- 0 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_0_0.log ACTIVE 4 104857600 4 /home/sunje/sundb/sundb_mercury/sundb_data/db/redo_4_0.log CURRENT 5 15728640 5 /home/sunje/sundb/sundb_mercury/sundb_data/db/redo_5_0.log UNUSED -1 15728640 1 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_1_0.log INACTIVE 1 104857600 2 /home/sunje/sundb/sundb_mercury/sundb_data/wal/redo_2_0.log INACTIVE 2 104857600 5 rows selected. |
DATABASE를 OPEN하여 사용할수 있다.
gSQL> alter system open database; System altered. gSQL> select * from v$instance; RELEASE_VERSION STARTUP_TIME INSTANCE_STATUS DATA_ACCESS_MODE ------------------------------------- -------------------------- --------------- ---------------- Release Mercury.2.2.1 revision(14629) 2015-03-31 13:37:34.361397 OPEN READ_WRITE 1 row selected. gSQL> |
