Answer Posted / saranya
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 |
Post New Answer View All Answers
What are data pump export and import modes?
What is private procedure oracle?
How can Oracle users be audited?
Can we protect our pl/sql source code?
How to increment dates by 1 in oracle?
How to assign a table row to a record variable?
What is a data lock in oracle?
how to handle exceptions in post production
What is raw datatype?
How to check your oracle database 10g xe installation?
What are the different windows events activated at runtime ?
What is the difference between post-database commit and post-form commit?
What are the various oracle database objects?
How will you identify oracle database software release?
How a database is related to tablespaces?
