Resiliency in database workloads involves withstanding and recovering from failures, which is essential for critical business applications.
High availability and disaster recovery are vital for a resilient database architecture, with metrics like RPO and RTO guiding the design.
AWS offers options like Amazon RDS or self-managed Amazon EC2 for running Oracle Database workloads.
Different architecture patterns and options are available for the compute and storage layers when configuring self-managed Oracle databases on Amazon EC2.
Considerations for Oracle Database AMIs and Amazon EBS storage are crucial for designing resilient and performant database environments.
Multiple architecture patterns are discussed, including configurations with Data Guard, Active Data Guard, Amazon EBS, and Oracle ASM for volume management.
Cross-Region disaster recovery using Data Guard can provide high availability and data protection for critical workloads, with multiple standby databases.
Backup considerations include using Oracle native tools, AWS Backup, and RMAN to meet data protection, disaster recovery, and compliance needs.
Start with RPO and RTO requirements, choose appropriate HA and DR options, and consider Amazon EBS and AWS Backup when running Oracle databases on Amazon EC2.
The authors are specialists from Amazon Web Services, focusing on database projects, migrations to AWS Cloud, and building resilient architectures.