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 is a select query statement in oracle?
How can you merge two tables in oracle?
How to load a large xml file?
What is different types of joins?
How to create a single index for multiple columns?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
how do u setup a replication site?
why dont we assign not null constraint as table level constraint.
How a database is related to tablespaces?
What do you mean by cdb and pdb in oracle 12c?
definition of cluster and non-clustered index?
What is literal?
Explain the use of ignore option in imp command.
List the various oracle database objects?
How to assign data of the deleted row to variables?
