Oracle Database - Control Files

Card Puncher Data Processing


Every Oracle database has a control file.

Every time an instance of an Oracle database is started, its control file identifies the physical structure:

that must be opened for database operation to proceed.

A control file contains also entries that specify:

  • Database name
  • Timestamp of database creation

If the physical makeup of the database is altered (for example, if a new datafile or redo log file is created), then the control file is automatically modified by Oracle Database to reflect the change. A control file is also used in database recovery.

The parameter file has a listing of all the control files and the control file is responsible for storing information about all the other data files and resources used by the database.

If the control file can't be read the database doesn't know what else exists! This is why you should be careful to keep good backups of your control files using plain of system backups. This is also why Oracle maintains multiple copies (typically 3) of the control file for safety. It multiplex the control file, that is, simultaneously maintain a number of identical control file copies, to protect against a failure involving the control file.

Control files in Data Dictionary

select name from v$controlfile;

Discover More
Card Puncher Data Processing
Oracle Database - ASM (Automatic Storage Management)

Starting with Oracle Database 10g ( or later), Automatic Storage Management is a high-performance storage management solution. For Oracle Database files, it simplifies the management of a dynamic...
Card Puncher Data Processing
Oracle Database - Internal Locks

Internal locks are higher-level, more complex mechanisms than latches and mutexes and serve various purposes. The database uses the following types of internal locks: These locks are of very short...
Card Puncher Data Processing
Oracle Database - NOARCHIVELOG

When you run your database in NOARCHIVELOG mode, you disable the archiving of the redo log : the ARCHIVELOG. The database control file indicates that filled groups are not required to be archived. ...
Card Puncher Data Processing
Oracle Database - Physical Database Structures (Files)

Oracle Database files include: data files, temporary files, control files, the server parameter file, the password file. redo log files, Archived Redo Log Files Parameter Files Alert...
Oracle Database File Location Variable
Oracle Database - System Identifier (SID)

The System Identifier (SID) identifies a specific database instance. The SID uniquely distinguishes the instance from any other instance on the same computer. Each database instance requires a unique SID...

Share this page:
Follow us:
Task Runner