Databases Reference
In-Depth Information
For good performance we need to distribute the online redo log files on different disks, on
which little or no other I/O is performed. To do so, in step 4, we retrieve their current position,
as shown in the following screenshot:
In step 5 through step 9, we moved the online redo log files to another disk, mounted in
/
u01/oradata/TESTDB2
. We need to stop the database by executing a
SHUTDOWN
command
and then use the
mv
command to physically move the redo log files identified in step 4.
In step 7, we mounted the database and, before opening it, informed the system of the new
redo log file positions, by executing the
ALTER
statements in step 8.
In the following screenshot, we can see the result of all these operations:
