Moving Oracle Redo log files step by step
1-Query the v$logfile table to find the logiles location.
SQL> SELECT member FROM v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u00/oracle/oradata/RCAT/redo03.log
/u00/oracle/oradata/RCAT/redo02.log
/u00/oracle/oradata/RCAT/redo01.log
2-Shutdown your database.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
3-Move your redologs to the new location.
mv /u00/oracle/oradata/RCAT/redo03.log /u01/oracle/oradata/RCAT/redo03.log
mv /u00/oracle/oradata/RCAT/redo02.log /u01/oracle/oradata/RCAT/redo02.log
mv /u00/oracle/oradata/RCAT/redo01.log /u01/oracle/oradata/RCAT/redo01.log
4-Start your database in mount mode and rename your logfiles.
ALTER DATABASE RENAME FILE '/u00/oracle/oradata/RCAT/redo03.log' to '/u01/oracle/oradata/RCAT/redo03.log';
ALTER DATABASE RENAME FILE '/u00/oracle/oradata/RCAT/redo02.log' to '/u01/oracle/oradata/RCAT/redo02.log';
ALTER DATABASE RENAME FILE '/u00/oracle/oradata/RCAT/redo01.log' to '/u01/oracle/oradata/RCAT/redo01.log';
5-Open your database.
SQL> ALTER DATABASE OPEN;
Database altered.
