AWS Database Blog

Category: RDS for Oracle

Best practices for upgrading Amazon RDS for Oracle database snapshots

Amazon Relational Database Service (Amazon RDS) for Oracle provides the option to take manual DB snapshots of your databases. These DB snapshots may have to be retained for regulatory purposes or just as backups taken before any major database or application activities like upgrades or releases. When you create a DB snapshot, the snapshot is […]

Read More

Implement Oracle GoldenGate high availability in the AWS Cloud

The need to move data from one location to another in an asynchronous manner is a goal for many enterprises. Use cases might include migrating data to a reporting database, moving applications from on premises to the cloud, storing a redundant copy in another data center, configuring active/active databases across geographic locations, and performing heterogeneous […]

Read More

Implement high availability for Oracle Enterprise Manager in the AWS Cloud

As you migrate Oracle workloads to AWS, you may want to implement Oracle Enterprise Manager (OEM) Cloud Control in AWS. OEM is Oracle’s management platform, which provides a single pane of glass for managing Oracle environments. In this post, we provide two solutions to implement OEM high availability in AWS. The first solution is Oracle’s […]

Read More

Load and unload data without permanently increasing storage space using Amazon RDS for Oracle read replicas

Generally, DBAs use Oracle Data Pump to move data around for activities like migrating existing data from Oracle on-premises to Amazon Relational Database Service (Amazon RDS) for Oracle or refreshing Oracle on-premises by exporting data from Amazon RDS for Oracle. As of this writing, after you create an RDS DB instance, you can’t decrease the […]

Read More

Implement Oracle Database Resident Connection Pool with Amazon RDS for Oracle

This post describes how to configure Oracle Database Resident Connection Pool (DRCP) in an Amazon Relational Database Service (Amazon RDS) for Oracle environment. You can use DRCP with application servers that can’t do middle-tier connection pooling. You can also use DRCP to manage hundreds or thousands of database connections from clients spread across multiple application […]

Read More

Automate post-database creation scripts or steps in an Amazon RDS for Oracle database

In some cases, Database Administrators (DBAs) need to run post-database creation steps such as running SQL statements for creating users and database objects, resetting passwords, or standardizing Oracle database builds. This is mainly done during the database creation phase of new application deployment or during database refreshes that occur in non-production environments. AWS CloudFormation gives […]

Read More

Validate Native Network Encryption on Amazon RDS for Oracle

Many organizations go through auditing, and have to meet auditing compliance policies that require data to be encrypted over the network from application servers to the database server. Oracle Database provides two types of network security encryption methods: native network encryption (NNE) and Secure Sockets Layer (SSL). Amazon Relational Database Service (Amazon RDS) for Oracle […]

Read More

Upgrading Amazon RDS for Oracle database engine with minimal downtime using AWS DMS

Amazon Relational Database Service (Amazon RDS) for Oracle is a managed database service that makes it easier to set up, operate, and scale Oracle deployments on AWS. Amazon RDS for Oracle provides newer versions of Oracle Database so you can keep your DB instance up to date. Newer versions can include bug fixes, security enhancements, […]

Read More

Managed disaster recovery with Amazon RDS for Oracle cross-Region automated backups – Part 2

In the first part of this series, we discussed several use cases for including a second Region in your disaster recovery (DR) plans for your Amazon Relational Database Service (Amazon RDS) for Oracle  database instances. We also introduced cross-Region automated backups to assist you in establishing and maintaining cross-Region point in time restore (PITR) capability for your Amazon […]

Read More

Managed disaster recovery with Amazon RDS for Oracle cross-Region automated backups – Part 1

Today, customers using Amazon Relational Database Service (Amazon RDS) for Oracle have several managed high availability (HA) and disaster recovery (DR) capabilities to choose from based on your business requirements and use cases: With Amazon RDS Multi-AZ, you get enhanced availability and durability for database (DB) instances within a specific AWS Region. This is often […]

Read More