{"id":205,"date":"2012-01-16T14:06:33","date_gmt":"2012-01-16T14:06:33","guid":{"rendered":"https:\/\/adilfahim.com\/myblog\/?p=205"},"modified":"2012-01-16T14:06:33","modified_gmt":"2012-01-16T14:06:33","slug":"control-file-and-its-functions-in-oracle","status":"publish","type":"post","link":"https:\/\/adilfahim.com\/myblog\/control-file-and-its-functions-in-oracle\/","title":{"rendered":"Control file and its functions in Oracle."},"content":{"rendered":"<p><strong>Control file and its functions in Oracle<\/strong><\/p>\n<p>This article answers the following queries :<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What is the control file in oracle?<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What are the functions of control file in oracle?<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What are the control file contents ?<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Can database function properly without control file?<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Can we edit control file<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Who can modify control file?<br \/>\n\u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 At what time control file will be created?<\/p>\n<p><strong>What is control file in Oracle and what are its functions ?<\/strong><br \/>\nControl file is a small binary file which is necessary for the database to start and operate successfully.<\/p>\n<p><strong>What are the functions of control file ?<\/strong><br \/>\nEach control file is associated with only one database.\u00a0 Oracle continuously updates control file during database use so this file must be available for writing whenever the database is in the open state.\u00a0 Control file will be created at the same time of database creation.<br \/>\nWhenever a datafile or a redolog file is added to, dropped or renamed in the database, the control file is updated to reflect the physical structural change.<br \/>\nThese changes are recorded in control file which facilitates:<br \/>\n&gt; \u00a0 Oracle to identify the files that are required or available in case database recovery is needed<br \/>\n&gt; \u00a0 Oracle to identify the datafiles and redolog files to open during database startup.<\/p>\n<p><strong>Can database function properly without control file?<\/strong><br \/>\nNo. Database cannot function properly if the control file is not available.<\/p>\n<p><strong>Can we edit control file? Who can modify control file?<\/strong><br \/>\nPlease note control file cannot be edited by database administrator or by any user. Control file information can only be modified by Oracle.<\/p>\n<p><strong>Contents of control files :<\/strong><br \/>\n&gt; Control file contains information such as<br \/>\n&gt; \u00a0 Database name<br \/>\n&gt; \u00a0 Timestamp of database creation<br \/>\n&gt; \u00a0 Tablespace information<br \/>\n&gt; \u00a0 The log history<br \/>\n&gt; \u00a0 Archive log information<br \/>\n&gt; \u00a0 Current log sequence number<br \/>\n&gt; \u00a0 Checkpoint information<br \/>\n&gt; \u00a0 Names and locations of associated datafiles and redolog files<br \/>\n&gt; \u00a0 Datafile copy information<br \/>\n&gt; \u00a0 Datafile offline ranges<br \/>\n&gt; \u00a0 Backup set and backup related information<br \/>\n&gt; \u00a0 Backup datafile and redolog information<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Control file and its functions in Oracle This article answers the following queries : \u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What is the control file in oracle? \u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What are the functions of control file in oracle? \u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 What are the control file contents ? \u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Can database function properly without control file? \u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Can we edit control file \u2022\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,8],"tags":[39,40,64,69],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-it","category-sap-updates","tag-archive-log","tag-backup","tag-control-file-sap-orcale","tag-datafile"],"_links":{"self":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":0,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/205\/revisions"}],"wp:attachment":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/categories?post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/tags?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}