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