SIG Database Backup & Recovery“ Leipzig, DE 08.09 · Frank Schwaak EMEA Product Specialist Databases, UNIX & Network Security SIG Database "Backup & Recovery“ Leipzig, DE –08.09.2011

Frank SchwaakEMEA Product Specialist

Databases, UNIX & Network Security

SIG Database "Backup & Recovery“

Leipzig, DE – 08.09.2011

2005 2006 2007 2008 2009 2010

CommVault in Zahlen

Über 14.000 Kunden

1.900 neue Kunden allein im letzten Jahr

97% Kundenzufriedenheit

Mehr als 1.300 Mitarbeiter weltweit

NASDAQ: CVLT

Leader in einem 5 Milliarden $Backup & Recovery Markt.

3

CommVault wurde im “Leaders”

Quadrant im Gartner 2011 Magic

Quadrant Enterprise Disk-Based

Backup and Recovery

2011 Info-Tech Research

Group’s Champion für Enterprise

Backup Software

2011 DCIG Best in Class Virtual

Server Backup Software

2011 Microsoft Server Platform

Partner des Jahres

MarktbetrachtungEin 5 Milliarden $ Markt in Bewegung

4

Kunden weltweit

5

Referenzen DACHwww.commvault.de

6

Strategische PartnerTier2 Business – KEIN Direktgeschäft

7

The ChallengePrimary Storage Growth at Unprecedented Rates

Files Email Databases Messaging Web Growing

50+%

Annually

07 08 09 10

07 08 09 10

Files Email Databases Messaging Web

The Compounded Problem Secondary Copies exacerbate the growth dilemma

Backup Replication Archive Migration Appliances

10-15X Copies


Out of Control Complexity, Cost & Risk Unmanageable, Limited Access, Poor Recovery


- Siloed Data

- Different UIs

- Disparate HW

Acquisition

Hardware

People

Consumable

Ownership Costs


Traditional SolutionsDisparate, point level products addressing data management


Console/UI

Data Mover

Catalog/Index

Security

Job Manager

RedundantComponents

A Paradigm Shift to a Better WayFundamentally requires a new architecture

Replication Archive Migration Appliances

Acquisition

Hardware

People

Consumable

Ownership Costs

Backup


A Paradigm ShiftUnification through a Singular Approach

Replication Archive Migration Appliances

Unification Lowers Cost

TCO Inputs

Backup


Acquisition

Hardware

People

Consumable

Simpana Software’s Architecture The Key to Truly Unifying Data Management

Some Top of Mind TechnologiesBuilt-in to the Common Platform

Policy based platform

Disk2Disk2Tape tiered storage

Virtualization Support

Embedded Data Deduplication

Built-in Recovery options

• Autodiscover and enable hardware snapshots

• Object level recovery

• Enduser search/recover

Encryption with key management

Role based Security

Highly Optimized Agents for various applications

Content Indexing

Data Classification

HSM/Migration

E-Discovery

Supported Applications & Databases

Confidential

Agenda

Who is Oracle?

What’s the Issue?

Key Benefits of Simpana

GUI Overview

Q&A

Oracle Data Protection and Recovery

Confidential

Agenda

Who is Oracle?

What’s the Issue?


GUI Overview

Q&A


Confidential

Agenda

Who is Oracle?

What’s the Issue?


GUI Overview

Q&A


Oracle databases contain the data which companies need to conduct and sustain their ongoing daily operations

Managing Oracle databases demands exacting core competency and knowledge of Oracle systems

RMAN is the pre-eminent feature that Oracle DBAs use to provide an optimal level of data protection and recovery

New RMAN features being added to almost every release of Oracle which DBA’s wish to adopt

What’s the issue?Pain Points

What’s the issue?Pain Points Cont’d

Companies must typically dedicate an Oracle DBA or team of DBA’s to develop scripts that utilise these specific features within RMAN

Creating and testing RMAN scripts, scheduling their execution, troubleshooting and ongoing maintenance and script changes for each new release is a high cost of DBA time

run {

allocate channel ch1 type 'sbt_tape‘...

TRACE 0;

setlimit channel ch1 maxopenfiles 8;

backup

incremental level = 0

filesperset = 32

database

include current controlfile ;

}

What’s the issue?Pain Points Cont’d

Complex database designs and infrastructure (e.g. RAC) require in depth skilled people

Massive data growth will cause backups to run out of the data protection operation window and therefore SLA are hardly to meet

Escalating Data Growth & Shrinking Operation Windows

What is required?

To take advantage of Oracle RMAN’s features requires a data protection solution that simplifies and automates the process of RMAN script management

Enterprise data protection software needs to evolve in order provide a higher level of integration with Oracle RMAN

Need to minimise or remove the need for intervention on the part of Oracle DBAs to manage these scripts.

Need to run Snapshot based backups to minimize server load impact and to speed up data protection operations

Automated Script Generation

Continuous Adaption to new RMAN Features

Scripts created by Simpana® – not by the DBA

Full SnapProtect™ integration with RMAN

Confidential

Agenda

Who is Oracle?

What’s the Issue?


GUI Overview

Q&A


Key Benefits of Simpana for OracleUnique Selling Points

Simplified and automated creation of RMAN scripts

Integrated

• Deduplication

• Compression

• Encryption

Simplified and guided Oracle recovery with flexible options

• Restore to alternative server and/or location

• Restore and rename, set new DBID

• Restore and recovery to point-in-time or SCN

• Restore identifies DB mode and provides user info on required DB mode

• Table level restore (even from a SnapProtect backup)


• Auto Discovery of Oracle Instances

• Extensive range of backup and recovery options supported

• Support backup and restore of Oracle Fast Recovery area (FRA)

• Preserved use of existing Oracle recovery scripts

• Automated and fine-tuned archive log management

• All options can be automated and scheduled by policy

• Define and assign operational and management activities to different users and user groups


Flexible and full featured command line operations for Oracle, designed by our Enterprise Customers

• Configuration of backup policies

• Full and flexible restore

• Ability to change policy configurations by command line including passwords

Oracle streams managed in a single Simpana Job, reducing management and making it easy to identify unrecoverable databases


• Oracle specific failure codes, including RMAN log out put viewable from GUI or included in HTML reporting

• Automatic preview of RMAN script before backup and restore

• Reduces the need for Oracle DBA to be data protection managers

• Scripts can be customized before starting the job

• Full SnapProtect integration to create instant recovery points and to be used for off-host (proxy backups)

Key Benefits of Simpana for OracleRelation with Oracle Corp.

CommVault is a Gold Member

of the Oracle Partner Network

The benefits of this status are:

• Promotion on http://solutions.oracle.com

• Included in various demos

• Solutions collateral

• Inclusion in selected events (Oracle Open World)

• SAP Partner Product Catalog support w/ logo highlighting

http://solutions.oracle.com/

http://www.oracle.com/partners/

Oracle Data ProtectionReal Application Cluster (RAC)

Raw(FC/iSCSI) / CIFS / NFS / ASM

Pseudo RAC Client

iDataAgents will be installed

on RAC nodes (no

configuration necessary)

A pseudo client with RAC

Database information will be

created to logon to each

instance for backup/recovery

operations

Commvault Simpana v9 LicensingWhere to put the Agents?

iDA for Oracle licenses are required per Oracle Server that performs data protection & recovery operations

In a RAC environment the iDA for Oracle license is only required on the B’n’R nodes

• Operational minimum: one license per cluster

• Business requirement: two licenses per cluster

• Ideal situation: all cluster nodes licensed

Alternatively use the Capacity Based License Program and go for the “Ideal Situation”

Confidential

Agenda

Who is Oracle?

What’s the Issue?


GUI Overview

Q&A


The History of Oracle Data ProtectionThe Evolution has just begun

Available Data Protection Options before

Oracle 8.1.7 (8i)• Export and Import of SQL statements

•Slow operation but quite flexible due to table level and schema granularity

• Cold / Offline Backups

•The one and only consistent backup causes an interruption of the 24/7 production

• Hot / Online Backups

•The first step into the right direction, but causes heavy CPU and Online Redo Log load on the Oracle production servers

The History of Oracle Data ProtectionThe Evolution has just begun

Oracle 8.1.7 (8i) and beyond• RMAN (Recovery Manager) Backups

•Real online backups

•Point in Time (PIT) recoveries

•Block Level Incremental backups

•Block level corruption checks during backup

•Simulation of backup/restore (validate)

•Duplication of databases

– Test / QA

– Development

– Production

What is RMAN exactly?A Wikipedia overview…

Oracle Recovery Manager (RMAN), • command-line and Enterprise Manager-based tool

• is the Oracle-preferred method for efficiently backing up and recovering your Oracle database

• RMAN is designed to work intimately with the server

• providing block-level corruption detection during backup and restore

• optimizes performance and space consumption during backup with

•multiplexing

•backup set compression

• integrates with third party media management products for tape backup

Source: http://en.wikipedia.org/wiki/RMAN

What is RMAN exactly?A Wikipedia overview… cont’d

RMAN takes care of all underlying database procedures before and after backup or restore

• freeing dependency on OS and SQL*Plus scripts

• provides a common interface for backup tasks across different host operating systems

• offers features not available through user-managed methods, such as

•parallelization of backup/recovery data streams

•backup files retention policy

•detailed history of all backups.

Source: http://en.wikipedia.org/wiki/RMAN

Oracle Data ProtectionData Types to be Protected

Data Type FS iDA Oracle

iDA

Pfile

Spfile

Controlfiles

Datafiles/Tablespaces

Archivelogs

Oracle Binaries and Configuration Files

Application Logfiles

Oracle Data ProtectionData Types and Backup Levels

Data Type FULL BLI INCR DIFF

Pfile

Spfile

Controlfiles

Datafiles/Tablespaces

Online Redo Logs not backed up

Archivelogs *)

Oracle Binaries and Configuration Files

Application Logfiles

*) Note: Archive Logs can be backed up incremental and differential, if “backup optimization is disabled”

Confidential

Agenda

Who is Oracle?

What’s the Issue?


GUI Overview

Q&A


GUI OverviewDefining the Oracle Instance

Define Oracle variables and Logon Credentials (OS & App)

Define the Storage Policies for

• Default Subclient

• Command line/RMAN backups

• Archive Log Backups

GUI Overview Subclient Properties

Define the content of the subclient

Enable “Table Browse” if required

v9

GUI Overview Subclient Properties cont’d

Select ArchiveLog Destination for

• Backup

• Deletion

Simpana uses the

“default archive log

destination” if not

specified

GUI Overview Subclient Properties cont’d

Configure Storage Array for SnapProtect™ backup operation

Since Simpana v9 you can use RMAN for Tape Movement

v9

GUI Overview Job Options

Backup Options and Script Preview

GUI Overview Advanced Job Options

Fine-tune Archive Log Backup

Critearia


Fine-tune Archive Log Deletion

Critearia


Add commands, tags, features to the RMAN

script, generated by Simpana v9

• Simpana “understands” about 90% of the complete

RMAN Syntax.

• DBA’s can customize even further, if required

v9

GUI Overview

Job Management

View RMAN Output in Real Time

GUI Overview Monitoring

RMAN Output can be included into standard CommCell Job Summary Reports

GUI OverviewMonitoring

Job History allows to list Snapshots of a SnapProtect™ backup

v9

Snaps can be

• Mounted

• Unmounted

• Reverted

• Deleted

GUI OverviewRestore Options

Job History allows to list Snapshots of a SnapProtect™ backup

v9

GUI OverviewSnap Restore

A backup with SnapProtect™ can be restored in two ways:

• Use RMAN for the data movement including all RMAN features

• Use FileSystem Restore to bring back the control files, datafiles and archive logs.

v9

GUI OverviewAdvanced Restore Options

Controlfiles and SPFiles can be restored from

• Autobackup

• Backup Piece

Controlfiles and SPFiles can be

restored to any location

v9

v9

v9

v9


Datafiles and Tablespaces can be restored

• To Point In Time

• From Latest Backup

• By TAG

Archive Logs only need to be restored for auditing and Log Shipping Purposes. RMAN will restore automatically all necessary Archive Logs during the Recover Phase if they don’t exist on disk.


Databases can be recovered to

• Current Time

• Point In Time

• SCN (System Change Number)

The System Change Number of the last backup can be found at the job details section


Advanced Options

GUI OverviewTable Level Backup & Restore

Index/List of Tables from an entire Database Backup

Enable Table View for browsing on

Schema/User Level


Table Level Browse is dependency aware!

v9


An auxiliary instance can be defined, but not necessarily

• Simpana will create a temporary Auxiliary Instance automatically

Staging Area Space to be provided

• CommVault will only restore tablespaces that are required for the schema export/import


Advanced Export Options can be defined

• Datapump (YES/NO)

• Include Triggers

• Include Constraints

• Include Indexes

• Include Grants

• Include Stored Procedures

v9

GUI OverviewDuplicate a Database

A database can duplicated onto the same or a different host for:• Testing

• Development

• Acceptance Testing & Training

• Mining

• Hardware replacement

Commandline BackupA must with the competition – an option in Commvault

Backups and Restores can be started from the RMAN commandline

Jobs will be registered as “Third Party Commandline” in the Job Controller

Documentationhttp://documentation.commvault.com

The various backup and restore procedures available in the Simpana Product Suite have been very well documented.

• Almost Every PoC scenario can be found in the Online Docs.

Practical ExperienceRecorded Demo

SnapProtect™ Backup, Browse and Recover of Oracle

11gR2 on RHEL 5.1 on Netapp iSCSI volumes

Conclusion

CommVault Simpana v9 Oracle capabilities are:• Simple to Use and Manage

• Unified

• Cost Effective (low TCO and high ROI)

• Storage Resource Effective

• Secure

• State of the Art

• Powerful

• Fast

• Reliable

Q&A

Vielen Dank für Ihre

Aufmerksamkeit!

Frank SchwaakEMEA Product Specialist Databases, UNIX & Network Security

Email: [email protected]: +49 (0) 172 / 5837225

mailto:[email protected]

Documents

SIG Database Backup & Recovery“ Leipzig, DE 08.09 · Frank Schwaak EMEA Product Specialist Databases, UNIX & Network Security SIG Database "Backup & Recovery“ Leipzig, DE –08.09.2011