HP Data Protector A.06.11 Kurzanleitung zur Einrichtung

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

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

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

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

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

authentication mode) ..................................................................... 176

Configuring an SAP R/3 database on a Windows system (database

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

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

Andere Handbücher für Data Protector A.06.11

Inhaltsverzeichnis

Andere HP Software Handbücher

HP INSIGHT DYNAMICS T8671-91017 Bedienungsanleitung

HP 3000 - 37XE System Bedienungsanleitung

HP Surestore Disk Array 12h - And FC60 Referenzhandbuch

HP NonStop SSH 544701-014 Bedienungsanleitung

HP PROCURVE 2520 Bedienungsanleitung

HP NC320m - PCI Express Gigabit Server Adapter Bedienungsanleitung

HP ProBook 4325s - Notebook PC Bedienungsanleitung

HP VL400 - Vectra - 64 MB RAM Bedienungsanleitung

HP 4X - DDR InfiniBand Mezzanine HCA Leitfaden

HP Rp7410 - Server - 0 MB RAM Service-Handbuch

HP mfp digital sending software v. 4 Bedienungsanleitung

HP T5700 - compaq thin client Bedienungsanleitung

HP Presario SG1100 - Desktop PC Bedienungsanleitung

HP Xw460c - ProLiant - Blade Workstation Bedienungsanleitung

HP BladeSystem Dual NC370i - Multifunction Network... Bedienungsanleitung

HP ProCurve 3500yl Series Anleitung zur Verwendung

HP Data Protector A.06.11 Kurzanleitung zur Einrichtung

HP T5725 - Compaq Thin Client Bedienungsanleitung

HP D6030A - NetServer - E50 Bedienungsanleitung

HP ProLiant SL170s - G6 Server Bedienungsanleitung

HP AJ878A - StorageWorks 320 GB Hard Drive Bedienungsanleitung

HP Vectra VL800 Bedienungsanleitung

HP e-Diagtools 3.02 Handbuch

HP Neoview SQL Bedienungsanleitung

Beliebte Software Handbücher anderer Marken

COMPRO

COMPRO COMPROFM Bedienungsanleitung

Muratec

Muratec OFFICEBRIDGE ONLINE Bedienungsanleitung

Oracle

Oracle Contact Center Anywhere 8.1 Bedienungsanleitung

Adobe

Adobe 65007312 - Photoshop Lightroom Handbuch

Avaya

Avaya NULL One-X for RIM Blackberry Bedienungsanleitung

PS Audio

PS Audio PowerPlay Betriebsanleitung

Brady

Brady LOCKOUT PRO 3.0 Service-Handbuch

Avaya

Avaya Interaction Center Bedienungsanleitung

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Handbuch

Novell

Novell GROUPWISE 8 - INTERNET AGENT Bedienungsanleitung

Oracle

Oracle Application 9i Bedienungsanleitung

Acer

Acer RDM Bedienungsanleitung

Canon

Canon Vixia HF21 Bedienungsanleitung

Canon

Canon ZR950 Bedienungsanleitung

Samsung

Samsung Auto Backup Bedienungsanleitung

Polycom

Polycom Vortex EF2201 Montage- und Bedienungsanleitung

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c Bedienungsanleitung

Novell

Novell SP2 - S Bedienungsanleitung