- OSコマンドでREDOログをリネームする。(mv すると、alter database rename file ... で失敗するので注意)
cp -p /home/oracle/redo1/* /export/home/oracle/orasys02/orcl/
startup mount
alter database rename file '/home/oracle/redo1/redo01.log'
to '/export/home/oracle/orasys02/orcl/redo01.log';
alter database rename file '/home/oracle/redo1/redo02.log'
to '/export/home/oracle/orasys02/orcl/redo02.log';
alter database rename file '/home/oracle/redo1/redo03.log'
to '/export/home/oracle/orasys02/orcl/redo03.log';
alter database open;
select member from v$logfile;