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?
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