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


2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
SYS-CON.TV
Top Links You Must Click On


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

Enterprise Open Source Magazine Latest Stories . . .
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 solut...
Before embarking on using open source cloud technology for your web property, a basic understanding of cloud, as it’s used in the industry, is essential. While there might be exceptions, here are the definitions. A software application delivered on the web instead of installing standa...
Private clouds solve many problems for enterprises and bring unique operational challenges along with them. There are dozens of companies of all sizes that will build you a private cloud and turn over the keys – then what? Trying to convert a traditional enterprise IT operations team t...
The networking industry has gone through different waves over last 30+ years. In the ’80s, the first wave was all about connecting and sharing; how to connect a computer to other peripheral devices and other computers. There were many players who developed technology and services to ad...
If your organization already uses virtualized infrastructure, you are well on your way to providing IT as a Service. But as businesses demand faster results in today’s competitive market, organizations look to gain more benefits from cloud computing than just virtualized infrastructure...
In this CTO Power Panel at the 10th International Cloud Expo, moderated by Cloud Expo Conference Chair Jeremy Geelan, industry-leading CTOs & VPs of Technology will discuss such topics as: Which do you think is the most important cloud computing standard still to tackle? Who should...
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