© 2008 Hitachi Data Systems Corporation
Simplifying Online Backup
Operations for Microsoft Exchange,
SQL and Oracle with Hitachi
Protection Manager Software
Craig Chan: Product Manager
Bobby Crouch: Product Marketing Manager
Hitachi Data Systems
WebTech Educational Seminar Series
Simplifying Online Backup Operations for Microsoft Exchange, SQL
and Oracle with Hitachi Protection Manager Software
Business Session: Microsoft Exchange, SQL and Oracle databases are critical business applications for most IT environments. Additionally, these environments have complex SAN and backup solutions. The tasks associated with discrete management of these business applications to maintain complete defined time images are both complex and involved. Hear from Craig Chan, Software Product Manger how Hitachi Protection Manager software uses its application awareness to backup these applications to be successfully recoverable. ,
You’ll learn how to:
– Simplify complex tasks associated with database storage operations with Hitachi Replication Manager
– Centrally manage database volume, backup target and device, as well as automate restoration operations
– Use the Correlation Wizard to generate ad hoc reports
– Use new functionality available in application aware storage solutions and gain an understanding of what this means to your Microsoft Exchange, SQL and Oracle
3
Data Protection
• Protecting data is
THE key element is Business Continuity and Disaster
Recovery planning.
• Some risk examples are
– Data Corruption
– Hardware or Software Failures – Major Data Center Disaster – Viruses
• Most large enterprises, especially those in the financial sector deploy
several different technologies, not only to recover data but also to
minimize data loss
Hitachi Data Protection Architecture
• Hitachi Business Continuity and Disaster Recovery Solutions address:
– Cross platform operation;
• Hitachi Universal Storage Platform™ family • Hitachi Adaptable Modular Storage family
– In-System and Remote replication solutions
• Full volume clone and Snapshot for In-System Replication • Synchronous and Asynchronous for Remote Replication • Industry leading architecture for remote replication
– Application Awareness for Microsoft Exchange, SQL and Oracle
– Integrated support for VMware SRM environments
5
Hitachi Replication Product Portfolio
Data Replication
Hitachi ShadowImage® In System Replication
Copy-on-Write Snapshot
Hitachi Universal Replicator Hitachi TrueCopy® Remote
Replication
Hitachi Protection Manager Hitachi Business Continuity Manager
Table of Contents
•
Topics
– Overview: Hitachi Protection Manager – Protection Manager for Oracle Overview
• Concept of Protection Manager • Support Platform and Products
– Understanding Protection Manager for Oracle • Backup and Restore
– Using Protection Manager for Oracle • Install and Setup
7
Hitachi Protection Manager Introduction
• Hitachi Protection Manager is a Split-Mirror backup solution
– Discovers SQL/Exchange and File system objects and maps the relationship from databases of instance to storage LUNs – Works with VSS for Exchange and NTFS
– Works with VDI for SQL
– Hitachi Storage replication product is pre-requisite
• Currently supports
– Exchange 2000, 2003 and 2007 – SQL 2000 and 2005
– SharePoint 2007 – Oracle
• Supports all Hitachi Storage Subsystems
– Hitachi Universal Storage Platform™ family – Hitachi Adaptable Modular Storage family
– Legacy Hitachi storage systems – Lightning, Thunder
• Typical Use Case
Hitachi Protection Manager for Oracle
Overview
•
What’s New on Hitachi Protection Manager version 6.1?
– Now supports Oracle 10g, 11g database on Solaris 9, 10 (SPARC) environment
– Provides a Solaris edition of “Hitachi Protection Manager Copy Controller" and "Hitachi Protection Manager for Oracle"
•
What is Hitachi Protection Manager for Oracle?
– Allows user to perform high speed and simplified backup and restore operations
• Utilizes storage volume copy for high speed operation
• Allows to specify oracle objects (database, tablespace, redo log) instead of volume structure like LDEV, for simplified operation
– Allows user to manage backup catalog
• Maintains the backup history, and allows to view and verify the backed up objects
– Allows user to perform unified backup operation across multiple DBMS
• Provides similar command architectures among SQL Server, Exchange and Oracle, allowing to reduce the operational cost
9
Hitachi Protection Manager for Oracle Overview
Quick Look
Interacts with Oracle and CCI, to manage mapping between oracle files and physical volumes
Oracle Instance Oracle Database
Oracle Files
System Tablespace
Archived Redo Log
PFILE, SPFILE Control File User Tablespace .dbf file .dbf file .arc file
.ora file .ctl file
11/2 2:00 AM 11/1 2:00 AM Volumes do rotation (*1) (*2)
(*1) HPtM backups files to the folder specified by “drmorainit” command
(*2) If it is “cold backup” and “files are stored on P-VOL”, they are backed up to S-VOL. For other case, HPtM backups files to the folder specified by “drmorainit” command (*3) They are backed up only when “cold backup”. Backed up from P-VOL to S-VOL.
volume copy operation using CCI
(Shadow Image, COW Snapshot, etc)
HPtM
dictionary map file
(*3)
Online Redo Log
Benefits
• Significantly shrinks backup windows
– No load impact on Exchange/SQL/Oracle host – No overnight “backup” windows needed
– More frequent full backups – Minimize risk exposure (RPO)
• RTO and RPO improvement
– Minutes instead of hours – Designed for high availability – Achieves uptime SLA
• Operational excellence
11
Exchange Backup performance - example
5 min 47 sec 11 min 24 sec 295 min 44 sec 51 min 55 sec 1 min 16 sec 0 50 100 150 200 250 300 VSS backup Online backup Cold backup Ntbackup Time (Minutes) Backup time Verify process • Test configuration – 1500 users, 110MB mailbox – 200GB data plus log
– Simulate I/O workload with LoadSim
– NT backup’s destination is disks within the production array
Hitachi Protection Manager for Oracle - Overview
Support Platform and Products
• Oracle 10g (R1) Family Product (*2)
• Oracle 10g (R2) Family Product • Oracle 11g (R1) Family Product • Oracle 10g (R1) Family Product • Oracle 10g (R2) Family Product • Oracle 11g (R1) Family Product
DBMS
Real Application Clusters (RAC) and Automatic Storage Management (ASM) are not supported
Veritas Cluster File System ( VxCFS ) and Solaris ZFS are not supported
Note
• Veritas File System (VxFS) • UNIX File System (UFS) • Veritas File System (VxFS) • UNIX File System (UFS)
File System Solaris 10 Solaris 9 Operating System # 2 1
(*1) “Solaris 9/10 (SPARC 64bit)” environment is supported for Oracle Backup / Restore (As for the File System Backup, “Solaris 9 (SPARC 32bit”) environment is also supported) (*2) Requires version 10.1.0.3
• CCI(RAID Manager)
• VERITAS Volume Manager 5.0 MP1 • Veritas Cluster Server (VCS) 5.0 MP1 • Veritas Dynamic Multipathing (DMP)
Products
Non-global zone of Solaris is not supported
VCS is required only when the Oracle is clustered. DMP needs to be the same version as VxVM
Note Solaris 10 Solaris 9 Operating System # 2 1
• Support Platform
– Hitachi Protection Manager supports Oracle 10g, 11g on Solaris9, 10 (*1)
• Support Products
13
Installing Hitachi Protection Manager
for Oracle
Using Hitachi Protection Manager
Installation and Setup•
Installation Procedure
The following slides describes the topics below
–
Install
• Confirm the Environment
• Install Hitachi Protection Manager Controller • Install Hitachi Protection Manager for Oracle • Setting Environment Variables
–
Setup
• Setting up CCI
• Setting up Hitachi Protection Manager for operation
• Setting up Hitachi Protection Manager for Linkage with CCI • Updating a Dictionary Map File
15
Using Hitachi Protection Manager
Installation and Setup - Install
•
Confirm the Environment
– Install the prerequisite products (CCI, VxVM, etc.)
•
Install Hitachi Protection Manager Copy Controller
(*1)– Execute install.sh for Hitachi Protection Manager Copy Controller
• PROMPT> Solaris/Copy_Controller/install.sh
Do you want to continue with the installation of <HPTM> [y, n, ?] y …
Installation of <HPTM> was successful
•
Install Hitachi Protection Manager for Oracle
(*1) (*2)– Create the license file for installation
• PROMPT> echo license-key > /var/tmp/drm_lic_key
– Execute install.sh for Hitachi Protection Manager for Oracle
• PROMPT> Solaris/Oracle/install.sh Input Oracle version [10,11] : 11
Do you want to continue with the installation of <HPTM-ORA> [y, n, ?] y …
The following describes the installation flow of Hitachi Protection Manager for Oracle
(*1) The files are installed to /opt/drm and /var/opt/drm, and these directories cannot be changed
Using Hitachi Protection Manager
Installation and Setup - Setup
•
Setup for Using Protection Manager (1)
– Setting up CCI
• Configure the HORCM file in the “/etc” directory • Create the pairs for backup/restore
– Setting up Hitachi Protection Manager for operation • Configure “/opt/drm/conf/init.conf”
– In the case changing values from their defaults, refer to the “Hitachi
17
Using Hitachi Protection Manager
for Oracle
Understanding Hitachi Protection Manager
Overview - Component Relationship
Storage Subsystem Solaris HPtM Copy Controller CCI HPtM for Oracle Oracle Solaris HPtM Copy Controller CCI VERITAS NetBackup Backup Catalog Backup Catalog Oracle Files Tape Library Control Files, PFILE, SPFILE Archived Redo, etc.
Database Server (*1) Backup Server (*2)
Backup & Restore Backup & Restore
LAN
Mount/Unmount Volume Dynamically
drmorabackup drmorarestore drmmediabackup drmmediarestore (1) (1) (2) (2) Run Commands Run Commands P-VOL S-VOL
19
Understanding Hitachi Protection Manager
Usage Scenario
•
Hitachi Protection Manager for Oracle Command Usage
– The following slides describe the usage of commands with example
•
Scenario
1. Check the Oracle database configuration • “drmoradisplay” command
2. Backup Database
• “drmorabackup” command 3. Check the Backup Result
• “drmoracat” command 4. Backup Archived REDO Log
• drmoralogbakcup command
– Restore and Recovery database • “drmorarestore” command • RMAN / SQL*Plus command
Understanding Hitachi Protection Manager
Usage – Check Oracle Database Configuration
• Check oracle database information with “drmoradisplay”
– “drmoradisplay –refresh” command acquire the latest information of oracle and volume, then stores into the dictionary map file.
– “drmoradisplay [instace]” displays the information registered in the dictionary map file • Displayed information : oracle files (tablespaces, redo log, etc.), logical / physical
volume relations, oracle information, or last update time of dictionary map, etc.
PROMPT> drmoradisplay oracle1 INSTANCE: oracle1
T OBJECT FILE FS DG DEVICE COPY-GROUP T SYSTEM /prodsk/oravol1201/system01.dbf /prodsk/oravol1201 stdvgora12 c10t2d4 STD02,orastd121
- - - STD02,orastd121
T UNDOTBS1 /prodsk/oravol1203/undotbs01.dbf /prodsk/oravol1203 stdvgora12 c10t2d4 STD02,orastd121
- - - STD02,orastd121
T USERS /prodsk/oravol1204/users01.dbf /prodsk/oravol1204 stdvgora12 c10t2d4 STD02,orastd121
- - - STD02,orastd121
A ARCLOG1 /prodsk/oravol0401/disk01/arch /prodsk/oravol0401 stdvgora04 c10t2d3 STD01,orastd041
- - - STD01,orastd041
O ONLRDO1 /prodsk/oravol0301/redo01.log /prodsk/oravol0301 stdvgora03 c10t2d2 STD02,orastd031
- - - STD02,orastd031
C CNTL1 /prodsk/oravol1101/control01.ctl /prodsk/oravol1101 stdvgora11 c10t2d0 STD02,orastd111
- - - STD02,orastd111
I INIT /prodsk/oravol1101/inithorn01.ora /prodsk/oravol1101 stdvgora11 c10t2d0 STD02,orastd111
- - - STD02,orastd111
21
Understanding Hitachi Protection Manager
Usage – Backup Database
•
Backup database with “drmorabackup”
– Backup Options
• Perform Online Backup for Tablespace
– drmorabackup instance-name –mode online –target tablespace-name(s)
• Perform Online Backup for the entire database
– drmorabackup instance-name –mode online –all
• Perform Cold Backup for entire database
– drmorabackup instance-name –mode cold
– Notes
• Backup is performed based on the information in the dictionary map file
• Hitachi Protection Manager also backs up control file and initialization parameter file (PFILE), server parameter file (SPFILE).
– Use “-exfile” option, for backing up network file and password file too
• If multiple generations of S-VOL are defined, Hitachi Protection Manager will automatically pick one, or it can be specified by user. If all of the S-VOLs are already in use, re-use the oldest one
PROMPT> drmorabackup ORA1 -all
KAVX0001-I The drmorabackup command will now start. KAVX0019-I Copying file(s) now...
KAVX0040-I The backup ID has been assigned as follows: Backup ID = 0000000001
KAVX0002-I The drmorabackup command will now end. PROMPT>
Understanding Hitachi Protection Manager
Usage – Check Backup Result
•
Display backup catalog information with “drmoracat”
– It displays the list of oracle backup information acquired by Hitachi Protection Manager
• Displayed information: Backup ID, tablesapce, oracle files, file system, logical/physical volume information, etc.
PROMPT> drmoracat oracle1 INSTANCE: oracle1
BACKUP-ID: 0000000001 BACKUP-MODE: COLD INSTANCE: oracle1 ORIGINAL-ID: 0000000001 START-TIME:2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00
HOSTNAME: DB_SVR1
T OBJECT FILE FS DG DEVICE COPY-GROUP
I INIT /disk2_0/u01/app/initsun250d.ora - - -
-C -CNTL1 /disk2_0/u01/app/control01.ctl - - -
-T USERS /df500-2/USERS/users01.dbf /df500-2 L1-TestDG c4t0d4s2 VG01,oradb14 T TOOLS /df500-2/TOOLS/tools01.dbf /df500-2 L1TestDG c4t0d4s2 VG01,oradb14 T TEMP /df500-2/TEMP/temp01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 T SYSTEM /df500-2/SYSTEM/system01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 T RBS /df500-2/RBS/rbs01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 T INDX /df500-2/INDX/indx01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 PROMPT> drmoracat oracle1
INSTANCE: oracle1
BACKUP-ID: 0000000001 BACKUP-MODE: COLD INSTANCE: oracle1 ORIGINAL-ID: 0000000001 START-TIME:2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00
HOSTNAME: DB_SVR1
T OBJECT FILE FS DG DEVICE COPY-GROUP
I INIT /disk2_0/u01/app/initsun250d.ora - - -
-C -CNTL1 /disk2_0/u01/app/control01.ctl - - -
-T USERS /df500-2/USERS/users01.dbf /df500-2 L1-TestDG c4t0d4s2 VG01,oradb14 T TOOLS /df500-2/TOOLS/tools01.dbf /df500-2 L1TestDG c4t0d4s2 VG01,oradb14 T TEMP /df500-2/TEMP/temp01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 T SYSTEM /df500-2/SYSTEM/system01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 T RBS /df500-2/RBS/rbs01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13 T INDX /df500-2/INDX/indx01.dbf /df500-2 L1TestDG c4t0d3s2 VG01,oradb13
23
Understanding Hitachi Protection Manager
Usage – Backup Log
•
Log backup with “drmoralogbackup”
– “drmoralogbackup” backups “Archived REDO Log” and “Control Files”
• It backs up Archived REDO Logs created since the last database open with “RESETLOGS” option
• It is available when “instance is running” and “ARCHIVELOG MODE” is enabled • Using “-v” option displays the information of already backed up archived redo logs
Backup the archived redo log
View the result of backup
PROMPT> drmoralogbackup ORA1
KAVX0001-I The drmoralogbackup command will now start. KAVX0808-I Log backup is acquired from the following contents.
Log backup ID = 0001
KAVX0002-I The drmoralogbackup command will now end. PROMPT>
PROMPT> drmoralogbackup ORA1 -v 0001 BACKUP_ID :0001
DATE :2003-08-13 17:58:30
CONTROL FILE :/var/opt/drm/log/backup/oracle/ORA1/ control1.ctl00001
FILE NAME :/var/opt/drm/log/backup/oracle/ORA1/arc0001.arc SEQUENCE :100
FIRST_CHANGE :30182 NEXT_CHANGE :30258
FIRST_TIME :2003-08-13 16:45:13 NEXT_TIME :2003-08-13 17:02:08
FILE NAME :/var/opt/drm/log/backup/oracle/ORA1/arc0002.arc SEQUENCE :101 FIRST_CHANGE :30258 NEXT_CHANGE :30419 FIRST_TIME :2003-08-13 17:02:08 NEXT_TIME :2003-08-13 17:16:58 PROMPT>
Understanding Hitachi Protection Manager
Usage - Restore and Recovery
•
Restore using Hitachi Protection Manager for Oracle
– Restore using “drmorarestore” command restore oracle files
• This command stops the Oracle instance. But, in case all of the
following conditions are satisfied, only the restoring tablespaces are placed offline and instance itself is not stopped
– Restoring a backup acquired with online backup – Non-clustered configuration
– Any of (SYSTEM, UNDO, TEMP) are not included in restore target
• Specify the backup to be restored by its “Backup ID” (ex. 0000000003)
PROMPT> drmorarestore 0000000003 –resync
KAVX0001-I The drmorarestore command will now start. KAVX0019-I Copying file(s) now...
KAVX0002-I The drmorarestore command will now end. PROMPT>
25
Understanding Hitachi Protection Manager
Usage - Restore and Recovery
•
Recovery using RMAN/SQL*Plus
– Perform the recovery operation using RMAN/SQL*Plus (recovery operation not supported as Hitachi Protection Manager commands)
• Apply the recovery commands provided by Oracle • Start the Oracle instance/Online tablespace
– It is required because “drmorarestore” command does not start the stopped oracle instance, and does not online the offline tablespaces
• Example on SQL*Plus
PROMPT> sqlplus user/pass as sysdba SQL> startup mount
SQL> recover database
Understanding Hitachi Protection Manager
Usage - Restore and Recovery
•
Recovery using RMAN/SQL*Plus
– Oracle provides Roll-Forward recovery and Point-In-Time recovery after restoring the data by Hitachi Protection Manager
Tablespace
Archived Redo LOGs
TIME Recovery Point Roll-Forward recovery drmorarestore BACKUP 0000000001 P-VOL S-VOL BACKUP : 0000000001 RMAN> run { recover database; } RMAN run {
set until time ’12-may-06 15:30’; recover database;
27
Upcoming Events
•
2009 WebTech Schedule to be announced shortly
– January–March: Series on Microsoft Exchange
• Please check www.hds.com/webtech
for:
– Link to the recording, the presentation, and Q&As (available next week) – Schedule and registration for upcoming WebTech sessions
