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
Explain the use of full option in exp command.
Explain user account with reference to oracle.
What is SQL access advisor in Oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is an oracle?
How do I recompile a procedure in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What is bind variable in oracle 11g?
What happens if you use a wrong connect identifier?
What is format trigger?
Can you drop an index associated with a unique or primary key constraint?
What is the difference between pre-select and pre-query?
Will you be able to store pictures in the database?explain.
Please explain drop constraint oracle?
How to filter out duplications in the returning rows using oracle?
