1.

What Information Is Stored In Control File?

Answer»

Oracle DATABASE must have at least one control file.
It's a binary file contains some of the following information:

  • The database name and unique ID.
  • The timestamp of database creation.
  • The names and locations of associated datafiles and REDO log files.
  • Tablespace information.
  • DATAFILE offline RANGES.
  • Archived log information and history.
  • Backup set and backup piece information.
  • Backup datafile and redo log information.
  • Datafile copy information.
  • Log records: sequence numbers, SCN range in each log.
  • RMAN Catalog.
  • Database block CORRUPTION information.

The location of the control files is specified through the control_files init param:

SYS@DB1_SID SQL>show parameter control_file;
NAME TYPE VALUE.
control_file_record_keep_time integer 7 .
control_files string /u01/app/oracle/oradata/DB1_SID.
/control01.ctl, /u01/app/oracl.
e/flash_recovery_area/DB1_SID/c.
ontrol02.ctl.

Oracle Database must have at least one control file.
It's a binary file contains some of the following information:

The location of the control files is specified through the control_files init param:


Discussion

No Comment Found

Related InterviewSolutions