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 |
How to best split csv strings in oracle 9i?
Are truncate and delete commands same? If so why?
How many memory layers are in the shared pool?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
What is the implicit cursor in oracle?
Explain rename?
What is memory advisor in Oracle?
Can objects of the same Schema reside in different tablespaces.?
Difference between inner join vs where ?
How to write a query with a left outer join in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the difference between sharding and partitioning?