Oracle - SPLessons

Oracle Control Files

Chapter 25

SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

Oracle Control Files

Oracle Control Files

shape Description

Oracle Control Files is a little binate record,important to begin and work efficiently for database. A Oracle Control Files is re-designed ceaselessly by Oracle amid database usage, and it can be accessible begin composing at whatever point the database is opened. And for any reason when  record does’t opened, database can’t work appropriately.

Each Oracle Control Files is connected with stand out Oracle database. And these Oracle Control Files are classified into 2 types.

Oracle Control Files Content

shape Description

This document consists of data about the relevant database needed for accessing an occurrence, paired at the start up and amid ordinary operation. Control record data will be adjusted based on Oracle, no database overseas or client can alter the document.

Beside different condition, a control record consists of data, for example, it contain

The database term and intersection starts at the production of database. The term is taken from  the term determined or by  DB_NAME instatement parameter or the term utilized as the part of DATABASE CREATE articulations.

Whenever redo log record and data record is combined, fornamed or discarded from the database, the document is upgraded to mirror this substantial design alterations. And the  progressions are registered so that

  • It recognize the information files and re-try log document to accessible amid database start up.
  • It distinguish records that are accessible in the event that database recuperation is vital.

Hence, if some changes are to be made into the physical structure of the database then ought to instantly make a reinforcement of the control record. Control documents additionally record data about checkpoints. The checkpoint processed the documents data into control document about the checkpoint status in the re-try log record. And data utilized amid database recuperation to forecast Oracle that all the re-try log records passages recorded before this point in the redo logs gathering are redundant for recuperation of database, and are readily kept in touch with the information documents.

shape Example

By viewing the below example the concept of control files can be easily understood.

   LOGFILE GROUP 1 ('/u01/oracle/prod/redo01_01.log', 
           GROUP 2 ('/u01/oracle/prod/redo02_01.log', 
           GROUP 3 ('/u01/oracle/prod/redo03_01.log', 
   DATAFILE '/u01/oracle/prod/system01.dbf' SIZE 3M,
            '/u01/oracle/prod/rbs01.dbs' SIZE 5M,
            '/u01/oracle/prod/users01.dbs' SIZE 5M,
            '/u01/oracle/prod/temp01.dbs' SIZE 5M

Multiplexed control document

shape Description

Similarly to re-try log records, Oracle empowers different, indistinguishable control documents will be opened simultaneously and composed for similar database. And putting away various control records in a solitary database on various disks, will protect against a individual count of break down in regards to control documents. In the event that a solitary disk that consists a control record clash, the present example comes up short when Oracle endeavours to get to the harmed control document, so that, when different duplicates of the present control document are accessible on various disks, an occurrence will be reloaded beyond the requirement for recuperation of database.

shape Conceptual

All the control documents of the database are enduringly vanished amid an execution,and the occasion is prematurely ended and recuperation is needed. Recuperation is no more directed if more established reinforcement in control record commitments can be utilized and the fact that a present duplicate does’t accessible. And firmly prescribed to fulfills the accompanying steps.

  • In each database, multiplexed control records are used.
  • Keeps every duplicate on an alternate substantial circle.
  • Utilizing working framework reflecting.
  • Screen reinforcements.


shape Key Points

  • Oracle Control Files – Tiny binate census that records the physical design.
  • Control files content- Is a collection of all control documents and treated it as a single unit.
  • Multiplexed control files – Database contain two control files stored on physical disk.