Oracle Database Architecture

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • #18716

    Ebru Yildiz

    What is the importance of oracle database control files ?


    The Control file is a file with a .ctl extension that is physically stored on the operating system that is a must for an Oracle database. This file also acts as the brain for our Oracle database. When the Oracle database starts, it reads the parameter file called SPFILE or PFILE and learn the location of the Control file.

    the Control file is the brain of our database, the database needs to find this file to work. Because Controlfile includes SCN (System Change number), Datafile paths, Archivelog paths, Onlinelog paths, Backup files and etc.


    You can read the following post to learn more details about Controlfile and Oracle database architecture.

    Oracle Database Architecture -1 Controlfile, Datafile, SGA and PGA

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
IT Tutorial