{"id":802,"date":"2020-09-21T19:05:36","date_gmt":"2020-09-21T22:05:36","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=802"},"modified":"2020-10-11T14:50:38","modified_gmt":"2020-10-11T17:50:38","slug":"zdlra-maa-protection-for-gold-architecture","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/","title":{"rendered":"ZDLRA + MAA, Protection for Gold Architecture"},"content":{"rendered":"<p style=\"text-align: justify;\">The Gold architecture for MAA is used to emphasis the application continuity. All the possible outages (planned or no) are protected by Oracle features. Here we are one step further and start to design using multi-site architecture. Data Guard, RAC, Oracle Clusterware, everything is there. But even with these, ZDLRA is still needed to allow complete protection.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-783\" src=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png\" alt=\"\" width=\"1917\" height=\"1079\" srcset=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png 1917w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-300x169.png 300w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-1024x576.png 1024w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-768x432.png 768w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-1536x865.png 1536w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-624x351.png 624w\" sizes=\"auto, (max-width: 1917px) 100vw, 1917px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">The image above taken from <a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maa-overview-onpremise-2019.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.oracle.com\/a\/tech\/docs\/maa-overview-onpremise-2019.pdf<\/a>.<\/p>\n<p style=\"text-align: justify;\">With the <a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maximum-availability-wp-19c.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">MAA references<\/a>, we have the <a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maa-overview-onpremise-2019.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">blueprints<\/a> and highlights how to protect them since the standalone\/single instance until the multiple site database. But for Gold we are beyond RPO and RTO, they are important but application continuity and data continuity join to complete the whole picture.<\/p>\n<p style=\"text-align: justify;\"><!--moreClick here to read more...--><\/p>\n<h2 style=\"text-align: justify;\">Gold Architecture<\/h2>\n<p style=\"text-align: justify;\">If the Silver architecture focuses on High Availability (HA), the Gold focus in Disaster Recovery (DR). Even suffering a complete site outage is possible to survive with zero data loss, and beyond that, without loss of connection form the application side. Here the goal is critical databases and applications, those that can\u2019t tolerate loss and need to have a quick response to outages.&nbsp;<\/p>\n<p style=\"text-align: justify;\">If we check the base architecture, we can see the usage for Data Guard is fundamental\/requirement. It can do intra-site protection (to provide a fast switchover\/failover \u2013 or FarSync in case of long-distance for standby), and a multi-site synchronization.&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">Data Guard<\/h3>\n<p style=\"text-align: justify;\">The addition of Data Guard allow the environment to be HA (since is 100% compatible with RAC) but also includes data protection and disaster recovery. I will not cover all features of DG here, but will highlight some of them for Gold architecture (if you want to see all a comprehensive information, you can check <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/haovw\/high-availability-overview.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">this doc about HA<\/a>):<\/p>\n<ul style=\"text-align: justify;\">\n<li>HA+DR: If you think about application continuity, the connection needs to continue even from a complete site outage. The RAC+DG is required for Gold architecture to have HA and DR. Services can be created to be automatically activated when the role change occurs.<\/li>\n<li>Active DG: Active DG is a superset of traditional DG, but it allows us to use some features and open (in read-only mode) the standby database. So, you can relocate some services to connect at standby and scalable more the architecture.<\/li>\n<li>Block Repair: When using Active DG is possible to recover one corrupted block (in primary as an example) reading it directly from the other side. Think that now, when you have on corruption, there is no impact on RPO and RTO.<\/li>\n<li>DML Standby: This is a new feature that was released for 19c (for 18c just with an underscore parameter) that allows you to send DML commands at standby and these will be applied at the primary database. This is important because if you need to connect at standby (to do a report from the application), and this application needs to record something (like an audit), now is possible. I made a post about this feature some time ago, you can <a href=\"https:\/\/www.fernandosimon.com\/blog\/dml-over-standby-for-active-data-guard-in-19c\/\" target=\"_blank\" rel=\"noopener noreferrer\">read it here<\/a>.<\/li>\n<li>Far-Sync: This feature allows what is called \u201czero data loss any distance\u201d because to have zero RPO\/RTO you need to operate DG at SYNC mode. But if your primary is in Tokyo and standby in London? The latency for every transaction will kill the performance. Using the Far-Sync you can have a local copy (with just part of your database) near your primary just to operate in SYNC the redo, and the Far-Sync will send in ASYNC mode to the standby. In the case of a primary site outage, the RPO\/RTO can be zero due to SYNC mode, but the transaction will not be affected because the network trip between primary and far-sync are small.<\/li>\n<li>Standby-First Patch: This allows us to apply patches in standby first and continue the operation without interruption in the primary database. This is good because, in case of a software error, the fix can be applied at standby to bypass the bug. One example is the bug <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/BugDisplay?id=29129534\" target=\"_blank\" rel=\"noopener noreferrer\">29129534<\/a>\/<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/PatchDetail?patchId=25518372\" target=\"_blank\" rel=\"noopener noreferrer\">25518372<\/a> that affects the backups\/restores, this can be applied at standby, and standby backups can be used to restore\/clone the database.<\/li>\n<li>Rolling Upgrades: with DG is possible to automatize part of the process for the upgrade of the database, this reduces a lot the RTO of your database in case of upgrades, or even the outage in case of planned maintenance. So, again, application continuity.<\/li>\n<li>Fast-Start Failover\/Broker: The Broker allows you to use the fast-start failover and automatize the failure detection in case of an outage. The failover occurs automatically without intervention. So, the RTO can be reduced to zero even for complete site outage, data continues always available and the application continuity as well. I already wrote about it in the past and you can read the series <a href=\"https:\/\/www.fernandosimon.com\/blog\/observer-where\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/li>\n<li>Observer-Only\/Health-Conditions: Sometimes we need to have better control of how the failover occurs, maybe we don\u2019t want that it occurs (during network maintenance as on the example). So, is possible (at 19c version) put the FSFO in Observe-Only mode, and even change some checks that are valid or no to do the failover. I already wrote about this in a previous post, you can <a href=\"https:\/\/www.fernandosimon.com\/blog\/fast-start-failover-observe-only-mode-and-health-conditions\/\" target=\"_blank\" rel=\"noopener noreferrer\">read it here<\/a>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">All of these features help the Gold architecture to reduce the RPO and RTO to zero. If you check the most important is the Data Guard itself. You can run your database at a non-Engineered System machine and continue to have zero RPO. The Exadata usage is recommended, not required.<\/p>\n<p style=\"text-align: justify;\">If you want to check more technical details please <a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maximum-availability-wp-19c.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">read this doc<\/a>.<\/p>\n<h3 style=\"text-align: justify;\">The Architecture<\/h3>\n<p style=\"text-align: justify;\">Look the traditional design from one&nbsp; <a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/maa-reference-architectures-2244929.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">old version of the MAA Reference Architecture doc<\/a>:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/09\/MAA-Gold-No-ZDLRA.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-803 size-full\" src=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/09\/MAA-Gold-No-ZDLRA.png\" alt=\"\" width=\"997\" height=\"310\" srcset=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/09\/MAA-Gold-No-ZDLRA.png 997w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/09\/MAA-Gold-No-ZDLRA-300x93.png 300w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/09\/MAA-Gold-No-ZDLRA-768x239.png 768w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/09\/MAA-Gold-No-ZDLRA-624x194.png 624w\" sizes=\"auto, (max-width: 997px) 100vw, 997px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">And the outage matrix is:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"208\"><strong>Event<\/strong><\/td>\n<td width=\"208\"><strong>RPO<\/strong><\/td>\n<td width=\"208\"><strong>RTO<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"208\"><strong>Hardware Error<\/strong><\/td>\n<td width=\"208\">Zero<\/td>\n<td width=\"208\">Zero<\/td>\n<\/tr>\n<tr>\n<td width=\"208\"><strong>Database Error (SW)<\/strong><\/td>\n<td width=\"208\">Zero<\/td>\n<td width=\"208\">Zero<\/td>\n<\/tr>\n<tr>\n<td width=\"208\"><strong>Database Corruption<\/strong><\/td>\n<td width=\"208\">Zero<\/td>\n<td width=\"208\">Zero<\/td>\n<\/tr>\n<tr>\n<td width=\"208\"><strong>Site Outage<\/strong><\/td>\n<td width=\"208\">Zero*<\/td>\n<td width=\"208\">Zero<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: justify;\"><strong>Hardware Error<\/strong>: Even occurring HW error for the machines running the primary database, you can failover\/switchover to the standby without losing data. And if your primary database runs over RAC, before switch\/fails you need to have all nodes failings (what is not common).<\/li>\n<li style=\"text-align: justify;\"><strong>Database Error<\/strong>: For SW error, using DG, is not an outage that will cause data loss or even application continuity error. Remember that you can patch the standby. So, in case of some error, you can patch it and switchover and the application continues to runs without a gasp.<\/li>\n<li style=\"text-align: justify;\"><strong>Database Corruption<\/strong>: For logical and physical corruption both sides can be used to restore the exact block. So, there is no outage caused by this error (on both sides).<\/li>\n<li style=\"text-align: justify;\"><strong>Site Outage<\/strong>: The point for site outage is important because even with complete loss your data is in another site and read for usage. But you need to guarantee that both (PRY and STB) are synced<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">The architecture is pretty simple, you have your database replicated and synced in another datacenter. Is really recommended that you run in RAC (both sides) because in case of a simple HW error you don\u2019t need to switchover\/failover to standby.<\/p>\n<p style=\"text-align: justify;\">A failover is usually a complex operation because involves a lot of things. You need that your application is able to connect on the other side. And is really important that both sides are synced. If you have one outage\/maintenance at your standby and at the same time occurs one outage at primary, you don\u2019t have where to switch\/failover. So, DG environments are nice but require quite more care than a traditional instance (single or RAC). A lot of more external problems (like a network) can break a running DG. As an architect, we need to think in more details to reduce the simple point of failure. Like multiple network connections between DC\u2019s.<\/p>\n<p style=\"text-align: justify;\">One important detail in the design is that the synchronization between DC\u2019s is done by DG. Solutions like replicated storage, extended environments can be not suitable (or even more complex and expensive) to sustain for Gold architecture. Keep it simple.<\/p>\n<h2 style=\"text-align: justify;\">ZDLRA to protect Gold Architecture<\/h2>\n<p style=\"text-align: justify;\">If we check the new version of the <a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maximum-availability-wp-19c.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">MAA Architecture Reference<\/a> the ZDLRA is there for Gold Architecture. But, why? Why we need ZDLRA if the RPO is Zero? I will explain:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-783 size-full\" src=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png\" alt=\"\" width=\"1917\" height=\"1079\" srcset=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png 1917w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-300x169.png 300w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-1024x576.png 1024w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-768x432.png 768w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-1536x865.png 1536w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold-624x351.png 624w\" sizes=\"auto, (max-width: 1917px) 100vw, 1917px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">The image above taken from <a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maa-overview-onpremise-2019.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.oracle.com\/a\/tech\/docs\/maa-overview-onpremise-2019.pdf<\/a><\/p>\n<p style=\"text-align: justify;\"><strong>The ZDLRA is there, mainly, to remove the Single Point of Failure. Look at the schematic above and imagine that you have a network outage between sites. What will be your RPO in case of failure? It will be huge, if you have an HW failure you will lose data (think in one environment that you are not running over Exadata). So, ZDLRA is your second line of defense. Is there to protects and guarantee the ZERO RPO even when the standby is offline<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Another point in the Gold architecture, the ZDLRA operates isolate (where each one protects the respective database), but ZDLRA from the primary site can be used by standby to read the backups (and vice-versa). And again, DG is the responsible database synced between DC\u2019s.<\/p>\n<p style=\"text-align: justify;\">The outage matrix when using ZDLRA is:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"201\"><strong>Event<\/strong><\/td>\n<td width=\"200\"><strong>RPO<\/strong><\/td>\n<td width=\"200\"><strong>RTO<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"201\"><strong>Hardware Error<\/strong><\/td>\n<td width=\"200\">Zero<\/td>\n<td width=\"200\">Zero<\/td>\n<\/tr>\n<tr>\n<td width=\"201\"><strong>Database Error (SW)<\/strong><\/td>\n<td width=\"200\">Zero<\/td>\n<td width=\"200\">Zero<\/td>\n<\/tr>\n<tr>\n<td width=\"201\"><strong>Database Corruption<\/strong><\/td>\n<td width=\"200\">Zero<\/td>\n<td width=\"200\">Zero<\/td>\n<\/tr>\n<tr>\n<td width=\"201\"><strong>Site Outage<\/strong><\/td>\n<td width=\"200\">Zero<\/td>\n<td width=\"200\">Zero<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\"><strong>And again, in case of failure of the database the ZDLRA will generate a partial archivelog until the moment of failure. This means that for every failure HR\/SW\/Corruption ZDLRA will protect until the last SCN generated by the database<\/strong><strong>. So, whatever the outage, you have one copy of all your transactions at an external place that is not linked (at any level like storage\/HW) with your database.<\/strong><\/p>\n<h3 style=\"text-align: justify;\">How to use ZDLRA<\/h3>\n<p style=\"text-align: justify;\">The way to use ZDLRA is quite different for Gold. As explained before, the DG is responsible to sync the databases between sites, and even to provide the RPOT\/RTO. At least the first line of protection. For the second line, we use ZDLRA.<\/p>\n<p style=\"text-align: justify;\">So, more or less, the steps to have a Gold architecture are (I will use my previous posts as a guide):<\/p>\n<ul style=\"text-align: justify;\">\n<li><a href=\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/11\/Steps-RAC-RAC-DG-Creation.txt\" target=\"_blank\" rel=\"noopener noreferrer\">Create a DG environment (RAC + RAC synced with DG)<\/a>.<\/li>\n<li><a href=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-multi-site-protection-zero-rpo-for-primary-and-standby\/\" target=\"_blank\" rel=\"noopener noreferrer\">Enrolling and protecting both sides with ZDLRA<\/a>.<\/li>\n<li><a href=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-osb-and-clone-to-tape\/\" target=\"_blank\" rel=\"noopener noreferrer\">ZDLRA and clones to tape<\/a><\/li>\n<li><a href=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-dataguard-archivelogs-and-rman-08137\/\" target=\"_blank\" rel=\"noopener noreferrer\">ZDLRA, DG, and Rman configuration to avoid errors<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Following these steps, you will have everything: Primary and Standby databases running with Oracle RAC and synced. Both will be protected by the correspondent ZDLRA, and the backups will be cloned to tapes as well. So, more than two lines\/fronts of protection.<\/p>\n<p style=\"text-align: justify;\">If you need more information about ZDLRA itself you can read my <a href=\"https:\/\/www.fernandosimon.com\/blog\/category\/engineeredsystems\/zdlra\/\" target=\"_blank\" rel=\"noopener noreferrer\">blog series about ZDLRA<\/a>. For ZDLRA and MAA integration, more details can be check at this <a href=\"https:\/\/www.oracle.com\/technetwork\/database\/availability\/disaster-recovery-2526839.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">doc about ZDLRA and MAA<\/a>.<\/p>\n<h2 style=\"text-align: justify;\">Trying to protect without ZDLRA<\/h2>\n<p style=\"text-align: justify;\">So, if we don\u2019t want to use ZDLRA for Gold architecture we can still have (more or less the same RPO\/RTO), but we will have a single point of failure. As I already wrote above, if your standby is down (for any reason, planned or no), your primary is unprotected. Basically, you drop from Gold to Bronze, you will be unprotected and your RPO\/RTO will be undefined. An this can be worst because maybe you need to follow some regulations that require you to have some kind of replication\/protection for your primary database to avoid single point of failure.<\/p>\n<p style=\"text-align: justify;\">It is really hard to design several levels of protection for outrages for Gold Architecture. We can replicate storages, but they need to be different here. Think that usually, the companies don\u2019t have a lot of datacenters (they cost a lot do maintain). So, if your standby DC is down, we need to have the storage replicated to a third one, and this needs to be the same for Standby. In the end we are talking about four DC\u2019s to have the same level of protection that ZDLRA can provide (and as you can imagine, they will be cheaper). And again, the same ZDLRA that protects Gold will protect Silver and Bronze architectures, and 100% integrated with MAA architecture.<\/p>\n<h3 style=\"text-align: justify;\">References<\/h3>\n<p style=\"text-align: justify;\">I will list some references for Gold architecture that you can read from Oracle itself:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maa-onpremises-overview.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Maximum Availability Architecture (MAA)<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/maa-reference-architectures-2244929.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle MAA Reference Architectures (Old version)<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/maximum-availability-wp-19c.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Maximum Availability with Oracle Database 19c<\/a><\/p>\n<p style=\"text-align: justify;\">&nbsp;<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/multitenant-maa.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Multitenant MAA Solutions (includes the \u201cAurous\u201d Option)<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/availability\/maa-consolidation-5648225.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Best Practices for Database Consolidation<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/haovw\/high-availability-overview.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle\u00ae Database High Availability Overview<\/a><\/p>\n<p style=\"text-align: justify;\">&nbsp;<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/availability\/farsync-2267608.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Active Data Guard Far Sync Zero Data Loss at Any Distance<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/a\/tech\/docs\/adg-best-practices-and-new-features-deep-dive.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Active Data Guard: Best Practices and New Features Deep Dive<\/a><\/p>\n<p style=\"text-align: justify;\">&nbsp;<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/availability\/disaster-recovery-2526839.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Disaster Recovery for Oracle Database Zero Data Loss Recovery Appliance, Active Data Guard and Oracle GoldenGate<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/availability\/recovery-appliance-data-guard-2767512.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Deploying the Zero Data Loss Recovery Appliance in a Data Guard Configuration<\/a><\/p>\n<p style=\"text-align: justify;\">&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>Disclaimer<\/strong>: <em>\u201cThe postings on this site are my own and don\u2019t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications were removed to allow reach the generic audience and to be useful for the community. Post protected by copyright.\u201d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Gold architecture for MAA is used to emphasis the application continuity. All the possible outages (planned or no) are protected by Oracle features. Here we are one step further and start to design using multi-site architecture. Data Guard, RAC, Oracle Clusterware, everything is there. But even with these, ZDLRA is still needed to allow [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[71,44,50,41,29,77,6,47,53,141,54,5,140,45,49,51],"tags":[143,67,100,146,75,65,74],"class_list":["post-802","post","type-post","status-publish","format-standard","hentry","category-19c","category-backup","category-broker","category-data-guard","category-database","category-engineeredsystems","category-exadata","category-failover","category-fast-start-failover","category-maa","category-observer","category-oracle","category-replication","category-restore","category-switchover","category-zdlra","tag-architecture","tag-data-guard","tag-engineered-systems","tag-gold","tag-maa","tag-oracle","tag-zdlra"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ZDLRA + MAA, Protection for Gold Architecture - Fernando Simon<\/title>\n<meta name=\"description\" content=\"How ZDLRA is needed at your MAA design for Gold Architecture (RAC\/Data Guard) to reaches zero RPO\/RTO to every planned and unplanned outage for a multi-site environment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ZDLRA + MAA, Protection for Gold Architecture - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"How ZDLRA is needed at your MAA design for Gold Architecture (RAC\/Data Guard) to reaches zero RPO\/RTO to every planned and unplanned outage for a multi-site environment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-21T22:05:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-11T17:50:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"ZDLRA + MAA, Protection for Gold Architecture\",\"datePublished\":\"2020-09-21T22:05:36+00:00\",\"dateModified\":\"2020-10-11T17:50:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/\"},\"wordCount\":2170,\"commentCount\":2,\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/MAA-Gold.png\",\"keywords\":[\"Architecture\",\"Data Guard\",\"Engineered Systems\",\"Gold\",\"MAA\",\"Oracle\",\"ZDLRA\"],\"articleSection\":[\"19c\",\"Backup\",\"Broker\",\"Data Guard\",\"Database\",\"Engineered Systems\",\"Exadata\",\"Failover\",\"Fast-Start Failover\",\"MAA\",\"Observer\",\"Oracle\",\"Replication\",\"Restore\",\"Switchover\",\"ZDLRA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/\",\"name\":\"ZDLRA + MAA, Protection for Gold Architecture - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/MAA-Gold.png\",\"datePublished\":\"2020-09-21T22:05:36+00:00\",\"dateModified\":\"2020-10-11T17:50:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"How ZDLRA is needed at your MAA design for Gold Architecture (RAC\\\/Data Guard) to reaches zero RPO\\\/RTO to every planned and unplanned outage for a multi-site environment.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/MAA-Gold.png\",\"contentUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/MAA-Gold.png\",\"width\":1917,\"height\":1079},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/zdlra-maa-protection-for-gold-architecture\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ZDLRA + MAA, Protection for Gold Architecture\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\\\/\\\/www.fernandosimon.com\"],\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/author\\\/simon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ZDLRA + MAA, Protection for Gold Architecture - Fernando Simon","description":"How ZDLRA is needed at your MAA design for Gold Architecture (RAC\/Data Guard) to reaches zero RPO\/RTO to every planned and unplanned outage for a multi-site environment.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/","og_locale":"en_US","og_type":"article","og_title":"ZDLRA + MAA, Protection for Gold Architecture - Fernando Simon","og_description":"How ZDLRA is needed at your MAA design for Gold Architecture (RAC\/Data Guard) to reaches zero RPO\/RTO to every planned and unplanned outage for a multi-site environment.","og_url":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/","og_site_name":"Fernando Simon","article_published_time":"2020-09-21T22:05:36+00:00","article_modified_time":"2020-10-11T17:50:38+00:00","og_image":[{"url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"ZDLRA + MAA, Protection for Gold Architecture","datePublished":"2020-09-21T22:05:36+00:00","dateModified":"2020-10-11T17:50:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/"},"wordCount":2170,"commentCount":2,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png","keywords":["Architecture","Data Guard","Engineered Systems","Gold","MAA","Oracle","ZDLRA"],"articleSection":["19c","Backup","Broker","Data Guard","Database","Engineered Systems","Exadata","Failover","Fast-Start Failover","MAA","Observer","Oracle","Replication","Restore","Switchover","ZDLRA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/","url":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/","name":"ZDLRA + MAA, Protection for Gold Architecture - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png","datePublished":"2020-09-21T22:05:36+00:00","dateModified":"2020-10-11T17:50:38+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"How ZDLRA is needed at your MAA design for Gold Architecture (RAC\/Data Guard) to reaches zero RPO\/RTO to every planned and unplanned outage for a multi-site environment.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#primaryimage","url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png","contentUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2020\/08\/MAA-Gold.png","width":1917,"height":1079},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-maa-protection-for-gold-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ZDLRA + MAA, Protection for Gold Architecture"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-cW","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=802"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/802\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}