What is the use of Control File ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I recompile a procedure in oracle?

527


How to drop an existing view in oracle?

562


Explain coalesce function?

622


Explain the use of grant option in exp command.

582


What is user managed backup in Oracle?

610






Why do we need integrity constraints in a database?

584


How to export your own schema?

567


What is transaction control statement and how many types of transaction control statement in Oracle?

562


How to commit the current transaction in oracle?

574


Will you be able to store pictures in the database?

633


How do I find my oracle client driver version?

522


State the various uses of dbcc command?

544


Explain an index segment?

638


How to specify default values in insert statement using oracle?

556


How to connect the oracle server as sysdba?

625