Prev | Current Page 102 | Next

Rick Greenwald, Robert Stackowiak, Jonathan Stern

"Oracle Essentials: Oracle Database 11g"


However, rebuilding control files can be difficult, introduces risk, and can be easily
avoided.
The location of the control files is defined, as previously mentioned, by the
CONTROL_FILES initialization parameter. Youcan specify multiple copies of control
files by indicating multiple locations in the CONTROL_FILES parameter for the
instance, as illustrated here:
control_files = (/u00/oradata/control.001.dbf,
/u01/oradata/control.002.dbf,
/u02/oradata/control.003.dbf)
This parameter tells the instance where to find the control files. Oracle will ensure
that all copies of the control file are kept in sync so all updates to the control files
will occur at the same time. If you do not specify this parameter, Oracle will create a
control file using a default filename or by leveraging Oracle Managed Files (if
enabled).
Many Oracle databases are deployed on some type of redundant disk solution such
as RAID-1 or RAID-5 to avoid data loss when a disk fails. (RAID is covered in more
detail in Chapter 7.) Youmight conclude that storing the control file on protected
disk storage eliminates the need for maintaining multiple copies of control files and
that losing a disk won??™t mean loss of the control file.


Pages:
90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114
okapy kuchenne urządzenia do magnetoterapii roboty ziemne warszawa Katalog stron internetowych architekci