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 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-Explorer– 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-Explorer 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-Explorer 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 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.



Remote Monitoring & Control 


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 of this project were great! We happily recommend DSP-Explorer for anyone looking for proven results in Oracle consultancy."

Senior Engineer | Metasphere



DSP-Explorer logo-full white-SVG


Contact us Today