sig database backup & recovery“ leipzig, de 08.09 · frank schwaak emea product specialist...
TRANSCRIPT
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
Files Email Databases Messaging Web
Out of Control Complexity, Cost & Risk Unmanageable, Limited Access, Poor Recovery
Backup Replication Archive Migration Appliances
- Siloed Data
- Different UIs
- Disparate HW
Acquisition
Hardware
People
Consumable
Ownership Costs
Files Email Databases Messaging Web
Traditional SolutionsDisparate, point level products addressing data management
Backup Replication Archive Migration Appliances
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
Files Email Databases Messaging Web
A Paradigm ShiftUnification through a Singular Approach
Replication Archive Migration Appliances
Unification Lowers Cost
TCO Inputs
Backup
Files Email Databases Messaging Web
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?
Key Benefits of Simpana
GUI Overview
Q&A
Oracle Data Protection and Recovery
Confidential
Agenda
Who is Oracle?
What’s the Issue?
Key Benefits of Simpana
GUI Overview
Q&A
Oracle Data Protection and Recovery
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?
Key Benefits of Simpana
GUI Overview
Q&A
Oracle Data Protection and Recovery
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)
Key Benefits of Simpana for OracleUnique Selling Points
• 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
Key Benefits of Simpana for OracleUnique Selling Points
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
Key Benefits of Simpana for OracleUnique Selling Points
• 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
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?
Key Benefits of Simpana
GUI Overview
Q&A
Oracle Data Protection and Recovery
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?
Key Benefits of Simpana
GUI Overview
Q&A
Oracle Data Protection and Recovery
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
GUI Overview Advanced Job Options
Fine-tune Archive Log Deletion
Critearia
GUI Overview Advanced Job Options
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
GUI OverviewAdvanced Restore Options
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.
GUI OverviewAdvanced Restore Options
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
GUI OverviewAdvanced Restore Options
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
GUI OverviewTable Level Backup & Restore
Table Level Browse is dependency aware!
v9
GUI OverviewTable Level Backup & Restore
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
GUI OverviewTable Level Backup & Restore
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