Remember that Anytime you restore a control file from a backup, you are required to perform media recovery on your entire database and then open it with the open resetlogs command. 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. The control file must be available for writing by the Oracle Database server whenever the database is open.īy default, at least one copy of the control file is created during database creation. Without the control file, the database cannot be mounted and recovery is difficult. – Names and locations of associated datafiles and redo log files It is a small binary file that records the physical structure of the database. Every Oracle Database has a control file as one of its important file.
