{"id":38003,"date":"2025-04-11T17:40:52","date_gmt":"2025-04-11T15:40:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=38003"},"modified":"2025-04-11T17:44:41","modified_gmt":"2025-04-11T15:44:41","slug":"migrating-an-oracle-database-to-another-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/","title":{"rendered":"Migrating an Oracle database to another server"},"content":{"rendered":"\n<p>There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods for such migrations considering ease of use and reduced downtime. I do not cover migrations to the Oracle Cloud here, because the recommended way is to use the Zero Downtime Migration tool from Oracle for that.<\/p>\n\n\n\n<p>For a migration to another server, we have different possibilities:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data Pump expdp\/impdp<\/li>\n\n\n\n<li>Logical replication with e.g. Golden Gate<\/li>\n\n\n\n<li>Setup of a Standby DB with Data Guard (or third party products like dbvisit standby for Standard Edition 2 DBs) and switchover during cutover<\/li>\n\n\n\n<li>Using a refreshable PDB in case the multitenant architecture is already used. During migration, stop the source PDB and do a final refresh, stop refreshing and open the target PDB read\/write.<\/li>\n\n\n\n<li>Relocate a PDB<\/li>\n\n\n\n<li>Unplug PDB, copy PDB-related files and Plug-In the PDB<\/li>\n\n\n\n<li>RMAN backup and restore. To reduce downtime this can also be combined with incremental backups restored regularly on the target until cutover, when a last incremental backup is applied to the target DB.<\/li>\n\n\n\n<li>RMAN duplicate<\/li>\n\n\n\n<li>Data Pump Full Transportable, where you set your source tablespaces read only, export the metadata and physically move datafiles to the target, where you can import the metadata.<\/li>\n\n\n\n<li>Transportable tablespaces. This can be combined with Incremental Backups to do a cross platform migration to a different endian as described in MOS Note &#8220;V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)&#8221;<\/li>\n\n\n\n<li>Detaching ASM devices from the old server and attaching them to the new server.<br>REMARK: This is kind of what happens when migrating to a new OS-version on the Oracle Database Appliance with Data Preserving Reprovisioning (DPR). See the blogs from my colleague J\u00e9r\u00f4me Duba on that: <a href=\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/\">https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/<\/a><\/li>\n\n\n\n<li>Just copy (e.g. with scp) all needed files to the new server<\/li>\n<\/ul>\n\n\n\n<p>There are even more possibilities, but with above list you should find a method which fits your needs. Some of the methods above do require to be on the same Operating System and hardware architecture (no endian change), and some of them are totally independent on platform, version or endian change (like the logical migrations with data pump or Golden Gate).<\/p>\n\n\n\n<p>One of the best methods in my view is the possibility of <strong>refreshable PDBs<\/strong>, because<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>it is very easy to do<\/li>\n\n\n\n<li>provides a short downtime during cutover<\/li>\n\n\n\n<li>allows a fallback as the previous PDB is still available<\/li>\n\n\n\n<li>allows migrating PDBs individually at different times<\/li>\n\n\n\n<li>allows migrating non-CDBs to PDBs as well. I.e. I can refresh a non-CDB to a PDB.<\/li>\n\n\n\n<li>it is available since 12.2. and can also be used with Standard Edition 2 (SE2) DBs<\/li>\n\n\n\n<li>allows going to a different Release Update (RU)<\/li>\n\n\n\n<li>even allows going to a different major release and run the PDB upgrade afterwards on the target CDB<\/li>\n\n\n\n<li>if the source PDB is on SE2 then the target PDB can also be on Enterprise Edition (EE)<\/li>\n\n\n\n<li>moving Transparent Data Encrypted PDBs is almost as easy as moving non-encrypted PDBs<\/li>\n\n\n\n<li>the inital copy of the PDB can be done very fast as Oracle is using a block-level-copy mechanism when cloning a PDB and parallelism is allowed as well on EE<\/li>\n\n\n\n<li>we can use 3 PDBs per CDB since 19c without licensing the Multitenant Option. This provides some flexibility on which CDB to move the PDB to<\/li>\n<\/ul>\n\n\n\n<p>You may check this <a href=\"https:\/\/database-heartbeat.com\/2021\/02\/04\/minimal-downtime-patching-using-refreshable-pdb-clones\/\">blog<\/a> with the steps to do when migrating through the refreshable PDB mechanism.<\/p>\n\n\n\n<p>Can we migrate a 19c database to 23ai with refreshable PDBs? Yes, we can do that as shown below:<\/p>\n\n\n\n<p>REMARK: The whole process described below can be done with the autoupgrade tool automatically. However, to see each step separately, I do this manually here.<\/p>\n\n\n\n<p>1. Preparing the source CDB, which is on 19.22.:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>sys@CDB0&gt; select force_logging from v$database;\n\nFORCE_LOGGING\n---------------------------------------\nYES\n\nsys@CDB0&gt; create user c##refresh_pdbs identified by welcome1 container=all;\n\nUser created.\n\nsys@CDB0&gt; grant create session, create pluggable database to c##refresh_pdbs container=all;\n\nGrant succeeded.\n<\/code><\/pre>\n\n\n\n<p>2. Create the refreshable PDB<\/p>\n\n\n\n<p>To have a connection between the Oracle Cloud and my on-prem 19.22.-DB I used the method described here through a ssh-tunnel:<br><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/push-pdb-to-cloud\/\">https:\/\/www.ludovicocaldara.net\/dba\/push-pdb-to-cloud\/<\/a><\/p>\n\n\n\n<p>On the target server:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;oracle@db23aigi ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Apr 4 15:16:15 2025\nVersion 23.7.0.25.01\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 23ai EE High Perf Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems\nVersion 23.7.0.25.01\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME\t\t\t  OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n\t 2 PDB$SEED\t\t\t  READ ONLY  NO\n\t 3 PDB1 \t\t\t  READ WRITE NO\nSQL&gt; exit\nDisconnected from Oracle Database 23ai EE High Perf Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems\nVersion 23.7.0.25.01\n&#091;oracle@db23aigi ~]$ cat clone_db.sh \nSRC_PDB=$1\nTGT_PDB=$2\nALIAS=$3\n \nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/23.0.0.0\/dbhome_1\nexport ORACLE_SID=DB23AIGI\n \n$ORACLE_HOME\/bin\/sqlplus -s \/ as sysdba &lt;&lt;EOF\n        set timing on\n        create database link prod_clone_link connect to c##refresh_pdbs\n          identified by welcome1 using '$ALIAS';\n        create pluggable database $2 from $1@prod_clone_link refresh mode manual;\n        dbms_session.sleep(120);\n        alter pluggable database $2 refresh;\n        alter pluggable database $2 refresh mode none;\n        exit\nEOF\n&#091;oracle@db23aigi ~]$ <\/code><\/pre>\n\n\n\n<p>On the source-server:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>oracle@pm-DB-OEL8:~\/Keys\/dbi-OCI\/dbi3oracle\/DB-systems\/db23aigi\/ &#091;cdb0 (CDB$ROOT)] ssh -i .\/ssh-key-2025-04-04.key opc@&lt;public-ip-OCI&gt; -R 1522:pm-DB-OEL8:1521 \"sudo -u oracle \/home\/oracle\/clone_db.sh PROD PROD23AI localhost:1522\/PROD_PRI\"\n\nDatabase link created.\n\nElapsed: 00:00:00.01\n\nPluggable database created.\n\nElapsed: 00:06:16.42\n\nPluggable database altered.\n\nElapsed: 00:00:14.99\n\nPluggable database altered.\n\nElapsed: 00:00:00.78\noracle@pm-DB-OEL8:~\/Keys\/dbi-OCI\/dbi3oracle\/DB-systems\/db23aigi\/ &#091;cdb0 (CDB$ROOT)] <\/code><\/pre>\n\n\n\n<p>3. Upgrade the PDB to 23ai on the target server<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SQL&gt; alter pluggable database PROD23AI open upgrade;\n\nPluggable database altered.\n\nSQL&gt; select name, open_mode, restricted from v$pdbs where name='PROD23AI';\n\nNAME\t\t\t\t OPEN_MODE  RES\n-------------------------------- ---------- ---\nPROD23AI\t\t\t MIGRATE    YES\n\nSQL&gt; \n\n&#091;oracle@db23aigi ~]$ $ORACLE_HOME\/bin\/dbupgrade -c \"PROD23AI\" -l \/tmp\n....\nUpgrade Summary Report Located in:\n\/tmp\/upg_summary.log\n\n     Time: 673s For PDB(s)\n\nGrand Total Time: 673s \n\n LOG FILES: (\/tmp\/catupgrd*.log)\n\n\nGrand Total Upgrade Time:    &#091;0d:0h:11m:13s]\n&#091;oracle@db23aigi ~]$ <\/code><\/pre>\n\n\n\n<p>REMARK: As mentioned initially I should have used autoupgrade for the whole process (or just the upgrade) here as $ORACLE_HOME\/bin\/dbupgrade has been desupported in 23ai, but for demonstration purposes of refreshable PDBs it is OK.<\/p>\n\n\n\n<p>4. Final steps after the upgrade<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- check the PDB_PLUG_IN_VIOLATIONS view for unresolved issues\nSQL&gt; alter session set container=PROD23AI;\n\nSession altered.\n\nSQL&gt; select type, cause, message \nfrom PDB_PLUG_IN_VIOLATIONS \nwhere name='PROD23AI' and status != 'RESOLVED';  2    3  \n\nTYPE\t\tCAUSE\t\t\t       MESSAGE\n--------------- ------------------------------ ------------------------------------------------------------------------------------------\nWARNING \tis encrypted tablespace?       Tablespace SYSTEM is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.\nWARNING \tis encrypted tablespace?       Tablespace SYSAUX is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.\nWARNING \tis encrypted tablespace?       Tablespace USERS is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.\nWARNING \tTraditional Audit\t       Traditional Audit configuration mismatch between the PDB and CDB$ROOT\n\nSQL&gt; administer key management set key using tag 'new own key' force keystore identified by \"&lt;wallet password&gt;\" with backup;\n\nkeystore altered.\n\nSQL&gt; alter tablespace users encryption online  encrypt;\n\nTablespace altered.\n\nSQL&gt; alter tablespace sysaux encryption online  encrypt;\n\nTablespace altered.\n\nSQL&gt; alter tablespace system encryption online  encrypt;\n\nTablespace altered.\n\nSQL&gt; exec dbms_pdb.CLEAR_PLUGIN_VIOLATIONS;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select type, cause, message \nfrom PDB_PLUG_IN_VIOLATIONS \nwhere name='PROD23AI' and status != 'RESOLVED';\n\nno rows selected\n\n\n-- Recompile invalid objects using the utlrp.sql script:\nSQL&gt; alter session set container=PROD23AI;\n \nSession altered.\n \nSQL&gt; @?\/rdbms\/admin\/utlrp.sql\n \nPL\/SQL procedure successfully completed.\n\n-- Downtime ends. Check the DBA_REGISTRY_SQLPATCH view:\nSQL&gt; alter session set container=PROD23AI;\n \nSession altered.\n \nSQL&gt; select patch_id, patch_type, status, description, action_time from dba_registry_sqlpatch order by action_time desc;\n\n  PATCH_ID PATCH_TYPE STATUS\t DESCRIPTION\t\t\t\t\t\t      ACTION_TIME\n---------- ---------- ---------- ------------------------------------------------------------ --------------------------------\n  37366180 RU\t      SUCCESS\t Database Release Update : 23.7.0.25.01 (37366180) Gold Image 04-APR-25 04.00.06.975353 PM<\/code><\/pre>\n\n\n\n<p><strong>Summary:<\/strong><\/p>\n\n\n\n<p>If you haven&#8217;t done this yet, then I do recommend to migrate to the multitenant architecture as soon as possible. It makes several DBA tasks so much easier. Especially the migration to a new server with refreshable PDBs is very easy to do with low downtime, high flexibility and almost no impact on the source PDB during refreshes. On top of it you do not lose your source PDB during the process and may go back to it in case tests show that the target is not working correctly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[3598,96,3596],"type_dbi":[],"class_list":["post-38003","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-new-server","tag-oracle","tag-refreshable-pdb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Migrating an Oracle database to another server - 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\/migrating-an-oracle-database-to-another-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrating an Oracle database to another server\" \/>\n<meta property=\"og:description\" content=\"There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-11T15:40:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-11T15:44:41+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Migrating an Oracle database to another server\",\"datePublished\":\"2025-04-11T15:40:52+00:00\",\"dateModified\":\"2025-04-11T15:44:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/\"},\"wordCount\":849,\"commentCount\":0,\"keywords\":[\"new server\",\"Oracle\",\"refreshable PDB\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/\",\"name\":\"Migrating an Oracle database to another server - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2025-04-11T15:40:52+00:00\",\"dateModified\":\"2025-04-11T15:44:41+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/migrating-an-oracle-database-to-another-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrating an Oracle database to another server\"}]},{\"@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\\\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\\\/\\\/www.dbi-services.com\",\"https:\\\/\\\/x.com\\\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/clemens-bleile\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Migrating an Oracle database to another server - 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\/migrating-an-oracle-database-to-another-server\/","og_locale":"en_US","og_type":"article","og_title":"Migrating an Oracle database to another server","og_description":"There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/","og_site_name":"dbi Blog","article_published_time":"2025-04-11T15:40:52+00:00","article_modified_time":"2025-04-11T15:44:41+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Migrating an Oracle database to another server","datePublished":"2025-04-11T15:40:52+00:00","dateModified":"2025-04-11T15:44:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/"},"wordCount":849,"commentCount":0,"keywords":["new server","Oracle","refreshable PDB"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/","url":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/","name":"Migrating an Oracle database to another server - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-04-11T15:40:52+00:00","dateModified":"2025-04-11T15:44:41+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/migrating-an-oracle-database-to-another-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Migrating an Oracle database to another server"}]},{"@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\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38003","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=38003"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38003\/revisions"}],"predecessor-version":[{"id":38007,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38003\/revisions\/38007"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=38003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=38003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=38003"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=38003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}