Put all your eggs in one basket and --- WATCH THAT BASKET.
Following the IT industry's never-ending quest to introduce new and confusing names for well-understood concepts, our gurus in the High Availability engineering teams for the Oracle database and application server products have coined a new term: Oracle Maximum Availability Architecture.
From their OTN website:
- "Oracle Maximum Availability Architecture (MAA) is Oracle's best practices blueprint based on proven Oracle high availability technologies and recommendations. The goal of MAA is to remove the complexity in designing the optimal high availability architecture."
This team held a fascinating session at OpenWorld 2006, "MAA Best Practices: Building an Oracle E-Business Suite Maximum Availability Architecture" (S283064). They covered a range of MAA topics for E-Business Suite environments, including:
- RAC, ASM
- Flashback databases
- Data Guard Redo Apply
- Disaster recovery
- Minimizing outages while converting to MAA architectures
- Switchover and failover procedures
- Hardware vendor partner validations on:
- HP-UX, HP 9000, HP Integrity, HP StorageWorks, HP ServiceGuard
- Sun Solaris, Sun Clusters, Sun Fire, Sun StorEdge
Related
Comments (10)
Hi Steven,
Biggest MAA gain will be with Availability during database Upgrades . any idea when is rolling upgrades going to be certified with Physical Standby dataases so this can be utilised in MAA during Upgrades.
Regards
Atul
Posted by Atul Kumar | November 5, 2006 4:21 PM
Posted on November 5, 2006 16:21
I second Atul's sentiments. The bulk of our downtime is scheduled, so we've got to figure out how to deploy database code/objects, and do upgrades without kicking off the users.
Posted by Dan Loomis | November 6, 2006 2:15 PM
Posted on November 6, 2006 14:15
I agree that this would be highly desirable. There are some pretty stiff technical challenges that we're working on now, but I don't have specifics that I can share at this stage. I'll be sure to post updates on this as soon as they're available.Regards,Steven
Posted by Steven Chan | November 7, 2006 1:05 PM
Posted on November 7, 2006 13:05
Steve.
Was looking for information on 'flashback database' and its use within an 11i environment. Are there any docs/case studies and has anyone tried it in their environments as part of the MAA ???
I have used it with teh 10g database (3rd Party App but not with the 11i techstack).
cheers
Posted by John Fak | April 1, 2007 7:38 PM
Posted on April 1, 2007 19:38
John,Use of the Flashback database feature is supported with the E-Business Suite. The base Oracle database documentation applies to E-Business Suite, so there's no Apps-specific documentation for using this feature.Regards,Steven
Posted by Steven Chan | April 2, 2007 9:58 AM
Posted on April 2, 2007 09:58
Hi Steven,
Just want to confirm that in Release 12 EBS with RAC in PRIMARY site and single instance in STANDBY site with Database 10g 10.2.0.3 is supported? I checked database docs, which states that standby can be non-RAC, does same applies for EBS R12 as well?
Regards,
Preet
Posted by Preet | February 25, 2008 10:12 AM
Posted on February 25, 2008 10:12
Do Oracle support Harware Failover Load Balancing for E-Business Suite??? i know they support software level load balancing but i m not sure about hardware LB.
Posted by Ishaq | July 8, 2008 12:08 AM
Posted on July 8, 2008 00:08
Ishaq:
Yes, we support hardware-based load-balancers. See this article for more information and pointers to EBS 11i resources:
http://blogs.oracle.com/stevenChan/2006/06/16/
Regards,
Steven
Posted by Steven Chan | July 8, 2008 10:28 AM
Posted on July 8, 2008 10:28
Hi Steven
We are now running into a project of using MSCA on our production lines. This will require us to a 24x7 EBS availability to avoid stopping production lines. Currently we patch our system on a bi-weekly basis putting the system down for 2 hours (both Oracle and custom code patches). Is there a way to avoid downtime at all ? What is Oracle's best practice to achieve that business requirement ?
Regards
Nitzan
Posted by Nitzan | August 25, 2008 5:28 AM
Posted on August 25, 2008 05:28
Hi, Nitzan,
Congratulations on getting MSCA into production. You'll find a number of recommendations in these articles:
Top 7 Ways of Reducing Patching Downtimes for Apps -
http://blogs.oracle.com/stevenChan/2007/06/top_7_ways_of_reducing_patchin.html
Reducing Patching Downtimes via Shared Apps File Systems -
http://blogs.oracle.com/stevenChan/2007/05/reducing_patching_downtimes_vi.html
Regards,
Steven
Posted by Steven Chan | August 25, 2008 10:25 AM
Posted on August 25, 2008 10:25