Interested to Buy Any Domain ? << Click Here >> for more details...
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 the advantages of running a database in archive log mode?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is data file?
 What are the oracle DML commands possible through an update strategy?
What is null value in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to update a table row with a record?
What happens if you lost a data file?
What are the different types of modules in oracle forms?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
List out the types of joins.
What is the best way to do multi-row insert in oracle?
Please explain compound trigger in oracle?
What is a database table in oracle?
What is Segment Advisor in Oracle?
