{"id":3225,"date":"2013-09-05T07:33:10","date_gmt":"2013-09-05T05:33:10","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/"},"modified":"2013-09-05T07:33:10","modified_gmt":"2013-09-05T05:33:10","slug":"oracle-database-12c-the-secret-of-moving-datafiles-online","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/","title":{"rendered":"Oracle Database 12c: The secret of moving datafiles online"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\" alt=\"\" \/><\/p>\n<p>Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.<\/p>\n<p>To do that, I have written a tiny test protocol composed of two parts:<\/p>\n<ul>\n<li>Session 1: starts a batch (schema BATCH) processing which runs for hours<\/li>\n<li>Session 2: that\u2019s us, we are connected as SYS (of course we are DBA\u2019s) and we start moving the big datafile from file system u00 to u01 ONLINE.<\/li>\n<\/ul>\n<p>Session 1 and Session 2 are working concurrently. Session 1 writes heavily into the big datafile, whereas session 2 is moving this datafile online to a new (and of course faster) file system.<\/p>\n<p>On Linux (Oracle Linux), I have used the \u201cfuser\u201d command to figure out which processes are currently working on my original BIG datafile:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># fuser \/u00\/oradata\/PDB1\/tbs_big_file.dbf \n\/u00\/oradata\/PDB1\/tbs_big_file.dbf:\u00a0 3771\u00a0 3775\u00a0 3781\u00a0 4487<\/pre>\n<p>Those process IDs belong to Oracle background processes and the batch session, as shown below using the Linux command \u201cps\u201d:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># ps -ef | egrep \"3771|3775|3781|4487\" | grep -v egrep\noracle\u00a0\u00a0\u00a0 3771\u00a0\u00a0\u00a0\u00a0 1\u00a0 5 14:37 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:32 ora_dbw0_CDBUTF8\noracle\u00a0\u00a0\u00a0 3775\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:37 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_ckpt_CDBUTF8\noracle\u00a0\u00a0\u00a0 3781\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:37 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_smon_CDBUTF8\noracle\u00a0\u00a0\u00a0 4487\u00a0\u00a0\u00a0\u00a0 1 16 14:45 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:34 oracleCDBUTF8 (LOCAL=NO)<\/pre>\n<p>As the move of the big datafile has been initiated, I have performed the same operation to figure out which processes are working on the new datafiles on the faster file system:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># fuser \/u01\/oradata\/PDB1\/tst01.dbf \n\/u01\/oradata\/PDB1\/tst01.dbf:\u00a0 3771\u00a0 4767<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># ps -ef | egrep \"3771|4767\"| grep -v grep\noracle\u00a0\u00a0\u00a0 3771\u00a0\u00a0\u00a0\u00a0 1 11 14:37 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:02:38 ora_dbw0_CDBUTF8\noracle\u00a0\u00a0\u00a0 4767\u00a0 4766\u00a0 0 14:56 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:01 oracleCDBUTF8 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))<\/pre>\n<p>For verification, I have queried the dynamic performance views V$SESSION and V$PROCESS to crosscheck the process id (SPID):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; SELECT sess.username, proc.spid,sess.sid,sess.serial# \n\u00a0\u00a0\u00a0\u00a0 FROM v$session sess, v$process proc \n\u00a0\u00a0\u00a0\u00a0 WHERE proc.addr=sess.paddr AND sess.username IN ('BATCH','SYS');\nUSERNAME\u00a0\u00a0\u00a0 SPID \u00a0\u00a0 SID\u00a0\u00a0 \u00a0 \u00a0\u00a0 SERIAL#\n----------\u00a0 ------- ---------- ----------\nBATCH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4487\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 245\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 465\nSYS\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 4767\u00a0 \u00a0\u00a0\u00a0 \u00a0 133\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 295<\/pre>\n<p>As the online move operation takes several minutes, I had the idea to check the content of the view V$SESSION_LONGOPS.<br \/>\nThis view normally displays the status of various operations that run for longer than 6 seconds (in absolute time):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; SELECT sid,serial#,opname,ROUND(sofar\/totalwork*100,2) \"% Complete\" \n\u00a0 \u00a0\u00a0\u00a0 FROM v$session_longops WHERE opname LIKE 'Online%';\nSID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SERIAL#\u00a0\u00a0\u00a0 OPNAME\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 % Complete\n---------- ---------- ------------------------- ----------\n245\u00a0\u00a0\u00a0 \u00a0 \u00a0 465 \u00a0\u00a0\u00a0 Online data file move\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 44.11<\/pre>\n<p>As you can see, this enables you to monitor the operation. In addition, if you decide to display the column V$SESSION_LONGOPS.MESSAGE, you will see the progression in Bytes:<\/p>\n<p><code>Online data file move: data file 15: 4736417792 out of 10737418240 bytes done<\/code><\/p>\n<p>It clearly appears that the user process (Session 2 as SYS) is responsible for the copy of the datafile.<br \/>\nLike for a user-managed backup, the datafile copy is inconsistent, block might be fuzzy (Oracle terminology to describe blocks which are modified during a copy operation).<\/p>\n<p>The secret of the online datafile move resides in the fact that the Database Writer Process (DBWR) writes twice the changed blocks (from any database session) during the operation.<br \/>\nYou can verify this by comparing the \u201cphysical write total bytes\u201d at database instance level (V$SYSSTAT):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; SELECT stan.name, syst.value \nFROM v$sysstat syst,v$statname stan \nWHERE syst.statistic#=stan.statistic# \nAND stan.name='physical write total bytes';<\/pre>\n<p>P. S.: The moved datafile integrates the database structure only once the operation is completed.<br \/>\nI hope you enjoyed this small post about Oracle Database 12c!<\/p>\n<p>Cheers,<br \/>\nJ\u00e9r\u00f4me<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do that, I have written a tiny test protocol composed of two parts: Session 1: starts a [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":3226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[30,209],"type_dbi":[],"class_list":["post-3225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-data-file","tag-oracle-12c"],"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>Oracle Database 12c: The secret of moving datafiles online - dbi Blog<\/title>\n<meta name=\"description\" content=\"Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.\" \/>\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\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12c: The secret of moving datafiles online\" \/>\n<meta property=\"og:description\" content=\"Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-05T05:33:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Witt\" \/>\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 Witt\" \/>\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\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Witt\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7\"},\"headline\":\"Oracle Database 12c: The secret of moving datafiles online\",\"datePublished\":\"2013-09-05T05:33:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\"},\"wordCount\":416,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"keywords\":[\"Data file\",\"Oracle 12c\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\",\"name\":\"Oracle Database 12c: The secret of moving datafiles online - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"datePublished\":\"2013-09-05T05:33:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7\"},\"description\":\"Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"width\":300,\"height\":314},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12c: The secret of moving datafiles online\"}]},{\"@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\/a2d3ecddaf732850101a39b9d62c31b7\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 12c: The secret of moving datafiles online - dbi Blog","description":"Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.","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\/oracle-database-12c-the-secret-of-moving-datafiles-online\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 12c: The secret of moving datafiles online","og_description":"Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/","og_site_name":"dbi Blog","article_published_time":"2013-09-05T05:33:10+00:00","og_image":[{"width":300,"height":314,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","type":"image\/jpeg"}],"author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Witt","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/"},"author":{"name":"J\u00e9r\u00f4me Witt","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"headline":"Oracle Database 12c: The secret of moving datafiles online","datePublished":"2013-09-05T05:33:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/"},"wordCount":416,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","keywords":["Data file","Oracle 12c"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/","name":"Oracle Database 12c: The secret of moving datafiles online - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","datePublished":"2013-09-05T05:33:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"description":"Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","width":300,"height":314},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-the-secret-of-moving-datafiles-online\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12c: The secret of moving datafiles online"}]},{"@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\/a2d3ecddaf732850101a39b9d62c31b7","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3225","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\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3225"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3225\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3226"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3225"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}