log
1 /u05/oradata/redo01.log
2 /u04/oradata/redo02.log
2 /u05/oradata/redo02.log
3 /u04/oradata/redo03.log
3 /u05/oradata/redo03.log
6 rows selected.
SQL>
The I/O for the redo log files no longer contends with the Oracle software; in addition, the
redo log files are multiplexed between two different mount points, /u04 and /u05.
96 Oracle Database 11g DBA Handbook
Moving Control Files
Moving a control file when you use an initialization parameter file follows a procedure similar
to the one you used for datafiles and redo log files: Shut down the instance, move the file with
operating system commands, and restart the instance.
When you use a server parameter file (SPFILE), however, the procedure is a bit different. The
initialization file parameter CONTROL_FILES is changed using alter system ??¦ scope=spfile when
either the instance is running or it??™s shut down and opened in NOMOUNT mode. Because the
CONTROL_FILES parameter is not dynamic, the instance must be shut down and restarted in
either case.
In this example, you discover that you have three copies of the control file in your database,
but they are not multiplexed on different disks. You will edit the SPFILE with the new locations,
shut down the instance so that you can move the control files to different disks, and then restart
the instance.
SQL> select name, value from v$spparameter
2 where name = 'control_files';
NAME VALUE
--------------- --------------------------------------------------
control_files /u01/app/oracle/oradata/control01.
Pages:
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193