{"id":22441,"date":"2023-02-13T17:30:53","date_gmt":"2023-02-13T16:30:53","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=22441"},"modified":"2023-02-13T17:38:10","modified_gmt":"2023-02-13T16:38:10","slug":"migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/","title":{"rendered":"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)"},"content":{"rendered":"\n<p>Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of these managed migration services require that the source system is running Linux. So what do you do when you&#8217;re running Windows? <br>Well this blog details one way using Oracle Data Guard to perform a cross platform migration from Windows to a Linux Server in OCI.  As I didn&#8217;t have a Windows Server available, I decided to use AWS to host the Windows server. This made the test a little more complicated and I had to resort to using a SSH Tunnel for migration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Environment<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Original \/ Primary Database &#8211; AWS<\/strong><\/td><td><\/td><\/tr><tr><td>Server<\/td><td>cda-srv-01<\/td><\/tr><tr><td>Operating System<\/td><td>Windows Server 2019<\/td><\/tr><tr><td>Database Version<\/td><td>19.17.0.0.0<\/td><\/tr><tr><td>Database Name<\/td><td>AWSTEST<\/td><\/tr><tr><td>Database Unique Name<\/td><td>AWSTEST_AWS<\/td><\/tr><tr><td><strong>Migration \/ Standby  Target &#8211; Oracle Cloud Infrastructure<\/strong><\/td><td><\/td><\/tr><tr><td>Server<\/td><td>oci-node2-public<\/td><\/tr><tr><td>Operating System<\/td><td>Oracle Linux Server release 7.9<\/td><\/tr><tr><td>Database Version<\/td><td>19.17.0.0.0<\/td><\/tr><tr><td>Database Name<\/td><td>AWSTEST<\/td><\/tr><tr><td>Database Unique Name<\/td><td>AWSTEST_OCI<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Setup Oracle Cloud Infrastructure<\/h2>\n\n\n\n<p>Create an Oracle DB System in Oracle Cloud Infrastructure using a Public Subnet so that the database can be accessed from the internet. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"814\" height=\"189\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg\" alt=\"\" class=\"wp-image-22525\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg 814w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip-300x70.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip-768x178.jpg 768w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>The Security List for this Public Subnet should be restricted to only allow in-comming connections from the Public IP addresses of the AWS Server and the Oracle OCI Database System.<\/p>\n\n\n\n<p>The Public IP addresses of the Servers can be found using the following commands:<\/p>\n\n\n\n<p><strong>Windows Powershell<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PS C:\\Users\\Administrator&gt; <mark class=\"has-inline-color has-vivid-purple-color\">(curl -uri \"http:\/\/ifconfig.me\/ip\").Content<\/mark>\n3.xxx.xxx.xxx\nPS C:\\Users\\Administrator&gt;\n<\/code><\/pre>\n\n\n\n<p><strong>Linux Bash<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;opc@oci-node2-public ~]$ <mark class=\"has-inline-color has-vivid-purple-color\">curl -w '\\n' 'ifconfig.me'<\/mark>\n140.xxx.xxx.xxx\n&#091;opc@oci-node2-public ~]$<\/code><\/pre>\n\n\n\n<p>Here is an example of the Ingress Rules:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"288\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/oci_ingress_rules-1024x288.jpg\" alt=\"\" class=\"wp-image-22489\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/oci_ingress_rules-1024x288.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/oci_ingress_rules-300x84.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/oci_ingress_rules-768x216.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/oci_ingress_rules.jpg 1353w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Setup the Primary database for Data Guard<\/h2>\n\n\n\n<p>The Oracle Listener has to listen on the port 1522, as this port has been forward from the standby server to the primary server. Using Port 1522 allows the <strong>StaticConnectIdentifier <\/strong>entry to be resolveable on both servers.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = <mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST_AWS_DGMGRL<\/mark> )\n      (ORACLE_HOME = C:\\app\\oracle\\product\\19.0.0\\dbhome_1)\n      (SID_NAME = <mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST<\/mark>)\n    )\n  )\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = <mark class=\"has-inline-color has-vivid-purple-color\">cda-srv-01<\/mark>)(PORT = <mark class=\"has-inline-color has-vivid-purple-color\">1522<\/mark>))\n    )\n  )<\/code><\/pre>\n\n\n\n<p>Setup the entries in tnsnames.ora<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>AWSTEST_AWS = (DESCRIPTION=\n              (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<strong><mark class=\"has-inline-color has-vivid-purple-color\">localhost<\/mark><\/strong>)(PORT=<strong><mark class=\"has-inline-color has-vivid-purple-color\">1522<\/mark><\/strong>)))\n              (CONNECT_DATA=(SERVICE_NAME=<strong><mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST_AWS_DGMGRL<\/mark><\/strong>))\n            )\n\nAWSTEST_OCI = (DESCRIPTION=\n              (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<strong><mark class=\"has-inline-color has-vivid-purple-color\">140.xxx.xxx.xxx<\/mark><\/strong>) (PORT=<strong><mark class=\"has-inline-color has-vivid-purple-color\">1521<\/mark><\/strong>)))\n              (CONNECT_DATA= (SERVICE_NAME=<strong><mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST_OCI_DGMGRL<\/mark><\/strong>))\n            )<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Startup SSH Tunnel<\/h2>\n\n\n\n<p>From the Primary Server cda-srv-01 start the ssh tunnel to forward the remote port 1522 to the local port 1522.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh  -R 1522:localhost:1522 -N -f oracle@140.xxx.xxx.xxx<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Setup the Standby Server<\/h2>\n\n\n\n<p>Delete the database created by OCI. Delete the controlfiles, datafiles, tempfiles and logfiles Keep the <strong>spfile <\/strong>and <strong>password <\/strong>file. <\/p>\n\n\n\n<p>The listener.ora requires a static entry for the Standby database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>LISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = <mark class=\"has-inline-color has-vivid-purple-color\">oci-node2-public<\/mark>)(PORT = <mark class=\"has-inline-color has-vivid-purple-color\">1521<\/mark>))\n    )\n  )\n\nSID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = <mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST_OCI_DGMGRL <\/mark>)\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1 )\n      (SID_NAME = <mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST<\/mark>)\n    )\n  )<\/code><\/pre>\n\n\n\n<p>Setup the entries in tnsnames.ora<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>AWSTEST_AWS = (DESCRIPTION=\n              (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<strong><mark class=\"has-inline-color has-vivid-purple-color\">localhost<\/mark><\/strong>)(PORT=<strong><mark class=\"has-inline-color has-vivid-purple-color\">1522<\/mark><\/strong>)))\n              (CONNECT_DATA=(SERVICE_NAME=<strong><mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST_AWS_DGMGRL<\/mark><\/strong>))\n            )\n\nAWSTEST_OCI = (DESCRIPTION=\n              (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=<strong><mark class=\"has-inline-color has-vivid-purple-color\">140.xxx.xxx.xxx<\/mark><\/strong>) (PORT=<strong><mark class=\"has-inline-color has-vivid-purple-color\">1521<\/mark><\/strong>)))\n              (CONNECT_DATA= (SERVICE_NAME=<strong><mark class=\"has-inline-color has-vivid-purple-color\">AWSTEST_OCI_DGMGRL<\/mark><\/strong>))\n            )<\/code><\/pre>\n\n\n\n<p>Reset the  db_file_name_convert &amp; log_file_name_convert parameters as we are using Oracle Managed Files.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>alter system reset db_file_name_convert;\nalter system reset log_file_name_convert;<\/code><\/pre>\n\n\n\n<p>Copy the password from the primary database to the standby:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd $env:ORACLE_HOME\\database\nscp PWDAWSTEST.ora oracle@140.xxx.xxx.xxx:\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/dbs\/orapwAWSTEST<\/code><\/pre>\n\n\n\n<p>Startup the standby database in nomount status.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sqlplus \/ as sysdba\nstartup nomount<\/code><\/pre>\n\n\n\n<p>Duplicate the primary database to the standby.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rman target <mark class=\"has-inline-color has-vivid-purple-color\">sys@AWSTEST_AWS<\/mark> auxiliary <mark class=\"has-inline-color has-vivid-purple-color\">sys@AWSTEST_OCI<\/mark>\n\nduplicate target database for standby from active database;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Enable Data Guard &amp; Switchover<\/h2>\n\n\n\n<p>On the Primary and Standby databases:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>alter system set dg_broker_start=true;<\/code><\/pre>\n\n\n\n<p>Setup Data Guard configuration:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create configuration 'AWS' as\n  primary database is AWSTEST_AWS\n  connect identifier is 'AWSTEST_AWS';\n\nedit database AWSTEST_AWS\n  set property StaticConnectIdentifier =\n  '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=AWSTEST_AWS_DGMGRL)(INSTANCE_NAME=awstest)(SERVER=DEDICATED)))';\n\nadd database AWSTEST_OCI as connect identifier is 'AWSTEST_OCI' maintained as physical;\n\nedit database AWSTEST_OCI\n  set property StaticConnectIdentifier =\n  '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=140.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=AWSTEST_OCI_DGMGRL)(INSTANCE_NAME=AWSTEST)(SERVER=DEDICATED)))';\n\nedit database AWSTEST_OCI set property LogXptMode = ARCH;\nedit database AWSTEST_AWS set property LogXptMode = ARCH;\n\nenable configuration\n<\/code><\/pre>\n\n\n\n<p>Perform Switchover<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>show configuration verbose\nvalidate database awstest_aws\nvalidate database awstest_oci\nswitchover to awstest_oci\nswitchover to awstest_aws<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;oracle@oci-node2-public ~]$ <kbd><mark class=\"has-inline-color has-vivid-purple-color\">dgmgrl<\/mark><\/kbd>\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat Feb 11 15:34:29 2023\nVersion 19.17.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nWelcome to DGMGRL, type \"help\" for information.\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">connect sys\/<em>password<\/em>@AWSTEST_AWS<\/mark><\/kbd><\/strong>\nConnected to \"AWSTEST_AWS\"\nConnected as SYSDBA.\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">show configuration verbose<\/mark><\/kbd><\/strong>\n\nConfiguration - AWS\n\n  Protection Mode: MaxPerformance\n  Members:\n  awstest_aws - Primary database\n    awstest_oci - Physical standby database\n\n  Properties:\n    FastStartFailoverThreshold      = '30'\n    OperationTimeout                = '30'\n    TraceLevel                      = 'USER'\n    FastStartFailoverLagLimit       = '30'\n    CommunicationTimeout            = '180'\n    ObserverReconnect               = '0'\n    FastStartFailoverAutoReinstate  = 'TRUE'\n    FastStartFailoverPmyShutdown    = 'TRUE'\n    BystandersFollowRoleChange      = 'ALL'\n    ObserverOverride                = 'FALSE'\n    ExternalDestination1            = ''\n    ExternalDestination2            = ''\n    PrimaryLostWriteAction          = 'CONTINUE'\n    ConfigurationWideServiceName    = 'AWSTEST_CFG'\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS\n\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">validate database awstest_aws<\/mark><\/kbd><\/strong>\n\n  Database Role:    Primary database\n\n  Ready for Switchover:  Yes\n\n  Flashback Database Status:\n    awstest_aws:  Off\n\n  Managed by Clusterware:\n    awstest_aws:  NO\n    Validating static connect identifier for the primary database awstest_aws...\n    The static connect identifier allows for a connection to database \"awstest_aws\".\n\nDGMGRL&gt; <strong><mark class=\"has-inline-color has-vivid-purple-color\">validate database awstest_oci<\/mark><\/strong>\n\n  Database Role:     Physical standby database\n  Primary Database:  awstest_aws\n\n  Ready for Switchover:  Yes\n  Ready for Failover:    Yes (Primary Running)\n\n  Flashback Database Status:\n    awstest_aws:  Off\n    awstest_oci:  Off\n\n  Managed by Clusterware:\n    awstest_aws:  NO\n    awstest_oci:  NO\n    Validating static connect identifier for the primary database awstest_aws...\n    The static connect identifier allows for a connection to database \"awstest_aws\".\n\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">switchover to awstest_oci<\/mark><\/kbd><\/strong>\nPerforming switchover NOW, please wait...\nOperation requires a connection to database \"awstest_oci\"\nConnecting ...\nConnected to \"AWSTEST_OCI\"\nConnected as SYSDBA.\nNew primary database \"awstest_oci\" is opening...\nOperation requires start up of instance \"awstest\" on database \"awstest_aws\"\nStarting instance \"awstest\"...\nConnected to an idle instance.\nORACLE instance started.\nConnected to \"AWSTEST_AWS\"\nDatabase mounted.\nSwitchover succeeded, new primary is \"awstest_oci\"\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">show configuration verbose<\/mark><\/kbd><\/strong>\n\nConfiguration - AWS\n\n  Protection Mode: MaxPerformance\n  Members:\n  awstest_oci - Primary database\n    awstest_aws - Physical standby database\n\n  Properties:\n    FastStartFailoverThreshold      = '30'\n    OperationTimeout                = '30'\n    TraceLevel                      = 'USER'\n    FastStartFailoverLagLimit       = '30'\n    CommunicationTimeout            = '180'\n    ObserverReconnect               = '0'\n    FastStartFailoverAutoReinstate  = 'TRUE'\n    FastStartFailoverPmyShutdown    = 'TRUE'\n    BystandersFollowRoleChange      = 'ALL'\n    ObserverOverride                = 'FALSE'\n    ExternalDestination1            = ''\n    ExternalDestination2            = ''\n    PrimaryLostWriteAction          = 'CONTINUE'\n    ConfigurationWideServiceName    = 'AWSTEST_CFG'\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS\n\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">switchover to awstest_aws<\/mark><\/kbd><\/strong>\nPerforming switchover NOW, please wait...\nOperation requires a connection to database \"awstest_aws\"\nConnecting ...\nConnected to \"AWSTEST_AWS\"\nConnected as SYSDBA.\nNew primary database \"awstest_aws\" is opening...\nOperation requires start up of instance \"AWSTEST\" on database \"awstest_oci\"\nStarting instance \"AWSTEST\"...\nConnected to an idle instance.\nORACLE instance started.\nConnected to \"AWSTEST_OCI\"\nDatabase mounted.\nSwitchover succeeded, new primary is \"awstest_aws\"\nDGMGRL&gt; <strong><kbd><mark class=\"has-inline-color has-vivid-purple-color\">show configuration verbose<\/mark><\/kbd><\/strong>\n\nConfiguration - AWS\n\n  Protection Mode: MaxPerformance\n  Members:\n  awstest_aws - Primary database\n    awstest_oci - Physical standby database\n\n  Properties:\n    FastStartFailoverThreshold      = '30'\n    OperationTimeout                = '30'\n    TraceLevel                      = 'USER'\n    FastStartFailoverLagLimit       = '30'\n    CommunicationTimeout            = '180'\n    ObserverReconnect               = '0'\n    FastStartFailoverAutoReinstate  = 'TRUE'\n    FastStartFailoverPmyShutdown    = 'TRUE'\n    BystandersFollowRoleChange      = 'ALL'\n    ObserverOverride                = 'FALSE'\n    ExternalDestination1            = ''\n    ExternalDestination2            = ''\n    PrimaryLostWriteAction          = 'CONTINUE'\n    ConfigurationWideServiceName    = 'AWSTEST_CFG'\n\nFast-Start Failover:  Disabled\n\nConfiguration Status:\nSUCCESS\n\nDGMGRL&gt;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>With the above method I was able to migrate an Oracle database from AWS into the Oracle Cloud Infrastructure, with Data Guard via a ssh tunnel. The ssh tunnel was necessary as I don&#8217;t have direct routing between the AWS &amp; OCI clouds, and this setup allows me to test various migration methods anyway.<\/p>\n\n\n\n<p>I wouldn&#8217;t necessarily recommend this in a production environment, as there are number of security issues, like connecting a database server directly to the internet and opening a tunnel between the 2 cloud providers that could violate some organisational security policies.<\/p>\n\n\n\n<p>In this test, the migration was performed between a AWS Sandbox and an Oracle OCI Sandbox where only the Oracle Demo accounts are installed in the database and there is no danger to any other infrastructure. The test environment will be deleted when testing is complete.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of these managed migration services require that the source system is running Linux. So what do you [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,229,59],"tags":[133,221,280,73,1375,96,549],"type_dbi":[],"class_list":["post-22441","post","type-post","status-publish","format-standard","hentry","category-cloud","category-database-administration-monitoring","category-oracle","tag-aws","tag-data-guard","tag-database","tag-linux","tag-oci","tag-oracle","tag-windows"],"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>Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI) - dbi Blog<\/title>\n<meta name=\"description\" content=\"Blog about migrating a Oracle DB from a Windows Server on AWS to an Oracle Cloud Infrastructure (OCI) Database System\" \/>\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\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)\" \/>\n<meta property=\"og:description\" content=\"Blog about migrating a Oracle DB from a Windows Server on AWS to an Oracle Cloud Infrastructure (OCI) Database System\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-13T16:30:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-13T16:38:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)\",\"datePublished\":\"2023-02-13T16:30:53+00:00\",\"dateModified\":\"2023-02-13T16:38:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\"},\"wordCount\":580,\"commentCount\":2,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg\",\"keywords\":[\"AWS\",\"Data Guard\",\"database\",\"Linux\",\"OCI\",\"Oracle\",\"Windows\"],\"articleSection\":[\"Cloud\",\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\",\"name\":\"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg\",\"datePublished\":\"2023-02-13T16:30:53+00:00\",\"dateModified\":\"2023-02-13T16:38:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Blog about migrating a Oracle DB from a Windows Server on AWS to an Oracle Cloud Infrastructure (OCI) Database System\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg\",\"width\":814,\"height\":189},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI) - dbi Blog","description":"Blog about migrating a Oracle DB from a Windows Server on AWS to an Oracle Cloud Infrastructure (OCI) Database System","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\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/","og_locale":"en_US","og_type":"article","og_title":"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)","og_description":"Blog about migrating a Oracle DB from a Windows Server on AWS to an Oracle Cloud Infrastructure (OCI) Database System","og_url":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/","og_site_name":"dbi Blog","article_published_time":"2023-02-13T16:30:53+00:00","article_modified_time":"2023-02-13T16:38:10+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg","type":"","width":"","height":""}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)","datePublished":"2023-02-13T16:30:53+00:00","dateModified":"2023-02-13T16:38:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/"},"wordCount":580,"commentCount":2,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg","keywords":["AWS","Data Guard","database","Linux","OCI","Oracle","Windows"],"articleSection":["Cloud","Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/","url":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/","name":"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg","datePublished":"2023-02-13T16:30:53+00:00","dateModified":"2023-02-13T16:38:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Blog about migrating a Oracle DB from a Windows Server on AWS to an Oracle Cloud Infrastructure (OCI) Database System","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/02\/tempsnip.jpg","width":814,"height":189},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/migration-with-data-guard-oracle-on-windows-aws-to-oracle-cloud-infrastructure-oci\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22441","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=22441"}],"version-history":[{"count":24,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22441\/revisions"}],"predecessor-version":[{"id":22535,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/22441\/revisions\/22535"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=22441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=22441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=22441"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=22441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}