Oracle Database Architecture Question:

What is the use of Oracle Control File?

Tweet Share WhatsApp

Answer:

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

Control files is a binary file. Before database is opened it determines whether database is in valid state or not. If yes then database is opened.

Download Database Architecture PDF Read All 18 Database Architecture Questions
Previous QuestionNext Question
Can objects of the same Schema reside in different tablespaces?Can a View based on another View in Oracle?