What does a Control file Contain ?
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 |
What are privileges and grants?
Give the various rollback segment states.
How to create a new table in your schema?
What are the different types of record groups in oracle? Explain each of them
how to retrieve data from different tables ,place this data in different excel worksheets.
What is merge in oracle?
What does `(+)` do in a where clause?
What is the meaning of recursive hints in oracle?
What is parameterized cursor in oracle?
How to upsert (update or insert into a table)?
Why does for update in oracle 8 cause an ora-01002 error?
In oracle there is column command, how will you explain that?