Introduction This blog post describes the steps to migrate from Oracle RDS to Autonomous Database using Oracle Zero Downtime Migration (ZDM) logical online method, which leverages Oracle Data Pump for data export and import and uses Amazon S3 Object Storage to store the Data Pump dump files. Additionally, it uses Oracle GoldenGate to keep the…
Introduction This blog post describes the steps to migrate from Oracle RDS to Autonomous Database using Oracle Zero Downtime Migration (ZDM) logical offline method, which leverages Oracle Data Pump for data export and import and uses Amazon S3 Object Storage to store the Data Pump dump files. The Environment Step 1: Download and Install Oracle…
Introduction Customers can deploy Oracle Autonomous Database Serverless (ADB-S) on Oracle Database@Azure to benefit from Autonomous Database features in the Azure’s data center, next to their Azure applications, ensuring low latency and high performance. This blog post highlights the options to migrate your data from an Oracle database on-premises to ADB-S on Oracle Database@Azure. Option…
Introduction You can create a database link in the Oracle Autonomous Database to another Autonomous Database, to an Oracle Database that is not an Autonomous Database, or to Non-Oracle Databases. See the documentation for more details. This blog post shows how to create a database link from an Oracle Autonomous Database on Oracle Database@Azure to…
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
Introduction Oracle Autonomous Database is based on Oracle RAC and Exadata and hence, highly available by design. But how about your application? What happens to sessions getting interrupted by a maintenance event (e.g., patching), a local failure (e.g., instance crash), or (accidentally) terminated by a KILL SESSION command? Let’s give it a try! You can…
Introduction Oracle Autonomous Database provides a fully automated, self-securing database service with a wide range of security features, including: Always-on Transparent Data Encryption (TDE) to secure your data at rest. Automated encrypted backups. SQL*Net encryption for client connections. Oracle-managed and customer-managed encryption keys. Access Control Lists to restrict access to trusted sources only. Database Vault…
Introduction AWS Relational Database Service (RDS) provides a managed service for several database engines, including Oracle. It offers automation for administration tasks like provisioning, patching, and backup. Hence, it is often compared to Oracle Autonomous Database on Shared Exadata Infrastructure. However, the differences are tremendous, especially (and not only) regarding database high availability. This is…
Introduction Since day one, I have been involved in discussions about whether Oracle Autonomous Database runs on Oracle RAC and whether the CPUs are distributed on multiple RAC nodes only for 17 OCPUs or more. Does that actually matter? No! But many, including me, always want to know more about what’s happening behind the scene.…
Do you want to develop an application and need a database? Create an Oracle Autonomous Database, download the Client Credentials, connect to the database, and create your first table, all in 50 seconds. Without pre-installing any tools. Open the Cloud Shell in your Cloud Console and execute the following few lines after adjusting the values…
Database Heartbeat 