AWS Database Blog

Tag: Oracle

Migrating Oracle databases with near-zero downtime using AWS DMS

Do you have critical Oracle OLTP databases in your organization that can’t afford downtime? Do you want to migrate your Oracle databases to AWS with minimal or no downtime? In today’s fast-paced world with 24/7 application and database availability, some of your applications may not be able to afford significant downtime while migrating on-premises databases […]

Improving Oracle backup and recovery performance with HAQM EBS multi-volume crash-consistent snapshots

HAQM Elastic Block Store (EBS) snapshots offer the ability to back up the data on your EBS volumes to HAQM S3 by taking point-in-time snapshots. If you run your Oracle Databases on HAQM EC2 and use EBS volumes, you may be using EBS snapshots to meet your backup requirements. Prior to May 2019, you had […]

Continuous database replication using AWS DMS to migrate from Oracle to HAQM Aurora

This is a guest post from IPG. In their own words, “IPG, based in Japan, specializes in TV-related data. We use data from broadcasters across Japan, format it for easy use and understanding, structure it with metatags, and make it simple to use on any platform, like smartphones.” This post discusses the different optimizations we […]

Integrating HAQM RDS for Oracle with HAQM S3 using S3_integration

HAQM RDS for Oracle gives you the full benefits of a managed service solution. You can use the lift-and-shift approach to migrate your legacy Oracle database to HAQM RDS for Oracle and, as a result, reduce the need to refactor and change existing application components. Data warehouse (DW) extraction is an integral part of most […]

Best practices for migrating an Oracle database to HAQM RDS PostgreSQL or HAQM Aurora PostgreSQL: Target database considerations for the PostgreSQL environment

An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog post is the third in a series that discusses high-level aspects about the components to consider for a database migration. The series doesn’t […]

Best practices for migrating an Oracle database to HAQM RDS PostgreSQL or HAQM Aurora PostgreSQL: Source database considerations for the Oracle and AWS DMS CDC environment

An Oracle to PostgreSQL migration in AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. To better understand details of the complexities involved, see the AWS Database Blog post Database Migration—What Do You Need to Know Before You Start? This blog […]

Best practices for migrating an Oracle database to HAQM RDS PostgreSQL or HAQM Aurora PostgreSQL: Migration process and infrastructure considerations

An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog series covers the environment and configuration setups for your source Oracle database, the AWS Database Migration (AWS DMS) service, and the target PostgreSQL […]

How to migrate from Oracle to HAQM Aurora MySQL using AWS CloudFormation (Part 1)

Database migrations are challenging, especially for heterogeneous database migrations such as Oracle to HAQM Aurora PostgreSQL, Oracle to HAQM Aurora MySQL, or Microsoft SQL Server to MySQL. The schema structure, data types, and database code of source databases can be quite different from those of the target databases, requiring a schema and code transformation step before the […]

HAQM Aurora as an Alternative to Oracle RAC

Written by David Yahalom, CTO and co-founder of NAYA Tech—a leading database, big data, and cloud professional and consulting service provider, located in San Jose, CA. In this post, I discuss how HAQM Aurora can serve as a powerful and flexible alternative to Oracle RAC. Both Oracle RAC and HAQM Aurora are designed to provide increased high availability and performance scalability for your databases.

VPC Configuration

Cross-Region Automatic Disaster Recovery on HAQM RDS for Oracle Database Using DB Snapshots and AWS Lambda

Sameer Malik is a specialist solutions architect and Christian Williams is an enterprise solutions architect at HAQM Web Services. Many AWS users are taking advantage of the managed service offerings that are available in the AWS portfolio to remove much of the undifferentiated heavy lifting from their day-to-day activities. HAQM Relational Database Service (HAQM RDS) […]