HP B6960-96008 User Manual

HP OpenView Storage Data Protector

Integration Guide

for

Oracle

SAP

Manual Edition: July 2006

Manufacturing Part Number: B6960-9

Release A.06.00

6008

Legal Notices

to this material, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Hewlett-Packard shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of this material.

This document contains proprietary information, which is protected by copyright. No part of this document may be photocopied, reproduced, or translated into another language without the prior written consent of Hewlett-Packard. The information contained in this document is subject to change without notice.

Microsoft® and MS Windows®, Windows® and Windows NT® are U.S. registered trademarks of Microsoft Corporation.

Oracle® is a registered U.S. trademark of Oracle Corporation, Redwood City, California.

UNIX® is a registered trademark of The Open Group Hewlett-Packard Company shall not be liable for technical or editorial

errors or omissions contained herein. The information is provided “as is” without warranty of any kind and is subject to change without notice. The warranties for Hewlett-Packard Company products are set forth in the express limited warranty statements for such products. Nothing herein should be construed as constituting an additional warranty.

Contents

1. Integrating Oracle and Data Protector

In This Chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Integration Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Configuring the Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Cluster-Aware Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Linking Oracle with the Data Protector Oracle Integration Media Management

Library (MML) on UNIX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Linking Oracle with MML on OpenVMS Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Configuring Oracle Users on UNIX and OpenVMS . . . . . . . . . . . . . . . . . . . . . . . . . . 21

Configuring Oracle Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

Checking the Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

Configuring an Oracle Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Creating a New Template . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Creating a Data Protector Oracle Backup Specification . . . . . . . . . . . . . . . . . . . . . . 37

Editing the Oracle RMAN Script. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47

Creating Copies of Backed Up Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51

Testing the Integration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52

Backing Up an Oracle Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55

Scheduling a Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58

Running an Interactive Backup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

Starting Oracle Backup Using RMAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62

Restoring an Oracle Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70

Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72

Restoring Oracle Using the Data Protector GUI . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72

Restoring and Recovering an Oracle Database in Oracle Data Guard Environment 84

Duplicating an Oracle Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85

Restore, Recovery, and Duplicate Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88

Restoring Oracle Using RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93

Restoring Oracle Using CLI. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

Restoring Using Another Device . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108

Disaster Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109

Monitoring an Oracle Backup and Restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110

Monitoring Current Sessions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110

Viewing Previous Sessions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111

iii

Contents

Using Oracle After Removing the Data Protector Oracle Integration on UNIX and

OpenVMS Systems. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112

Removing the Data Protector Oracle Integration Link on HP-UX Systems. . . . . . 112

Removing the Data Protector Oracle Integration Link on Solaris and other UNIX

Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113

Removing the Data Protector Oracle Integration Link on OpenVMS Systems . . . 113

Oracle RMAN Metadata and Data Protector Media Management

Database Synchronization. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114

Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116

Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116

Using Oracle After Removing the Data Protector

Oracle Integration on UNIX Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116

General Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117

Checking Prerequisites Related to the Oracle Side

of the Integration on UNIX Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117

Checking Prerequisites Related to the Oracle Side

of the Integration on Windows Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

Configuration Problems on UNIX Systems. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125

Configuration Problems on Windows Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127

Backup Problems on UNIX Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129

Backup Problems on Windows. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133

Restore Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135

2. Integrating SAP R/3 and Data Protector

In This Chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145

Prerequisites and Limitations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147

Integration Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

Data Protector SAP R/3 Configuration File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158

Setting, Retrieving, Listing, and Deleting Data Protector SAP R/3 Configuration

File Parameters Using the CLI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161

Configuring the Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165

Configuring an SAP R/3 User in Data Protector (UNIX Systems Only) . . . . . . . . . 165

Configuring an SAP R/3 Database Server. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167

Configuring an SAP R/3 Backup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179

Creating a New Template . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179

Creating a Data Protector SAP R/3 Backup Specification . . . . . . . . . . . . . . . . . . . . 180

SAP R/3 Specific Backup Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186

Creating or Modifying the Parameter File on the SAP R/3 Database Server . . . . . 190

Contents

Backing Up Using Recovery Manager. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191

Manual Balancing of Files into Subsets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193

Creating an SAP /R3 Backup Specification for Manual Balancing . . . . . . . . . . . . . 194

Testing the Integration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195

Backing Up an SAP R/3 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197

Scheduling a Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198

Running an Interactive Backup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200

Using SAP R/3 Commands. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202

Restoring an SAP R/3 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204

Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204

Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 205

Finding Information Needed for Restore. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 205

Restoring Using the Data Protector GUI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 205

Restoring Using the Data Protector CLI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207

Restoring Using the SAP R/3 Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208

Using Another Device. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209

Disaster Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209

Monitoring an SAP R/3 Backup and Restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212

Monitoring Current Sessions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212

Viewing Previous Sessions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 213

Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214

Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214

General Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214

Troubleshooting on Windows Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215

Troubleshooting on UNIX Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225

Examples of SAP R/3 Database Restore. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239

Preparing the SAP R/3 Database for Restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239

Example of Full Database Restore and Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . 241

Example of Partial Restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245

Example of Lost Files Restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245

Example of Archive Log Files Restore. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247

3. Integrating SAP DB/MaxDB and Data Protector

In This Chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250

Prerequisites and Limitations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 252

Integration Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256

Data Protector SAP DB/MaxDB Configuration File . . . . . . . . . . . . . . . . . . . . . . . . . . 259

Contents

Setting, Retrieving, and Listing Data Protector SAP DB/MaxDB Configuration File

Parameters Using the CLI. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260

Configuring the Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263

Configuring Users. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263

Configuring an SAP DB/MaxDB Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264

SAP DB/MaxDB Specific Backup Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 270

Modifying the Configuration of an SAP DB/MaxDB Instance in Data Protector . . 272

Checking the Configuration of an SAP DB/MaxDB Instance . . . . . . . . . . . . . . . . . 276

Testing the Integration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 278

Backing Up an SAP DB/MaxDB Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281

Scheduling an Existing Backup Specification. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281

Running an Interactive Backup Using the Data Protector GUI . . . . . . . . . . . . . . . 284

Running an Interactive Backup Using the Data Protector CLI. . . . . . . . . . . . . . . . 285

Running an Interactive Backup Using SAP DB/MaxDB Utilities . . . . . . . . . . . . . . 286

Restoring an SAP DB/MaxDB Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290

Restore and Recovery Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290

SAP DB/MaxDB Migration Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294

Restoring Using the Data Protector GUI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 295

Restoring Using the Data Protector CLI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 297

Restoring Using SAP DB/MaxDB Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299

SAP DB/MaxDB Restore and Recovery Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . 304

Using Another Device. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 308

Disaster Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309

Monitoring an SAP DB/MaxDB Backup and Restore . . . . . . . . . . . . . . . . . . . . . . . . . 310

Monitoring Current Sessions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 310

Viewing Previous Sessions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311

Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313

Before You Begin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313

Problems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313

SAP DB/MaxDB Cluster-Related Troubleshooting. . . . . . . . . . . . . . . . . . . . . . . . . . 316

Glossary

Index

Printing History

Manual 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

Part Number Manual Edition Product

B6960-90109 October 2004 Data Protector Release

A.05.50

B6960-9

6008 July 2006 Data Protector Release

A.06.00

vii

viii

Table 2

Conventions

The following typographical conventions are used in this manual.

Convention Meaning Example

Italic Book or manual

titles, and manual page names

Provides emphasis You must follow these steps.

Specifies a variable that you must supply when entering a command

Bold New terms The Data Protector Cell

Computer Text and items on the

computer screen

Command names Use the grep command ...

File and directory names

Process names Check to see if Data

Refer to the HP OpenView

Storage Data Protector Integration Guide for more

information.

At the prompt type: rlogin your_name where you supply your login name.

Manager is the main ...

The system replies: Press

Enter

/usr/bin/X11

Protector Inet is

running.

Window/dialog box names

Text that you must enter

Keycap Keyboard keys Press Return.

In the Backup Options dialog box...

At the prompt, type: ls -l

Data Protector provides a cross-platform (Windows and UNIX) graphical user interface. Refer to the online Help for information about the Data Protector graphical user interface.

Figure 1 Data Protector Graphical User Interface

Contact Information

General Information

Technical Support Technical support information can be found at the HP Electronic

Documentation Feedback

Training Information

General information about Data Protector can be found at http://www.hp.com/go/dataprotector

Support Centers at http://www.itrc.hp.com Information about the latest Data Protector patches can be found at http://www.itrc.hp.com HP does not support third-party hardware and software. Contact the

respective vendor for support.

Your comments on the documentation help us to understand and meet your needs. You can provide feedback at

storagedocs.feedback@hp.com

For information on currently available HP OpenView training, see the HP OpenView World Wide Web site at

http://www.openview.hp.com/training/ Follow the links to obtain information about scheduled classes, training

at customer sites, and class registration.

xii

Data Protector Documentation

Data Protector documentation comes in the form of manuals and online Help.

Manuals Data Protector manuals are available in printed format and in PDF

format. Install the PDF files during the Data Protector setup procedure by selecting the User Interface component on Windows or the OB2-DOCS component on UNIX. Once installed, the manuals reside in the

<Data_Protector_home>\docs directory on Windows and in the /opt/omni/doc/C/ directory on UNIX. You can also find the manuals in

PDF format at http://www.hp.com/support/manuals

HP OpenView Storage Data Protector Concepts Guide

This manual 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 OpenView Storage Data Protector Installation and Licensing Guide

This manual describes how to install the Data Protector software, taking into account the operating system and architecture of your environment. This manual also gives details on how to upgrade Data Protector, as well as how to obtain the proper licenses for your environment.

HP OpenView Storage Data Protector Troubleshooting Guide

This manual describes how to troubleshoot problems you may encounter when using Data Protector.

HP OpenView Storage Data Protector Disaster Recovery Guide

This manual describes how to plan, prepare for, test and perform a disaster recovery.

xiii

HP OpenView Storage Data Protector Integration Guide

This manual describes how to configure and use Data Protector to back up and restore various databases and applications. It is intended for backup administrators or operators. There are four versions of this manual:

• HP OpenView Storage Data Protector Integration Guide for Microsoft

Applications: SQL Server, Exchange Server, and Volume Shadow Copy Service

This manual describes the integrations of Data Protector with the following Microsoft applications: Microsoft Exchange Server 2000/2003, Microsoft SQL Server 7/2000/2005, and Volume Shadow Copy Service.

• HP OpenView Storage Data Protector Integration Guide for Oracle

and SAP

This manual describes the integrations of Data Protector with Oracle, SAP R3, and SAP DB.

• HP OpenView Storage Data Protector Integration Guide for IBM

Applications: Informix, DB2, and Lotus Notes/Domino

This manual describes the integrations of Data Protector with the following IBM applications: Informix Server, IBM DB2, and Lotus Notes/Domino Server.

• HP OpenView Storage Data Protector Integration Guide for Sybase,

Network Node Manager, and Network Data Management Protocol

This manual describes the integrations of Data Protector with Sybase, Network Node Manager, Network Data Management Protocol, and VMware.

HP OpenView Storage Data Protector Integration Guide for HP OpenView

This manual describes how to install, configure, and use the integration of Data Protector with HP OpenView Service Information Portal, and HP OpenView Reporter. It is intended for backup administrators. It discusses how to use the OpenView applications for Data Protector service management.

xiv

HP OpenView Storage Data Protector Integration Guide for HP OpenView Operations for UNIX

This manual describes how to monitor and manage the health and performance of the Data Protector environment with HP OpenView Operations (OVO), HP OpenView Service Navigator, and HP OpenView Performance (OVP) on UNIX.

HP OpenView Storage Data Protector Integration Guide for HP OpenView Operations for Windows

There are two versions of the manual:

• for OVO 7.1x, 7.2x

• for OVO 7.5

HP OpenView Storage Data Protector Zero Downtime Backup Concepts Guide

This manual 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 OpenView Storage Data Protector

Zero Downtime Backup Administrator’s Guide and the HP OpenView Storage Data Protector Zero Downtime Backup Integration Guide.

HP OpenView Storage Data Protector Zero Downtime Backup Administrator’s Guide

This manual 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 OpenView Storage Data Protector Zero Downtime Backup Integration Guide

This manual 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 2000/2003, and Microsoft

SQL Server 2000 databases. The manual also describes how to configure and use Data Protector to perform backup and restore using the Microsoft Volume Shadow Copy Service.

HP OpenView Storage Data Protector MPE/iX System User Guide

This manual describes how to configure MPE/iX clients and how to back up and restore MPE/iX data.

HP OpenView Storage Data Protector Media Operations User's Guide

This manual provides tracking and management of offline storage media. It is intended for network administrators responsible for maintaining and backing up systems. It describes the tasks of installing and configuring the application, performing daily media operations and producing reports.

HP OpenView Storage Data Protector Product Announcements, Software Notes, and References

This manual gives a description of new features of HP OpenView Storage Data Protector A.06.00. It also provides information on supported configurations (devices, platforms and online database integrations, SAN, and ZDB), required patches, and limitations, as well as known problems and workarounds. An updated version of the supported configurations is available at http://www.hp.com/support/manuals

There are also four other Product Announcements, Software Notes and References, which serve a similar purpose for the following:

• OVO UNIX integration

• OVO 7.1x/7.2x Windows integration

• OVO 7.5 Windows integration

• Media Operations

Online Help Data Protector provides context-sensitive (F1) Help and Help Topics for

Windows and UNIX platforms.

xvi

Documentation Map

Abbreviations

Abbreviations in the documentation map that follows are explained below. The manual titles are all preceded by the words “HP OpenView

Storage Data Protector”

Abbreviation Manual

CLI Command Line Interface Reference Guide Concepts Concepts Guide DR Disaster Recovery Guide GS Getting Started Guide Help Online Help IG-IBM Integration Guide—IBM Applications IG-MS Integration Guide—Microsoft Applications IG-O/S Integration Guide—Oracle, SAP R/3, and

SAP DB/MaxDB

IG-OV Integration Guide—HP OpenView Service Information

Portal/OpenView Reporter IG-OVOU Integration Guide—HP OpenView Operations, UNIX IG-OVOW Integration Guide—HP OpenView Operations 7.1x,

7.2x, Windows

IG-OVOW Integration Guide—HP OpenView Operations 7.5,

Windows IG-Var Integration Guide—Sybase, Network Node Manager,

NDMP and VMware Install Installation and Licensing Guide MO GS Media Operations Getting Started Guide MO RN Media Operations Product Announcements, Software

Notes, and References MO UG Media Operations User Guide MPE/iX MPE/iX System User Guide

xvii

Abbreviation Manual

PA Product Announcements, Software Notes, and

References Trouble Troubleshooting Guide ZDB Admin ZDB Administrator's Guide ZDB Concpt ZDB Concepts Guide ZDB IG ZDB Integration Guide

Map

The following table shows where to find information of different kinds. Shaded squares are a good place to look first.

Integration Guides

HelpGSConcepts

Backup XXX XXXX XXX X CLI Concepts/Techniques X Disaster Recovery X X Installation/Upgrade X X Instant Recovery X X X Licensing X Limitations X XXXXXXXXX New features X Planning strategy X Procedures/Tasks Recommendations X X X X Requirements X XXXXX X XXX Restore XXX XXXX XX X Support matrices X Supported configurations X Troubleshooting X X

X XXX XXXXXXX XX X

Install

Trouble

O/S

IBM

Var

X XXXXXXXXXX X

XX XXX XXX

XX X

XXX

X XXXXX XX

ZDB MO

OVOU

OVOW

Concpt

AdminIGGS

MPE/iX

User

CLI

xviii

Integrations

Look in these manuals for details of the following integrations:

Integration Guide

HP OpenView Operations (OVO) IG-OVOU, IG-OVOW HP OpenView Reporter (OVR) IG-OV HP OpenView Reporter Light IG-OVOW HP OpenView Service Information Portal

(OVSIP) HP StorageWorks Disk Array XP all ZDB HP StorageWorks Enterprise Virtual Array

(EVA) HP StorageWorks Virtual Array (VA) all ZDB IBM DB2 UDB IG-IBM Informix IG-IBM Lotus Notes/Domino IG-IBM Media Operations MO User MPE/iX System MPE/iX Microsoft Exchange Servers IG-MS, ZDB IG Microsoft Exchange Single Mailbox IG-MS Microsoft SQL Servers IG-MS, ZDB IG Microsoft Volume Shadow Copy Service (VSS) IG-MS, ZDB IG NDMP Server IG-Var Network Node Manager (NNM) IG-Var Oracle IG-O/S

IG-OV

all ZDB

Oracle ZDB ZDB IG SAP DB IG-O/S SAP R/3 IG-O/S, ZDB IG Sybase IG-Var Symmetrix (EMC) all ZDB VMware IG-Var

xix

In This Book

This guide describes how to configure and use Data Protector with Oracle and SAP applications.

Audience

It 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 OpenView Storage Data

Protector Concepts Guide, which is recommended to fully understand the fundamentals and the model of Data Protector.

xxi

Organization

The manual is organized as follows:

Chapter 1 “Integrating Oracle and Data Protector” on page 1. Chapter 2 “Integrating SAP R/3 and Data Protector” on page 143. Chapter 3 “Integrating SAP DB/MaxDB and Data Protector” on

page 249.

Glossary Definition of terms used in this manual.

xxii

1 Integrating Oracle and Data

Protector

Chapter 1 1

Integrating Oracle and Data Protector

In This Chapter

This chapter explains how to configure and use the Data Protector Oracle integration.

The chapter is organized into the following sections:

“Introduction” on page 3 “Integration Concept” on page 5 “Configuring the Integration” on page 11 “Configuring an Oracle Backup” on page 36 “Backing Up an Oracle Database” on page 55 “Restoring an Oracle Database” on page 70 “Monitoring an Oracle Backup and Restore” on page 110 “Using Oracle After Removing the Data Protector Oracle Integration

on UNIX and OpenVMS Systems” on page 112 “Oracle RMAN Metadata and Data Protector Media Management

Database Synchronization” on page 114 “Troubleshooting” on page 116

Chapter 12

Integrating Oracle and Data Protector

Introduction

Data Protector offers offline as well as online backup of the Oracle Server instances. To enable 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 recovery catalog

• Backup of the Oracle control files

• With Oracle 10g, 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 Flashback logs, the current control file, and online redo logs are not

backed up.

•In Oracle Data Guard environment, backup of standby database.

Chapter 1 3

Integrating Oracle and Data Protector

Introduction

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.

Chapter 14

Integrating Oracle and Data Protector

Integration Concept

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

How Does the Integration Work?

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)

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.

Chapter 1 5

Integrating Oracle and Data Protector

Integration Concept

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, 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.

Chapter 16

Integrating Oracle and Data Protector

Integration Concept

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.

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.

Backup Flow 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 a specific user. This user must be defined as the owner of the Data Protector Oracle backup specification. Further on, ob2rman.pl prepares the environment to start the backup, and issues the RMAN backup command. RMAN instructs the Oracle Server processes to perform the specified command.

The Oracle Server processes initialize the backup through MML, which establishes a connection to the Data Protector Backup Session Manager. The Backup Session Manager starts the General Media Agent, sets up a connection between MML and the General Media Agent, and then monitors the backup process.

The Oracle Server processes read the data from the disks and send it to the backup devices through MML and the General Media Agent.

RMAN writes information regarding the backup either to the recovery catalog (if one is used) or to the control file of the Oracle target database.

Chapter 1 7

Integrating Oracle and Data Protector

Integration Concept

Messages from the backup session are sent to the Backup Session Manager, which writes messages and information regarding the backup session to the IDB.

The Data Protector General Media Agent writes data to the backup devices.

Restore Flow A restore session can be started using:

• Data Protector GUI

•RMAN CLI

• Oracle Enterprise Manager GUI

You must specify which objects are to be restored. A restore from the Data Protector user interface is triggered by the Data

Protector Restore Session Manager, which starts the ob2rman.pl command. Ob2rman.pl prepares the environment to start the restore, and issues the RMAN restore command. RMAN checks the recovery catalog (if one is used) or the control file to gather the information about the Oracle backup objects. It also contacts the Oracle Server processes, which initialize the restore through MML. MML establishes a connection with the Restore Session Manager and passes along the information about which objects and object versions are needed.

The Restore Session Manager checks the IDB to find the appropriate devices and media, starts the General Media Agent, establishes a connection between MML and the General Media Agent, and then monitors the restore and writes messages and information regarding the restore to the IDB.

The General Media Agent reads the data from the backup devices and sends it to the Oracle Server processes through MML. The Oracle Server Processes write the data to the disks.

The concept of Oracle integration, data and the control flow are shown in Figure 1-1 on page 9, and the related terms are explained in the following table.

Chapter 18

+ 366 hidden pages