Interested to Buy Any Domain ? << Click Here >> for more details...
What does a Control file Contain ?
- 2 Answers
- 8292 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
A Control file records the physical structure of the
database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.
| Is This Answer Correct ? | 9 Yes | 0 No |
The control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation. It contains (but
is not limited to) the following types of information:
* Database information (RESETLOGS SCN and their time
stamp)
* Archive log history
* Tablespace and datafile records (filenames, datafile
checkpoints, read/write status, offline or not)
* Redo threads (current online redo log)
* Database's creation date
* database name
* current archive log mode
* Log records (sequence numbers, SCN range in each log)
* RMAN catalog
* Database block corruption information
* Database ID, which is unique to each DB
| Is This Answer Correct ? | 7 Yes | 1 No |
Explain rename?
how to delete all duplicate records from a table using subquery?
How to get the Installed Oracle Version Information ?
What is the quickest way to fetch the data from a table?
How to filter out duplications in the returning rows using oracle?
Are truncate and delete commands same? If so why?
How to experiment a data lock in oracle?
What are the types of Database Links ?
How to create an oracle database?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What are a query and state the different types of queries and their uses?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Oracle General 
