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