The method you will use here is very similar to the method used to move
datafiles with the alter database method.
SQL> select group#, member from v$logfile
2 order by group#, member;
GROUP# MEMBER
---------- --------------------------------------------
1 /u01/app/oracle/oradata/redo01.log
1 /u05/oradata/redo01.log
2 /u01/app/oracle/oradata/redo02.log
2 /u05/oradata/redo02.log
3 /u01/app/oracle/oradata/redo03.log
3 /u05/oradata/redo03.log
6 rows selected.
Chapter 4: Physical Database Layouts and Storage Management 95
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ! mv /u01/app/oracle/oradata/redo0[1-3].log /u04/oradata
SQL> startup mount
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1299112 bytes
Variable Size 230690136 bytes
Database Buffers 184549376 bytes
Redo Buffers 6131712 bytes
Database mounted.
SQL> alter database rename file '/u01/app/oracle/oradata/redo01.log'
2 to '/u04/oradata/redo01.log';
Database altered.
SQL> alter database rename file '/u01/app/oracle/oradata/redo02.log'
2 to '/u04/oradata/redo02.log';
Database altered.
SQL> alter database rename file '/u01/app/oracle/oradata/redo03.log'
2 to '/u04/oradata/redo03.log';
Database altered.
SQL> alter database open;
Database altered.
SQL> select group#, member from v$logfile
2 order by group#, member;
GROUP# MEMBER
---------- ------------------------------------------
1 /u04/oradata/redo01.
Pages:
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192