{"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\/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;&nbsp;<\/p>\n","protected":false},"author":25,"featured_media":3226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[30,209],"class_list":["post-3225","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-data-file","tag-oracle-12c"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Database 12c: The secret of moving datafiles online - dbi services 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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/ee31feb6f100473958f6f8193c36f427\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"keywords\":[\"Data file\",\"Oracle 12c\"],\"articleSection\":[\"Database\"],\"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 services 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\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"datePublished\":\"2013-09-05T05:33:10+00:00\",\"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\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/ee31feb6f100473958f6f8193c36f427\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9r\u00f4me Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux\\\/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c\\\/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.\",\"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 services 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 services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","type":"image\/jpeg"}],"author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/ee31feb6f100473958f6f8193c36f427"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","keywords":["Data file","Oracle 12c"],"articleSection":["Database"],"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 services 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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","datePublished":"2013-09-05T05:33:10+00:00","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\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c_Plug.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ee31feb6f100473958f6f8193c36f427","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9r\u00f4me Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux\/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c\/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}