Contained in the controlfile of oracle database

oracle-11g

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In addition to this,what more a controlfile contains? Does it contain user backup info?

Best Answer

Lets define the controlfile in oracle: it is a small binary file that records the physical structure of the database and its include:

1) The database name.

2) Names and locations of associated datafiles and redo log files.

3) The timestamp of the database creation

4) The current log sequence number

5) Checkpoint information