AWS Database Blog

Category: RDS for Oracle

How AEVI substituted Oracle materialized views fast refresh with AWS DMS when migrating to Amazon Aurora

AEVI took the journey to migrate to AWS. In their own words, “AEVI provides merchant-facing businesses—banks, acquirers, PSPs, ISOs, ISVs, and others—with a platform that enables merchants to run their business smarter by giving them easy access to any payment technology and business solution for the best in-store customer experience. AEVI’s Platform for Smart Merchant […]

Read More

Set Oracle diagnostics system events on Amazon RDS for Oracle

With Amazon Relational Database Service (Amazon RDS) for Oracle, you can now set Oracle diagnostic events parameters requested by Oracle Support at the system level to enable Oracle to dump additional diagnostics information from the database instance on the Oracle database Ora-errors or process context of a malfunctioning process. You can set these events parameters […]

Read More

Security auditing in Amazon RDS for Oracle: Part 2

Security auditing is an effective method of enforcing strong internal controls that can enable you to monitor business operations to find activities that may deviate from company policy and meet various regulatory compliance requirements. Security auditing allows you to record the activity on the database for future examination and is one part of an overall […]

Read More

Security auditing in Amazon RDS for Oracle: Part 1

Due to compliance requirements and increasing security threats, security auditing has become more important to implement than ever before. Security auditing is an effective method of enforcing strong internal controls that enable you to monitor business operations to find any activities that may deviate from company policy and meet various regulatory compliance requirements. Security auditing […]

Read More

Physical migration of Oracle databases to Amazon RDS Custom using Data Guard

This blog post was reviewed and updated May 2022. In the first post of this series, we showed you how to perform a physical migration of an Oracle database into Amazon RDS Custom using the RMAN duplicate tool. In this post, we walk through the steps to migrate Oracle databases into Amazon RDS Custom using […]

Read More

Physical migration of Oracle databases to Amazon RDS Custom using RMAN duplication

This blog post was reviewed and updated May 2022. Organizations are moving their self-managed Oracle databases to AWS managed database services to modernize their applications and gain access to cloud services. With Amazon RDS Custom, you now have the privileges needed to perform a physical migration of your Oracle database into Amazon Relational Database Service […]

Read More

Restore Amazon RDS for Oracle to a self-managed infrastructure using RMAN duplication

Amazon Relational Database Service (Amazon RDS) for Oracle is a fully managed commercial database that makes it easy to set up, operate, scale a relational database in the cloud. It takes care of installation, storage provisioning, management, OS and database patching, backup and restore automatically. This helps you focus your efforts on where you can […]

Read More

Restore an Amazon RDS for Oracle instance to a self-managed instance

Fully managed database services often bring lots of benefits to customers for running their database workload in the cloud, such as easy administration and high scalability, availability, and durability. Amazon Relational Database Service (Amazon RDS) for Oracle is a fully managed commercial database that makes it easy to set up, operate, and scale Oracle database […]

Read More

Migrate from Amazon RDS for Oracle to Aurora PostgreSQL or Amazon RDS for PostgreSQL using this self-service guide

Today, we’re introducing the Amazon Database Migration Accelerator (DMA) Connect program which is designed to help you migrate from Amazon Relational Database Service (Amazon RDS) for Oracle to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL. Migration to Amazon RDS for Oracle is a common first step for many customers making their foray into […]

Read More

Automate Amazon RDS backups using the Oracle RMAN utility and upload backup files to Amazon S3

Amazon Relational Database Service (Amazon RDS) for Oracle creates automated snapshots and allows creation of user-initiated manual snapshots in a Region. In addition, Amazon RDS for Oracle supports Oracle native backup tools like Oracle Recovery Manager (RMAN) and Oracle Data Pump. Many organizations spend considerable time and resources to manage and maintain database backups to […]

Read More