Control Files - Definition - Oracle Managed Files

Q.  In the Oracle Database which file contain the information needed to maintain and verify database integrity, and include the names of all the Data Files and the online and archived log files?
- Published on 29 Jul 15

a. Data Files
b. Control Files
c. Redo Log Files
d. Temp Files

ANSWER: Control Files
 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - The following files are:

    1. Redo log files - The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.

    2. Control files - A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the database creation.

    3. Data files - A datafile can be associated with only one tablespace and only one database.

    4. Temp files - They are a special class of data files that are associated only with temporary tablespaces.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)