Oracle Database on Amazon Web Services Book

The first book that covers running Oracle on Amazon Web Services:
http://www.amazon.com/Oracle-Databases-Amazon-Web-Services/dp/012800956X

Written by these companies:
http://www.appsassociates.com/awslabs/
http://aws.amazon.com/rds/partners/dbvisit/
http://www.e-dba.com/oracle_labs_aws.html

Oracle Database AMIs

An easy way to Bring Your Own License (BYOL) to AWS and start running the Oracle Database is to utilize the AWS Marketplace AMIs.  There are six AMIs for Oracle 12c and 11g.  Standard Edition One, Standard Edition and Enterprise Edition versions are available for both 12c and 11g. All these Marketplace AMIs, use PIOPS with a provisioning of 500 IOPS.  The OS system is Red Hat Enterprise Linux 6.5. The AWS Marketplace AMIs can be found here:

https://aws.amazon.com/marketplace/search/results/ref=sp_navgno_search_box?page=1&searchTerms=oraclempbyol

Oracle Database on SSD

New options for running the Oracle Database on EC2 using SSD storage for your database. The I2 instances feature the latest generation of Intel Ivy Bridge processors - each virtual CPU (vCPU) is a hardware hyperthread from an Intel Xeon E5-2670 v2 (Ivy Bridge) processor. I2 instances are available in four sizes as listed in the table below. Instance Type vCPUs ECU Rating Memory (GiB) Instance Storage SSD (GB) Note           i2.xlarge 4 14 30.5 1 x 800 800 GB of SSD i2.2xlarge 8 27 61 2 x 800 1.6 TB of SSD i2.4xlarge 16 53 122 4 x 800 3.2 TB of SSD. hi.4xlarge with 2 TB  of SSD was previously largest SSD instance type i2.8xlarge 32 104 244 8 x 800 6.4 TB of SSD The i2.8xlarge instance size is capable of providing over 365,000 4 kilobyte (KB) random read IOPS and over 315,000 4 KB random write IOPS.   Great for Oracle databases that have high IO requirements.  This document has more on configuring Oracle Databases on EC2 and using SSD based instances : http://cloudconclave.blogspot.com/2013/11/aws-database-reference-implementation.html

AWS Database reference implementation

This reference implementation provides the architecture and associated CloudFormation templates for a standard, enterprise class, large enterprise class and high performance Oracle 11g configuration on AWS EC2:

http://media.amazonwebservices.com/AWS_RDBMS_Oracle_11g_on_EC2_Reference_Architecture.pdf

Oracle Database on AWS white paper

This white paper is a great resource for Oracle DBAs and developers:

http://media.amazonwebservices.com/AWS_RDBMS_Oracle.pdf

Best Practices for running Oracle Database on EC2

Register for this session on Tuesday, October 8TH:

https://www2.gotomeeting.com/register/196955594

Oracle Secure Backup restore

A benchmark test using OSB, a DBA, was able to restore 3.8 terabytes in 2.5 hours over gigabit Ethernet. This amounts to 25 gigabytes per minute, or 422MB per second. This 2.5 hours using OSB and S3 compares to, conservatively, 10-15 hours that would be required to restore from tape.

Gettings started with Oracle DB on AWS

Here are some links to get you started with Oracle database on AWS (EC2 and RDS):

• Oracle on AWS FAQ - http://www.oracle.com/technetwork/topics/cloud/faq-098970.html
• Landing page on AWS - http://aws.amazon.com/oracle/
• Oracle Amazon Machine Imagines - https://aws.amazon.com/amis?ami_provider_id=4&selection=ami_provider_id.  You can find the latest OEL AMIs, for OEL 5.9 and 6.4, at the bottom of this web page: http://aws.amazon.com/oracle/        
• Marketplace AMIs - Can be found here:  https://aws.amazon.com/marketplace/search/results/ref=srh_navgno_search_box?page=1&searchTerms=oracle+database+12c
• AWS EC2 Instances (you manage the database) - http://aws.amazon.com/ec2/instance-types/
• AWS EC2 Pricing - http://aws.amazon.com/pricing/ec2/
• AWS Pricing calculator - http://calculator.s3.amazonaws.com/calc5.html
• AWS RDS (managed database) - http://aws.amazon.com/rds/oracle/
• 10g Database - This can only be run on EC2 as RDS does not support 10g.
• Licensing - http://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf
• AWS RDS limitations - http://docs.amazonwebservices.com/AmazonRDS/latest/UserGuide/Concepts.DBEngine.Oracle.html
• Download and use the Oracle Database on AWS reference implementation - Oracle Database 11g on Amazon EC2 Implementation Guide
• Review the presentations here - http://www.slideshare.net/tomlaszewski