ctl, /u
03/oradata/control02.ctl, /u04
/oradata/control03.ctl
SQL>
The three control files have been moved to separate file systems, no longer on the volume
with the Oracle software and in a higher availability configuration (if the volume containing one
of the control files fails, two other volumes contain up-to-date control files).
NOTE
In a default installation of Oracle Database 11g using ASM disks for
tablespace storage and the flash recovery area, one copy of the control
file is created in the default tablespace ASM disk and another in the
flash recovery area.
Making one or more copies of the control file to an ASM volume is just as easy: using the
RMAN utility (described in detail in Chapter 12), restore a control file backup to an ASM disk
location, as in this example:
RMAN> restore controlfile to
'+DATA/dw/controlfile/control_bak.ctl';
The next step is identical to adding file system??“based control files as I presented earlier in
this section: change the CONTROL_FILES parameter to add the location +DATA/dw/controlfile/
control_bak.ctl in addition to the existing control file locations, and then shut down and restart
the database.
SQL> show parameter control_files
NAME TYPE VALUE
---------------- ----------- ------------------------------
control_files string /u02/oradata/control01.ctl, /u
03/oradata/control02.ctl, /u04
98 Oracle Database 11g DBA Handbook
/oradata/control03.ctl, +DATA/
dw/controlfile/control_bak.
Pages:
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195