If a control file is damaged due to a disk failure, the associated instance must be shut down. Multiplex Control Files on Different DisksĮvery Oracle database should have at least two control files, each stored on a different disk. The default name is operating system specific. If you do not specify files for CONTROL_FILES before database creation, and you are not using the Oracle Managed Files feature, Oracle creates a control file and uses a default filename. The instance writes to and maintains all listed control files during database operation. The instance startup procedure recognizes and opens all the listed files. You specify control file names using the CONTROL_FILES initialization parameter in the database's initialization parameter file (see "Creating Initial Control Files" ). Multiplex Control Files on Different Disks.
Provide Filenames for the Control Files.This section describes guidelines you can use to manage the control files for a database, and contains the following topics: You might also need to create control files later, if you lose control files or want to change particular settings in the control files. You should create two or more copies of the control file during database creation. On some operating systems the default is to create multiple copies. By default, at least one copy of the control file is created during database creation. The control file of an Oracle database is created at the same time as the database. Without the control file, the database cannot be mounted and recovery is difficult. The control file must be available for writing by the Oracle database server whenever the database is open.
0 kommentar(er)
