Oracle Database Architecture

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

    blank

    #18731
    blankEbru Yildiz
    Participant

    What is the importance of oracle database control files ?

    #18734

    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.

    #18775

    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.