Re: AWS capability question - Near 0 RPO options?

Chris,

Whether you're on-prem or in cloud...

• RAC, RAC one-node, and OS-level HA clusters (i.e. Pacemaker/Corosync, etc) provide protection only to the /database //service/, not to the /data/ in the database/ / o RPO isn't a factor with service protection, as RPO is a characteristic of /data protection// /
• Restore/recovery from database backups can not guarantee RPO lower than the initialization parameter setting for ARCHIVE_LAG_TARGET o ...and there are many reasons to consider RPO to be at least twice the ARCHIVE_LAG_TARGET value as well...
• Data replication utilities like GoldenGate, SharePlex, etc cannot guarantee RPO=0 due to all the queuing and forwarding necessary o "/eventual consistency/" also implies that "/eventual/" could turn out to be "/never/"

-Tim

On 9/23/2022 3:51 AM, Chris Taylor wrote:
> Hey guys, recently started working at a new company that's moving
> their Oracle database to AWS.
>
> One of the things they want is a near-0 RPO.
>
> I was looking into AWS snapshot and replication to accomplish this
> which seems pretty doable.
> Either in the same region or into another region in case the region
> was down/unavailable.
>
> So I'm looking for two things:
> 1.) Other options?  Active-Passive setup in 2 different regions? 
> (Like Failover but non-RAC)
> 2.) Anyone using AWS and snapshot copies & replication for Oracle in AWS?
>
> Reference:
>
> (Taking snapshots)
>
> https://aws.amazon.com/blogs/database/improving-oracle-backup-and-recovery-performance-with-amazon-ebs-multi-volume-crash-consistent-snapshots/
>
> (Replicating Snapshots) em>
> https://aws.amazon.com/blogs/aws/ebs-snapshot-copy/
>
>
> Thanks,
> Chris

--
http://www.freelists.org/webpage/oracle-l