HP OpenView Storage B6960-96008 272

Integrating SAP DB/MaxDB and Data Protector

In This Chapter

This chapter explains how to configure and use the HP OpenView Storage Data Protector SAP DB/MaxDB integration. It explains the concepts and methods you need to understand in order to back up and restore SAP DB/MaxDB databases using Data Protector.

It is organized into the following sections:

“Prerequisites and Limitations” on page 251

“Introduction” on page 252

“Integration Concept” on page 256

“Data Protector SAP DB/MaxDB Configuration File” on page 259

“Configuring the Integration” on page 263

“Backing Up an SAP DB/MaxDB Database” on page 281

“Restoring an SAP DB/MaxDB Database” on page 290

“Monitoring an SAP DB/MaxDB Backup and Restore” on page 310

“Troubleshooting” on page 313

250

Chapter 3

Contents

HP OpenView Storage Data Protector Integration Guide for Oracle SAP Legal Notices 1. Integrating Oracle and Data Protector 2. Integrating SAP R/3 and Data Protector 3. Integrating SAP DB/MaxDB and Data Protector Glossary Index Printing History Page Conventions Figure Data Protector Graphical User Interface Contact Information Page Data Protector Documentation HP OpenView Storage Data Protector Integration Guide HP OpenView Storage Data Protector Integration Guide for HP OpenView HP OpenView Storage Data Protector Zero Downtime Backup Concepts Guide HP OpenView Storage Data Protector Zero Downtime Backup Administrator’s Guide HP OpenView Storage Data Protector Zero Downtime Backup Integration Guide HP OpenView Storage Data Protector MPE/iX System User Guide HP OpenView Storage Data Protector Media Operations User's HP OpenView Storage Data Protector Product Announcements Software Notes, and References Online Help Documentation Map Abbreviations Abbreviation Manual Map Integration ZDB Concepts Guides Integrations Guide Page In This Book Organization Chapter Glossary Integrating Oracle and Data Protector In This Chapter Introduction Backup Types recovery files flash recovery area •In Oracle Data Guard environment, backup of standby database Restore Types Duplicating a Database Integration Concept Components Functionality Overview How Does the MML Oracle Backup Types Handled by the Integration Oracle differential incremental Backup Flow Restore Flow Data Protector Oracle Integration Concept Legend: Page Configuring the Integration Page •Oracle Data Guard: Before You Begin Cluster-AwareClients Windows UNIX RAC: Linking Oracle with the Data Protector Oracle Filenames for the MML on Different Platforms 32-bitOracle: cd <ORACLE_HOME>/lib 64-bitOracle 8i: cd <ORACLE_HOME>/lib64 64-bitOracle 9i/10g: cd <ORACLE_HOME>/lib HP-UX: Solaris: Linking Oracle with MML on OpenVMS Systems Linking Oracle8i Example Page Page Page After Relinking Linking Oracle9i Configuring Oracle Users on UNIX and OpenVMS Finding the Oracle User OpenVMS 1. Oracle Oracle 2.Oracle 8i/9i 3.Oracle 8i/9i TIP Configuring Oracle Databases Using the Data Protector GUI Configuring Oracle - General (Windows) Configuring Oracle - General (UNIX) Configuring Oracle - Primary Configuring Oracle - Catalog Oracle Data Guard Configuring Oracle - Standby Using the Data Protector CLI UNIX only: Windows: HP-UXand Solaris: /opt/omni/lbin On UNIX and OpenVMS: Parameter Description Syntax What Happens After the Configuration Checking the Configuration Other UNIX Handling Errors HP-UXand Solaris: Run: Other UNIX: Run: OpenVMS: Run: Page Configuring an Oracle Backup Configuring an Oracle Backup Cluster-Aware Clients Creating a New Template Creating a Data Protector Oracle Backup Specification Archive Archive_Delete Whole_Online Whole_Online_Delete Database_Switch_ArchiveDel Direct_Database SMB_Proxy_Database SMB_BackupSet_Database UNIX only Specifying an Oracle Server System (Windows) Specifying an Oracle Server System (UNIX) Oracle 10g: Oracle Data Guard (10g): Selecting Backup Objects Page Figure 1-11Oracle Specific Options Figure 1-12Saving the Backup Specification UNIX: Oracle Backup Options Oracle Data Guard: OpenVMS Examples of Pre-Execand Post-ExecScripts on UNIX Pre-ExecExample Post-Exec Editing the Oracle RMAN Script Limitations Data Protector RMAN Script Structure The Oracle channel allocation Page an RMAN backup statement for the backup of Oracle control files Example of the Oracle Duplex Mode Creating Copies of Backed Up Objects Testing the Integration Testing Using the Data Protector GUI Figure 1-13Previewing a Backup Testing Using the CLI Page Backing Up an Oracle Database Backing Up an Oracle Database Oracle Offline Oracle Online If SPFILE is used: If PFILE is used: Backup Methods Backup Procedure Deleting Data from the Recovery Catalog Scheduling a Backup Page Figure 1-14Scheduling Backups Running an Interactive Backup Starting a Backup Using the GUI Figure 1-15Starting an Interactive Backup Starting a Backup Using the CLI HP-UXand Solaris: /opt/omni/bin Starting Oracle Backup Using RMAN Oracle 9i/10g: Oracle 8i: Target Database Login Recovery Catalog Page Page Examples of the RMAN Scripts Backing Up a Single Channel Backing Up Three Channels in Backing Up Particular Archived Logs Backing Up the Flash Recovery Including Control File in a Backup Specification Backing Up While Allowing for Some On Windows Restoring an Oracle Database Restoring an Oracle Database Restorable Items Duplicating duplicate Databases Figure 1-16Taking the Oracle Resource Group Offline Figure 1-17Checking Properties MC/ServiceGuard Restoring Oracle Using the Data Protector GUI Restoring Database Items in a Disaster Recovery Changing The Database State Required Database States Item to restore Database state Restoring the Recovery Catalog Database Figure 1-18Recovery Catalog Settings Dialog Restoring the Control File HP-UXand Solaris: /var/opt/omni/tmp Oracle Data Guard (10g only): Restoring Oracle Database Objects Source Page Page Options Page Devices Page Restoring Tablespaces and Datafiles Restoring and Recovering an Oracle Database in Oracle Data Guard Environment Restoring and Recovering a Primary Database Restoring and Recovering a Standby Database duplication Duplicating an Oracle Database Limitation Prerequisites Page Figure 1-22Oracle Duplicate Options Restore, Recovery, and Duplicate Options Restore Action Options Perform Restore Perform Restore and Recovery Perform Recovery Only General Options Client Settings User name User group Parallelism Duplicate Options For Standby DORECOVER To database name NOFILENAMECHECK Restore and Recovery Options Restore until Recover until Open database after recovery Reset logs Restoring Oracle Using RMAN Preparing the Oracle Database for Restore Windows Example UNIX Example —Oracle 9i: —Oracle 8i: Connection Strings Used in the Examples Example of Full Database Restore and Recovery Example of Point-in-TimeRestore Page Example of Tablespace Restore and Recovery Page Example of Datafile Restore and Recovery UNIX Windows Page Example of Archive Log Restore Page Restoring Oracle Using CLI Restoring the Recovery Catalog HP-UXand Solaris: Restoring Using Another Device Disaster Recovery Monitoring an Oracle Backup and Restore Monitoring an Oracle Backup and Restore Monitoring Current Sessions Clearing Sessions Monitoring Tools Viewing Previous Sessions HP-UX and Solaris: Removing the Data Protector Oracle Integration Link on HP-UXSystems Using Oracle After Removing the Data Protector Oracle Integration on UNIX and OpenVMS Systems Removing the Data Protector Oracle Integration Link on OpenVMS Systems Oracle Oracle RMAN Metadata and Data Protector Media Management Database Synchronization Synchronization Troubleshooting General Troubleshooting Data Protector reports “12:8422” error when using Data Protector Oracle integration after an upgrade of Oracle 8i to Oracle Problem Page Page 6.Verify backup and restore directly to disk using an RMAN channel type disk Page Page Page Page Configuration Problems on UNIX Systems 1. Verify that the Data Protector software has been installed properly 2. Verify that the Data Protector Oracle integration Media Management Library (MML) is linked with the Oracle Figure 1-24Output of the ldd command on other UNIX systems: 3.Perform a filesystem backup of the Oracle Server system 4.Verify the permissions of the current user account 5.Examine the system errors Configuration Problems on Windows Systems 4.Verify the inet startup parameters: Figure 1-25Checking the Inet Start-UpParameters: Backup Problems on UNIX Systems 1.Check your Oracle Server configuration 2.Verify Data Protector internal data transfer using the testbar2 utility Data Protector reports “Export of the Recovery Catalog Database Failed” when backing up Oracle EXP-00008:ORACLE error 6550 encountered Data Protector reports “Cannot allocate/attach shared memory” Backup Fails After a Point in Time Restore and Recovery Backup of Archive Logs on RAC Cannot be Performed Backup Problems on Windows 1. Check your Oracle Server configuration 2. Verify Data Protector internal data transfer using the testbar2 utility Data Protector reports errors when calling Page Restore Problems 1.Verify that an object exists on the backup media 2.Simulate a restore session HP-UX and Solaris Other UNIX 3. Ensure that the database is in the correct state 4.Check your environment variables 5.Try using the RMAN CLI to restore the database items Page The Recovery Catalog was lost and the control file cannot be restored from Data Protector managed backup Shared library that provides thread local storage cannot be loaded Page Page Integrating SAP R/3 and Data Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Integrating SAP DB/MaxDB and Data Protector Page Page offer an integrated online backup of SAP DB/MaxDB instance. The • SAP DB/MaxDB data • SAP DB/MaxDB configuration and • SAP DB/MaxDB archive logs Offline backup SAP DB/maxDB Backup Mode and Data Protector GUI Selections SAP DB/MaxDB Backup Mode Full Diff migration Parallelism Permissions permissions Supported Page Interfaces Page Page Data Protector SAP DB/MaxDB Configuration File Data Protector SAP DB/MaxDB Configuration File Configuration File Setting, Retrieving, and Listing Data Protector SAP DB/MaxDB Configuration File Parameters Using the CLI Page Page Configuring Users Configuring an SAP DB/MaxDB Backup Creating a Backup Specification Page Page Selecting an SAP DB Server and Instance on Windows Systems Selecting SAP DB Objects Saving the Backup Specification SAP DB/MaxDB Specific Backup Options Backup Options Change database state Keep archive logs Modifying the Configuration of an SAP DB/MaxDB Instance in Data Protector Modifying the Configuration of an SAP DB/MaxDB Instance Using the GUI SAP DB/MaxDB Configuration Modifying the Configuration of an SAP DB/MaxDB Instance Using the CLI Page Checking the Configuration of an SAP DB/MaxDB Instance Checking the Configuration of an SAP DB/MaxDB Instance Using the GUI Page Previewing a Backup Page Backing Up an SAP DB/MaxDB Database Procedure Backing Up an SAP DB/MaxDB Database Scheduling an Existing Backup Specification Page Scheduling the Backup Specification Running an Interactive Backup Using the Data Protector GUI Figure 3-10Starting an Interactive Backup Protector CLI Running an Interactive Backup Using SAP DB/MaxDB Utilities Page Page Page Restoring an SAP DB/MaxDB Database Restoring an SAP DB/MaxDB Database Restore and Recovery Overview Page SAP DB/MaxDB Restore Process Figure 3-12SAP DB/MaxDB Archive Logs Restore Process—RedoLogs Details SAP DB/MaxDB Migration Prerequisites Figure 3-13Selecting SAP DB/MaxDB Objects for a Restore The Properties for Data Dialog Box Finding Information Needed for a Restore Restoring Command Syntax Restoring Using SAP DB/MaxDB Utilities Finding Information Needed for Restore SAP DB/MaxDB Restore and Recovery Restore Page Page SAP DB/MaxDB Migration SAP DB/MaxDB Restore and Recovery Options Figure 3-15SAP DB/MaxDB Restore and Recovery Options Migration Options Restore to client Restore to instance Recovery Options Latest version Until date Use existing archive logs Page Monitoring an SAP DB/MaxDB Backup and Restore Monitoring an SAP DB/MaxDB Backup and Restore Figure 3-16Monitoring a Current Session Page Page Problems Data Protector reports the following error during backup or restore: An SAP DB/MaxDB instance cannot be started after restore A restore from an object copy hangs Data Protector reports the following error: Page SAP DB/MaxDB Cluster-RelatedTroubleshooting Glossary access rights See user rights ACSLS Active Directory AML autochanger See library autoloader See library Automatic Storage Management BACKINT backup API backup object backup owner backup session See also incremental backup and full backup backup set backup system See also application system, target volume, and replica backup types backup view BCV BC Process BC VA BCV See also BC and BC Process Boolean operators BRBACKUP See also SAPDBA, BRARCHIVE and BRRESTORE BRARCHIVE BSM catalog protection See also data protection CDB MMDB CDF file client backup client backup with disk discovery client or client system cluster-awareapplication CMD Script for Informix Server COM+ Registration Database command-lineinterface Command View (CV) EVA (HP See also HP StorageWorks EVA SMI– S Agent concurrency data file data protection See also catalog protection Data Protector Event Log Data Protector user account database server Dbobject DC directory DCBF delta backup DHCP server differential backup See incremental backup differential backup (MS SQL specific See also backup types Disk Agent concurrency disk discovery disk group disk image (rawdisk) backup disk quota Distributed File System (DFS) DMZ DNS server domain controller DR image emergency boot file (Informix Server enhanced incremental backup Enterprise Backup Environment Event Logs exchanger FC bridge See Fibre Channel bridge Fibre Channel Fibre Channel bridge file depot filesystem first level mirror (HP StorageWorks Disk Array XP specific term) See also Primary Volume, and MU numbers flash recovery area (Oracle specific See also recovery files See also incremental ZDB global options file group GUI hard recovery HP ITO OVO HP OpC HP OpenView SMART Plug-In(SPI) HP OVO HP StorageWorks Virtual Array LUN See also BC VA and replica HP VPO ICDA incremental1 mailbox backup incremental (re)-establish (EMC incremental restore (EMC Symmetrix incremental ZDB Inet Key Management Service Site Replication Service Informix Server initializing See formatting IP address ISQL ITO jukebox See library jukebox device LISTENER.ORA load balancing local and remote recovery lock name log_full shell script (Informix Server logical-logfiles login ID login information to the Oracle Target Database login information to the Recovery Catalog Database (Oracle specific LVM Magic Packet See Wake ONLAN mailbox Mailbox Store media allocation policy media condition media condition factors media ID media label overwrite Microsoft Exchange Server Microsoft Management Console (MMC) Microsoft SQL Server mount request mount point MSM MU number See also first level mirror object copy object copy session object copying Object ID object mirror offline redo log See archived redo log On-Bar ONCONFIG online backup online redo log See also archived redo log OpC OpenSSH Oracle Data Guard (Oracle specific ownership P1S file package pair status G-33 parallel restore parallelism physical device post-exec pre-exec See also Secondary Volume (S-VOL) protection See data protection and also catalog protection public folder store (Microsoft Exchange Server specific term) public/private backed up data RDF1/RDF2 RDS Recovery Catalog (Oracle specific Recovery Catalog Database (Oracle recovery files recycle redo log Remote Control Unit (HP StorageWorks Disk Array XP specific term) Removable Storage Management reparse point replica set See also replica and replica set rotation See also replica and replica set restore chain restore session Scheduler Secondary Volume (S-VOL) (HP StorageWorks Disk Array XP specific term) See also Primary Volume (P-VOL) session See backup session, media management session, and restore session SIBF Site Replication Service (Microsoft Exchange Server specific term) See also Information Store and Key Management Service slot SMB source (R1) device (EMC Symmetrix See also target (R2) device source volume sparse file split mirror sqlhosts file SRD file SRDF SSE Agent sst.conf file standard security (MS SQL specific See also integrated security Storage Group StorageTek ACS library storage volume synthetic full backup System Backup to Tape (Oracle system databases (Sybase specific system disk system partition SysVol tablespace tapeless backup ZDB to disk target database TimeFinder TLU TNSNAMES.ORA transaction transaction backup See also Microsoft Volume Shadow Copy service (VSS) TSANDS.CFG file (Novell NetWare unattended operation See lights-outoperation user account user disk quotas verify Virtual Controller Software (VCS) Command View (CV) EVA Virtual Device Interface (MS SQL Server specific term) virtual disk volume mountpoint (Windows specific term) Volume Shadow Copy service See Microsoft Volume Shadow Copy service VPO VSS WINS server writer XBSA interface XCopy engine See also direct backup ZDB to tape zero downtime backup (ZDB) ZDB to disk instant recovery ZDB to disk+tape Page Index