HP Data Protector A.06.11 Kurzanleitung zur Einrichtung

HP Data Protector A.06.11

Zero downtime backup integration guide

for Oracle, SAP R/3, Microsoft SQL Server,

Microsoft Exchange Server, and Microsoft

Volume Shadow Copy Service

B6960-90163

Part number: B6960-90163

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

About this guide ................................................................. 19

Intended audience ............................................................................................. 19

Documentation set ............................................................................................. 19

Guides ...................................................................................................... 19

Online Help ............................................................................................... 22

Documentation map .................................................................................... 23

Abbreviations ...................................................................................... 23

Map ................................................................................................... 24

Integrations ......................................................................................... 25

Document conventions and symbols ..................................................................... 27

Data Protector graphical user interface ................................................................. 28

General information .......................................................................................... 29

HP technical support .......................................................................................... 29

Subscription service ........................................................................................... 30

HP websites ...................................................................................................... 30

Documentation feedback .................................................................................... 30

1 Data Protector Oracle ZDB integration ............................... 31

Introduction ...................................................................................................... 31

Backup and restore types ............................................................................. 32

Integration concepts .......................................................................................... 35

Oracle backup set ZDB concepts ......................................................................... 39

Backup process .......................................................................................... 42

Oracle proxy-copy ZDB concepts ........................................................................ 44

Backup process .......................................................................................... 47

Configuring the integration ................................................................................. 49

Prerequisites ............................................................................................... 49

Limitations .................................................................................................. 51

Before you begin ........................................................................................ 51

Backup set method ............................................................................... 53

Enabling instant recovery in an ASM configuration for the XP array ............ 56

Zero downtime backup integration guide 3

Cluster-aware clients .................................................................................... 56

Linking Oracle Server with the Data Protector MML ......................................... 56

Configuring Oracle user accounts ................................................................. 57

Configuring Oracle operating system user accounts .................................. 57

Configuring Oracle database users accounts ........................................... 59

Configuring Oracle databases ...................................................................... 60

Using the Data Protector GUI ................................................................. 60

Using the Data Protector CLI .................................................................. 65

Checking the configuration .......................................................................... 69

Using the Data Protector GUI ................................................................. 69

Using the Data Protector CLI .................................................................. 69

Checking configuration for instant recovery .............................................. 70

Setting environmental variables ..................................................................... 71

Using the Data Protector GUI ................................................................. 72

Using the Data Protector CLI .................................................................. 73

Switching between Oracle backup methods .................................................... 74

Backup ............................................................................................................ 75

Creating backup specifications ..................................................................... 76

Examples of pre-exec and post-exec scripts on UNIX ................................. 92

Editing the Oracle RMAN script .................................................................... 93

Starting backup sessions .............................................................................. 97

Considerations ..................................................................................... 97

Scheduling backup specifications ........................................................... 98

Running an interactive backup .............................................................. 100

Restore ........................................................................................................... 102

Prerequisites ............................................................................................. 104

Restoring from backup media to the application system on LAN ...................... 104

Restoring Oracle using the Data Protector GUI .............................................. 104

Restoring database items in a disaster recovery ...................................... 104

Changing the database state ............................................................... 105

Restoring the recovery catalog database ............................................... 105

Restoring the control file ...................................................................... 108

Restoring Oracle database objects ........................................................ 109

Restoring tablespaces and datafiles ...................................................... 114

Duplicating an Oracle database ................................................................. 115

Restore, recovery, and duplicate options ...................................................... 119

Restore action options ......................................................................... 119

General options ................................................................................. 119

Duplicate options ............................................................................... 120

Restore and recovery options ............................................................... 121

Restoring Oracle using RMAN .................................................................... 123

Preparing the Oracle database for restore ............................................. 123

Connection strings used in the examples ................................................ 125

SBT_LIBRARY parameter ...................................................................... 125

Example of full database restore and recovery ....................................... 126

Example of point-in-time restore ............................................................ 127

Example of tablespace restore and recovery .......................................... 129

Example of datafile restore and recovery ............................................... 131

Example of archive log restore ............................................................. 135

Example of database restore using a different device (with the automatic

device selection functionality disabled) .................................................. 136

Restoring using another device ................................................................... 137

Instant recovery and database recovery ....................................................... 138

Instant recovery using the Data Protector GUI ......................................... 139

Oracle database recovery after the instant recovery ................................ 142

Oracle in Veritas Cluster instant recovery ............................................... 144

Aborting sessions ............................................................................................ 145

Troubleshooting ............................................................................................... 145

Before you begin ...................................................................................... 146

Checks and verifications ............................................................................ 146

Problems .................................................................................................. 154

2 Data Protector SAP R/3 ZDB integration ........................... 163

Introduction .................................................................................................... 163

Integration concepts ........................................................................................ 164

ZDB flow ................................................................................................. 165

Data Protector SAP R/3 configuration file ........................................................... 167

Setting, retrieving, listing, and deleting Data Protector SAP R/3 configuration file

parameters using the CLI ............................................................................ 170

Configuring the integration ............................................................................... 173

Prerequisites ............................................................................................. 173

Before you begin ...................................................................................... 174

Cluster-aware clients .................................................................................. 175

Configuring user accounts .......................................................................... 175

Configuring SQL*Net V2 or Net8 TNS listener ............................................. 177

Checking the connection ............................................................................ 178

Authentication password file ....................................................................... 178

Enabling archived logging ......................................................................... 179

Sharing directories on the application system ................................................ 180

UNIX application system ..................................................................... 181

Windows application system ................................................................ 181

Choosing authentication mode ................................................................... 182

Configuring SAP R/3 databases ................................................................. 182

Before you begin ................................................................................ 183

Using the Data Protector GUI ............................................................... 183

Zero downtime backup integration guide 5

Using the Data Protector CLI ................................................................ 186

Checking the configuration ........................................................................ 188

Using the Data Protector GUI ............................................................... 188

Using the Data Protector CLI ................................................................ 189

Configuring the SAP R/3 parameter file ....................................................... 190

Backup .......................................................................................................... 191

Considerations ........................................................................................ 192

Creating backup specifications ................................................................... 193

Modifying backup specifications ................................................................. 206

Scheduling backup specifications ................................................................ 206

Scheduling example ........................................................................... 206

Previewing backup sessions ........................................................................ 207

Using the Data Protector GUI ............................................................... 207

Using the Data Protector CLI ................................................................ 208

What happens during the preview? ...................................................... 208

Starting backup sessions ............................................................................ 208

Backup methods ................................................................................. 208

Using the Data Protector GUI ............................................................... 208

Using the Data Protector CLI ................................................................ 209

Using the SAP BRTOOLS ..................................................................... 209

Configuring SAP compliant ZDB sessions ..................................................... 211

Using the Data Protector GUI ............................................................... 211

Using the Data Protector CLI ................................................................ 213

Manual balancing .................................................................................... 214

Restore ........................................................................................................... 214

Considerations ......................................................................................... 216

Standard restore ....................................................................................... 216

Instant recovery ........................................................................................ 221

Considerations ................................................................................... 221

Instant recovery using the Data Protector GUI ......................................... 221

Instant recovery using the Data Protector CLI .......................................... 225

Instant recovery from replicas containing the control file ........................... 226

Restoring using another device ................................................................... 227

Using the Data Protector GUI ............................................................... 227

Using the Data Protector CLI or SAP commands ...................................... 227

Localized SAP R/3 objects ......................................................................... 228

Monitoring sessions ......................................................................................... 228

Troubleshooting ............................................................................................... 228

Before you begin ...................................................................................... 229

General troubleshooting ............................................................................ 229

Verifying the prerequisites (Oracle side) ....................................................... 230

Verifying the prerequisites (SAP side) ........................................................... 231

Verifying the configuration ......................................................................... 232

Verifying the backup configuration .............................................................. 233

Verifying restore ........................................................................................ 235

Configuration and backup problems ............................................................ 238

Restore problems ...................................................................................... 240

3 Data Protector Microsoft SQL Server ZDB integration .......... 243

Introduction .................................................................................................... 243

Integration concepts ........................................................................................ 244

Configuring the integration ............................................................................... 245

Prerequisites ............................................................................................. 245

Before you begin ...................................................................................... 246

Data Protector SQL Server configuration file ................................................. 246

Configuring users ...................................................................................... 247

Configuring SQL Server instances ............................................................... 248

Using the Data Protector GUI ............................................................... 249

Using the Data Protector CLI ................................................................ 251

Changing and checking configuration ......................................................... 252

Using the Data Protector GUI ............................................................... 252

Using the Data Protector CLI ................................................................ 253

Backup .......................................................................................................... 254

Creating ZDB specifications ....................................................................... 254

SQL Server Specific Backup Options ..................................................... 263

Scheduling backups .................................................................................. 265

Scheduling example ........................................................................... 265

Starting backup sessions ............................................................................ 265

Using the Data Protector GUI ............................................................... 266

Using the Data Protector CLI ................................................................ 266

Restore ........................................................................................................... 266

Before you begin ...................................................................................... 267

Standard restore ....................................................................................... 267

Restore options ......................................................................................... 271

Restoring to another SQL Serverinstance or/and another SQL Server ......... 273

Instant recovery ........................................................................................ 274

Monitoring sessions ......................................................................................... 276

Troubleshooting .............................................................................................. 277

Before you begin ...................................................................................... 277

Checks and verifications ............................................................................ 277

Problems .................................................................................................. 278

4 Data Protector Microsoft Exchange Server ZDB integration ... 285

Introduction .................................................................................................... 285

Integration concepts ........................................................................................ 286

Zero downtime backup integration guide 7

Configuring the integration ............................................................................... 287

Prerequisites ............................................................................................. 287

Before you begin ...................................................................................... 288

Backup .......................................................................................................... 289

Configuring Exchange Server ZDB .............................................................. 290

Creating ZDB specifications ................................................................. 290

Examples of using omnicreatedl ........................................................... 300

Modifying ZDB specifications ............................................................... 303

Checking Exchange files for consistency ................................................ 304

Scheduling backups .................................................................................. 307

Scheduling example ........................................................................... 307

Starting backup sessions ............................................................................ 307

Using the Data Protector GUI ............................................................... 308

Using the Data Protector CLI ................................................................ 308

Restore ........................................................................................................... 309

Standard restore ....................................................................................... 309

Point-in-time recovery .......................................................................... 310

Rollforward recovery ........................................................................... 314

Instant recovery ........................................................................................ 320

Point-in-time recovery .......................................................................... 321

Rollforward recovery ........................................................................... 321

Troubleshooting .............................................................................................. 323

Before you begin ...................................................................................... 324

Checks and verifications ............................................................................ 324

Problems .................................................................................................. 325

5 Integrating the Data Protector ZDB integrations and Microsoft

Volume Shadow Copy Service ........................................... 329

Introduction .................................................................................................... 329

Volume Shadow Copy Service .................................................................... 329

VSS backup types ..................................................................................... 332

VSS restore .............................................................................................. 332

Integration concepts ........................................................................................ 332

Backup .................................................................................................... 333

Data consistency ................................................................................ 336

Backup with the Enterprise Virtual Array VSS and VDS hardware

provider ............................................................................................ 337

Backup with the Disk Array XP VSS and VDS hardware provider ............... 337

Instant recovery ........................................................................................ 337

Standard restore from tape ......................................................................... 338

Restoring components ......................................................................... 338

Restoring files ..................................................................................... 339

VSS database .......................................................................................... 339

Querying the VSSDB .......................................................................... 340

Deleting backup sessions ..................................................................... 341

Enabling and disabling replicas ........................................................... 341

Changes in the environment ................................................................. 341

Microsoft Exchange Server 2007 writer concepts .......................................... 342

Backup ............................................................................................. 342

Restore .............................................................................................. 343

Microsoft Hyper-V VSS writer concepts ......................................................... 343

Prerequisites ...................................................................................... 343

Prerequisites and limitations .............................................................................. 344

Prerequisites ............................................................................................. 344

Transportable backup prerequisites ....................................................... 344

Limitations ................................................................................................ 345

Enterprise Virtual Array hardware provider limitations .............................. 345

Disk Array XP hardware provider limitations ........................................... 346

ZDB limitations ................................................................................... 346

Instant recovery limitations ................................................................... 346

Configuring the integration ............................................................................... 347

Configuring the application system for instant recovery-enabled backup

sessions ................................................................................................... 347

Configuring HP StorageWorks Enterprise Virtual Array ................................... 349

Prerequisites ...................................................................................... 351

Configuring the Integration .................................................................. 350

Configuring HP StorageWorks Disk Array XP ................................................ 351

Prerequisites ...................................................................................... 351

Limitations ......................................................................................... 351

VSS and VDS provider configuration for ZDB and instant recovery .................. 352

Configuring the VSS hardware provider for Enterprise Virtual Arrray .......... 352

Configuring the VSS hardware provider for Disk Array XP ........................ 353

Configuration check .................................................................................. 353

Microsoft Exchange Server writer specific configuration .................................. 354

Prerequisites ...................................................................................... 354

Microsoft Exchange Server 2007 configuration in CCR environments ......... 355

Writers specifics .............................................................................................. 355

Backing up writers data ................................................................................... 360

Overview ................................................................................................. 360

Replica types ..................................................................................... 360

HP StorageWorks EVA specifics ............................................................ 361

HP StorageWorks Disk Array XP specifics .............................................. 362

Creating backup specifications using GUI .................................................... 362

VSS specific backup options ................................................................ 370

Microsoft Exchange Server writer backup specifics .................................. 370

Zero downtime backup integration guide 9

Microsoft Hyper-V VSS writer backup specifics ........................................ 375

Scheduling the backup .............................................................................. 376

Running an interactive backup .................................................................... 378

Restoring writers data ...................................................................................... 379

Restore procedure ..................................................................................... 380

Restore options ................................................................................... 384

MSDE writer restore specifics ...................................................................... 384

Microsoft Exchange Server writer restore specifics ......................................... 386

Rollforward recovery from the loss of one or more databases ................... 386

Point-in-time restore after loss of a log file .............................................. 387

Microsoft Exchange Server 2007 writer restore specifics .......................... 388

Microsoft Hyper-V VSS writer restore specifics ............................................... 391

Restore from a physical cluster node ...................................................... 391

Instant recovery ........................................................................................ 391

Overview .......................................................................................... 392

Limitations ......................................................................................... 393

Instant recovery using Microsoft Virtual Disk Service ................................ 393

Instant recovery using HP StorageWorks EVA SMIS-S Agent ..................... 394

Instant recovery using HP StorageWorks Disk Array XP Agent ................... 396

Microsoft Exchange Server writer instant recovery specifics ...................... 397

Instant recovery procedure ................................................................... 400

Troubleshooting ............................................................................................... 408

Before you begin ...................................................................................... 409

Checks and verifications ............................................................................ 409

Common problems .................................................................................... 409

Backup problems ...................................................................................... 410

Restore problems ...................................................................................... 415

User scenario for Microsoft Exchange Server 2003 backup and restore .................. 417

Example - VSS transportable backup ........................................................... 417

Example restore scenario for Microsoft Exchange Server 2003 ........................ 419

A Appendix ..................................................................... 421

In this appendix .............................................................................................. 421

Reconfiguring an Oracle instance for instant recovery .......................................... 421

Examples for moving the control files and redo logs to different locations ........ 423

ZDB integrations omnirc variables ..................................................................... 425

Glossary ......................................................................... 433

Index .............................................................................. 491

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

Inhaltsverzeichnis

Andere HP Software Handbücher

HP Rx2620-2 - Integrity - 0 MB RAM Bedienungsanleitung

HP AE370A - Brocade 4Gb SAN Switch 4/12 Service-Handbuch

HP e3000 Bedienungsanleitung

HP T5145 - Thin Client - Tower Service-Handbuch

HP Integrity BL890c - i2 Server Bedienungsanleitung

HP B2355-92068 Bedienungsanleitung

HP mfp digital sending software v. 4 Montageanleitung

HP BL680c - ProLiant - G5 Bedienungsanleitung

HP StorageWorks MSA 2/8 - SAN Switch Bedienungsanleitung

HP Compaq dc5750 MT Bedienungsanleitung

HP MultiSeat ms6000 Bedienungsanleitung

HP StorageWorks 1510i - Modular Smart Array Bedienungsanleitung

HP Media Center m1000 - Desktop PC Kurzanleitung

HP t5630 - Thin Client Montage- und Bedienungsanleitung

HP T5725 - Compaq Thin Client Bedienungsanleitung

HP Designjet T1300 Bedienungsanleitung

HP C7791C - DesignJet 130 Color Inkjet Printer Konfigurationshandbuch

HP Vectra E-Vectra Kurzanleitung

HP LeftHand P4000 - SAN Solutions Bedienungsanleitung

HP 742n - Pavilion - 512 MB RAM Montage- und Bedienungsanleitung

HP Surestore Disk Array 12h - And FC60 Referenzhandbuch

HP mfp digital sending software v. 4 Bedienungsanleitung

HP Integrity BL860c Bedienungsanleitung

HP Integrity Superdome 2 16-socket 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