Also, if the size of the old control file differs from the SIZE parameter of the new one, you cannot use the REUSE clause. If files with the specified names currently exist at the time of database creation, you must specify the CONTROLFILE REUSE clause in the CREATE DATABASE statement, or else an error occurs. The following is an example of a CONTROL_FILES initialization parameter:ĬONTROL_FILES = (/u01/oracle/prod/control01.ctl, The filenames specified in CONTROL_FILES should be fully specified and are operating system specific. The names of the control files are specified by the CONTROL_FILES parameter in the initialization parameter file used during database creation. The initial control files of an Oracle Database are created when you issue the CREATE DATABASE statement. See the sections "About Oracle ASM Filenames" and "Creating a Database That Uses Oracle ASM" in Oracle Automatic Storage Management Administrator's Guide for more information. Oracle ASM then automatically creates control files in the appropriate places. If you are using Oracle Automatic Storage Management (Oracle ASM), you can place incomplete Oracle ASM filenames in the DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST initialization parameters. If you are using Oracle Managed Files, then the initialization parameters you set to enable that feature determine the name and location of the control files, as described in Chapter 17, "Using Oracle Managed Files". The default name is operating system specific. If you are not using Oracle Managed Files, then the database creates a control file and uses a default filename. If you do not specify files for CONTROL_FILES before database creation: The instance recognizes and opens all the listed file during startup, and the instance writes to and maintains all listed control files during database operation. You specify control file names using the CONTROL_FILES initialization parameter in the database initialization parameter file (see "Creating Initial Control Files"). You can also 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. Names and locations of associated data files and redo log files Every Oracle Database has a control file, which is a small binary file that records the physical structure of the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |