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
Name the various constraints used in oracle?
Explain an extent?
What is the difference between online and offline backups?
How to revoke create session privilege from a user in oracle?
How to change program global area (pga) in oracle?
Can we insert data in view oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are group functions in oracle?
What is an Oracle index?
What is coalesce function?
What is oracle host variable?
What is the disadvantage of User defind function?
How to execute a stored program unit?
What are the different types of partitions in oracle?