Copies of Oracle data are needed for many IT functions, including local and remote recovery, development and test, reporting, compliance and so on. According to IDC, over 80% of organizations maintain more than ten copies of every Oracle database at any given time. Not only does this create a massive infrastructure
cost penalty, but the ongoing demand for copies consumes valuable IT staff time and effort. For this reason, Copy Data Management (CDM) is fast becoming a must-have solution for any enterprise Oracle environment. Catalogic ECX integrates storage array copy processes (snapshots, replication, clones) with Oracle, allowing customers to leverage their existing storage infrastructure to automatically create, track and deliver fresh copies of Oracle databases to those business units that demand them.
By orchestrating the creation and use of Oracle-aware storage snapshots, ECX becomes a powerful solution for next generation data protection and recovery. You can skip traditional backup completely and move to a snap-and-replicate model that provides near instant protection and rapid recovery. Compared to the slow restores of traditional backup, ECX allows IT to mount and instantly access copies that are already in the production storage environment. ECX catalogs all snapshots and replicas and alerts you if a copy job was missed or failed. Disaster recovery can be automated and tested non-disruptively.
ECX can also be used to serve copies to data consumers. Using Oracle database virtualization, application consistent copies of Oracle can be automatically mapped to host servers every day, ready to go when the work day begins. Ad hoc requests can be satisfied with a few clicks. Self-service access means that IT can relieve itself of the daily grind of copy provisioning while still retaining ultimate control and not giving direct access to storage systems.
For example, using the ECX self-service portal, a developer could spin up their own Oracle test copies whenever they needed them, but they would be restricted to a set number of copies coming from a predefined set of storage volumes. This kind of intelligent Oracle test data management prevents abuse of infrastructure and maintains security.
The benefits of ECX Oracle database management copy delivery are even more pronounced when used in conjunction with all-flash storage arrays. The high I/O of these systems allows zero-footprint snapshot copies to run at production speeds, even when servicing multiple workloads from the same copy.
With ECX, users create copy policies that define key copy metrics: how often to make Oracle copies, where the copies will reside (local, remote or both), how long copies are retained and so on. Once a policy is created, it can easily be applied to any Oracle workload. No more complex scripting or working with multiple tools; just click-and-apply ease of use.
The ECX copy process is agentless giving you true application awareness without the maintenance headaches.
The meta-data catalog at the core of ECX tracks all copies, making them searchable and reportable. ECX also handles the deletion of copies, ensuring that you only retain the data you really need.
ECX includes integrated data masking workflows with the ability to leverage third party masking tools. Oracle database virtualization can create and share masked data copies.
Integrated Pre-and Post-Scripting
ECX allows the customer to leverage existing or new scripts that manage the detailed settings and parameters that are unique to every Oracle instance. The policy workflow in ECX includes the step for the user to define which script should be utilized, and to specify when and how the script(s) should be used.
Integrated Log Management
The ECX policy workflow for creating and using copies of a database includes rich and flexible functionality for managing the database logs.
Oracle RMAN Integration
Users can optionally leverage the Oracle RMAN catalog to enable RMAN-supported recoveries with local or remote RMAN catalog creation built into ECX policies.
This video provides a full demonstration of Pure Storage and Catalogic ECX with a Linux instance of Oracle. It walks you through all the steps: registering the Oracle server, automatically discovering data LUNs, setting up and taking snapshots, and recovering a database. Optional features such as RMAN integration, archive log backup and data masking are also shown. Learn how easy it is to protect and recover Oracle, as well as using Oracle copies for purposes such as Oracle dev-test.
Copy Data Management is fast-becoming a must-have solution for any enterprise Oracle environment. ECX integrates storage array copy processes (snapshots, replication, clones) with Oracle databases, allowing customers to leverage their existing storage infrastructure to eliminate copy sprawl, while dramatically improving their capabilities to deliver fresh copies of key databases to those functions and business units that demand them.
This webinar will provide you with a high-level, value-based explanation of how Catalogic can transform your database environment through a simple, software-only solution. Supported databases include Oracle, SQL Server, SAP HANA and InterSystems Caché (used for EPIC EHR and other applications). The webinar is suitable for IT architects, storage admins, developers, DBAs, etc.