Interested to Buy Any Domain ? << Click Here >> for more details...
What does a Control file Contain ?
- 2 Answers
- 8404 Views
- I also Faced
- E-Mail Answers
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 happens if you use a wrong connect identifier?
How to retrieve the count of updated rows?
How many categories of data types in oracle?
How to define default values for formal parameters?
What happens if the imported table already exists?
What are ddl statements in oracle?
How to define Data Block size ?
what is the difference between sql& oracle?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
what are the default admin accounts in Oracle 10g ?
What is the relation of a user account and a schema?
How would you go about verifying the network name that the local_listener is currently using?
Oracle General 
