Oracle Database on EC2 HA environment

Oracle Data Guard can be used to set up one or several slave databases which will be the foundation of a highly available environment. It maintains the standby databases as transaction- consistent copies of the primary database.  These instances can be placed in several availability zones.Then, if the production database becomes unavailable because of a planned or an unplanned outage of this instance or of the full availability zone, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage.  It has three protection modes allowing the customers to maximize protection, availability or performance. The Active Data Guard module enables read-only access to the standby databases, thereby allowing customers to run read queries and reports on the standby instances, and to perform the backups from a standby instance.

You can have zero data loss by using the appropriate data protection mode:

http://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm#CHDEDGIF

Oracle Data Guard on EC2

Oracle Data Guard can be used to set up one or several slave databases which will be the foundation of a highly available environment. It maintains the standby databases as transaction- consistent copies of the primary database.  These instances can be placed in several availability zones.Then, if the production database becomes unavailable because of a planned or an unplanned outage of this instance or of the full availability zone, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage.   The Active Data Guard module enables read-only access to the standby databases, thereby allowing customers to run read queries and reports on the standby instances, and to perform the backups from a standby instance.

You can have zero data loss by using the appropriate data protection mode:http://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm#CHDEDGIF

Oracle on AWS - EBS mirroring

Question RAID and EBS Raid 1 - Does AWS EBS provide recovery from an EBS volume since the data is automatically mirrored by AWS?

Response:  It depends on whether  you want control over the recovery for mirroring.   Using the built in mirroring means you do not control the mirroring and therefore when recovery happens.  Other options include using Oracle Standby DB/DataGuard, GoldenGate or even EBS snapshots.