AWS Database Blog

Arnab Saha

Author: Arnab Saha

Arnab Saha is a Senior Database Specialist Solutions Architect at Amazon Web Services. Arnab specializes in Amazon RDS, Amazon Aurora , AWS DMS and Amazon Elastic Block Store. He provides guidance and technical assistance to customers for building scalable, highly available and secure solutions in AWS Cloud.

Manage users and privileges in Amazon RDS Custom for Oracle with Multitenant option

Oracle Multitenant feature is available in Oracle database from 12cR1 (12.1.0.1) and later. This enables customers to use multiple PDBs in a single Oracle database, facilitating better manageability and consolidation of environments. In Oracle Multitenant architecture, there are various user management approaches available that can be used to create and manage user accounts in the container database (CDB) and PDBs. In this post we discuss the options for managing users and how they can be set up and used for different scenarios.

How Infosys used Amazon Aurora zero-ETL integration with Amazon Redshift for near real-time analytics and insights

In this post, we talk about how Infosys redefined the ETL landscape for their product sales and freight management application using Aurora zero-ETL to Amazon Redshift. We also explain our experience with the old process and how the new zero-ETL integration helped us effortlessly move data into a Redshift cluster for analytics along with metrics to monitor the health of the integration.

Use Oracle Forms and Reports on Amazon RDS Custom for Oracle

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Amazon RDS: Snapshot, restore, and recovery demystified

Amazon Relational Database Service (Amazon RDS) is a managed relational database service offering. The managed service automation of Amazon Web Services (AWS) takes care of installation, storage provisioning, storage management, OS and database patching, and snapshot and restore of database instances. Offloading the undifferentiated heavy lifting of database infrastructure management to AWS helps you focus […]

Multitenant best practices for Amazon RDS Custom for Oracle

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

AWS DMS key troubleshooting metrics and performance enhancers

In this post, we discuss AWS Database Migration Service (AWS DMS) and how you can use Amazon CloudWatch and logs to monitor the performance and health of a replication task. Additionally, we discuss how to set up CloudWatch Alarms for an AWS DMS task as well as instance related metrics that we configure to receive […]

Monitor Amazon RDS Custom for SQL Server using Amazon CloudWatch

Amazon RDS Custom for SQL Server is a managed database service for applications that require customization of the underlying operating system and database environment. Amazon RDS Custom allows you to access and customize your database server host and operating system, for example, by applying special patches and changing the database software settings to support third-party […]

Monitor Amazon RDS Custom for Oracle with Amazon CloudWatch metrics

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

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 […]