Easy Database Migration to Oracle Cloud Infrastructure OCI by Creating a Backup in the Cloud

Oracle has provided an updated OCI command line toolset with a new and easy method to migrate an on-premises database into the Oracle Cloud Infrastructure as DBaaS. According the document here, I have tried it out – and it works: https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/mig-onprembackup.htm My Test Setup Oracle 18c Enterprise Edition with SID=ORA18 Single Tenant Architecture Oracle Linux 7.4 non TDE – Attention: non TDE on-premises data stays unencrypted in the cloud !!! Database and Server Prerequisites Archivelog Mode is enabled Parameter db_create_file_dest is set Server needs Internet Connection Oracle OCI CLI installed and configured – https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliinstall.htm#bash OPC Backup Module available –  https://www.oracle.com/technetwork/database/availability/oracle-cloud-backup-2162729.html Java installed – https://www.java.com/de/download/help/linux_x64rpm_install.xml The OCI CLI Directory  OCI CLI and opc_install.jar plus the .pem file have to be in the same directory. oracle@ol7ora18:~/migrate/…

Read More

Oracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 3

In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump.  Part 1: Creation of the ATP database and connection verification Part 2: Export of  on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Oracle Import Prerequisites Credentials To get acccess to the dump file on the Oracle Object Storage, a credential has to be created in the Oracle Autonomous Transaction Processing database with the DBMS_CLOUD procedure. For more information about the package, see the blog post from Christian Antognini – DBMS_CLOUD Package – A…

Read More

Oracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 2

In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump.  Part 1: Creation of the ATP database and connection verification Part 2: Export of  on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump   Oracle Data Pump Export on On-Premises Database Oracle recommends the following settings for the Oracle Data Pump export job. If you use already an 18c database, you have to set the version parameter to 12.2 to avoid this error during ATP import process: ORA-39358: Export dump file version 18.0.0…

Read More

Oracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 1

In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database Oracle Data Pump.  Part 1: Creation of the ATP database and connection verification Part 2: Export of  on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Basics about ATP from the Using Oracle Autonomous Transaction Processing User Guide: Autonomous Transaction Processing is designed to support all standard business applications and deliver scalable query performance. Autonomous Transaction Processing provides all of the performance of the marketleading Oracle Database in an environment that is tuned and optimized for transaction processing workloads. As…

Read More

Oracle Database Backup Service – Encrypt your 12.2 Database Backups to the Cloud

The Oracle RMAN backup encryption is necessary if you want to backup your database into the Oracle cloud. In Oracle 12c, you have three methods available to encrypt an Oracle RMAN backup: with a passphrase with a master encryption key hybrid with a passphrase and an encryption key On docs.oracle.com, the basic setup is described here: https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/configuring-encryption-backups.html#GUID-4A1F5CF5-7EAF-4D71-9B7F-B46412F552CE In this blog post, I show you how to configure your database environment with a master encryption key and a keystore. I use this solution to to backup and recovery to and into the Oracle cloud. And in the cloud, I don’t like to type in passwords manually for every action or write passwords in backup and restore scripts. There are also some…

Read More