OracleのREDOログを移動する備忘録

すぐに忘れるのでメモ。

Oracle 9iで実行。

移動先にファイルが存在したら失敗するので、あるなら削除する。

del /PATH_TO_MOVE/NEWREDO01.LOG

del /PATH_TO_MOVE/NEWREDO02.LOG

del /PATH_TO_MOVE/NEWREDO03.LOG

sqlplus “sys/password@hogehoge as sysdba”

ALTER DATABASE ADD LOGFILE MEMBER ‘/PATH_TO_MOVE/NEWREDO01.LOG’ TO GROUP 1;

ALTER DATABASE ADD LOGFILE MEMBER ‘/PATH_TO_MOVE/NEWREDO02.LOG’ TO GROUP 2;

ALTER DATABASE ADD LOGFILE MEMBER ‘/PATH_TO_MOVE/NEWREDO03.LOG’ TO GROUP 3;

ALTER SYSTEM SWITCH LOGFILE;

ALTER SYSTEM SWITCH LOGFILE;

ALTER SYSTEM SWITCH LOGFILE;

ALTER DATABASE DROP LOGFILE MEMBER ‘/PATH_TO_DELETE/OLDREDO01.LOG’;

ALTER DATABASE DROP LOGFILE MEMBER ‘/PATH_TO_DELETE/OLDREDO02.LOG’;

ALTER DATABASE DROP LOGFILE MEMBER ‘/PATH_TO_DELETE/OLDREDO03.LOG’;