Deepak katyal
Answered On : Jul 7th, 2005
Control file is binary file which is having all the information realted to database. db_name, maxlogfiles, maxdatafiles, tablespaces information. Without this u cannot open your database. Init.ora parameter file showing the location of the controlfile.
Login to rate this answer.
nagabhushan reddy
Answered On : Feb 8th, 2006
control file is a binary file which contains db_name,dbcreated,checkpoint information,datafiles and logfiles.
Login to rate this answer.
Control file contains the names and locations of data files and redolog files, database creation timestamp along with the SCN information through which the controlfile could find the inconsistency.
Login to rate this answer.
ravi
Answered On : Nov 21st, 2006
USE of Control File:
Control file contains control information used to - Start an instance such as location of datafile and redo log files. These file maintain internal consistency and guide recovery operation.
Control file is stored in .ctl format and in binary format
Login to rate this answer.
Sriniv@s..
Answered On : Jun 8th, 2012
Control file contain metadata of the database.And also containing as follows,
Name of the database & when was database created.
Name & location of datafiles,redolog files.
Backup information(RMAN).
SCN information stored into it.
Login to rate this answer.
Mubeen
Answered On : Jul 19th, 2012
control file is used to startup the database from nomount stage to mount stage. Firstly, when the database is started it looks for the path of control file in the parameter file and the database is now in the nomount stage. Now the database looks for the control files to startup the database.
Login to rate this answer.
