Databases Reference
In-Depth Information
When we execute the database in
ARCHIVELOG
mode (the norm for a production
environment), we need to separate the disks in which online redo logs and archived redo
logs are stored. If we want to change the location of our archived redo logs, we can follow
step 10 through step 13.
Also, in this situation, we need to shut down the database and open and mount it, as in step
10 and step 11. In step 12, we set three different locations for our archived redo logs, storing
them on three different disks. In step 13 we open the database and start using the new
destinations for archived redo log.
Please note that when we change the archived redo log file
locations, we need to change backup procedures accordingly,
to reflect the changes made to the locations. We could
obtain a
RMAN-06207
error, and to fix it we can execute the
CROSSCHECK
COPY
command in the
RMAN
prompt.
You can see the output of the preceding operations in the following screenshot:
In step 14 through step 17, we have seen how to move data files to different disks. When we
heavily access data files and we know which file is executing the query against the statistics
(shown in step 2 and step 3), we can gain in performance by separating the heavily-accessed
data files on different disks.
