Copyright 2006 Hewlett-Packard Development Company, L.P
HP OpenView Storage Data Protector Integration Guide
Legal Notices
Contents
Integrating SAP R/3 and Data Protector
Integrating SAP DB/MaxDB and Data Protector
Glossary Index
Vii
Edition History Part Number Manual Edition Product
Viii
Text and items on System replies Press Computer screen
When entering a You supply your login name Command
Command names Use the grep command File and directory
New terms Data Protector Cell Manager is the main
Data Protector Graphical User Interface
Protector graphical user interface
Feedback
General
Information Technical Support
Documentation
Xii
Xiii
Manuals
Xiv
HP OpenView Storage Data Protector Integration Guide
Page
Xvi
Online Help
Xvii
Documentation Map
Abbreviations
Abbreviation Manual
Xviii
Map
Xix
Integrations
Integration Guide
Page
Xxi
Audience
Xxii
Organization
Integrating Oracle and Data
This Chapter
Introduction
Oracle Data Guard environment, backup of standby database
Database
Restore Types
Duplicating a
Integration Concept
Manager User’s Guide
Oracle Backup
Integration Concept
Rman CLI
Data Protector Oracle Integration Concept
Data Protector General Media Agent, which reads
IDB where all the information about Data
Protector sessions, including session messages, objects
Data, used devices, and media is written
Prerequisites
Configuring the Integration
Limitations
Oracle Data Guard
Before You Begin
Integration Media Management Library MML on
Cluster-Aware Clients
Linking Oracle with the Data Protector Oracle
Filenames for the MML on Different Platforms
Edit the following files
Linking Oracle with MML on OpenVMS Systems
On Oracle Server systems running on OpenVMS, link the MML
SYS$SHARELIBOBK2SHR32.EXE Oracle9i with the Oracle Server
ORARDBMSLORACLE64.COM
Orainstalloracleins
Documentation for OpenVMS
When you are prompted for the root directory, enter
Username and password. For more information, see the Oracle
Oracle documentation for OpenVMS
Options marked by Y will be selected
Relinking process
After Relinking
Configuring Oracle Users on Unix and OpenVMS
OpenVMS
Finding the Oracle User
Verify the changes of the group ID
Uncomment the following lines in OMNI$ROOTLOGLOGIN.COM
If the entry is not present, copy it from
Configuring Oracle Databases
Procedure
Verify that the -key Oracle8 entry is present
Pathname of the Oracle Server home directory
Using the Data Protector GUI
Configuring Oracle General Windows
Configuring Oracle General Unix
Configuring Oracle Primary
Database instance
Configuring Oracle Catalog
Specify the login information to the standby database
Instance
Using the Data Protector CLI
Configuring Oracle Standby
Where
On Windows
Parameter Description
Syntax
What Happens After the Configuration?
OpenVMS OMNI$ROOTBIN run
Checking the Configuration
Windows On the Cell Manager, see the file
To get the error description
Information, see Troubleshooting on
Clients
Configuring an Oracle Backup
Creating a New Template
Cluster-Aware
Creating a Data Protector Oracle Backup Specification
SMBProxyDatabase
DatabaseSwitchArchiveDel
SMBBackupSetDatabase
DirectDatabase
Specifying an Oracle Server System Windows
Specifying an Oracle Server System Unix
Selecting Backup Objects
Specification
Application Options, see the online Help
Set the backup options
Flash recovery area in the Pre-execor Post-exectext box.
Data Protector Oracle integration backup to tape
11Oracle Specific Options
Oracle Backup Options
By default, Data Protector backs up the Data Protector
Post-Exec
Examples of Pre-Exec and Post-Exec Scripts on Unix
Pre-Exec Example
Limitations
Editing the Oracle Rman Script
Data Protector Rman Script Structure
BackupSpecificationNameDBNAME%s%t%p.dbf
Whole database selection
Rman current controlfile command
Variables and DBNAME, which are obligatory
Creating Copies of Backed Up Objects
Oracle Duplex Mode Example
Testing Using the Data Protector GUI
Testing the Integration
Run the omnib command with the -testbaroption as follows
13Previewing a Backup Testing Using the CLI
Configuring an Oracle Backup
Backing Up an Oracle Database
Oracle Online
If Pfile is used
Start SQL*Plus and type alter database archivelog
Catalog
Scheduling a Backup
Backup Procedure
Recovery
Backing Up an Oracle Database
Click OK and then Apply to save the changes
Running an Interactive Backup
Starting a Backup Using the GUI
HP-UX and Solaris /opt/omni/bin
OpenVMS To set up the CLI, run
See the omnib man page for details
Starting Oracle Backup Using Rman
Following command
You can select among the following listoptions
Target Database The format of the target database login is
Allocated
If you specify more than a single allocate channel command
Commands is handled internally by Rman
Tape in the second case
Use rcvcat instead of catalog in the above syntax
Parallel
Examples of the Rman Scripts
Archived Logs
Flash Recovery
Backing Up
Particular
Backing Up While
File in a Backup
Specification
Including Control
On Windows
Databases
Restoring an Oracle Database
Restorable Items
Duplicating
16Taking the Oracle Resource Group Offline
Restoring Database Items in a Disaster Recovery
Restoring Oracle Using the Data Protector GUI
To put the database into NoMount state, run
Required Database States Item to restore Database state
Changing The Database State
Database, ensure that the database is in the correct state
Restoring the Recovery Catalog Database
18Recovery Catalog Settings Dialog
Restoring the Control File
After the restore, run the following script
Ensure that you have properly configured the Rman autobackup
Restoring Oracle Database Objects
Source
Results Area, select objects for restore
Restore As dialog box, specify the new datafile location
Oracle Data Guard If you restore a primary database from a
Will be used
Login information for the primary database. If you restore
Same can be done if you set the Dbfilenameconvert
Converts them appropriately
Options
Devices
If you are restoring a datafile enter
Restoring Tablespaces and Datafiles
If you are restoring a tablespace enter
Restoring and Recovering a Standby Database
Restoring and Recovering a Primary Database
Prerequisites
Duplicating an Oracle Database
Limitation
Restore Action drop-down list, select Perform Duplication
22Oracle Duplicate Options
Restore, Recovery, and Duplicate Options
This drop-down list allows you to specify which type
Settings
Restore mode
General Options Client
For Standby
Dorecover
Parallelism
Duplicate Options
Nofilenamecheck
Restore and Recovery Options Restore until
To database name
Recover until
Reset logs
Restoring Oracle Using Rman
Open database after recovery
Opens the database after a recovery is performed
Preparing the Oracle Database for Restore
Unix Example
Windows Example
Connection Strings Used in the Examples
Start the full database restore and recovery run
Example of Full Database Restore and Recovery
Example of Point-in-Time Restore
Start the point-in-time restore run
100
Example of Tablespace Restore and Recovery
Chapter 101
102
Example of Datafile Restore and Recovery
Windows
Unix
104
Example of Archive Log Restore
106
Start the archive log restore run
If you are using an sh like shell, run
Restoring Oracle Using CLI
Restoring the Recovery Catalog
108
Restoring Using Another Device
Disaster Recovery
110
Monitoring an Oracle Backup and Restore
Monitoring Current Sessions
Windows DataProtectorhome\log\oracle8.log
Viewing Previous Sessions
112
Oracle
Removing the Data Protector Oracle Integration Link
On OpenVMS Systems
114
Cases
116
Troubleshooting
Integration on Unix Systems
General Troubleshooting
Problem
Checking Prerequisites Related to the Oracle Side
118
If this fails, open the recovery catalog
Start SQL*Plus from the Oraclehome directory
If this fails, open the Oracle target database
Then
120
Chapter 121
122
23Checking the Status of the Oracle Listener
Connect to the recovery catalog
124
Configuration Problems on Unix Systems
126
Verify the permissions of the current user account
Configuration Problems on Windows Systems
Examine the system errors
128
Verify the inet startup parameters
Check your Oracle Server configuration
Backup Problems on Unix Systems
On other Unix systems
Data Protector reports Export of the Recovery Catalog
Database Failed when backing up Oracle
Following errors are listed in the Data Protector monitor
Data Protector reports Cannot allocate/attach shared memory
Backup Fails After a Point in Time Restore and Recovery
132
Backup of Archive Logs on RAC Cannot be Performed
Backup
Backup Problems on Windows
Data Protector reports errors when calling
SYS.LTEXPORTPKG.schemainfexp during Oracle 9i/10g
134
Recovery catalog
Simulate a restore session
Restore Problems
Verify that an object exists on the backup media
136
Other Unix
Ensure that the database is in the correct state
Restart Data Protector
Try using the Rman CLI to restore the database items
Check your environment variables
138
Browsing Oracle 9i database for restore on Linux
Binary utilorarest failed error message is displayed when
Following SQL script
Recovery Catalog was lost and the control file cannot be
Restored from Data Protector managed backup
Tape
Following is displayed
Problem occurs with Oracle8i on HP-UX
Shared library that provides thread local storage cannot be
Loaded
From the list of dynamic libraries for libclntsh.sl. See
Problem occurs when the Radius Authentication Adapter is
Radius Authentication Adapter
Library libjava.sl that provides thread local storage
142
Integrating SAP R/3 and Data
144
Advantages
Refer to the HP OpenView Storage Data Protector Product
Announcements, Software Notes, and References or
146
Software Notes, and References or
Prerequisites and Limitations
HP OpenView Storage Data Protector Product Announcements
148
Commands
User since the backups will not work
Utilities
Brbackup
150
Data Protector Zero Downtime Backup Administrator’s Guide
Data Protector
Software
Architecture
SAP R/3 Backup Concept
152
Backup Flow
Using Backint
SAP R/3 Architecture Backint Mode
Data Protector User Interface
Data Protector Backup Media Agent
Data Protector Restore Media Agent
Protector is limited to
Sapbackup
Finished data transfer, the BSM waits for a timeout
DataProtectorhome\tmp on Windows if the variable is not
Backup Flow Using Recovery Manager
156
SAP R/3 Architecture Rman Mode
Data Protector Backup General Media Agent
Restore Flow Using Recovery Manager
158
Data Protector SAP R/3 Configuration File
On Windows
Chapter 159
160
This is an example of the file
Command
Setting, Retrieving, Listing, and Deleting Data
Protector SAP R/3 Configuration
File Parameters Using the CLI
162
HP-UX and Solaris
Setting
Parameters
Protector SAP R/3 client
164
SAP R/3 instance ICE, use the following command on the Data
Listing Parameters
Deleting
Overviewsteps
166
SAP R/3 database using Data Protector
SAP R/3 database backup with Data Protector
Group
Windows/UNIX
Configuring an SAP R/3 Database Server
Before You Begin
Clients on
168
Utilsap.exe
Data Protector Inet
User Account on
170
Using the CLI Unix Systems Only
Is the directory in which Oracle binaries are installed
Chapter 171
172
Windows
Unix
174
Configuring an SAP R/3 Database Server on Windows
Configuring an SAP R/3 Database Server on Unix
Data Protector GUI
Configuration
What Happens?
Checking
176
Target database must be online during the check
Data Protector CLI
Checking the SAP R/3 Configuration
178
Configuring an SAP R/3 Backup
180
Creating a Data Protector SAP R/3 Backup Specification
BrbackupRMANOnline
BrbackupRMANOffline
182
10Selecting Backup Objects
Backing Up Using Recovery Manager on
Specify any SAP R/3 backup options, the current settings
184
11SAP R/3 Backup Options
Chapter 185
Log file
SAP R/3 Specific Backup Options
BR Backup
Logs?
Balancing By Time
Backup Objects
BR Archive
Balancing By Load
188
Balancing Manual
Balancing None
Pre-exec
Post-exec
Backup mode
190
Creating or Modifying the Parameter File on the SAP
Database Server
Objects outside database
Incrementally
Backing Up Using Recovery Manager
Benefits
192
Backup
Incremental
Backups if Using
Manual Balancing of Files into Subsets
194
Creating an SAP /R3 Backup Specification for Manual
Balancing
SID file Unix systems, or
Backup specification then looks like
196
Testing Using the Data Protector CLI
Tools version 4.5 and later
Backup Methods Duplicate SIDs Backup Modes
Backups
Backing Up an SAP R/3 Database
198
Aborting an SAP R/3 Backup Session
Aborting a
Running Session
Session options. See Figure
200
Starting a Backup Using the GUI
Cluster-Aware Clients
An interactive backup can also be started from the CLI
Windows 202
Using SAP R/3 Commands
Account on
Chapter 203
204
Restoring an SAP R/3 Database
Considerations
To get a list of SAP R/3 objects
Finding Information Needed for Restore
Restoring Using the Data Protector GUI
206
16Restoring SAP R/3 Database Objects
Set to restore from automatically
Restoring Using the Data Protector CLI
Using the CLI, execute the following command
Where FileName must be specified as follows
208
Restoring Using the SAP R/3 Commands
Commands
Restoring Using the Data Protector CLI or SAP R/3 Commands
Using Another Device
Restoring Using the Data Protector GUI
210
Run the following script
Restored
212
Monitoring an SAP R/3 Backup and Restore
ID consisting of a date in the YY/MM/DD format and a unique
Previous Sessions
Scoping Pane, expand Sessions to display all the sessions
Stored in the IDB
214
OpenView Storage Data Protector Troubleshooting Guide
Oracle9i
Correctly
Prerequisites Concerning the Oracle Side of the Integration
Troubleshooting on Windows Systems
216
At the Svrmgr prompt, type
Prerequisites on the SAP R/3 Side of the Integration
If you are not using the recovery catalog
218
Configuration Problems
\\clientname\sapmnt\ORACLESID\SYS\exe\run\brbackup or
Perform a filesystem backup of the SAP R/3 Database Server
Run the following command if you use the default directory
*RETVAL*0 indicates successful configuration
Examine system errors
Backup Problems
Check your SAP R/3 Server configuration
If the test fails again, call support
222
Restore Problems
Chapter 223
224
Verify the restore using backint
Actions
Do not use non-ASCII or non-Latin 1 characters for filenames
Troubleshooting on Unix Systems
226
At the Svrmgr Oracle8/8i or SQL Oracle9i prompt, type
If it fails, open the Oracle Target Database
If you use the Recovery Catalog
228
An example of the rmanscript is listed below
Which is provided by Data Protector
230
Solaris platform
232
Verify the permissions of the currently used user account
Chapter 233
234
Verify the backup using backint
Error
IDB
UtilFileOnline SAP backup fails with semop error
Verify a user for the restore
Verify that a backup object exists on the backup media
236
Verify the restore using backint Run the following command
BarbackupspecificationnameHP-UX and Solaris systems or
238
Use SAP R/3 commands for example, brrestore to restore these
Preparing the SAP R/3 Database for Restore
Examples of SAP R/3 Database Restore
240
Example of Full Database Restore and Recovery
242
When the menu appears, select the Restore/Recovery option
Chapter 243
244
Was recovered, run the Alter Database Open command with
Example of Lost Files Restore
Example of Partial Restore
246
This means that the existing file can be used
To restore the archive log files, follow the steps below
Example of Archive Log Files Restore
Lost files are restored using the SAP utility Brrestore
248
Integrating SAP DB/MaxDB
250
SAP DB/MaxDB instance to enable transactional backup log
Aware of before using the integration
Architectures and how to install the Data Protector
SAP DB/MaxDB Automatic Log Backup must be activated for an
252
GUI
Restore
Platforms
Parallelism
Permissions
Supported
Chapter 255
256
Interfaces
Restore Flow
258
SAP DB/MaxDB Backup and Restore Concept
Data Protector SAP DB/MaxDB Configuration File
260
Setting, Retrieving, and Listing Data Protector SAP
DB/MaxDB Configuration File Parameters Using
Configuration File
Optionvalue is the value for the parameter
Command output is written to. If the -localoption is not
SAP DB/MaxDB configuration file
Optionname is the name of the parameter
262
Configuring Users
264
Configuring an SAP DB/MaxDB Backup
Creating a Backup Specification
Chapter 265
266
Selecting an SAP DB Server and Instance on Unix Systems
Selecting an SAP DB Server and Instance on Windows Systems
Selecting SAP DB Objects
To backup SAP DB/MaxDB archive logs, select the Data item
Backup interactively
Interactively. See Backing Up an SAP DB/MaxDB Database on
Saving the Backup Specification
270
SAP DB/MaxDB Specific Backup Options
Backup Options
272
Chapter 273
274
Modifying the Configuration of an SAP DB/MaxDB Instance
Using the CLI
Described in Configuring Users on
Then execute the following command
Specified during the installation
Instance to be configured
276
Checking the Configuration of an SAP DB/MaxDB Instance
Using the GUI
Checking the Configuration of an SAP DB/MaxDB Instance
SAP DB/MaxDB Server system
To check the configuration, run the following command on
If an error occurs, it is explained
It before running a backup
Description of these options, press F1
Previewing a Backup
280
Backing Up an SAP DB/MaxDB Database
Scheduling an Existing Backup Specification
Backup Methods Scheduling Procedure
282
Scheduling the Backup Specification
284
Running an Interactive Backup Using the Data Protector GUI
10Starting an Interactive Backup
Running an Interactive Backup Using the Data Protector CLI
286
Running an Interactive Backup Using SAP
DB/MaxDB Utilities
Chapter 287
288
Chapter 289
290
Restore and Recovery Overview
Restoring an SAP DB/MaxDB Database
SAP DB/MaxDB Server is overwritten
From the selected backup session is restored. The data on
Selected backup session are restored
Mode, SAP DB/MaxDB always checks whether such a gap exists
292
SAP DB/MaxDB Restore Process
Chapter 293
294
SAP DB/MaxDB Migration Prerequisites
Chapter 295
296
Properties for Data Dialog Box
Finding Information Needed for a Restore
298
Command Syntax an SAP DB/MaxDB instance
To get a list of SAP DB/MaxDB objects
Restoring
Finding Information Needed for Restore
Restoring Using SAP DB/MaxDB Utilities
300
Chapter 301
302
SAP DB/MaxDB Migration
304
SAP DB/MaxDB Restore and Recovery Options
Chapter 305
306
Recovery Options
Refer to Restoring Using the Data Protector CLI on
308
Chapter 309
310
Monitoring an SAP DB/MaxDB Backup Restore
Media used for this session, respectively. See Figure
312
17Viewing a Previous Session
Restore
Problems
Data Protector reports the following error during backup or
314
An SAP DB/MaxDB instance cannot be started after restore
Restore from an object copy hangs
Data Protector reports the following error
Start the SAP DB/MaxDB instance. Refer to the SAP DB/MaxDB
Documentation for information on how to do that
Task command. Finish these tasks
Start the SAP DB/MaxDB xserver. Refer to the SAP DB/MaxDB
316
SAP DB/MaxDB Cluster-Related Troubleshooting
Glossary
Backup ID
Backup API
Backup chain See restore chain Backup device
Backup generation
See also incremental backup and full backup Backup set
Backup object
Backup owner
Backup session
See also BCV BC HP StorageWorks Disk Array XP specific term
Backup system ZDB specific term
See also replica, source volume, snapshot, and CA+BC EVA
Instant copies of EMC Symmetrix standard devices
BC Process EMC Symmetrix specific term
Boot volume/disk/partition
See also SAPDBA, Brbackup
Brrestore
CA HP StorageWorks Disk Array XP specific term
See also BC EVA, replica, and source volume
See also SAPDBA, Brarchive
Brarchive BSM
CDB
Cmmdb
CSM
CRS
Data stream
Data protection
See also catalog protection Data Protector Event Log
Data Protector user account
Dcbf
Direct backup
Differential backup
See incremental backup Differential backup MS SQL specific
See also backup types Differential database backup
Disk discovery
Disk image rawdisk backup
See also virtual full backup
Disk Agent concurrency
DR OS
DMZ
Event Logs
Emergency boot file Informix Server
Enhanced incremental backup
Enterprise Backup Environment
File depot
File Replication Service FRS
FC bridge See Fibre Channel bridge
Fibre Channel bridge
Full mailbox backup
See also recovery files Fnames.dat
Full backup
See also backup types Full database backup
Holidays file
See also incremental ZDB Global options file
Heartbeat
Hierarchical Storage Management HSM
HP OVO
HP ITO
IDB
LUN
HP VPO
Incremental ZDB
Incremental1 mailbox backup
Incremental restore EMC Symmetrix
Incremental re-establish EMC
Integration object
Initializing See formatting Installation Server
Informix Server Informix Server specific term
Refers to Informix Dynamic Server
Library
IP address
ITO
Jukebox See library Jukebox device
Logfull shell script Informix Server
Local and remote recovery
Load balancing
Lock name
Database Oracle and SAP R/3 specific term
Login information to the Oracle Target
An interface for the exchange of backup
Logical-log files
Mailbox Store Microsoft Exchange Server specific term
LVM
Magic Packet See Wake Onlan
Mailbox Microsoft Exchange Server specific term
Media ID
Media allocation policy
Media condition
Media condition factors
Mmdb
MMD
MSM
Object copying
Offline backup
Object copy
Object copy session
Offline redo log See archived redo log
Onconfig Informix Server specific term
Online backup
See also zero downtime backup ZDB and offline backup
OVO
Pair status HP StorageWorks Disk Array XP specific term
Package MC/ServiceGuard and Veritas Cluster specific term
Ownership
P1S file
Physical device
Parallel restore
Pre- and post-exec commands
Primary Volume P-VOL HP
RAID Manager XP HP StorageWorks Disk Array XP specific term
Rawdisk backup See disk image backup
Public/private backed up data
RAID
Recovery Manager Rman Oracle
Recovery Catalog Oracle specific
Recovery Catalog Database Oracle
See also flash recovery area RecoveryInfo
Removable Storage Management
Recycle
Scanning
Restore session
RSM
Scan
Shadow copy set MS VSS specific term
Scheduler
Session key
See also shadow copy
Smbf
Sibf
SMB
See also ZDB to tape, ZDB to disk+tape, and replica
Creation Split mirror backup EMC Symmetrix
Source R1 device EMC Symmetrix
See also target R2 device
Stackers
SRD file
Sst.conf file
St.conf file
See also integrated security Storage Group
Switchover See failover Sybase Backup Server API Sybase
Synthetic backup
Standard security MS SQL specific
System databases Sybase specific
Synthetic full backup
System Backup to Tape Oracle
System volume/disk/partition
See also source R1 device
Terminal Services Windows specific
Tablespace
Target R2 device EMC Symmetrix
TLU
User rights
Unattended operation See lights-out operation User account
User disk quotas
User group
Virtual Device Interface MS SQL Server specific term
Volume group
Verify
Virtual Controller Software VCS
VSS
VPO
Writer
See also direct backup
See zero downtime backup ZDB
ZDB to tape ZDB specific term
Zero downtime backup ZDB
Glossary
Index
Index
BRARCHIVE, 149
Index
286
Index
281-289