change the path of redo log file

changing the path of REDO log file is the same as datafile and temporary file

1.keep the instance shutdown
SQL> SHUTDOWN IMMEDIATE
2.host copy the datafile to new location

SQL> HOST COPY F:oradataaaaREDO01.DBF F:oradata2aaaREDO01.DBF
The system cannot find the file specified.

SQL> HOST COPY F:oradataaaaREDO01.LOG F:oradata2aaaREDO01.LOG
1 file(s) copied.

SQL> HOST COPY F:oradataaaaREDO02.LOG F:oradata2aaaREDO02.LOG
1 file(s) copied.

SQL> HOST COPY F:oradataaaaREDO03.LOG F:oradata2aaaREDO03.LOG
1 file(s) copied.

3.start the database to mount stage

SQL> STARTUP MOUNT;
Total System Global Area 612368384 bytes
Fixed Size 1304728 bytes
Variable Size 167774056 bytes
Database Buffers 436207616 bytes
Redo Buffers 7081984 bytes

3.change the path of redo log file
SQL> alter database rename file ‘F:ORADATAAAAREDO01.LOG’ to ‘F:ORADATA2AAAREDO01.LOG’;

database altered

SQL> alter database rename file ‘F:ORADATAAAAREDO02.LOG’ to ‘F:ORADATA2AAAREDO02.LOG’;

database altered

SQL> alter database rename file ‘F:ORADATAAAAREDO03.LOG’ to ‘F:ORADATA2AAAREDO03.LOG’;

database altered

SQL> ALTER DATABASE OPEN;

database altered

SQL>
SQL> select status from v$instance;

STATUS
————————
OPEN

ok,everything was done!!