TRADITIONAL ORACLE DATA MANAGEMENT CHALLENGES

Most enterprise applications are built on Oracle databases. The most popular Enterprise Resource Planning (ERP) applications such as SAP or Oracle E Business Suite (EBS) also rely on Oracle database. With such critical information stored in Oracle, Enterprises require enterprise grade backup, disaster recovery, and database cloning solutions.

Large Backup Window

Most enterprise backup products perform weekly full and daily Incremental backups

Large RPO

Large backup windows lead to large RPOs which often exceed 24 hours

Large RTO

Traditional data recoveries lead to large RTOs because data has to be converted from custom backup format to native Oracle format.

Slow & Expensive DB Cloning

Too much time and storage is consumed by physical clones used for Dev, Test, UAT, Analytics

Expensive Data Retention

Retaining information in proprietary format in dedup appliances or tapes makes it expensive and hard to access data for compliance

No Effective Cloud Leverage

Traditional backup formats make it too complex, slow, and cumbersome to leverage on-demand cloud data warehouse services

 

Actifio Sky for Oracle

Oracle databases can be deployed in a variety of different storage architecture such as standalone file system, standalone ASM or RAC with ASM. Enterprises can deploy Oracle databases with a variety of infrastructure options including custom configurations, Oracle cloud, Oracle Virtual Machines, or Exadata appliances. Enterprises can also use Oracle Data Guard (Active / Passive or Active / Active), or Oracle Redgate.

Actifio Sky delivers enterprise grade backup, disaster recovery, long term data retention, and database cloning for Oracle databases deployed in any of these configurations. Most importantly – enterprises can use Actifio Sky for very large databases including 100+ TB sized Oracle database environments.

 

 

Ideal Solution

An incremental forever backup solution that backs up only changed blocks

An incremental forever backup solution that can lower the RPO to 1 hour, and capture transaction logs every 15 minutes

An instant mount of the backup that is fully read/write enabled and that can lower RTO by up to 10x

Instant virtual mounts to multiple test environments that can reduce time and storage by up to 10x

Instant access from backups stored in scalable and cheap object storage can reduce costs and satisfy compliance

Instant mount of Oracle database data in native format that can accelerate analytics using ETL to AWS Redshift, Google BigQuery or Oracle Cloud

Key Features: Backup & Disaster Recovery

“We cut recovery points and times from three days to hours. No more tape! We’re able to recover corrupted business intelligence databases in minutes where it once took hours.”

Bill Croteau, Infrastructure Services Director, Electric Insurance

Instant Recovery (Low RTO)

 Users can perform instant recoveries and access a multi TB database in just minutes.

Zero Down Time

 Actifio Sky supports Oracle ASM environments and allows automated migration of fail-over production databases from Actifio storage to production storage with zero down time

Small Backup Window

 After the first full backup, all backups are incremental forever. Actifio Sky uses Oracle RMAN APIs for application consistent backups, and users can tune Actifio Sky to optimize backups to leverage multiple RMAN channels or to stream from multiple nodes simultaneously in Oracle RAC clusters

Oracle Data Guard Integration 

For environments that use Oracle Data Guard, users can backup Oracle database from Primary database or Standby database

Replicate to Any Cloud

 Users can set SLAs to replicate from Actifio Sky in one location to a Sky in another data center or public cloud like Oracle cloud, AWS, Azure, IBM, or any MSP. Users can then do instant low RTO DR and DR testing at the remote site. DR testing does not impact production or continuing backup and replication

Flexible RPO

 Users can set SLAs to replicate incremental backups anywhere between 1 hour to 24 hours. For lower than 1 hour RPOs, archive log backups can be backed up and replicated every 15 minutes

Key Features: Database Cloning

“Actifio allows us to create self-service copies of VLDB’s on demand. It drastically reduces time to provision copies from 18 hours to 15 minutes. We have also reduced our storage footprint by over 50%.”

SOURCE: GARTNER PEER INSIGHT

Space Efficient

The virtual copies do not take any extra storage space. For example: 20 users/projects can create 20 virtual copies of a 5 TB database without consuming any extra storage. Incremental extra storage is only required to store changes corresponding to modifications done to a virtual database clone

Instant Copies

 Irrespective of the size of database, whether 1TB or 50TB, users can provision multiple virtual database clones within minutes

High Performance

 Actifio Sky can easily handle 130,000 IOPs from multiple virtual Oracle database clones

Role Based Access Control

 Actifio admins can control WHO can access WHAT databases on WHICH servers, thus ensuring IT Ops has sufficient controls

Self Service 

Users can use their domain user accounts to login to Actifio Sky and provision virtual database clones in a self service manner

Data Masking Integration

 Actifio enables automated data masking by enabling Actifio admins to specify any 3rd party data masking server, script and schedule. This ensures that data is masked automatically and testers get access to ONLY masked copies

Automated & Efficient Data Refresh

 Actifio Sky ingests only changed blocks from production to refresh virtual database clones. Thus users can refresh ad-hoc or based on schedule to work on the most recent virtual copy of production Oracle database

Bookmarks

 Testers can bookmark a cloned database at a specific point in time and branch out to a different data version. This is especially useful in creating DB schema changes and then promoting those changes to other test environments

DevOps Continuous Integration

 DevOps can use Actifio Sky API plugins for Jenkins, Chef, Puppet, Ansible or ServiceNow to automate the entire process of provisioning virtual DB clones

Heterogeneous Database Configuration Support

 Actifio Sky can protect and recover databases from heterogeneous configurations.  For example, Actifio can protect a standalone ASM or multi-node RAC with ASM instance, and then present a database clone with any ASM configuration i.e. standalone ASM, single node RAC or multi node RAC

Clone to Single Target Instance

 Once a production database is protected, users can provision multiple virtual database clones to a single target Oracle instance at schema level, thus reducing infrastructure management and overhead

Key Features: Data Retention

SLA Driven Retention

 Users can set flexible retention SLAs to store backups for days, weeks, months, years, or even decades

Flexible Retention Location

 Users can specify backup data to be stored in multiple locations such as disk with its software deduplication, or S3 API compliant object storage on-premises or in cloud with software compression

Instant Access

 Whether backup images are days old or decades old, users can mount backup images from object storage for near-instant data access

How Actifio Works for Oracle

 

Supported Oracle Platforms

Oracle version: 10g, 11g, 12c

Operating Systems: Linux RHEL, OEL, SLES, AIX, HP-UX, Solaris, and Windows

Supported Oracle Configuration: Standalone file system, Standalone ASM, RAC with ASM, Data Guard (Physical standby database: Active/Non Active), EXADATA

Supported Oracle Database Editions: Oracle Database Standard Edition One, Standard Edition, Enterprise Edition

Oracle Certifications: Oracle EXADATA Ready, Oracle Database Ready, Oracle Multitenant, Oracle In-Memory, Oracle Linux Ready

HOW ACTIFIO & ORACLE WORK TOGETHER

Actifio uses the native functionality in Oracle RMAN to ingest data to create a golden copy, update it incrementally with changed blocks, and maintain it in an incremental-forever architecture. Actifio will hold the virtual image in its native format for efficient usage and all Oracle storage formats are supported, including raw volumes, file systems, and ASM.

Actifio Web Diagrams_oracle

Once a golden image is captured, this image can be in a ready-state for immediate use, de-duplicated for long term retention, or sent to a remote location for disaster recovery purposes.

Actifio Oracle ASM Solution Brief

Download Now

LEARN MORE

Actifio integrates with Oracle to transform Oracle data management

GET THE WHITE PAPER