What is a control file?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a control file?
Rating:
A control file is a binary file that records the physical structure of a database and defines its current state. It contains the database name, the names and locations of associated data files and online redo log files, timestamp of database creation, current log sequence number, and checkpoint information. It is created during database creation and is continuously updated by the Oracle Server. A database is mounted using a control file. A database must contain at least one control file. However, the recommended number of control files is two or more. A database can contain a maximum of eight control files. However, a control file may belong to only one database.
Rating:
Was this information helpful?
Other articles
- Things to practice for Oracle 10g administrative test 1Z0-042.
- What is Flashback Query?
- What is a resource plan directive?
- What is the Undo Advisor?
- What is the sqlnet.ora file?