{"id":44737,"date":"2026-05-21T11:55:25","date_gmt":"2026-05-21T09:55:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=44737"},"modified":"2026-05-21T11:56:44","modified_gmt":"2026-05-21T09:56:44","slug":"reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/","title":{"rendered":"Reduce downtime when refreshing your non-production databases using Multitenant"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-introduction\">Introduction<\/h2>\n\n\n\n<p>You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback is the unavailability of the database being refreshed during the DUPLICATE. You first need to remove the old version of the database, then start the DUPLICATE and wait until it&#8217;s finished. If you have Enterprise Edition and enough CPU, you can lower the time needed for the refresh by allocating a sufficient number of channels. But with a small number of CPU (which is normal for a non-production server), or eventually with Standard Edition (single channel RMAN operations only), a multi-TB database refresh can take several hours to complete. And if it fails for some reasons, you need to retry the refresh, extending even more the downtime.<\/p>\n\n\n\n<p>Multitenant brought new possibilities for refreshing a database, and my favorite one is a CREATE PLUGGABLE DATABASE from a database link (DB link). It&#8217;s dead easy compared to a DUPLICATE FROM BACKUP on a non-CDB database. And you can lower the downtime to the very minimum. Here is how I did this for several projects.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-lower-the-downtime-to-the-minimum-when-refreshing-a-non-production-pdb\">How to lower the downtime to the minimum when refreshing a non-production PDB?<\/h2>\n\n\n\n<p>You probably know that one of the advantage of a pluggable database is the easiness of changing its name. You just need to stop the PDB, rename it, and restart it. You can then use this technique to refresh a PDB under a temporary name and let the actual PDB available during the refresh. Once the refresh is finished, drop or rename the actual PDB, and rename the newest one to its target name. Even if your refresh takes hours, your downtime is limited to a couple of seconds\/minutes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-1-add-an-additional-grant-for-source-pdb-s-administrator\">Step 1: add an additional grant for source PDB&#8217;s administrator<\/h2>\n\n\n\n<p>The PDB administrator on the source database must have the CREATE PLUGGABLE DATABASE privilege:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh oracle@p01-srv-ora\n. oraenv &lt;&lt;&lt; P19PMT\nsqlplus \/ as sysdba\nAlter session set container=P19_ERP;\ngrant create pluggable database to SYSERP;\nexit<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-2-add-a-tns-entry-on-the-target-server\">Step 2 : add a TNS entry on the target server<\/h2>\n\n\n\n<p>The target server must have a TNS entry to the source PDB (production). If your source PDB and its container are protected by a Data Guard configuration, dont&#8217;t forget to add both addresses:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh root@t01-srv-ora\nsu \u2013 oracle\n. oraenv &lt;&lt;&lt; D19PMT\nvi $ORACLE_HOME\/network\/admin\/tnsnames.ora\n\u2026\nP19_ERP =\n(DESCRIPTION =\n   (LOAD_BALANCE = OFF)\n   (FAILOVER = ON)\n   (ADDRESS_LIST =\n     (ADDRESS = (PROTOCOL = TCP)(HOST = p01-srv-ora)(PORT = 1521))\n     (ADDRESS = (PROTOCOL = TCP)(HOST = p02-srv-ora)(PORT = 1521))\n   )\n   (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = P19_ERP)\n   )\n)\n\ntnsping P19_ERP\n\u2026\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-3-create-a-db-link-on-the-target-container\">Step 3 : create a DB link on the target container<\/h2>\n\n\n\n<p>A DB link is required on the target container:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh root@t01-srv-ora\nsu \u2013 oracle\n. oraenv &lt;&lt;&lt; D19PMT\nsqlplus \/ as sysdba\nCREATE DATABASE LINK P19_ERP CONNECT TO SYSERP IDENTIFIED BY \"*************\"  USING 'P19_ERP';\n\nselect count(*) from dual@P19_ERP;\n  COUNT(*)\n----------\n         1\nexit<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-4-prepare-the-scripts-for-the-refresh\">Step 4 : prepare the scripts for the refresh<\/h2>\n\n\n\n<p>Basically, refresh will have 5 main tasks:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>create a new PDB with a temporary name _NEW on the target container from the source PDB<\/li>\n\n\n\n<li>start the new PDB for its correct registration in the container<\/li>\n\n\n\n<li>run an optional script for modifying production data (masking, disabling tasks, \u2026)<\/li>\n\n\n\n<li>stop and rename the current PDB to _OLD, then start it again<\/li>\n\n\n\n<li>stop and rename the new PDB to its target name and start it again<\/li>\n<\/ul>\n\n\n\n<p>Task 2 is needed because you cannot rename a PDB immediately after creation. You first need to open it, then close it for being able to change its name.<\/p>\n\n\n\n<p>Let&#8217;s create 2 scripts on the target server, one shell script and one SQL script:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vi \/home\/oracle\/scripts\/refresh_D19_ERP.sh\n#!\/bin\/bash\nexport ORACLE_SID=D19PMT\nexport REFRESH_LOG=\/home\/oracle\/scripts\/log\/refresh_D19_ERP_`date +%d_%m_%Y-%H_%M_%S`.log\nexport ORACLE_HOME=`cat \/etc\/oratab | grep $ORACLE_SID | awk -F ':' '{print $2;}'`\ndate &gt;&gt; $REFRESH_LOG\n$ORACLE_HOME\/bin\/sqlplus \/ as sysdba @\/home\/oracle\/scripts\/refresh_D19_ERP.sql &gt;&gt; $REFRESH_LOG\ndate &gt;&gt; $REFRESH_LOG\nexit 0\n\nvi \/home\/oracle\/scripts\/refresh_D19_ERP.sql\nset timing on\nshow pdbs\nalter pluggable database D19_ERP_OLD close immediate;\nDrop pluggable database D19_ERP_OLD including datafiles;\nshow pdbs\ncreate pluggable database D19_ERP_NEW from P19_ERP@P19_ERP ;\nshow pdbs\nalter pluggable database D19_ERP_NEW open;\nshow pdbs\nalter session set container=D19_ERP_NEW;\n@\/home\/oracle\/scripts\/post_refresh_D19_ERP.sql \nalter session set container=CDB$ROOT;\nalter pluggable database D19_ERP close immediate;\nalter pluggable database D19_ERP rename global_name to D19_ERP_OLD;\nalter pluggable database D19_ERP_OLD open;\nshow pdbs\nalter pluggable database D19_ERP_NEW close immediate;\nalter pluggable database D19_ERP_NEW rename global_name to D19_ERP;\nAlter pluggable database D19_ERP open;\nAlter pluggable database D19_ERP save state;\nshow pdbs\nexit<\/code><\/pre>\n\n\n\n<p>It does the job, although these are very basic scripts: further controls could be added to trap errors, manage services, and so on.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-5-schedule-the-refresh\">Step 5 : schedule the refresh<\/h2>\n\n\n\n<p>Scheduling can be done through the crontab, for example every evening at 11.30PM:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>crontab -l | grep D19_ERP | grep refresh\n30 23 * * * sh \/home\/oracle\/scripts\/refresh_D19_ERP.sh\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>This is definitely a smart solution as soon as you have enough space on disk to have 2 copies of the PDB. It&#8217;s quite reliable and ticks all the boxes where I deployed these scripts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback is the unavailability of the database being refreshed during the DUPLICATE. You first need to remove [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[3807,4057,311,4061,4062,4060,64,4058,1981,157],"type_dbi":[],"class_list":["post-44737","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-create-pluggable-database","tag-dev","tag-duplicate","tag-fast-refresh","tag-fast-refresh-pdb","tag-minimize-downtime","tag-multitenant","tag-qual","tag-refresh","tag-test"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Reduce downtime when refreshing your non-production databases using Multitenant - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to reduce the downtime when refreshing your non-production databases? It&#039;s easy when you&#039;re using Multitenant!\" \/>\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\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reduce downtime when refreshing your non-production databases using Multitenant\" \/>\n<meta property=\"og:description\" content=\"How to reduce the downtime when refreshing your non-production databases? It&#039;s easy when you&#039;re using Multitenant!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-21T09:55:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-21T09:56:44+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=\"3 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\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"Reduce downtime when refreshing your non-production databases using Multitenant\",\"datePublished\":\"2026-05-21T09:55:25+00:00\",\"dateModified\":\"2026-05-21T09:56:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/\"},\"wordCount\":597,\"commentCount\":0,\"keywords\":[\"create pluggable database\",\"dev\",\"duplicate\",\"fast refresh\",\"fast refresh pdb\",\"minimize downtime\",\"multitenant\",\"qual\",\"refresh\",\"test\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/\",\"name\":\"Reduce downtime when refreshing your non-production databases using Multitenant - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-05-21T09:55:25+00:00\",\"dateModified\":\"2026-05-21T09:56:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"description\":\"How to reduce the downtime when refreshing your non-production databases? It's easy when you're using Multitenant!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reduce downtime when refreshing your non-production databases using Multitenant\"}]},{\"@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":"Reduce downtime when refreshing your non-production databases using Multitenant - dbi Blog","description":"How to reduce the downtime when refreshing your non-production databases? It's easy when you're using Multitenant!","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\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/","og_locale":"en_US","og_type":"article","og_title":"Reduce downtime when refreshing your non-production databases using Multitenant","og_description":"How to reduce the downtime when refreshing your non-production databases? It's easy when you're using Multitenant!","og_url":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/","og_site_name":"dbi Blog","article_published_time":"2026-05-21T09:55:25+00:00","article_modified_time":"2026-05-21T09:56:44+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"Reduce downtime when refreshing your non-production databases using Multitenant","datePublished":"2026-05-21T09:55:25+00:00","dateModified":"2026-05-21T09:56:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/"},"wordCount":597,"commentCount":0,"keywords":["create pluggable database","dev","duplicate","fast refresh","fast refresh pdb","minimize downtime","multitenant","qual","refresh","test"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/","url":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/","name":"Reduce downtime when refreshing your non-production databases using Multitenant - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-05-21T09:55:25+00:00","dateModified":"2026-05-21T09:56:44+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"description":"How to reduce the downtime when refreshing your non-production databases? It's easy when you're using Multitenant!","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/reduce-downtime-when-refreshing-your-non-production-databases-using-multitenant\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Reduce downtime when refreshing your non-production databases using Multitenant"}]},{"@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\/44737","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=44737"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/44737\/revisions"}],"predecessor-version":[{"id":44738,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/44737\/revisions\/44738"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=44737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=44737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=44737"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=44737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}