OracleのREDOログを移動する備忘録
2009 年 6 月 23 日
Comments off
すぐに忘れるのでメモ。
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’;