Answer Posted / nishi
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Controlfile contains the information about the database like names and locations of datafiles, name of the database, database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the characteristics of oracle dba?
How much memory your 10g xe server is using?
How are extents allocated to a segment?
what is the difference between data migration and production migration.
How to define a sub function?
How to create a table interactively?
Will you be able to store pictures in the database?
What are the original export and import utilities?
How would you go about verifying the network name that the local_listener is currently using?
How to see the table columns used in an index?
What is a directory object?
How to define a cusotmer as a supplier in ORACLE R12
How to bring a tablespace offline?
Explain the use of record length option in exp command.
Explain what are the different type of segments?
