db_create_online_log_dest_1<\/strong> configured as following:<\/p>\nSQL> show parameter create\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ncreate_bitmap_area_size integer 8388608\ndb_create_file_dest string \/u02\/app\/oracle\/oradata\/datastore\/.ACFS\/snaps\/DBPROD1\ndb_create_online_log_dest_1 string \/u01\/app\/oracle\/oradata\/datastore\/DBPROD1\ndb_create_online_log_dest_2 string<\/pre>\nAs consequence all databases are created with a single control file located in the same ACFS volume than the redo logs.<\/p>\n
SQL> show parameter control_files\nNAME TYPE VALUE\n---------------- --------- ------------------------------\ncontrol_files string \/u01\/app\/oracle\/oradata\/datastore\/DBPROD1\/DBPROD1\/controlfile\/o1_mf_bj2r0f4n_.ctl<\/pre>\nThis volume is based on a triple mirrored ASM disk group, which already safeguard us from most possible issues except of course from user errors\u00a0\ud83d\ude44 or logical corruptions. Therefore if you still want to multiplex your control file, you will have manually to go through following steps:<\/p>\n
\n- Generate a trace file from your control file<\/li>\n
- Edit the trace file to keep only the NORESETLOGS version<\/li>\n
- Configure the db_create_online_log_dest_2 initialisation parameter<\/li>\n
- Reset the control_files parameter<\/li>\n
- Shutdown your database<\/li>\n
- Run the control file creation script<\/li>\n<\/ol>\n
<\/p>\n
Preparate control file creation script<\/h3>\n
First of all generate the trace file<\/p>\n
SQL> alter database backup controlfile to trace as '\/tmp\/ctl_DBPROD1.sql';\n\nDatabase altered.<\/pre>\nThen edit the generated file to keep only the NORESETLOGS version. It should look like something like this:<\/p>\n
STARTUP NOMOUNT\nCREATE CONTROLFILE REUSE DATABASE \"DBPROD1\" NORESETLOGS ARCHIVELOG\n MAXLOGFILES 16\n MAXLOGMEMBERS 3\n MAXDATAFILES 100\n MAXINSTANCES 8\n MAXLOGHISTORY 292\nLOGFILE\n GROUP 1 (\n '\/u01\/app\/oracle\/oradata\/datastore\/DBPROD1\/DBPROD1\/onlinelog\/o1_mf_1_bj2xmhs9_.log',\n '\/u01\/app\/oracle\/oradata\/datastore\/DBPROD1\/DBPROD1\/onlinelog\/o1_mf_1_bj2xmjlt_.log'\n ) SIZE 500M BLOCKSIZE 512,\n ...\n ...DATAFILE\n '\/u02\/app\/oracle\/oradata\/datastore\/.ACFS\/snaps\/DBPROD1\/DBPROD1\/datafile\/o1_mf_system_bj2r0ptp_.dbf',\n '\/u02\/app\/oracle\/oradata\/datastore\/.ACFS\/snaps\/DBPROD1\/DBPROD1\/datafile\/o1_mf_sysaux_bj2r0t8o_.dbf',\n ...\n ...\n ...\nCHARACTER SET WE8ISO8859P15\n;\nEXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('\/u01\/app\/oracle\/fast_recovery_area\/datastore\/DBPROD1\/snapcf_DBPROD1.f');\n\nVARIABLE RECNO NUMBER;\nEXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('SNAPSHOT CONTROLFILE NAME','TO ''\/u01\/app\/oracle\/fast_recovery_area\/datastore\/DBPROD1\/snapcf_DBPROD1.f''');\n\nRECOVER DATABASE\n\nALTER SYSTEM ARCHIVE LOG ALL;\n\nALTER DATABASE OPEN;<\/pre>\nPrepare database<\/h3>\n
Configure the parameter db_create_online_log_dest_2<\/strong> in order to Oracle to generate a second control file are re-creation<\/p>\nSQL> alter system set db_create_online_log_dest_2='\/u01\/app\/oracle\/oradata\/datastore\/DBPROD1' scope=both;\n\nSystem altered.<\/pre>\nThen remove the parameter control_files from the spfile. If you forget that point, Oracle will ignore the db_create_online_log_dest_X<\/strong> parameter and still re-create only one control file.<\/p>\n <\/p>\n
SQL> alter system reset control_files scope=spfile;\n\nSystem altered.<\/pre>\nRe-create the control files<\/h3>\n
At that point the system is ready to re-create the control file and multiplexing it. Simply shutdown the database and run the created SQL script:<\/p>\n
SQL> shutdown immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\nSQL> @ctl_DBPROD1.sql\nORACLE instance started.Total System Global Area 1.7180E+10 bytes\nFixed Size 3731384 bytes\nVariable Size 2550136904 bytes\nDatabase Buffers 1.4563E+10 bytes\nRedo Buffers 63377408 bytesControl file created.\n\nPL\/SQL procedure successfully completed.\n\nPL\/SQL procedure successfully completed.\n\nORA-00283: recovery session canceled due to errors\nORA-00264: no recovery requiredSystem altered.\nDatabase altered.<\/pre>\nThe database is now OPEN READ WRITE again and has two control files:<\/p>\n
SQL> select name from v$controlfile;NAME\n-------------------------------------------------------------------------------------\n\/u01\/app\/oracle\/oradata\/datastore\/DBPROD1\/DBPROD1\/controlfile\/o1_mf_bj3526gr_.ctl\n\/u01\/app\/oracle\/oradata\/datastore\/DBPROD1\/DBPROD1\/controlfile\/o1_mf_bj3526hy_.ctl<\/pre>\nEnjoy! \ud83d\ude00<\/p>\n","protected":false},"excerpt":{"rendered":"
Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA set up 3 ACFS volumes to store all non-CDB databases (CDB are managed on dedicated […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[461,280,283,96,365],"type_dbi":[],"class_list":["post-4404","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-best-practices","tag-database","tag-database-appliance","tag-oracle","tag-oracle-database-appliance"],"acf":[],"yoast_head":"\n
ODA 12.1.X.X.X - add a multiplexed control file under ACFS - dbi Blog<\/title>\n<meta name=\"description\" content=\"ODA 12 is creating database on ACFS volumes with OMF. As per default the control file is not multiplxed, this articles provides a procedure to add a second one.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA 12.1.X.X.X - add a multiplexed control file under ACFS\" \/>\n<meta property=\"og:description\" content=\"ODA 12 is creating database on ACFS volumes with OMF. As per default the control file is not multiplxed, this articles provides a procedure to add a second one.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-12T12:43:48+00:00\" \/>\n<meta name=\"author\" content=\"David Hueber\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Hueber\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/\"},\"author\":{\"name\":\"David Hueber\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8873e20a98a02305870909f4e3d0088f\"},\"headline\":\"ODA 12.1.X.X.X – add a multiplexed control file under ACFS\",\"datePublished\":\"2015-03-12T12:43:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/\"},\"wordCount\":363,\"commentCount\":0,\"keywords\":[\"Best Practices\",\"database\",\"Database Appliance\",\"Oracle\",\"Oracle database appliance\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/\",\"name\":\"ODA 12.1.X.X.X - add a multiplexed control file under ACFS - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-03-12T12:43:48+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8873e20a98a02305870909f4e3d0088f\"},\"description\":\"ODA 12 is creating database on ACFS volumes with OMF. As per default the control file is not multiplxed, this articles provides a procedure to add a second one.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA 12.1.X.X.X – add a multiplexed control file under ACFS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8873e20a98a02305870909f4e3d0088f\",\"name\":\"David Hueber\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc07284dbd5667f0bed32b0d8d64076ab885746973ea1b5c4e69c6fa7074cf59?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc07284dbd5667f0bed32b0d8d64076ab885746973ea1b5c4e69c6fa7074cf59?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc07284dbd5667f0bed32b0d8d64076ab885746973ea1b5c4e69c6fa7074cf59?s=96&d=mm&r=g\",\"caption\":\"David Hueber\"},\"description\":\"David Hueber has ten years of experience in infrastructure operation & management, engineering, and optimization. He is specialized in Oracle technologies (engineering, backup and recovery, high availability, etc.), Service Management standards and Oracle infrastructure operation processes (Service Desk, Change Management, Capacity Planning, etc.). David Hueber is ITILv3 Service Operation Lifecycle certified and Linux LPIC-1 certified. He received a university degree in Informatics and Networks at the IUT Mulhouse, France. He also studied Information Systems at the Conservatoire National des Arts et M\u00e9tiers in Mulhouse, France. His branch-related experience covers Financial Services \\\/ Banking, Chemicals & Pharmaceuticals, Transport & Logistics, Retail, Food, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/david-hueber\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ODA 12.1.X.X.X - add a multiplexed control file under ACFS - dbi Blog","description":"ODA 12 is creating database on ACFS volumes with OMF. As per default the control file is not multiplxed, this articles provides a procedure to add a second one.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/","og_locale":"en_US","og_type":"article","og_title":"ODA 12.1.X.X.X - add a multiplexed control file under ACFS","og_description":"ODA 12 is creating database on ACFS volumes with OMF. As per default the control file is not multiplxed, this articles provides a procedure to add a second one.","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/","og_site_name":"dbi Blog","article_published_time":"2015-03-12T12:43:48+00:00","author":"David Hueber","twitter_card":"summary_large_image","twitter_misc":{"Written by":"David Hueber","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/"},"author":{"name":"David Hueber","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8873e20a98a02305870909f4e3d0088f"},"headline":"ODA 12.1.X.X.X – add a multiplexed control file under ACFS","datePublished":"2015-03-12T12:43:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/"},"wordCount":363,"commentCount":0,"keywords":["Best Practices","database","Database Appliance","Oracle","Oracle database appliance"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/","name":"ODA 12.1.X.X.X - add a multiplexed control file under ACFS - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-03-12T12:43:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8873e20a98a02305870909f4e3d0088f"},"description":"ODA 12 is creating database on ACFS volumes with OMF. As per default the control file is not multiplxed, this articles provides a procedure to add a second one.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-121xxx-add-a-multiplexed-control-file-under-acfs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA 12.1.X.X.X – add a multiplexed control file under ACFS"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8873e20a98a02305870909f4e3d0088f","name":"David Hueber","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fc07284dbd5667f0bed32b0d8d64076ab885746973ea1b5c4e69c6fa7074cf59?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fc07284dbd5667f0bed32b0d8d64076ab885746973ea1b5c4e69c6fa7074cf59?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fc07284dbd5667f0bed32b0d8d64076ab885746973ea1b5c4e69c6fa7074cf59?s=96&d=mm&r=g","caption":"David Hueber"},"description":"David Hueber has ten years of experience in infrastructure operation & management, engineering, and optimization. He is specialized in Oracle technologies (engineering, backup and recovery, high availability, etc.), Service Management standards and Oracle infrastructure operation processes (Service Desk, Change Management, Capacity Planning, etc.). David Hueber is ITILv3 Service Operation Lifecycle certified and Linux LPIC-1 certified. He received a university degree in Informatics and Networks at the IUT Mulhouse, France. He also studied Information Systems at the Conservatoire National des Arts et M\u00e9tiers in Mulhouse, France. His branch-related experience covers Financial Services \/ Banking, Chemicals & Pharmaceuticals, Transport & Logistics, Retail, Food, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/david-hueber\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4404"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4404\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4404"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}