Welcome!

Microservices Expo Authors: Liz McMillan, Mehdi Daoudi, Pat Romanski, Andy Thurai, Elizabeth White

Related Topics: Microservices Expo, Recurring Revenue, @CloudExpo

Microservices Expo: Article

Oracle RMAN, BMC Patrol Catalogs Hosted in Amazon Cloud

Backup and monitoring metadata repositories efficiently hosted by Amazon Web Services EC2 Cloud

Oracle RMAN  (Recovery Manager) catalog database contains backup metadata for all enterprise wide Oracle databases. Each database backed up through RMAN needs connection to a central backup repository database. RMAN catalog  is purged and maintained by removing obsolete backup records, crosschecking with existing media etc. If central repository grows too big then backup performance will suffer since it will take too long for RMAN to locate metadata.

Amazon Web Services gives us the ability to quickly and easily create either brand new RMAN catalog database or move an existing catalog to it. If purging fails to remove sufficient number of rows and current catalog becomes too big and  then we can create another RMAN catalog and direct backups for newly created Oracle databases to it. RMAN catalog is ideally positioned to take advantage of Amazon Web Services EC2 Cloud since RMAN application perfectly scales horizontally. All you need to do is to add new repository database once catalog reaches certain size.  The only change on source database servers ( ones being backed up ) is that they will have to point to new RMAN catalog database. You can start using new catalog simply by adding a new entry to TNSNAMES.ORA configuration file on database server that is backed up. This is same as pointing to any other on-premise RMAN catalog, the only difference being target host name.

BMC Patrol is monitoring tool that often uses Oracle database as metadata repository. In-house developed database monitoring scripts and tools also frequently store their data in Oracle databases. All these repositories can quickly be moved to or created in AWS EC2 Cloud.

If there is a need to migrate  existing RMAN catalog data to AWS database it can be done very simply either by copying database files to target database ( if source and target databases are on the same platform - Linux, for example ), or by using Oracle Data Pump to dump data to flat files and upload to target database.

You can have brand new, fully functional RMAN catalog database server up and running in just couple of hours on Amazon EC2. The usual advantages of cloud computing i.e. ultra-fast, cheap provisioning and hosting apply here too, thus avoiding inter-departmental friction and long provisioning lead times.

We recommend Oracle database installation on Oracle Virtual Machine since this configuration is certified and fully supported by Oracle corporation.

RMAN catalog contains information critical for restores so it should be protected by Oracle Data Guard physical standby database.  Data Guard database can be created in Amazon Web Services Cloud.

More Stories By Ranko Mosic

Ranko Mosic, BScEng, is specializing in Big Data/Data Architecture consulting services ( database/data architecture, machine learning ). His clients are in finance, retail, telecommunications industries. Ranko is welcoming inquiries about his availability for consulting engagements and can be reached at 408-757-0053 or [email protected]

Microservices Articles
"NetApp's vision is how we help organizations manage data - delivering the right data in the right place, in the right time, to the people who need it, and doing it agnostic to what the platform is," explained Josh Atwell, Developer Advocate for NetApp, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
TCP (Transmission Control Protocol) is a common and reliable transmission protocol on the Internet. TCP was introduced in the 70s by Stanford University for US Defense to establish connectivity between distributed systems to maintain a backup of defense information. At the time, TCP was introduced to communicate amongst a selected set of devices for a smaller dataset over shorter distances. As the Internet evolved, however, the number of applications and users, and the types of data accessed and...
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm. In their Day 3 Keynote at 20th Cloud Expo, Chris Brown, a Solutions Marketing Manager at Nutanix, and Mark Lav...
Kin Lane recently wrote a couple of blogs about why copyrighting an API is not common. I couldn’t agree more that copyrighting APIs is uncommon. First of all, the API definition is just an interface (It is the implementation detail … Continue reading →
The Jevons Paradox suggests that when technological advances increase efficiency of a resource, it results in an overall increase in consumption. Writing on the increased use of coal as a result of technological improvements, 19th-century economist William Stanley Jevons found that these improvements led to the development of new ways to utilize coal. In his session at 19th Cloud Expo, Mark Thiele, Chief Strategy Officer for Apcera, compared the Jevons Paradox to modern-day enterprise IT, examin...
The Software Defined Data Center (SDDC), which enables organizations to seamlessly run in a hybrid cloud model (public + private cloud), is here to stay. IDC estimates that the software-defined networking market will be valued at $3.7 billion by 2016. Security is a key component and benefit of the SDDC, and offers an opportunity to build security 'from the ground up' and weave it into the environment from day one. In his session at 16th Cloud Expo, Reuven Harrison, CTO and Co-Founder of Tufin, ...
Many organizations are now looking to DevOps maturity models to gauge their DevOps adoption and compare their maturity to their peers. However, as enterprise organizations rush to adopt DevOps, moving past experimentation to embrace it at scale, they are in danger of falling into the trap that they have fallen into time and time again. Unfortunately, we've seen this movie before, and we know how it ends: badly.
Kubernetes is a new and revolutionary open-sourced system for managing containers across multiple hosts in a cluster. Ansible is a simple IT automation tool for just about any requirement for reproducible environments. In his session at @DevOpsSummit at 18th Cloud Expo, Patrick Galbraith, a principal engineer at HPE, discussed how to build a fully functional Kubernetes cluster on a number of virtual machines or bare-metal hosts. Also included will be a brief demonstration of running a Galera MyS...
Your homes and cars can be automated and self-serviced. Why can't your storage? From simply asking questions to analyze and troubleshoot your infrastructure, to provisioning storage with snapshots, recovery and replication, your wildest sci-fi dream has come true. In his session at @DevOpsSummit at 20th Cloud Expo, Dan Florea, Director of Product Management at Tintri, provided a ChatOps demo where you can talk to your storage and manage it from anywhere, through Slack and similar services with...
Growth hacking is common for startups to make unheard-of progress in building their business. Career Hacks can help Geek Girls and those who support them (yes, that's you too, Dad!) to excel in this typically male-dominated world. Get ready to learn the facts: Is there a bias against women in the tech / developer communities? Why are women 50% of the workforce, but hold only 24% of the STEM or IT positions? Some beginnings of what to do about it! In her Day 2 Keynote at 17th Cloud Expo, Sandy Ca...