Comments
bruce.armstrong wrote: Somebody just said it better than I did, and with more chops to say it: Open Letter to Mark Zuckerberg, Sheryl Sandberg & Facebook Mobile
Cloud Expo on Google News

SYS-CON.TV
Cloud Expo & Virtualization 2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Building Enterprise Class Oracle Databases on Amazon Web Services
Some considerations for building of robust, bullet proof Oracle Databases on Amazon Web Services

AWS is built on commodity hardware and it is software virtual machine based. AWS documentation states that:

It's inevitable that EC2 instances will fail, and you need to plan for it.

As a rule of thumb, you should be a pessimist when designing architecture for the cloud.

That means that putting your Oracle databases on AWS cloud should be accompanied with carefully thought out fault tolerance and DR procedures.

It is likely that:

  1. An AWS instance running Oracle database will fail
  2. Some of volumes ( EBS storage ) attached to an instance running Oracle database will fail, i.e., you will lose access to your instance and data at some point.

Usual practice of performing Oracle database backups should be carefully implemented and monitored. Databases can be backed up efficiently and conveniently to AWS S3 disk based storage using RMAN/S3 MML interface. This includes lower, non-production environments, to reduce rebuild time and preserve database side structures - tables and stored procedures.

File system configuration and Oracle database configuration should be recorded and stored safely away to serve as a starting point for server rebuild. Adding new EBS volumes should be done via a command tool that will automatically append volume creation command to volume recreation script. This script will be executed first when volumes need to be rebuilt.

Oracle configuration files ( spfile, listener.ora, OraInventory directory ) and Oracle binaries should be backed up daily via EBS snapshots. Oracle binaries can be restored either via recreation from AMI or by using EBS snapshots.  Database itself can then be restored either from the latest RMAN/S3 backup or from hot backup stored as an EBS snapshot.

Production databases that can not afford restore downtime need to have DR ( physical standby database ) set up. AWS also recommends taking periodic EBS snapshots to increase volume durability. Be sure to put database in hot backup mode (begin backup) before taking snapshots of EBS volumes containing Oracle datafiles. These snapshots can be used as a secondary recovery method.

Use AWS Elastic IPs so that IP addresses can be easily reassigned to newly started instance on instance failure.

According to AWS using custom-made RAID solutions on top of EBS is not of much help and should not be considered.

All database restore scripts should be ready and tested, as well as DR switchover/failover scripts and procedures for mission-critical databases. Monitoring should be in place to periodically check for  instance and storage health and to alert on failure.

About Ranko Mosic
Ranko Mosic is consultant - provider of remote Oracle Database Administration Services. He has more than 20 years of experience in IT industry in various consulting roles throught North America. He can be reached at ranko.mosic@gmail.com

Latest Cloud Developer Stories
HP said Wednesday that it would lay off 8% of workforce, 27,000 people, by October or 2014. It figures the move will save it $3 billion-$3.5 billion and expects to re- invest the money in cloud, security and Big Data.
With Cloud Expo 2012 New York (10th Cloud Expo) now under three weeks away, what better time to introduce you in greater detail to the distinguished individuals in our incredible Speaker Faculty for the technical and strategy sessions at the conference... We have technical and...
What do the CTOs of the CIA and the U.S. Dept. of Justice and the CIO of the National Reconnaissance Office have in common with the CEOs of Eucalyptus, GoGrid, ActiveState, Appcara, OpSource and Nortonworks, the CTOs of Rackspace, SoftLayer, SOA Software and AppZero, the Founder ...
Grid Dynamics, an eCommerce technology solutions company, and GridGain Systems, makers of an open source in-memory platform for Big Data processing, on Wednesday announced the expansion of their partnership which began in 2008. Grid Dynamics provides personalization and big data...
ServerCentral, Chicago’s leading provider of colocation, cloud, network connectivity, and managed services, announced on Tuesday that its high performance cloud will debut on June 11 at the 10th International Cloud Expo, held June 11-14 at the Javits Center in New York City. “Se...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021

SYS-CON Featured Whitepapers
ADS BY GOOGLE

Breaking Cloud Computing News
Acceleware® Ltd. ("Acceleware" or the "Company") (TSX VENTURE:AXE), a leading developer of high perf...