Metasphere

Solution: Oracle Backups

Metasphere: Oracle Backups


In the wake of a trend of shrinking I.T. budgets, Metasphere opted to provide their clients with extra support by designing, building and recommending a standardised and fit-for-purpose backup process.

The Challenge

The team at Metasphere had noticed a trend of shrinking I.T. budgets, which resulted in some clients losing staff with the necessary skills to effectively manage the Oracle backend databases required by the Metasphere application. These clients were turning to Metasphere for extra support. 

Whilst welcoming the opportunity to provide additional support services, this triggered in a sharp increase in backup performance related questions.  This was primarily around backups not completing in time or network bandwidth constraints in moving lots of data around.  To make matters more difficult, each customer additionally had a different setup and required a detailed investigation into the backup configuration before assistance could be provided.

It made sense for Metasphere to design, build and recommend a standardised and fit-for-purpose backup process for their clients. Paul Harding, Senior Engineer at Metasphere, approached DSP– a leading Oracle support and development partner with a reputation for delivering innovative and cost effective solutions – for advice on how best to resolve the problem.

The Solution

DSP worked with Paul to understand the application requirements and the nature of Metasphere’s client support requests, before implementing an incremental RMAN backup solution that could be rolled out across Metasphere’s client base.

Phase one of the solution switched from a 'daily full' back up to a 'weekly full' and 'daily incremental' backup.  The solution was then formalised in clearly understood and commented scripts that are proven on multiple client sites, providing:

  • Granularity of control
  • Highest level of DR in the event of a major outage
  • Improved performance across the network
Finally, they instigated a handover to include full documentation to explain the methodology of the new backup system, with instructions for ongoing management.

 

The Result

DSP had experienced Metasphere's issues before and was therefore able to provide a solution that had already been proven in multiple production environments.   As a result the team were able to free up key individuals to continue to focus on product development, rather than repeatedly devoting their efforts to supporting a poorly performing process. 

With a solid automation process now in place, the backups are created significantly quicker and the resulting daily network transfers are much smaller in size.  Backups are now transferred to an off-site location using the same network that had previously been saturated by the original backup process, eliminating the need for additional storage.

metasphere_logo
Profile: 
Metasphere has been involved in the remote monitoring and control business for over thirty years; improving process efficiency, reducing costs, enabling their customers to meet regulatory requirements and implementing some of the most innovative solutions that integrate telemetry with business systems.
 
Customer:
Metasphere

Industry:
Remote Monitoring & Control 
 

Solution:

  • implemented RMAN backup solution to be rolled out across Metasphere’s client base
  • Switched from a 'daily full' back up to a 'weekly full' and 'daily incremental' backup
  • Instigated a handover to fully explain the methodology of the new backup system
 

"The results from this project were great! We happily recommend DSP for anyone looking for proven results in Oracle consultancy."

Paul Harding, Senior Engineer at Metasphere 

 

Metasphere Oracle Backups