Control file is a small binary file which is necessary for the database to start and operate successfully.
Functions of control file ?
Each control file is associated with only one database. Oracle continuously updates control file during database use so this file must be available for writing whenever the database is in the open state. Control file will be created at the same time of database creation.
Whenever a datafile or a redo log file is added to , dropped or renamed in the database, the control file is updated to reflect the physical structural change.
These changes are recorded in control file which facilitates :
• Oracle to identify the files that are required or available in case database recovery is needed
• Oracle to identify the datafiles and redo log files to open during database startup.
Contents of control files :
• Control file contains information such as
• Database name
• Timestamp of database creation
• Tablespace information
• The log history
• Archive log information
• Current log sequence number
• Checkpoint information
• Names and locations of associated datafiles and redo log files
• Datafile copy information
• Datafile offline ranges
• Backup set and backup related information
• Backup datafile and redo log information
Can database function properly without control file?
No. Database cannot function properly if the control file is not available.
Can we edit control file ? Who can modify control file ?
Please note control file cannot be edited by database administrator or by any user. Control file information can only be modified by Oracle.
0 Comments