Recovery Manager (rman) And Oracle Secure Backup (osb) 5b324

Recovery Manager (RMAN) and Oracle Secure Backup (OSB) Secure Your Data, Protect Your Budget Donna Cooksey Principal Product Manager, Oracle Corporation

Program Agenda • • • • • • •

2

Oracle Data Protection Recovery Manager (RMAN) – Overview Oracle Secure Backup (OSB) - Overview OSB Competition How to Sell OSB Summary Q&A

Oracle Confidential – Internal Use Only

Oracle Database Protection Solutions Backup & Recovery

Recovery Time Objective (RTO)

Physical Data Protection

Hours/Days

• Recovery Manager (RMAN) • Oracle Secure Backup (OSB)

Logical Data Protection

Minutes/Hours

• Flashback Technologies

Recovery Analysis • Data Recovery Advisor

Minimizes time for problem identification & recovery planning

Disaster Recovery

Recovery Time Objective (RTO)

Physical Data Protection

Seconds/Minutes

• Active Data Guard

3


Complete Oracle Solution from Disk to Tape Backup and Recovery File System Data UNIX Windows

Oracle Secure Backup (OSB)

Tape Backup

Linux NAS

Oracle Databases

Oracle Recovery Manager (RMAN)

Fast Recovery Area

Oracle Secure Backup (OSB) Cloud Module

Amazon S3 Cloud Storage

• Oracle backup and recovery for your entire IT environment • Multiple media options available to meet the most stringent SLAs • Local disk, remote Cloud storage, physical and virtual tape

4


Oracle Recovery Manager (RMAN) Oracle-integrated Backup & Recovery Engine

Oracle Enterprise Manager

• Oracle’s Integrated Backup & Recovery solution Oracle Secure Backup

RMAN

Tape Drive

Fast Recovery Area Database

Cloud

• Intrinsic knowledge of database file formats and recovery procedures • Block validation • Online block-level recovery • Tablespace/data file recovery • Online, multi-streamed backup • Unused block compression • Native encryption • Data Recovery Advisor (11g)

• Integrated disk, tape & cloud backup leveraging the Fast Recovery Area and Oracle Secure Backup* *RMAN also s leading 3rd party media managers

5


Fast Recovery Area (FRA) Automated Disk-to-Disk (D2D) Backup & Recovery • Unified storage location for all recovery files and recovery related activities in an Oracle Database. • Centralized location for control files, online redo logs, archived logs, flashback logs, backups • A fast recovery area can be defined as a directory, file system, or Automatic Storage Management (ASM) disk group • Oracle Suggested Strategy • Incrementally updated backups on the FRA • Incremental forever backup strategy after initial full • Full backup on disk is rolled forward daily using incremental backup • Archive to tape on a regular basis

Database Area 6

Fast Recovery Area

Tape Device Oracle Confidential – Internal Use Only

Fast Recovery Area Space Management

Archived Logs & Data File Backups

Fast Recovery Area

Disk limit is reached and a new file needs to be written into the Fast Recovery Area

Oracle deletes files that are no longer required on disk.

Space pressure get Warning issued to 1 2 Backup files to tape/secondary disk location 7

Files not required for retention policy

Files backed up to tape/ secondary disk location


Fast Recovery Area Sizing • If you want to keep: • Control file backups and archived logs • Estimate total size of all archived logs generated between successive backups on the busiest days x 2 (in case of unexpected redo spikes) • Flashback logs • Add in {Redo rate x Flashback retention target time x 2} • Incremental backups • Add in their estimated sizes • On-disk image copy • Add in size of the database minus size of temporary files • Further details: • http://.oracle.com/docs/cd/E11882_01/backup.112/e106 42/rcmconfb.htm#i1019211

8


Oracle Suggested Backup Strategy Database

Backups Level 0 IMAGE backup

Level 1 differential incremental backup

Day 1

Day 2

Day 3 • Pros • Faster recovery from up-todate image copy • Less data to backup = shortened backup windows 9

• Cons • Can not recover data older than 24 hours • Image copy can not be compressed by RMAN Oracle Confidential – Internal Use Only

Oracle Suggested Backup Strategy Leveraging 7000’s SnapShot

Database

Backups Level 0 IMAGE backup

SnapShot

Level 1 differential incremental backup

Day 1

Day 2

Day 3

10


RMAN Backup to Tape Requires Media Management Software • Recovery Manager (RMAN) •

Oracle Databases

•

FREE online, full, incremental database backups to disk Requires media management software for tape backups

• Oracle Secure Backup (OSB)

Recovery Manager Server - managed database backup

•

• 3rd Party Media Management Software •

Media Management Software

LOW-COST media management software

EXPENSIVE, $$ Costs thousands per database server for RMAN integration!

Tape Device

11


Oracle Secure Backup (OSB) Enterprise Tape Backup Management Oracle Enterprise Manager

Protects Entire IT Environment

Oracle Secure Backup File System Data

Oracle Database

RMAN Integration

•Oracle Database 11g Release 2 back to Oracle9i

•25 – 40% faster tape backup •Heterogeneous file systems (UNIX/ Linux / Windows) and NAS devices •Built-in Oracle Integration •Centralized management in distributed environments

Tape Library

12

Virtual Tape Library (VTL)

•Over 75% less expensive than comparable products


Centralized Tape Backup Management Client / Server Architecture

Clients

NAS

istrative Server

UNIX / Linux / Windows

LAN

Media Server(s)

Central Management • Data protection for heterogeneous, distributed servers managed from a central console, istrative Server

Storage

• Media servers may be direct-attached or SANattached to tape devices • OSB communicates directly with the client host to backup mounted file systems and storage • Oracle database(s) may be located on any client or media server within the backup domain

Tape Library 13

Virtual Tape Library (VTL)


Oracle Database Protection Recovery Manager (RMAN) and OSB

Oracle Database

RMAN Integration

• Oracle database backup / recovery management • Utilize RMAN command line or Oracle EM (Database or Grid Control) restoring to original or alternate location • Performance optimizations achieving 25 – 40% faster backup to tape than comparable products • Unused block compression • Undo backup compression • Shared buffer between RMAN and OSB • Encrypted backups using either RMAN or OSB encryption capabilities • Tape vaulting optimizations with OSB and RMAN • RMAN restore database preview identifies offsite backup tapes • RMAN restore database preview recall initiates OSB recall of tapes for restoration OSB differentiator

14


Proven Performance Validated by MAA Best Practices • Performance results: – Backup rate : 8.6 TB/hr

(179MB/sec per tape drive)

– Restore rate: 7.8 TB/hr (162MB/sec per tape drive)

Environment

For more information, refer to the MAA white paper : http://www.oracle.com/technetwork/database/features/availability/maa-tech-wp-sundbm-backup-final-129256.pdf

15


File System Protection UNIX / Linux / Windows and NAS Devices File System Data

• File system backup / restore management: • EM Grid Control 10.2.0.5, EM Database Control 11.2.0.1, OSB web tool

or unified command line (obtool) • Heterogeneous file system backup/restore: • Solaris SPARC, Solaris x-86, Linux, Windows, HP-UX Itanium, and AIX

• Backup / restore of Network Attached Storage (NAS) devices using Network Data Management Protocol (NDMP): • Sun ZFS Storage Appliances*,Network Appliance, EMC and Pillar Data Systems

• Tree-style catalog browsing for restoration to original or alternate location • Automatic recall of tapes located offsite to perform restore operations

• Refer to Certifications on My Oracle for listing ed platforms, operating systems and NAS devices *OSB and Sun Storage Appliance qualification in progress.

16


Enterprise-Class Features Oracle Secure Backup Delivers…. Comprehensive media lifecycle management • Tapes managed from first write to reuse per -defined policies • Automates tape duplication and vaulting

Backup encryption and key management • Leverages host-based or tape drive (LTO or T10000B) encryption • Keys generated and managed per -defined policies

Advanced tape device configurations • Dynamic drive sharing between multiple media servers • Server-less tape duplication • StorageTek Automated Cartridge System Library Software (ACSLS)

17


Broad Tape Device Physical and Virtual Devices

Partners:

ADIC

Copan Systems

Data Domain

Dell

EMC

FalconStor

HP Quantum

IBM Qualstar

Overland Storage Sepaton

Sony

Spectra Logic

Sun / StorageTek

OSB Tape Device Compatibility Matrix: http://www.oracle.com/technetwork/database/secure-backup/learnmore/tape-devices-10-3-161824.pdf

18


IT Cost Savings… 75%+ Migration to Oracle Secure Backup

Oracle Secure Backup is licensed at $3500 per tape drive. Imagine how much in annual maintenance costs you’ll save!!!

19


OSB Competition

20


Who is the Competition? • Tier 1 Competitors • Symantec (Veritas) Netbackup • IBM Tivoli Storage Manager (TSM) • EMC Legato Networker

21

• Tier 2 Competitors • • • •

Commvault Simpana HP Data Protector Bakbone Netvault Syncsort Backup Express


Key Differentiators Oracle Secure Backup Oracle Enterprise Manager (EM)

Sun ZFS Storage Appliances

Oracle Exadata Database Machine

22

Oracle Secure Backup

Increased Return on Investment (ROI):

Recovery Manager (RMAN)

StorageTek Tape Devices

• Single technical resource from hardware to software • High-performance, secure tape backup – Exclusive optimizations • Fully validated component of the Oracle Maximum Availability Architecture (MAA) • Substantial cost savings – about 75% less than others

Who Better to Backup Oracle than Oracle?


Advanced Functionality Licensing OSB vs Leading Competitors

Advanced Features

23

Oracle Secure Backup

Integration with RMAN

Free

Dynamic tape drive sharing (often called shared storage option)

Free

Tape vaulting automation

Free

Backup Encryption to tape

Free

Servers backed up over the network

Free

“Media” servers (hosts direct attached to tape devices)

Free

Backup of NAS devices using NDMP (locally or remotely)

Free

Virtual tape library

Free

Sun / StorageTek ACSLS library

Free

Leading Competitors


Some Potential Gaps… Features Competitors May Have - Not in OSB Feature

Workaround

Disk backup for file system data

•Utilize Virtual Tape Library (VTL)

Online backup of non-Oracle databases (ie SQL, Exchange etc.)

•Backup database offline •Backup database online using native backup tools, then perform OSB file system backup to tape

Multiplexing of file system backups

•Utilize Virtual Tape Library (VTL)

Backup of open files and active directory on Windows Bare metal restore

24


Why Sell OSB? What’s in it for ME? • Increase hardware sales! •

Money saved on backup software frees up limited budget $ for additional hardware purchases

• Reduce exposure of competitor being introduced into sales opportunity •

Reseller promoting 3rd party backup software may also resell 3rd party tape/storage devices

• Oracle interoperability – Built-in • •

25

OSB domain (including StorageTek tape devices) managed by Oracle EM Oracle validated solutions save customer time • Potentially reduce sales cycle


How to Sell OSB

26


Target Markets • Small to medium companies: • Complete, affordable tape backup management solution • DBA and storage istration may be in same group

• Large / Enterprise companies: • Target OSB for their Oracle environment • Partition tape library – One partition to OSB and other to existing backup product • Usually storage / system istration are the decision makers • DBA group often influencer

• Oracle partners: • ISVs can bundle Oracle Secure Backup with their application • Resellers and integrators providing a complete backup and recovery solution

27


Identifying OSB Prospects • Cost conscience customers • OSB backs up unlimited servers to tape - FREE

• Customers making infrastructure changes • Deploying Oracle RAC, VTLs, consolidating tape devices, migrating server platforms etc

• Customers not happy with existing backup software • Oracle customer base • • • • •

28

Oracle database Exadata Oracle applications Oracle Enterprise Manager StorageTek tape devices


Probing Questions… Oracle Database Customers • How would reducing tape backup window benefit you? • Oracle database backup to tape is 25 – 40% faster with OSB than that of comparable products

• What is your current Oracle database backup strategy? • Online? Disk or tape or both? Full or incremental strategy? • If disk, do they use the Fast Recovery Area (FRA)?

• Have you purchased the Oracle database module from existing media management product? • Expensive option with competitor products - many customers don’t buy it • Without option, database tape backup / restore is two step process – NOT an integrated solution ! • Backup to disk using RMAN, “sweep” disk as part of file system backup • Media management restore back to disk location, then RMAN restores from disk location

29


Know Your Audience… Database s (DBA) •

DBAs don’t generally manage tape devices…so why would they be interested in OSB? • •

•

Who better to backup Oracle than Oracle? • •

•

OSB delivers the fastest database backup to tape Majority of Oracle database customer leverage RMAN and need an integrated solution to tape

Focus discussions on Oracle database backup • •

30

Control: DBAs are responsible for successful database recovery Single technical resource eliminating “finger pointing” between multiple vendors

DBA’s generally don’t have much insight into managing tape infrastructure itself – ie vaulting, tape devices, backup domain Familiar management interface – Oracle Enterprise Manager


Know Your Audience…Cont’d System / Storage s •

How will OSB will address backup / restore requirements •

•

Is DBA expertise needed to use OSB? •

• •

Media management: vaulting, duplication, tape retention Backup encryption and key management Heterogeneous file system data, Oracle databases, NAS devices

Ease of use – managing the backup domain Cost savings – helps their budget •

31

NO !!!! - An Oracle database is not required to be part of OSB domain

Is IT environment ed? Focus discussion on policy-based management infrastructure • • •

• •

Interested in OSB capabilities - not just Oracle database backup

Save money on backup software frees up budget for additional hardware/capability needs


Overcoming Customer Objectives •

We have standardized on “x” backup software, why would we switch to OSB? • • •

•

What about legacy tapes from existing backup software? •

•

Maintain a legacy backup server to restore from those tapes

We have non-Oracle databases, what about those? • • •

32

If most of customer data resides in Oracle database, an integrated Oracle validated / integrated solution will be long-term advantage Cost savings – Initial licensing and ongoing maintenance Increased scalability – Backup environment grows, only need to license OSB for additional tape drives…nothing else! • Simplified license management with OSB

Leverage native tools to disk, then OSB can backup disk backup to tape as part of file system backup Review storage snapshot capability (ie S7000) to acquiesce database for consistent snap which is backed up to tape using OSB Maintain existing software for that environment and migrate Oracle environment to OSB


1st Step in Qualifying… Confirm Customer Environment is ed • What platforms, NAS devices and operating system (os) versions are required? • http://www.oracle.com/technetwork/database/securebackup/learnmore/platforms-10302-161825.pdf

• Confirm tape device : • • • •

Tape drive Tape library Connectivity from host to tape device (ie fibre, SCSI, SAS etc) http://www.oracle.com/technetwork/database/securebackup/learnmore/platforms-10302-161825.pdf

• Oracle database ed versions: • Oracle9i through Oracle database 11g Release 2

33


Helping to Sell Customer Facing • Websites on OTN include: • • • • • • •

Datasheets, white papers, presentations Tutorials Software Customer forum And more… OSB : http://www.oracle.com/goto/osb RMAN: http://www.oracle.com/goto/rman

• Oracle University (OU) Backup and Recovery class

34


Helping to Sell Internal Resources • OSB collateral available at http://database.us.oracle.com • From “Collateral” tab, filter by: • Release = “OSB”

• Internal technical distribution list for RMAN and OSB: • [email protected]

35


Helping to Sell Customer Proof Points / References • Oracle data centers utilize OSB • Currently backing up 6.4+ Petabytes / month • http://www.oracle.com/technetwork/database/securebackup/overview/s316929-oow-2010-175358.pdf

• Customer references: • http://www.oracle.com/technetwork/database/features/hacasestudies-098033.html

• Want more customer references – NEED YOUR HELP!

36


Summary

37


Complete Oracle Integrated Solution Oracle Built, Validated and ed Oracle Enterprise Manager

OSB istrative Server Sun Fire X4270

Sun Fire X4275 OSB Media Servers

Oracle Exadata Database Machines

38

StorageTek SL3000 Infiniband QDR Network Fibre Channel


Advantages: Oracle Integration Solution • Maximum Return on Investment (ROI) for your Oracle environments • From hardware to software - production to tape backup

• Single vendor technical resource – Saves time! • Eliminates interoperability challenges • Expedites problem resolution

• Optimization benefits • Fastest Oracle database backup to tape • Single management interface , Oracle Enterprise Manager • Stay tuned, more to come…

39


Why Oracle Secure Backup? — Top 5 Reasons

40

1•

Reliable, built-in integration with Oracle

2•

25 – 40% faster Oracle database backup to tape

3•

Data protection for your entire IT environment

4•

Advanced policy-based data protection management

5•

75%+ less expensive than comparable products


41


Recovery Manager (rman) And Oracle Secure Backup (osb) 5b324

Overview 6h3y3j

More details h6z72

Related Documents 543cg

Recovery Manager (rman) And Oracle Secure Backup (osb) 5b324

Oracle Backup And Recovery 2c64p

Tutorial Oracle Secure Backup 2i5z

Oracle Secure Backup .pdf 1d4l34

Emc Backup And Recovery 1u5c6u

Avamar Enterprise Manager Transition To Backup And Recovery Manager 6v5435

More Documents from "alex" 45q1p

Ravening Hordes - Lizardmen 8th Ed 6l33u

Dac1220 p603n

Aos Warscroll Orruk Brutes En 3z4y1g

Ventajas De La Contabilidad Para Una Empresa 603s3y

11482j

Notebook Toshiba Qosmio X775 473d1j