X

The Latest Technology Stack News Directly from EBS Development

  • November 2, 2006

Maximum Availability Architectures and the E-Business Suite

Steven Chan
Senior Director

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.

MAA 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

Excellent stuff.  Associated with their OpenWorld session, they have a Powerpoint and a detailed whitepaper available for download.  See the article below for pointers to the OOW Content Catalog.

Oct. 14, 2011 Update: This presentation is available here.

Related


Join the discussion

Comments ( 14 )
  • Atul Kumar Sunday, November 5, 2006

    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


  • Dan Loomis Monday, November 6, 2006

    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.


  • Steven Chan Tuesday, November 7, 2006

    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 


  • John Fak Sunday, April 1, 2007

    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


  • Steven Chan Monday, April 2, 2007

    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 


  • Preet Monday, February 25, 2008

    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


  • Ishaq Tuesday, July 8, 2008

    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.


  • Steven Chan Tuesday, July 8, 2008

    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


  • Nitzan Monday, August 25, 2008

    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


  • Steven Chan Monday, August 25, 2008

    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


  • Vasu Ranganathan Tuesday, October 11, 2011

    Hi Steve,

    The link seems to be broken:

    Error: 404 Not Found!

    Sorry, that page does not exist. Please try another location or you can search.

    URL: http://blogs.oracle.com/stevenChan/2006/06/16/

    Van you check what's happenned here or do you have latest info.?

    Cheers,

    Vasu


  • Steven Chan Friday, October 14, 2011

    Vasu,

    Our IT team has moved content around. Article updated with a new link.

    Regards,

    Steven


  • vladimir Monday, January 26, 2015

    We are running new project with two environments , PROD & DEV on the different hosts.

    The DEV instance restore and recover from PROD rman backup and it worked during the day then flashback

    and recover(only recover) from rman backup and the cycle is repeated.

    The goal is to reduce the recovery time and the amount of data transmitted.


  • Brandon Monday, April 11, 2016

    Hello,

    I am wondering if this note it certified with EBS 12.2? How To Setup ASM (11.2 & 12.1) On An Active/Passive Cluster (Non-RAC). (Doc ID 1296124.1)


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.