HP A.06.11 User Manual
HP Data Protector A.06.11
Integration guide for Oracle and SAP
B6960-90158
Part number: B6960-90158
First edition: September 2009
Legal and notice information
© Copyright 2004, 2009 Hewlett-Packard Development Company, L.P.
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent
with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and
Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard
commercial license.
The information contained herein is subject to change without notice. The only warranties for HP products
and services are set forth in the express warranty statements accompanying such products and services.
Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for
technical or editorial errors or omissions contained herein.
Intel®, Itanium®, Pentium®, Intel Inside®, and the Intel Inside logo are trademarks or registered trademarks
of Intel Corporation or its subsidiaries in the United States and other countries.
Microsoft®, Windows®, Windows XP®, and Windows NT® are U.S. registered trademarks of Microsoft
Corporation.
Adobe and Acrobat are trademarks of Adobe Systems Incorporated.
Java is a US trademark of Sun Microsystems, Inc.
Oracle® is a registered US trademark of Oracle Corporation, Redwood City, California.
UNIX® is a registered trademark of The Open Group.
Printed in the US
Contents
Publication history .............................................................. 13
About this guide ................................................................. 15
Intended audience ............................................................................................. 15
Documentation set ............................................................................................. 15
Guides ...................................................................................................... 15
Online Help ............................................................................................... 18
Documentation map .................................................................................... 19
Abbreviations ...................................................................................... 19
Map ................................................................................................... 20
Integrations ......................................................................................... 21
Document conventions and symbols ..................................................................... 23
Data Protector graphical user interface ................................................................. 24
General information .......................................................................................... 25
HP technical support .......................................................................................... 25
Subscription service ........................................................................................... 26
HP websites ...................................................................................................... 26
Documentation feedback .................................................................................... 26
1 Integrating Oracle and Data Protector ................................ 27
Introduction ...................................................................................................... 27
Integration concepts .......................................................................................... 28
Configuring the integration ................................................................................. 33
Prerequisites ............................................................................................... 33
Limitations .................................................................................................. 34
Before you begin ........................................................................................ 35
Cluster-aware clients .................................................................................... 35
Linking Oracle Server with the Data Protector MML ......................................... 36
Linking on HP OpenVMS systems ........................................................... 36
Configuring Oracle user accounts ................................................................. 37
Configuring Oracle operating system user accounts .................................. 37
Configuring Oracle database users accounts ........................................... 39
Configuring user accounts on HP OpenVMS ............................................ 39
Integration guide for Oracle and SAP 3
Configuring Oracle databases ...................................................................... 41
Using the Data Protector GUI ................................................................. 42
Using the Data Protector CLI .................................................................. 45
Checking the configuration .......................................................................... 53
Using the Data Protector GUI ................................................................. 53
Using the Data Protector CLI .................................................................. 53
Setting environmental variables ..................................................................... 55
Using the Data Protector GUI ................................................................. 55
Using the Data Protector CLI .................................................................. 56
Backup ............................................................................................................ 57
Creating new templates ............................................................................... 57
Creating backup specifications ..................................................................... 58
Examples of pre-exec and post-exec scripts on UNIX ................................. 69
Editing the Oracle RMAN script .................................................................... 70
Creating copies of backed up objects ............................................................ 73
Testing the integration ................................................................................. 74
Testing using the Data Protector GUI ....................................................... 75
Testing using the CLI ............................................................................. 76
Starting backup sessions .............................................................................. 77
Scheduling backup specifications ........................................................... 81
Running an interactive backup ................................................................ 82
Starting Oracle backup using RMAN ...................................................... 85
Restore ............................................................................................................. 94
Prerequisites ............................................................................................... 96
Restoring Oracle using the Data Protector GUI ................................................ 96
Restoring database items in a disaster recovery ........................................ 96
Changing the database state ................................................................. 97
Restoring the recovery catalog database ................................................. 97
Restoring the control file ...................................................................... 100
Restoring Oracle database objects ........................................................ 102
Restoring tablespaces and datafiles ...................................................... 108
Restoring and recovering an Oracle database in Oracle Data Guard
environment ............................................................................................. 109
Restoring and recovering a primary database ........................................ 109
Restoring and recovering a standby database ........................................ 109
Duplicating an Oracle database ................................................................. 110
Restore, recovery, and duplicate options ...................................................... 114
Restore action options ......................................................................... 114
General options ................................................................................. 114
Duplicate options ............................................................................... 115
Restore and recovery options ............................................................... 116
Restoring Oracle using RMAN .................................................................... 118
Preparing the Oracle database for restore ............................................. 118
4
Connection strings used in the examples ................................................ 120
SBT_LIBRARY parameter ...................................................................... 121
Example of full database restore and recovery ....................................... 121
Example of point-in-time restore ............................................................ 122
Example of tablespace restore and recovery .......................................... 124
Example of datafile restore and recovery ............................................... 126
Example of archive log restore ............................................................. 129
Example of database restore using a different device (with the automatic
device selection functionality disabled) .................................................. 130
Restoring using another device ................................................................... 131
Disaster recovery ...................................................................................... 132
Monitoring sessions ......................................................................................... 132
Monitoring current sessions ........................................................................ 132
Viewing previous sessions .......................................................................... 133
Resuming sessions ........................................................................................... 134
Using the Data Protector GUI ...................................................................... 136
Using the Data Protector CLI ....................................................................... 137
Aborting sessions ............................................................................................ 138
Oracle RMAN metadata and Data Protector Media Management Database
synchronization ............................................................................................... 138
Troubleshooting ............................................................................................... 139
Before you begin ...................................................................................... 139
Checks and verifications ............................................................................ 140
Problems .................................................................................................. 147
2 Integrating SAP R/3 and Data Protector ........................... 153
Introduction .................................................................................................... 153
Integration concepts ........................................................................................ 154
Backup flow ............................................................................................. 158
Restore flow ............................................................................................. 160
Data Protector SAP R/3 configuration file ........................................................... 160
Setting, retrieving, listing, and deleting Data Protector SAP R/3 configuration file
parameters using the CLI ............................................................................ 163
Configuring the integration ............................................................................... 166
Prerequisites ............................................................................................. 167
Before you begin ...................................................................................... 167
Cluster-aware clients .................................................................................. 168
Configuring user accounts .......................................................................... 168
Checking the connection ............................................................................ 169
Authentication password file ....................................................................... 170
Enabling archived logging ......................................................................... 170
Linking Oracle Server with the Data Protector MML ....................................... 172
Integration guide for Oracle and SAP 5
Choosing authentication mode ................................................................... 173
Configuring SAP R/3 databases ................................................................. 173
Before you begin ................................................................................ 174
Using the Data Protector GUI ............................................................... 174
Using the Data Protector CLI ................................................................ 177
Checking the configuration ........................................................................ 179
Using the Data Protector GUI ............................................................... 179
Using the Data Protector CLI ................................................................ 180
Backup .......................................................................................................... 181
Considerations ........................................................................................ 183
Creating backup specifications ................................................................... 183
Modifying backup specifications ................................................................. 190
Scheduling backup specifications ................................................................ 190
Scheduling example ........................................................................... 190
Previewing backup sessions ........................................................................ 191
Using the Data Protector GUI ............................................................... 191
Using the Data Protector CLI ................................................................ 191
What happens during the preview? ...................................................... 192
Starting backup sessions ............................................................................ 192
Backup methods ................................................................................. 192
Using the Data Protector GUI ............................................................... 192
Using the Data Protector CLI ................................................................ 193
Using the SAP BRTOOLS ..................................................................... 193
Backing up using Oracle Recovery Manager ................................................ 194
Manual balancing .................................................................................... 195
Restore ........................................................................................................... 196
Considerations ......................................................................................... 196
Restoring using the Data Protector GUI ........................................................ 197
Restoring using the Data Protector CLI .......................................................... 200
Restoring using the SAP commands ............................................................. 201
Restoring using another device ................................................................... 201
Using the Data Protector GUI ............................................................... 201
Using the Data Protector CLI or SAP commands ...................................... 202
Localized SAP R/3 objects ......................................................................... 202
Sparse files .............................................................................................. 203
Disaster recovery ...................................................................................... 203
Restoring the control file ...................................................................... 203
Monitoring sessions ......................................................................................... 204
Troubleshooting ............................................................................................... 204
Before you begin ...................................................................................... 204
General troubleshooting ............................................................................ 205
Troubleshooting on Windows systems .......................................................... 205
Prerequisites concerning the Oracle side of the integration ....................... 205
6
Prerequisites on the SAP side of the integration ....................................... 208
Configuration problems ....................................................................... 209
Backup problems ................................................................................ 212
Restore problems ................................................................................ 214
Troubleshooting on UNIX systems ................................................................ 217
Prerequisites concerning the Oracle side of the integration ....................... 217
Prerequisites on the SAP side of the integration ....................................... 221
Configuration problems ....................................................................... 223
Backup problems ................................................................................ 224
Restore problems ................................................................................ 228
3 Integrating SAP DB/MaxDB and Data Protector ................ 233
Introduction .................................................................................................... 233
Integration concepts ........................................................................................ 234
Backup flow ............................................................................................. 236
Restore flow ............................................................................................. 236
Configuring the integration ............................................................................... 237
Prerequisites ............................................................................................. 237
Limitations ................................................................................................ 237
Before you begin ...................................................................................... 237
Cluster-aware clients .................................................................................. 238
Configuring SAP DB/MaxDB users .............................................................. 238
Configuring SAP DB/MaxDB instances ........................................................ 238
Before you begin ................................................................................ 239
Using the Data Protector GUI ............................................................... 239
Using the Data Protector CLI ................................................................ 241
Handling errors .................................................................................. 243
Checking the configuration ........................................................................ 243
Using the Data Protector GUI ............................................................... 243
Using the Data Protector CLI ................................................................ 243
Backup .......................................................................................................... 244
Creating backup specifications ................................................................... 244
Modifying backup specifications ................................................................. 247
Scheduling backup specifications ................................................................ 247
Scheduling example ........................................................................... 248
Previewing backup sessions ........................................................................ 248
Using the Data Protector GUI ............................................................... 249
Using the Data Protector CLI ................................................................ 249
What happens during the preview? ...................................................... 249
Starting backup sessions ............................................................................ 250
Backup methods ................................................................................. 250
Using the Data Protector GUI ............................................................... 250
Integration guide for Oracle and SAP 7
Using the Data Protector CLI ................................................................ 250
Using SAP DB/MaxDB utilities ............................................................. 251
Restore ........................................................................................................... 255
Restore and recovery overview .................................................................... 255
Before you begin ...................................................................................... 259
Restoring using the Data Protector GUI ........................................................ 259
Restoring using the Data Protector CLI .......................................................... 262
Restoring using SAP DB/MaxDB utilities ....................................................... 263
SAP DB/MaxDB restore and recovery ................................................... 264
SAP DB/MaxDB migration .................................................................. 269
Finding information for restore .................................................................... 269
SAP DB/MaxDB restore options .................................................................. 269
Restoring using another device ................................................................... 274
Monitoring sessions ......................................................................................... 274
Troubleshooting ............................................................................................... 274
Before you begin ...................................................................................... 274
Problems .................................................................................................. 275
SAP DB/MaxDB cluster-related troubleshooting ............................................. 278
Glossary ......................................................................... 279
Index .............................................................................. 337
8
Figures
Data Protector graphical user interface ............................................... 251
Data Protector Oracle integration concept ........................................... 322
Finding the Oracle user .................................................................... 373
Configuring Oracle - General (Windows) ........................................... 424
Configuring Oracle - General (UNIX) ................................................. 425
Configuring Oracle - Primary ............................................................ 436
Configuring Oracle - Catalog ............................................................ 447
Configuring Oracle - Standby ............................................................ 448
Keeping parameters in an XLS file ...................................................... 509
Keeping parameters in a CSV file ...................................................... 5010
Encoding a password ...................................................................... 5111
Setting environmental variables ......................................................... 5612
Specifying an Oracle Server system (UNIX) ......................................... 6213
Selecting backup objects .................................................................. 6414
Oracle specific options ..................................................................... 6615
Saving the backup specification ......................................................... 6716
Previewing a backup ........................................................................ 7617
Scheduling backups ......................................................................... 8218
Starting an interactive backup ........................................................... 8419
Taking the Oracle resource group offline ............................................ 9520
Checking properties ......................................................................... 9521
Recovery catalog settings dialog ....................................................... 9922
Source page ................................................................................. 10323
Options page ............................................................................... 10624
Integration guide for Oracle and SAP 9
Devices page ................................................................................ 10725
Oracle duplicate options ................................................................ 11326
Resuming a session ........................................................................ 13727
Checking the status of the Oracle listener ......................................... 14128
SAP R/3 architecture ..................................................................... 15529
SAP R/3 architecture: backint mode ................................................. 15630
SAP R/3 architecture: RMAN mode ................................................. 15831
Specifying an SAP R/3 system and Oracle instance ........................... 17532
Configuring an SAP R/3 database on a UNIX system (operating system
33
authentication mode) ..................................................................... 176
Configuring an SAP R/3 database on a Windows system (database
34
authentication mode) ..................................................................... 177
Checking the SAP R/3 configuration ................................................ 18035
Selecting backup objects ................................................................ 18636
Application specific options ............................................................ 18737
Scheduling backups ....................................................................... 19138
Selecting objects for restore ............................................................ 19839
10
Selecting the target client ................................................................ 19940
Checking the status of the Oracle listener .......................................... 20741
Checking the Inet start-up parameters ............................................... 21142
SAP DB integration architecture ....................................................... 23543
Specifying an SAP DB/MaxDB instance ........................................... 24044
SAP DB/MaxDB configuration ........................................................ 24145
Selecting SAP DB/MaxDB objects ................................................... 24546
Application specific options ............................................................ 24647
Scheduling the backup specification ................................................. 24848
SAP DB/MaxDB restore process ...................................................... 25849
SAP DB/MaxDB archive logs restore process—redo logs details .......... 25850
Selecting objects for restore ............................................................ 26051
Properties for data ......................................................................... 26152
SAP DB/MaxDB restore and recovery options ................................... 27053
Integration guide for Oracle and SAP 11
Tables
Edition history ................................................................................. 131
Document conventions ...................................................................... 232
Oracle database user accounts ......................................................... 393
Oracle database configuration parameters ......................................... 484
Environmental variables .................................................................... 555
Oracle backup options ..................................................................... 686
MML filenames on different platforms ................................................. 887
Required database states .................................................................. 978
Backup types ................................................................................ 1539
SAP backup and restore utilities ....................................................... 15410
Backup types ................................................................................ 18111
What is backed up ........................................................................ 18112
Two alternatives of specifying backup options .................................... 18213
Backup templates .......................................................................... 18414
12
SAP R/3 backup options ................................................................ 18815
Backup types ................................................................................ 23316
What is backed up ........................................................................ 24417
SAP DB/MaxDB backup options ..................................................... 24718
Publication history
Guide updates may be issued between editions to correct errors or document product
changes. To ensure that you receive updated or new editions, subscribe to the
appropriate product support service. See your HP sales representative for details.
Table 1 Edition history
ProductGuide editionPart number
Data Protector Release A.05.50October 2004B6960-90109
Data Protector Release A.06.00July 2006B6960-96008
Data Protector Release A.06.10November 2008B6960-96042
Data Protector Release A.06.11September 2009B6960-90158
Integration guide for Oracle and SAP 13
Publication history14
About this guide
This guide describes how to configure and use Data Protector with Oracle, SAP R/3,
and SAP DB/MaxDB.
Intended audience
This guide is intended for backup administrators responsible for planning, setting up,
and maintaining network backups. It assumes you are familiar with:
• Basic Data Protector functionality
• Database administration
Conceptual information can be found in the HP Data Protector concepts guide, which
is recommended to fully understand the fundamentals and the model of Data Protector.
Documentation set
Other documents and online Help provide related information.
Guides
Data Protector guides are available in printed format and in PDF format. Install the
PDF files during the Data Protector setup procedure by selecting the English
Documentation & Help component on Windows or the OB2-DOCS component
on UNIX. Once installed, the guides reside in the Data_Protector_home\docs
directory on Windows and in the /opt/omni/doc/C directory on UNIX.
You can find these documents from the Manuals page of the HP Business Support
Center website:
http://www.hp.com/support/manuals
In the Storage section, click Storage Software and then select your product.
• HP Data Protector concepts guide
Integration guide for Oracle and SAP 15
This guide describes Data Protector concepts and provides background information
on how Data Protector works. It is intended to be used with the task-oriented
online Help.
• HP Data Protector installation and licensing guide
This guide describes how to install the Data Protector software, taking into account
the operating system and architecture of your environment. This guide also gives
details on how to upgrade Data Protector, as well as how to obtain the proper
licenses for your environment.
• HP Data Protector troubleshooting guide
This guide describes how to troubleshoot problems you may encounter when
using Data Protector.
• HP Data Protector disaster recovery guide
This guide describes how to plan, prepare for, test and perform a disaster
recovery.
• HP Data Protector integration guides
These guides describe how to configure and use Data Protector to back up and
restore various databases and applications. They are intended for backup
administrators or operators. There are four guides:
• HP Data Protector integration guide for Microsoft applications: SQL Server,
SharePoint Portal Server, Exchange Server, and Volume Shadow Copy Service
This guide describes the integrations of Data Protector with the following
Microsoft applications: Microsoft Exchange Server, Microsoft SQL Server, and
Volume Shadow Copy Service.
• HP Data Protector integration guide for Oracle and SAP
This guide describes the integrations of Data Protector with Oracle, SAP R/3,
and SAP DB/MaxDB.
• HP Data Protector integration guide for IBM applications: Informix, DB2, and
Lotus Notes/Domino
This guide describes the integrations of Data Protector with the following IBM
applications: Informix Server, IBM DB2, and Lotus Notes/Domino Server.
• HP Data Protector integration guide for VMware Virtual Infrastructure, Sybase,
Network Node Manager, and Network Data Management Protocol Server
This guide describes the integrations of Data Protector with VMware Virtual
Infrastructure, Sybase, Network Node Manager, Network Data Management
Protocol Server, and Citrix XenServer.
• HP Data Protector integration guide for HP Service Information Portal
About this guide16
This guide describes how to install, configure, and use the integration of Data
Protector with HP Service Information Portal. It is intended for backup
administrators. It discusses how to use the application for Data Protector service
management.
• HP Data Protector integration guide for HP Reporter
This manual describes how to install, configure, and use the integration of Data
Protector with HP Reporter. It is intended for backup administrators. It discusses
how to use the application for Data Protector service management.
• HP Data Protector integration guide for HP Operations Manager for UNIX
This guide describes how to monitor and manage the health and performance of
the Data Protector environment with HP Operations Manager and HP Service
Navigator on UNIX.
• HP Data Protector integration guide for HP Operations Manager for Windows
This guide describes how to monitor and manage the health and performance of
the Data Protector environment with HP Operations Manager and HP Service
Navigator on Windows.
• HP Data Protector integration guide for HP Performance Manager and HP
Performance Agent
This guide provides information about how to monitor and manage the health
and performance of the Data Protector environment with HP Performance Manager
(PM) and HP Performance Agent (PA) on Windows, HP-UX, Solaris, and Linux.
• HP Data Protector zero downtime backup concepts guide
This guide describes Data Protector zero downtime backup and instant recovery
concepts and provides background information on how Data Protector works in
a zero downtime backup environment. It is intended to be used with the
task-oriented HP Data Protector zero downtime backup administrator's guide and
the HP Data Protector zero downtime backup integration guide.
• HP Data Protector zero downtime backup administrator's guide
This guide describes how to configure and use the integration of Data Protector
with HP StorageWorks Virtual Array, HP StorageWorks Enterprise Virtual Array,
EMC Symmetrix Remote Data Facility and TimeFinder, and HP StorageWorks
Disk Array XP. It is intended for backup administrators or operators. It covers the
zero downtime backup, instant recovery, and the restore of filesystems and disk
images.
• HP Data Protector zero downtime backup integration guide
This guide describes how to configure and use Data Protector to perform zero
downtime backup, instant recovery, and standard restore of Oracle, SAP R/3,
Microsoft Exchange Server, and Microsoft SQL Server databases. The guide also
Integration guide for Oracle and SAP 17
describes how to configure and use Data Protector to perform backup and restore
using the Microsoft Volume Shadow Copy Service.
• HP Data Protector MPE/iX system user guide
This guide describes how to configure MPE/iX clients and how to back up and
restore MPE/iX data.
• HP Data Protector Media Operations user guide
This guide provides tracking and management of offline storage media. It describes
the tasks of installing and configuring the application, performing daily media
operations and producing reports.
• HP Data Protector product announcements, software notes, and references
This guide gives a description of new features of HP Data Protector A.06.11. It
also provides information on installation requirements, required patches, and
limitations, as well as known issues and workarounds.
• HP Data Protector product announcements, software notes, and references for
integrations to HP Operations Manager, HP Reporter, HP Performance Manager,
HP Performance Agent, and HP Service Information Portal
This guide fulfills a similar function for the listed integrations.
• HP Data Protector Media Operations product announcements, software notes,
and references
This guide fulfills a similar function for Media Operations.
• HP Data Protector command line interface reference
This guide describes the Data Protector command-line interface, command options
and their usage as well as provides some basic command-line examples.
Online Help
Data Protector provides context-sensitive (F1) Help and Help Topics for Windows
and UNIX platforms.
You can access the online Help from the top-level directory on the installation
DVD-ROM without installing Data Protector:
•
Windows:
•
UNIX:
system through DP_help.htm.
Unzip DP_help.zip and open DP_help.chm.
Unpack the zipped tar file DP_help.tar.gz, and access the online Help
About this guide18
Documentation map
Abbreviations
Abbreviations in the documentation map that follows are explained below. The guide
titles are all preceded by the words “HP Data Protector”.
GuideAbbreviation
Command line interface referenceCLI
Concepts guideConcepts
Disaster recovery guideDR
Getting started guideGS
Online HelpHelp
IG-IBM
IG-MS
IG-PM/PA
IG-Var
Integration guide for IBM applications: Informix, DB2, and Lotus
Notes/Domino
Integration guide for Microsoft applications: SQL Server, SharePoint
Portal Server, Exchange Server, and Volume Shadow Copy Service
Integration guide for Oracle and SAPIG-O/S
Integration guide for HP Operations Manager for UNIXIG-OMU
Integration guide for HP Operations Manager for WindowsIG-OMW
Integration guide for HP Performance Manager and HP Performance
Agent
Integration guide for HP ReporterIG-Report
Integration guide for HP Service Information PortalIG-SIP
Integration guide for VMware Virtual Infrastructure, Sybase, Network
Node Manager, Network Data Management Protocol Server, and
Citrix XenServer.
Integration guide for Oracle and SAP 19
GuideAbbreviation
Installation and licensing guideInstall
Media Operations getting started guideMO GS
Map
MO RN
Media Operations product announcements, software notes, and
references
Media Operations user guideMO UG
MPE/iX system user guideMPE/iX
Product announcements, software notes, and referencesPA
Troubleshooting guideTrouble
ZDB administrator's guideZDB Admin
ZDB concepts guideZDB Concept
ZDB integration guideZDB IG
The following table shows where to find information of different kinds. Shaded squares
are a good place to look first.
About this guide20
Integrations
Look in these guides for details of the following integrations:
GuideIntegration
IG-OMU, IG-OMWHP Operations Manager for UNIX/for Windows
IG-PM/PAHP Performance Manager
IG-PM/PAHP Performance Agent
Integration guide for Oracle and SAP 21
GuideIntegration
IG-RHP Reporter
IG-SIPHP Service Information Portal
all ZDBHP StorageWorks Disk Array XP
all ZDBHP StorageWorks Enterprise Virtual Array (EVA)
all ZDBHP StorageWorks Virtual Array (VA)
IG-IBMIBM DB2 UDB
IG-IBMInformix
IG-IBMLotus Notes/Domino
MO UserMedia Operations
MPE/iXMPE/iX system
IG-MS, ZDB IGMicrosoft Exchange Server
IG-MSMicrosoft Exchange Single Mailbox
IG-MS, ZDB IGMicrosoft SQL Server
IG-MS, ZDB IGMicrosoft Volume Shadow Copy Service (VSS)
IG-VarNDMP Server
IG-VarNetwork Node Manager (NNM)
IG-O/SOracle
ZDB IGOracle ZDB
IG-O/SSAP DB
IG-O/S, ZDB IGSAP R/3
About this guide22
Document conventions and symbols
Table 2 Document conventions
ElementConvention
Cross-reference links and e-mail addressesBlue text: Table 2 on page 23
Website addressesBlue, underlined text: http://www.hp.com
Text emphasisItalic text
• File and directory names
• System output
Monospace text
• Code
• Commands, their arguments, and
argument values
GuideIntegration
IG-VarSybase
all ZDBEMC Symmetrix
IG-VarVMware
Monospace, italic text
Monospace, bold text
• Code variables
• Command variables
Emphasized monospace text
CAUTION:
Indicates that failure to follow directions could result in damage to equipment or data.
IMPORTANT:
Provides clarifying information or specific instructions.
Integration guide for Oracle and SAP 23
NOTE:
Provides additional information.
TIP:
Provides helpful hints and shortcuts.
Data Protector graphical user interface
Data Protector provides a cross-platform (Windows and UNIX) graphical user
interface. You can use the original Data Protector GUI (Windows only) or the Data
Protector Java GUI. For information about the Data Protector graphical user interface,
see the online Help.
About this guide24
Figure 1 Data Protector graphical user interface
General information
General information about Data Protector can be found at http://www.hp.com/go/
dataprotector.
HP technical support
For worldwide technical support information, see the HP support website:
http://www.hp.com/support
Before contacting HP, collect the following information:
• Product model names and numbers
• Technical support registration number (if applicable)
• Product serial numbers
• Error messages
• Operating system type and revision level
• Detailed questions
Integration guide for Oracle and SAP 25
Subscription service
HP recommends that you register your product at the Subscriber's Choice for Business
website:
http://www.hp.com/go/e-updates
After registering, you will receive e-mail notification of product enhancements, new
driver versions, firmware updates, and other product resources.
HP websites
For additional information, see the following HP websites:
• http://www.hp.com
• http://www.hp.com/go/software
• http://www.hp.com/support/manuals
• http://h20230.www2.hp.com/selfsolve/manuals
• http://www.hp.com/support/downloads
Documentation feedback
HP welcomes your feedback.
To make comments and suggestions about product documentation, please send a
message to DP.DocFeedback@hp.com. All submissions become the property of HP.
About this guide26
1 Integrating Oracle and Data Protector
Introduction
Data Protector offers offline as well as online backup of the Oracle Server instances.
To enable database recovery from an online backup, the respective Oracle Server
instance must operate in the ARCHIVELOG mode.
The online backup concept is widely accepted. It addresses the business requirements
for high application availability, as opposed to the offline concept. During an online
backup, a database remains available for use, while during an offline backup, the
database cannot be used by an application.
Backup types
Using the Data Protector Oracle integration, you can perform the following types of
backups:
• Online backup of a whole database or parts of it
• Online incremental backup (Oracle differential incremental backup 1 to 4)
• Offline backup of a whole database
• Backup of Archived Redo Logs only
• Backup of the Oracle database recovery catalog
• Backup of the Oracle control files
• With Oracle 10g/11g, backup of recovery files residing in the flash recovery
area.
The following recovery files in the flash recovery area are backed up:
• full and incremental backup sets
• control file autobackup (SPFILE included if used)
• archived redo logs
• datafile copies, control file copies
Integration guide for Oracle and SAP 27
Flashback logs, the current control file, and online redo logs are not backed up.
• In Oracle Data Guard environment, backup of standby database.
Restore types
Using the Data Protector Oracle integration, you can restore the following:
• The whole database or parts of it
• The database to a specific point in time
• From incremental backup
• To a host other than the one where the database originally resided
• A datafile to a location other than its original one
• A catalog before restoring the database
• From a chain of incremental backups
Duplicating a database
Using the Data Protector Oracle integration, you can perform duplication of a
production database.
Integration concepts
The Data Protector Oracle integration links the Oracle database management software
with Data Protector. From the Oracle point of view, Data Protector represents a media
management software. On the other hand, the Oracle database management system
can be seen as a data source for backup, using media controlled by Data Protector.
Components
The software components involved in backup and restore processes are:
• The Oracle Recovery Manager (RMAN)
• The Data Protector Oracle integration software
Integration functionality overview
The Data Protector Oracle Integration agent (ob2rman.pl) works with RMAN to
manage all aspects of the following operations on the Oracle target database:
• Backups (backup and copy)
• Recovery (restore, recovery, and duplication)
Integrating Oracle and Data Protector28
How does the integration work?
Ob2rman.pl executes RMAN, which directs the Oracle server processes on the
target database to perform backup, restore and recovery. RMAN maintains the
required information about the target databases in the recovery catalog, the Oracle
central repository of information, and in the control file of a particular target database.
The main information which ob2rman.pl provides to RMAN is:
• Number of allocated RMAN channels
• RMAN channel environment parameters
• Information on the database objects to be backed up or restored
For backup, ob2rman.pl uses the Oracle target database views to get information
on which logical (tablespaces) and physical (datafiles) target database objects are
available for backup.
For restore, ob2rman.pl uses current control file or recovery catalog (if used) to get
information on which objects are available for restore.
Using the Data Protector integration with RMAN, you can back up and restore the
Oracle control files, datafiles, and Archived Redo Logs.
The interface from the Oracle server processes to Data Protector is provided by the
Data Protector Oracle integration Media Management Library (MML), which is a set
of routines that allows the reading and writing of data to General Media Agents.
Besides handling direct interaction with the media devices, Data Protector provides
scheduling, media management, network backups, monitoring, and interactive
backup.
Oracle backup types handled by the integration
Using this integration, you can perform the Oracle full and incremental (up to
incremental level 4) backup types.
With Oracle full and incremental level 0 backups all data blocks per datafile are
backed up. With Oracle incremental backup (level 1 or higher), only the data blocks
that have changed since a previous backup are backed up.
The difference between a full backup and an incremental level 0 backup is that the
incremental 0 is a base for subsequent incremental backups. Therefore, Data Protector
always performs Oracle incremental 0 when you select the full backup type in a
backup specification.
The full backup type is not related to the number of datafiles included in the backup,
and can therefore be performed per single datafile. The data being backed up,
Integration guide for Oracle and SAP 29
regardless of the backup type (full or incremental), is selected and controlled by
Oracle.
Oracle incremental backups can be differential or cumulative. By default, Data
Protector performs Oracle differential incremental backups. By changing the default
RMAN script created by Data Protector, you can specify also a cumulative backup.
For information on differential and cumulative Oracle backups, see the Oracle
Recovery Manager User’s Guide.
NOTE:
Regardless of the Oracle backup type specified, Data Protector always marks the Oracle
backups as full in the Data Protector database, since the Data Protector incremental
backup concept is different from the Oracle incremental backup concept.
A backup that includes all datafiles and current control file that belong to an Oracle
Server instance is known as a whole database backup.
These features can be used for online or offline backup of the Oracle target database.
However, you must ensure that the backup objects (such as tablespaces) are switched
into the appropriate state before and after a backup session. For online backup, the
database instance must operate in the ARCHIVELOG mode; whereas for offline
backup, objects need to be prepared for backup using the Pre-exec and
Post-exec options in the backup specification.
Backup flow
The Data Protector backup specification contains information about backup options,
commands for RMAN, Pre- and Post-exec commands, media, and devices.
The Data Protector backup specification allows you to configure a backup and then
use the same specification several times. Furthermore, scheduled backups can only
be performed using a backup specification.
Backup and restore of an Oracle target database can be performed using the Data
Protector User Interface, the RMAN utility, or the Oracle Enterprise Manager utility.
The heart of the Data Protector Oracle integration is MML, which enables an Oracle
server process to issue commands to Data Protector for backing up or restoring parts
or all of the Oracle target database files. The main purpose is to control direct
interaction with media and devices.
A Data Protector scheduled or interactive backup is triggered by the Data Protector
Backup Session Manager, which reads the backup specification and starts the
ob2rman.pl command on the Oracle Server under the operating system user account
Integrating Oracle and Data Protector30
Loading...