{"id":15954,"date":"2021-03-12T16:35:03","date_gmt":"2021-03-12T15:35:03","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/"},"modified":"2021-03-12T16:35:03","modified_gmt":"2021-03-12T15:35:03","slug":"oda-move-a-db-to-asm-after-migrating-from-11g-to-19c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/","title":{"rendered":"ODA: Move a DB to ASM after migrating from 11g to 19c"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version:<\/p>\n<ul>\n<li>if you want\/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support &#8211; it ended at the end of 2020)<\/li>\n<li>some ODA features will not work with 11gR2 (odacli Data Guard feature for example)<\/li>\n<li>the use of ACFS filesystems is mandatory<\/li>\n<\/ul>\n<p>As I already told you, it&#8217;s more than time to migrate to 19c. Once done, you could get back to Premier Support and benefit for all ODA features dedicated to most recent versions. But what about ACFS filesystems?<\/p>\n<h2>ACFS is supported for all versions<\/h2>\n<p>ACFS is supported for all database versions, and migrating from 11gR2 to 19c will keep ACFS filesystems without any problem. Some of your databases can be using ASM, and other ACFS, both can live together.<\/p>\n<h2>Should I migrate to ASM?<\/h2>\n<p>If you are using ASM for your newest databases, it could be nice to keep only ASM and get rid of ACFS. ASM is fine as you don&#8217;t need to split your disks in numerous filesystems, so you optimize the disk usage (as disks on ODA are expensive).<\/p>\n<h2>How do I migrate from ACFS to ASM?<\/h2>\n<p>There are multiple methods to do this migration. <\/p>\n<p>One of these methods is to use RMAN to move the datafiles with a BACKUP AS COPY DATABASE FORMAT &#8216;+DATA&#8217; and then do a &#8216;SWITCHOVER DATABASE TO COPY&#8217;. It&#8217;s easy but it will only move datafiles, other files will need a manual move (redologs, controlfiles, archivelogs). Furthermore, your database will keep its ACFS volumes, and you should remove them manually. There is no way to detach ACFS volume from a database with odacli, unfortunately (for now).<\/p>\n<p>Another way to achieve this goal is to use odacli backup and restore features. Because odacli will pack everything to keep your ODA registry clean. And that&#8217;s everyone&#8217;s wish. A clean ODA repository is highly recommended.<\/p>\n<h2>Where do I would put the temporary backup?<\/h2>\n<p>For sure, you can backup your database to an external volume, but as it&#8217;s for restoring on the same ODA, you&#8217;d better do the backup locally, it means in the FRA. It will minimize the time needed for the operation (NVMe disk to NVMe disk).<\/p>\n<h2>How to do the database migration from 11gR2 to 19c?<\/h2>\n<p>Let&#8217;s first create an 11gR2 database. Remember that you do not give the version of the database in the create-database command, you just provide the Database Home associated to 11gR2 binaries (-dh):<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli create-database -dh e5db1546-2a78-416c-a70b-ea6a1ff022cd -u DEMO_767P -n DEMO -r ACFS -cs WE8ISO8859P15 -no-c -no-co -s odb2<\/pre>\n<p>Once database is created, let&#8217;s upgrade it to 19c, the -to is the target Database Home, the one running 19c:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli upgrade-database -i 371f1b1e-f1fe-4910-be10-e395d2c4ef67 -to fe4c4883-d8f6-4dad-97e8-ce04870fd9db<\/pre>\n<p>It will submit a job and would last from minutes to hours.<\/p>\n<p>At the end of the migration, I&#8217;m used to change the compatible version:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">sqlplus \/ as sysdba\nalter system set compatible='19.0.0.0' scope=spfile;\nshutdown immediate;\nstartup;\nexit;<\/pre>\n<h2>Create a backup configuration and link it to the database<\/h2>\n<p>To be able to restore with odacli, a backup needs to be made by odacli. It supposes to create a backupconfig first:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli create-backupconfig -n Local -w 1 -d Disk<\/pre>\n<p>Now let&#8217;s associate this backupconfig to the database:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli modify-database -in DEMO -bin Local<\/pre>\n<h2>Create the backup and save the report to a json file<\/h2>\n<p>Now let&#8217;s take a first backup:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli create-backup --backupType Regular-L0 -in DEMO -ka<\/pre>\n<p>List the backupreports to identify the backup task, and then describe the backupreport to a json file:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli list-backupreports \nodacli describe-backupreport -i 0bc90ed3-1fe0-472e-8191-a587c0b44de0 &gt; \/tmp\/br_DEMO_`date +\"%Y%m%d_%H%M%S\"`.json<\/pre>\n<h2>Delete the source database<\/h2>\n<p>This is only mandatory if you want to keep the database name, and I would like to in this DEMO:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli list-databases\n\nID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n8ad09a72-fbcf-410f-854b-cd8c945fb3de     DBTEST     Si       19.9.0.0.201020      false      Oltp     Odb1s    Asm        Configured   fe4c4883-d8f6-4dad-97e8-ce04870fd9db\n72723b58-bc91-4a04-9122-3b1e214bede9     MIG        Si       19.9.0.0.201020      false      Oltp     Odb2     Acfs       Configured   fe4c4883-d8f6-4dad-97e8-ce04870fd9db\n13b24dc6-f773-403b-a6e7-5b78d6b4c8b2     DBASM      Si       19.9.0.0.201020      false      Oltp     Odb2     Asm        Configured   fe4c4883-d8f6-4dad-97e8-ce04870fd9db\n371f1b1e-f1fe-4910-be10-e395d2c4ef67     DEMO       Si       19.9.0.0.201020      false      Oltp     Odb2     Acfs       Configured   fe4c4883-d8f6-4dad-97e8-ce04870fd9db\n\nodacli delete-database -i 371f1b1e-f1fe-4910-be10-e395d2c4ef67<\/pre>\n<h2>Restore the database<\/h2>\n<p>odacli is able to restore a database to a different filesystem, ASM for example:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli irestore-database -dh fe4c4883-d8f6-4dad-97e8-ce04870fd9db -r \/tmp\/br_DEMO_20201126_112503.json -dr ASM -bl \/u03\/app\/oracle\/fast_recovery_area\/DEMO_767P\/backupset\/2020_11_26\/<\/pre>\n<p>Describe the job with odacli to have a status of the task:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">Job details\n----------------------------------------------------------------\n                     ID:  5456a45a-ee7f-49eb-a6ae-3d4ffc9b5b42\n            Description:  Database service recovery with db name: DEMO\n                 Status:  Success\n                Created:  November 26, 2020 11:30:56 AM CET\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nCheck if cluster ware is running         November 26, 2020 11:30:56 AM CET   November 26, 2020 11:30:56 AM CET   Success\nCreating DbStorage for DbRestore         November 26, 2020 11:30:56 AM CET   November 26, 2020 11:30:57 AM CET   Success\nValidating DiskSpace for DATA            November 26, 2020 11:30:56 AM CET   November 26, 2020 11:30:57 AM CET   Success\nGenerating SSH key                       November 26, 2020 11:30:57 AM CET   November 26, 2020 11:30:57 AM CET   Success\nSSH key                                  November 26, 2020 11:30:57 AM CET   November 26, 2020 11:30:57 AM CET   Success\nSSH key scan                             November 26, 2020 11:30:57 AM CET   November 26, 2020 11:30:57 AM CET   Success\nCreate TDE And Audit Dir Locations       November 26, 2020 11:30:57 AM CET   November 26, 2020 11:30:57 AM CET   Success\nCreate pfile for Auxiliary Instance      November 26, 2020 11:30:57 AM CET   November 26, 2020 11:30:57 AM CET   Success\nDeleting FRA                             November 26, 2020 11:30:57 AM CET   November 26, 2020 11:30:58 AM CET   Success\nRman duplicate                           November 26, 2020 11:30:58 AM CET   November 26, 2020 11:35:24 AM CET   Success\nDelete RECO FileGroup DEMO_767P          November 26, 2020 11:35:24 AM CET   November 26, 2020 11:35:25 AM CET   Success\nCreate RECO FileGroup DEMO_767P          November 26, 2020 11:35:25 AM CET   November 26, 2020 11:35:25 AM CET   Success\nDelete RECO FileGroup DEMO_767P_9999     November 26, 2020 11:35:25 AM CET   November 26, 2020 11:35:25 AM CET   Success\nCreating pfile from spfile               November 26, 2020 11:35:25 AM CET   November 26, 2020 11:35:25 AM CET   Success\nSet PFile Ownership                      November 26, 2020 11:35:25 AM CET   November 26, 2020 11:35:26 AM CET   Success\nCustomize Db Parameters                  November 26, 2020 11:35:26 AM CET   November 26, 2020 11:35:27 AM CET   Success\nShutdown And Start database              November 26, 2020 11:35:27 AM CET   November 26, 2020 11:36:49 AM CET   Success\nCreate spfile for restore db             November 26, 2020 11:36:49 AM CET   November 26, 2020 11:36:49 AM CET   Success\nSet PFile Ownership                      November 26, 2020 11:36:49 AM CET   November 26, 2020 11:36:49 AM CET   Success\nShutdown And Mount database              November 26, 2020 11:36:49 AM CET   November 26, 2020 11:37:32 AM CET   Success\nRe-Create control file                   November 26, 2020 11:37:32 AM CET   November 26, 2020 11:38:12 AM CET   Success\nRemoving Disabled Redo Threads           November 26, 2020 11:38:12 AM CET   November 26, 2020 11:38:13 AM CET   Success\nUpdating DB attributes                   November 26, 2020 11:38:13 AM CET   November 26, 2020 11:38:13 AM CET   Success\nEnable block change tracking             November 26, 2020 11:38:13 AM CET   November 26, 2020 11:38:16 AM CET   Success\nRegister Database taskflow               November 26, 2020 11:38:17 AM CET   November 26, 2020 11:42:38 AM CET   Success\nCreate SPFile in shared loc              November 26, 2020 11:38:17 AM CET   November 26, 2020 11:38:21 AM CET   Success\nDelete Local Spfile                      November 26, 2020 11:38:21 AM CET   November 26, 2020 11:38:21 AM CET   Success\nRegister DB with clusterware             November 26, 2020 11:38:21 AM CET   November 26, 2020 11:39:40 AM CET   Success\nAdd Startup Trigger to Open all PDBS     November 26, 2020 11:39:40 AM CET   November 26, 2020 11:39:40 AM CET   Success\nSet SysPassword and Create PwFile        November 26, 2020 11:39:40 AM CET   November 26, 2020 11:39:42 AM CET   Success\nCreating pfile                           November 26, 2020 11:39:42 AM CET   November 26, 2020 11:39:43 AM CET   Success\nUpdating db env                          November 26, 2020 11:39:43 AM CET   November 26, 2020 11:39:44 AM CET   Success\nEnable DbSizing Template                 November 26, 2020 11:39:44 AM CET   November 26, 2020 11:41:00 AM CET   Success\nUpdate Database Global Name              November 26, 2020 11:41:00 AM CET   November 26, 2020 11:41:01 AM CET   Success\nCreate tns entry                         November 26, 2020 11:41:01 AM CET   November 26, 2020 11:41:02 AM CET   Success\nRunning datapatch                        November 26, 2020 11:41:02 AM CET   November 26, 2020 11:41:11 AM CET   Success\nSet CPU pool                             November 26, 2020 11:41:11 AM CET   November 26, 2020 11:41:11 AM CET   Success\nReset Associated Networks                November 26, 2020 11:42:38 AM CET   November 26, 2020 11:42:41 AM CET   Success\nCopy Pwfile to Shared Storage            November 26, 2020 11:42:41 AM CET   November 26, 2020 11:42:44 AM CET   Success\n<\/pre>\n<p>That&#8217;s it, our database is now using ASM like the other databases. You can control with another:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">odacli list-database<\/pre>\n<h2>Conclusion<\/h2>\n<p>This is the cleanest way to move a database from ACFS to ASM or vice-versa. Please make sure your backup is OK before deleting the database. Be carreful if your database is the latest one to use ACFS, because your recovery area ACFS volume could be removed after the source database deletion. If you want to make sure that your backup will persist, do it on a nfs share or restore the database with a new name.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want\/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support &#8211; it ended at the end of 2020) some ODA features will not work with 11gR2 [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,199,42,59],"tags":[2282,2283,2284,600,2285,2286,37,79,2287,2288,2289,2290,365],"type_dbi":[],"class_list":["post-15954","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-hardware-storage","category-operating-systems","category-oracle","tag-11g-to-19c","tag-11gr2","tag-19c-migration","tag-acfs","tag-acfs-to-asm","tag-asfs2asm","tag-asm","tag-oda","tag-odacli-create-backup","tag-odacli-create-backupconfig","tag-odacli-irestore-database","tag-odacli-upgrade-database","tag-oracle-database-appliance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ODA: Move a DB to ASM after migrating from 11g to 19c - dbi Blog<\/title>\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-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA: Move a DB to ASM after migrating from 11g to 19c\" \/>\n<meta property=\"og:description\" content=\"Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want\/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support &#8211; it ended at the end of 2020) some ODA features will not work with 11gR2 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-12T15:35:03+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"ODA: Move a DB to ASM after migrating from 11g to 19c\",\"datePublished\":\"2021-03-12T15:35:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\"},\"wordCount\":715,\"commentCount\":0,\"keywords\":[\"11g to 19c\",\"11gR2\",\"19c migration\",\"ACFS\",\"acfs to asm\",\"asfs2ASM\",\"ASM\",\"ODA\",\"odacli create-backup\",\"odacli create-backupconfig\",\"odacli irestore-database\",\"odacli upgrade-database\",\"Oracle database appliance\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Hardware &amp; Storage\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\",\"name\":\"ODA: Move a DB to ASM after migrating from 11g to 19c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-03-12T15:35:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA: Move a DB to ASM after migrating from 11g to 19c\"}]},{\"@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\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ODA: Move a DB to ASM after migrating from 11g to 19c - dbi Blog","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-move-a-db-to-asm-after-migrating-from-11g-to-19c\/","og_locale":"en_US","og_type":"article","og_title":"ODA: Move a DB to ASM after migrating from 11g to 19c","og_description":"Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want\/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support &#8211; it ended at the end of 2020) some ODA features will not work with 11gR2 [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/","og_site_name":"dbi Blog","article_published_time":"2021-03-12T15:35:03+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"ODA: Move a DB to ASM after migrating from 11g to 19c","datePublished":"2021-03-12T15:35:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/"},"wordCount":715,"commentCount":0,"keywords":["11g to 19c","11gR2","19c migration","ACFS","acfs to asm","asfs2ASM","ASM","ODA","odacli create-backup","odacli create-backupconfig","odacli irestore-database","odacli upgrade-database","Oracle database appliance"],"articleSection":["Database Administration &amp; Monitoring","Database management","Hardware &amp; Storage","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/","name":"ODA: Move a DB to ASM after migrating from 11g to 19c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-03-12T15:35:03+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-move-a-db-to-asm-after-migrating-from-11g-to-19c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA: Move a DB to ASM after migrating from 11g to 19c"}]},{"@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\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15954","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\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=15954"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15954\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15954"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}