What is the use of Control File ?
Answers were Sorted based on User's Feedback
Answer / guest
control file contains crucial information regarding the
database.Without control file u can't open the database.
It maintains integrity of database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abitha
Control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation.
Control file contains:
Database information
Archive log history
Redo threads
database name
Current archive log mode
Database's creation date etc.,
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
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.
Controlfile contains the information about the database like names and locations of datafiles, name of the database, database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.
Is This Answer Correct ? | 0 Yes | 0 No |
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
What are various constraints used in SQL?
Explain oracle left join with an example?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What privilege is needed for a user to create indexes in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
What are synonyms used for ?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What is TNS File
Where do we use decode and case statements?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.