Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of Control File ?
- 3 Answers
- 6578 Views
- I also Faced
- E-Mail Answers
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 do I learn what codesets are available in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
What are transaction isolation levels supported by oracle?
Calculate difference between 2 date / times in oracle sql?
How would you go about verifying the network name that the local_listener is currently using?
Which Oracle App Is Most Popular One ?
How will you write a query to get a 5th rank student from a table student_report?
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?
How to end the current transaction in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
Oracle General 
