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

| improve this answer | |
  • Other than the above,what more does it contain? – nvsnreddy Mar 3 '15 at 18:07
  • in my post I wrote everything the control file include – Ahmad Abuhasna Mar 3 '15 at 18:10
  • Not everything. Check V$CONTROLFILE_RECORD_SECTION view. There are much more different records. – Mindaugas Riauba Mar 3 '15 at 19:10
  • @MindaugasRiauba please check docs.oracle.com/cd/B28359_01/server.111/b28310/… and advise thanks – Ahmad Abuhasna Mar 3 '15 at 19:15
  • This doc lists what must be in controlfile but not all the possible info. The simpliest example is information about backups and copies which is stored only in controlfile if you do not use RMAN catalog database. – Mindaugas Riauba Mar 3 '15 at 19:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.