HP B6960-96008 Instrukcja Użytkownika Strona 1

HP OpenView Storage Data ProtectorIntegration GuideforOracleSAPManual Edition: July 2006Manufacturing Part Number: B6960-96008Release A.06.00© Copyrig

xData Protector provides a cross-platform (Windows and UNIX) graphical user interface. Refer to the online Help for information about the Data Protect

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 178Set the other restore options. See “Restore, Recovery, and Duplicate Optio

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 79Figure 1-19 Source Page6. In the Results Area, select objects for restore

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 180TIP The same can be done if you set the DB_FILE_NAME_CONVERT initializatio

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 81Figure 1-20 Options Page8. In the Devices page, select the devices to be

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 182Figure 1-21 Devices Page9. Click Restore.After the restore:1. Put the data

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 83Oracle 8i:Use rcvcat instead of catalog in the above syntax.3. If you did

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 184If you are restoring a tablespace enter:SQL>alter tablespace <tables

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 85• Failover of database roles occurred.Duplicating an Oracle DatabasePerfo

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 186databases when the duplicate database resides in the same Oracle home dire

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 87Figure 1-22 Oracle Duplicate Options6. Click Restore.When the standby dat

xiContact InformationGeneral InformationGeneral information about Data Protector can be found athttp://www.hp.com/go/dataprotectorTechnical Support

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 188Restore, Recovery, and Duplicate OptionsRestore Action OptionsThe followin

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 89General OptionsClientThis option specifies the client on which the Data P

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 190restore you would like perform. The options are:•NormalThis option should

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 91Select this option if you want RMAN to recover the database after creatin

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 192limit of redo logs to restore. Data Protector restores the backup that can

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 93RMAN> RESET DATABASE;RMAN> exitOracle 8i:Use rcvcat instead of cata

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 194This section only describes examples of how you can perform a restore. The

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 95• Control files must be available. If the control files are not available

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 196NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'OpenVMS ExampleORACLE_HO

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 97Example of Full Database Restore and RecoveryTo perform a full database r

xii

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 198You can also save the script into a file and perform a full database resto

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 99•On OpenVMS: rman target sys/manager@PROD sys/manager@PROD catalog rman/r

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1100• On Windows: <ORACLE_HOME>\bin\rman target sys/manager@PROD catalo

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 101• On Windows: <ORACLE_HOME>\bin\rman target sys/manager@PROD nocat

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 11022. Start the tablespace restore.If you use the recovery catalog database,

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 103Use rcvcat instead of catalog in the above syntax.If you do not use the

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1104''C:\oracle\data\oradata\DATA\temp01.dbf'' online&quo

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 105• On Windows: <ORACLE_HOME>/bin/rman target sys/manager@PROD catal

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1106• On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD nocatalog

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 107Restoring Oracle Using CLIRestoring the Recovery CatalogData Protector c

xiiiData Protector DocumentationData Protector documentation comes in the form of manuals and online Help.Manuals Data Protector manuals are availab

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 11083. Run:Windows: From the <Data_Protector_home>\bin directory:perl -

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 109Example Suppose you have Oracle objects backed up on a device called DAT

Integrating Oracle and Data ProtectorMonitoring an Oracle Backup and RestoreChapter 1110Monitoring an Oracle Backup and RestoreDuring a backup, system

Integrating Oracle and Data ProtectorMonitoring an Oracle Backup and RestoreChapter 1 111Viewing Previous SessionsTo view a previous session using the

Integrating Oracle and Data ProtectorUsing Oracle After Removing the Data Protector Oracle Integration on UNIX and OpenVMS SystemsChapter 1112Using Or

Integrating Oracle and Data ProtectorUsing Oracle After Removing the Data Protector Oracle Integration on UNIX andOpenVMS SystemsChapter 1 113Removing

Integrating Oracle and Data ProtectorOracle RMAN Metadata and Data Protector Media Management Database SynchronizationChapter 1114Oracle RMAN Metadata

Integrating Oracle and Data ProtectorOracle RMAN Metadata and Data Protector Media Management DatabaseSynchronizationChapter 1 115TIP It is recommende

Integrating Oracle and Data ProtectorTroubleshootingChapter 1116TroubleshootingThis section lists general checks and verifications, and problems you m

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 117General TroubleshootingData Protector reports “12:8422” error when using Data Protect

xivHP OpenView Storage Data Protector Integration GuideThis manual describes how to configure and use Data Protector to back up and restore various da

Integrating Oracle and Data ProtectorTroubleshootingChapter 1118Start SQL*Plus from the <ORACLE_HOME> directory:bin/sqlplus /nologStart SQL*Plus

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 119Start SQL*Plus from the <ORACLE_HOME> directory:bin/sqlplus /nologStart SQL*Plu

Integrating Oracle and Data ProtectorTroubleshootingChapter 1120Start SQL*Plus and type:connect <Recovery_Catalog_Login>;select * from rc_databa

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 121release channel 'dev0';}If this fails, see the Oracle documentation for det

Integrating Oracle and Data ProtectorTroubleshootingChapter 11223. Verify that the TNS listener is correctly configured for the Oracle target database

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 1234. Verify that the Oracle target database and the recovery catalog database are confi

Integrating Oracle and Data ProtectorTroubleshootingChapter 11246. Verify backup and restore directly to disk using an RMAN channel type disk.If you u

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 125Configuration Problems on UNIX SystemsIMPORTANT If you have encountered any errors up

Integrating Oracle and Data ProtectorTroubleshootingChapter 1126The output must state that the respective MML is required by the Oracle executable.The

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 127See the online Help index “standard backup procedure” for details about how to do a f

xvHP OpenView Storage Data Protector Integration Guide for HP OpenView Operations for UNIXThis manual describes how to monitor and manage the health

Integrating Oracle and Data ProtectorTroubleshootingChapter 11282. Verify that the Data Protector Oracle integration Media Management Library (MML) is

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 129Figure 1-25 Checking the Inet Start-Up Parameters:5. Examine the system errorsThe sys

Integrating Oracle and Data ProtectorTroubleshootingChapter 1130or /usr/omni/config/cell/cell_server (other UNIX systems) file, which contains the nam

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 131Export of the Recovery Catalog Database failed.Action Start SQL*Plus and grant the ex

Integrating Oracle and Data ProtectorTroubleshootingChapter 1132Oracle 8i:Use rcvcat instead of catalog in the above syntax.Backup of Archive Logs on

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 133Backup Problems on WindowsAt this stage, you should have performed all the verificati

Integrating Oracle and Data ProtectorTroubleshootingChapter 1134EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_ex

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 135Restore ProblemsAt this stage, you should have performed all the verification steps d

Integrating Oracle and Data ProtectorTroubleshootingChapter 1136Other UNIX /usr/omni/bin/testbar2 -type:Oracle8 -appname:<DB_NAME>-perform:rest

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 137• If you are restoring datafiles the database should be in the Mount state.Open a com

xviSQL Server 2000 databases. The manual also describes how to configure and use Data Protector to perform backup and restore using the Microsoft Volu

Integrating Oracle and Data ProtectorTroubleshootingChapter 11386. Try putting the database into the Open state manually after using the Data Protecto

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 1391. Rename the util_orarest.exe to util_orarest.exe.orig2. Rename the util_orarest9.ex

Integrating Oracle and Data ProtectorTroubleshootingChapter 1140restore database;recover database;sql 'alter database open resetlogs';releas

Integrating Oracle and Data ProtectorTroubleshootingChapter 1 141Can’t dlopen() a library containing Thread Local Storage: <ORACLE_HOME>/JRE/lib

Integrating Oracle and Data ProtectorTroubleshootingChapter 1142

Chapter 2 1432 Integrating SAP R/3 and Data Protector

Integrating SAP R/3 and Data ProtectorIn This ChapterChapter 2144In This ChapterThis chapter explains how to configure and use the Data Protector SAP

Integrating SAP R/3 and Data ProtectorIntroductionChapter 2 145IntroductionData Protector integrates with the SAP R/3 Database Server to offer online

Integrating SAP R/3 and Data ProtectorIntroductionChapter 2146Data Protector has an advanced media management system that allows you to keep track of

Integrating SAP R/3 and Data ProtectorPrerequisites and LimitationsChapter 2 147Prerequisites and LimitationsThis section provides you with a list of

xviiDocumentation MapAbbreviationsAbbreviations in the documentation map that follows are explained below. The manual titles are all preceded by the

Integrating SAP R/3 and Data ProtectorPrerequisites and LimitationsChapter 2148Limitations Refer to the HP OpenView Storage Data Protector Product Ann

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2 149Integration ConceptThis integration links SAP R/3 backup utilities (BRTOOLS) wit

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2150• BRRESTOREThis utility restores the backed up data using the BRBACKUP and BRARCH

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2 151Figure 2-1 SAP R/3 Backup ConceptLegendSM The Data Protector Session Manager,

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2152Backup Flow Using BackintThe backup session undergoes the following stages if the

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2 153BMA Data Protector Backup Media AgentRMA Data Protector Restore Media AgentG

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 21543. The backint program obtains the SAP R/3 configuration from the Cell Manager, d

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2 155(SmWaitForNewClient omnirc global variable) and completes the backup session, as

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2156Figure 2-3 SAP R/3 Architecture: RMAN ModeLegendBSM Data Protector Backup Sessi

Integrating SAP R/3 and Data ProtectorIntegration ConceptChapter 2 157The restore session proceeds according to the following stages if the restore is

xviiiMapThe following table shows where to find information of different kinds. Shaded squares are a good place to look first.PA Product Announcements

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2158Data Protector SAP R/3 Configuration FileData Protector sto

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2 159NOTE You can set up the parameters in the Environment sect

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2160Example This is an example of the file:ORACLE_HOME='/a

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2 161Setting, Retrieving, Listing, and Deleting Data Protector

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2162[-sub[list] <sublist_name>] specifies the sublist in

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2 163Setting ParametersTo set the Data Protector OB2OPTS and th

Integrating SAP R/3 and Data ProtectorData Protector SAP R/3 Configuration FileChapter 2164Listing Parameters To list all the Data Protector SAP R/3 c

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 165Configuring the IntegrationConfiguration OverviewConfiguring the Data Pr

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2166Such a user is the user ora<SID> from the group sapsys; or, you can

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 167Configuring an SAP R/3 Database ServerBefore You Begin It is recommended

xixIntegrationsLook in these manuals for details of the following integrations:Integration GuideHP OpenView Operations (OVO) IG-OVOU, IG-OVOWHP Open

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2168integration. However, you need to create a link to the Data Protector bac

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 169NOTE Make sure to set any Oracle and SAP R/3 related environment variabl

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2170Using the CLI - UNIX Systems OnlyOn UNIX, to configure an SAP R/3 Databas

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 171Directory where SAP R/3 database files are installed. This is an optiona

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2172Figure 2-5 Specifying the SAP R/3 Database Server and the Oracle SID on W

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 173Figure 2-6 Specifying the SAP R/3 Database Server and the Oracle SID on

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2174Figure 2-7 Configuring an SAP R/3 Database Server on WindowsFigure 2-8 Co

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 1755. Enter the following information in the Configure SAP dialog box:• The

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2176NOTE The target database must be online during the check.The configuratio

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2 177Figure 2-9 Checking the SAP R/3 ConfigurationYou can also (re)configure

iiLegal Notices ©Copyright 2006 Hewlett-Packard Development Company, L.P. Hewlett-Packard Company makes no warranty of any kind with regard to this ma

xx

Integrating SAP R/3 and Data ProtectorConfiguring the IntegrationChapter 2178On UNIX, to get the error description, start the /opt/omni/lbin/omnigetms

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 179Configuring an SAP R/3 BackupTo configure an SAP R/3 backup, perform t

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2180Creating a Data Protector SAP R/3 Backup SpecificationTo create an SAP

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 181Each tablespace is switched into backup mode just before the backup an

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2182Figure 2-10 Selecting Backup ObjectsSee “Why Archive Redo Logs?” on pag

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 183Click Next.8. Select the backup options.For information on the Backup

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2184Figure 2-11 SAP R/3 Backup OptionsClick Next.9. Optionally, schedule th

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 185Figure 2-12 Saving the Backup SpecificationClick OK.To start the backu

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2186NOTE The parallelism of a backup (the number of streams your SAP R/3 da

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 187BRBACKUP command options. For example, type -t online, for online back

xxiIn This BookThis guide describes how to configure and use Data Protector with Oracle and SAP applications.AudienceIt is intended for backup admin

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2188influences (such as mount prompts), and is therefore best for environme

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 189(HP-UX and Solaris systems), or /usr/omni/bin (other UNIX systems) dir

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2190Objects outside database With this option, you save all non-database

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 191You can perform two types of online backups as well as offline backups

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2192• In a disaster situation (such as the loss of a production database an

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 193the backup specification.— In the SAP parameter file, set:backup_dev_t

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2194<Data_Protector_home>\Config\server\integ\config\sap\<client_n

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 2 195SID> file (UNIX systems), or in the <Data_Protector_home>\Con

Integrating SAP R/3 and Data ProtectorConfiguring an SAP R/3 BackupChapter 21962. In the Scoping Pane, expand Backup, then Backup Specifications, SAP

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2 197Backing Up an SAP R/3 DatabaseTo run a backup of an SAP R/3 database,

xxiiOrganizationThe manual is organized as follows:Chapter 1 “Integrating Oracle and Data Protector” on page 1.Chapter 2 “Integrating SAP R/3 and

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2198To start an incremental backup, specify Incremental mode in the Data P

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2 199A backup schedule can be tailored according to your business needs. I

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2200Figure 2-14 Scheduling BackupsClick OK and then Apply to save the chan

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2 201In the Start Backup dialog box, select the Backup type and Network lo

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2202Tru64 Cluster Before starting a backup on the Tru64 Cluster, create th

Integrating SAP R/3 and Data ProtectorBacking Up an SAP R/3 DatabaseChapter 2 203set the service startup account of the Data Protector Inet service to

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2204Restoring an SAP R/3 DatabaseYou can restore SAP R/3 databases in any o

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2 205filenames are displayed correctly only if the encoding is set to the e

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2206Figure 2-16 Restoring SAP R/3 Database Objects3. Select the backed up S

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2 207Restoring Using the Data Protector CLICluster-Aware ClientsIn a cluste

Chapter 1 11 Integrating Oracle and Data Protector

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2208UNIX:omnir -sap computer.company.com:ABA.0 -session 2006/01/23-1 -tree

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2 209See the SAP R/3 System Online Documentation for instructions on how to

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2210Check the instructions from the database/application vendor on how to p

Integrating SAP R/3 and Data ProtectorRestoring an SAP R/3 DatabaseChapter 2 2112. Run the following script:run {allocate channnel 'dev0' ty

Integrating SAP R/3 and Data ProtectorMonitoring an SAP R/3 Backup and RestoreChapter 2212Monitoring an SAP R/3 Backup and RestoreThe Data Protector G

Integrating SAP R/3 and Data ProtectorMonitoring an SAP R/3 Backup and RestoreChapter 2 2132. In the Actions menu, select Clear Sessions. Or click the

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2214TroubleshootingThis section lists general checks and verifications plus problems you

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 215Troubleshooting on Windows SystemsPrerequisites Concerning the Oracle Side of the In

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2216Figure 2-18 Checking the Status of the Oracle Listenera. The status of the respective

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 217Repeat the procedure using SYSOPER instead of SYSDBA. Set the <ORACLE_HOME> di

Integrating Oracle and Data ProtectorIn This ChapterChapter 12In This ChapterThis chapter explains how to configure and use the Data Protector Oracle

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2218b. If this fails, refer to the SAP R/3 Online Help to learn how to execute backup and

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 2192. Perform a filesystem backup of the SAP R/3 Database Server:Perform a filesystem b

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2220Figure 2-19 Checking the Inet Start-Up Parameters:5. Examine the environment variable

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 2212. Verify Data Protector internal data transfer using the testbar2 utility.Before yo

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2222Backup fails at the beginning with the message “Internal heap ERROR 17112”Problem Whe

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 223You can also do this using the SAP R/3 utilities:Use backint, so that SAPDBA will al

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2224 -appname:<ORACLE_SID> -perform:restore -object:<object_name> -v

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 225• Do not use non-ASCII or non-Latin 1 characters for filenames.Troubleshooting on UN

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2226Start the Server Manager (Oracle8/9i) or SQL Plus (Oracle9i) from the <ORACLE_HOME

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 2273. If you run backups in RMAN mode, verify that the Oracle Target Database is config

Integrating Oracle and Data ProtectorIntroductionChapter 1 3IntroductionData Protector offers offline as well as online backup of the Oracle Server in

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2228If you do not use the Recovery Catalog:Export <ORACLE_HOME> as described on pag

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 229If this fails, check the error messages and resolve possible problems before you con

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2230echo "Test backint called as follows:"echo "$0 $*"echo "exit

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 231 Solaris platform:/usr/bin/ldd -s <ORACLE_HOME>/bin/oracleThe output has to st

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 22324. Examine the environment variables:If you need to export some variables before star

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 233To get the error description, start the command: /opt/omni/lbin/omnigetmsg 12 <Er

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2234If the test fails again, call support.3. Verify the backup using backintexport OB2BAR

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 235Util_File_Online SAP backup fails with “semop() error”Problem When the util_file_onl

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2236"<Session_ID>" -media (other UNIX systems)on the SAP R/3 Database Ser

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2 2374. Simulate a Restore SessionOnce you know the information about the object to be re

Integrating Oracle and Data ProtectorIntroductionChapter 14Restore Types Using the Data Protector Oracle integration, you can restore the following:•

Integrating SAP R/3 and Data ProtectorTroubleshootingChapter 2238• On other UNIX: /usr/omni/bin/backint -f restore -u <ORACLE_SID> -i <input_

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2 239Examples of SAP R/3 Database RestoreThis section describes some

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2240SAPSID refers to the name of the SAP R/3 system, while the DBSID

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2 241Syntax for SAPDATA<n> is: n=1, ..., 99. The environment v

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2242Figure 2-20 Starting the SAPDBA in Expert Mode2. When the menu a

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2 2433. When the new menu appears, you can select between different

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 22446. Select the Start restore and recover option to start the rest

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2 245After you have opened a database with the RESETLOGS option, it

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 22462. Select the Show the list of damaged files to determine the fi

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2 247The lost files are restored using the SAP utility BRRESTORE.7.

Integrating Oracle and Data ProtectorIntegration ConceptChapter 1 5Integration ConceptThe Data Protector Oracle integration links the Oracle database

Integrating SAP R/3 and Data ProtectorExamples of SAP R/3 Database RestoreChapter 2248The SAP BRRESTORE utility restores the required files. If the re

Chapter 3 2493 Integrating SAP DB/MaxDB and Data Protector

Integrating SAP DB/MaxDB and Data ProtectorIn This ChapterChapter 3250In This ChapterThis chapter explains how to configure and use the HP OpenView St

Integrating SAP DB/MaxDB and Data ProtectorPrerequisites and LimitationsChapter 3 251Prerequisites and LimitationsThis section provides a list of prer

Integrating SAP DB/MaxDB and Data ProtectorIntroductionChapter 3252IntroductionBackup Data Protector integrates with the SAP DB/MaxDB Database Server

Integrating SAP DB/MaxDB and Data ProtectorIntroductionChapter 3 253Table 3-1 on page 253 shows what is actually backed up with regards to the selecte

Integrating SAP DB/MaxDB and Data ProtectorIntroductionChapter 3254The integration supports SAP DB/MaxDB migration, meaning that an SAP DB/MaxDB insta

Integrating SAP DB/MaxDB and Data ProtectorIntroductionChapter 3 255•Media ManagementData Protector has an advanced media management system that allow

Integrating SAP DB/MaxDB and Data ProtectorIntegration ConceptChapter 3256Integration ConceptThe Data Protector SAP DB/MaxDB integration links the SAP

Integrating SAP DB/MaxDB and Data ProtectorIntegration ConceptChapter 3 257SAP DB/MaxDB dbmcli. The sapdbbar.exe module issues dbmcli commands that co

Integrating Oracle and Data ProtectorIntegration ConceptChapter 16The interface from the Oracle server processes to Data Protector is provided by the

Integrating SAP DB/MaxDB and Data ProtectorIntegration ConceptChapter 3258Figure 3-1 SAP DB/MaxDB Backup and Restore Concept

Integrating SAP DB/MaxDB and Data ProtectorData Protector SAP DB/MaxDB Configuration FileChapter 3 259Data Protector SAP DB/MaxDB Configuration FileDa

Integrating SAP DB/MaxDB and Data ProtectorData Protector SAP DB/MaxDB Configuration FileChapter 3260• when the configuration parameters are changedCo

Integrating SAP DB/MaxDB and Data ProtectorData Protector SAP DB/MaxDB Configuration FileChapter 3 261In a cluster environment, the environment variab

Integrating SAP DB/MaxDB and Data ProtectorData Protector SAP DB/MaxDB Configuration FileChapter 3262Return Values The util_cmd command displays a sho

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 263Configuring the IntegrationIt is assumed that the installation of D

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3264• InstallMgm• ParamCheckWrite2. Add the OS user under whose account

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 2654. Select the Blank SAPDB Backup template. With this template, no o

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3266Figure 3-2 Selecting an SAP DB Server and Instance on UNIX Systems

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 267Figure 3-3 Selecting an SAP DB Server and Instance on Windows Syste

Integrating Oracle and Data ProtectorIntegration ConceptChapter 1 7These features can be used for online or offline backup of the Oracle target databa

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3268IMPORTANT To backup SAP DB/MaxDB archive logs, select the Data item

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 269You can also specify whether you want to create additional copies (

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3270You can examine the newly created and saved backup specification in

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 271Figure 3-6 Backup OptionsThe following are the SAP DB/MaxDB specifi

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3272The value of the Parallelism option must be equal as or lower than t

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 273Modifying the Configuration of an SAP DB/MaxDB Instance Using the G

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3274Figure 3-7 SAP DB/MaxDB ConfigurationClick OK to confirm the configu

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 275Then execute the following command:On HP-UX:/opt/omni/lbin/util_sap

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3276<password> The password of the SAP DB/MaxDB user created or

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 277Checking the Configuration of an SAP DB/MaxDB Instance Using the GU

Contents iii1. Integrating Oracle and Data ProtectorIn This Chapter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Integrating Oracle and Data ProtectorIntegration ConceptChapter 18Messages from the backup session are sent to the Backup Session Manager, which write

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3278To obtain an error description, start the following command on the S

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3 2793. Click Preview Backup to open the Start Preview dialog box. Selec

Integrating SAP DB/MaxDB and Data ProtectorConfiguring the IntegrationChapter 3280Refer to the omnib man page for more information on the omnib comman

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3 281Backing Up an SAP DB/MaxDB DatabaseDuring the backup, the d

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 32824. In the Schedule property page, select a date in the calen

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3 283Figure 3-9 Scheduling the Backup Specification3. Repeat ste

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3284Running an Interactive Backup Using the Data Protector GUIAn

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3 285Figure 3-10 Starting an Interactive BackupMessages appear i

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3286Refer to the omnib man page for more information.Example To

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3 287<media_group_name> is the name of the SAP DB/MaxDB me

Integrating Oracle and Data ProtectorIntegration ConceptChapter 1 9Figure 1-1 Data Protector Oracle Integration ConceptOracle 10g database files can a

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3288ERROROUTPUT /var/opt/omni/tmp/<inst_name>.bsi_errPARAM

Integrating SAP DB/MaxDB and Data ProtectorBacking Up an SAP DB/MaxDB DatabaseChapter 3 289UNIX medium_put BACKDP-Data[2]/1 \ /var/opt/omni/tmp/<in

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3290Restoring an SAP DB/MaxDB DatabaseAn SAP DB/MaxDB database ca

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 291• If the Data Protector Recovery option is not selected and

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3292When a transactional backup session is selected for restore,

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 293Figure 3-12 SAP DB/MaxDB Archive Logs Restore Process—Redo L

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3294NOTE During the restore or migration, the archive logs on the

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 295Restoring Using the Data Protector GUIWhen performing an SAP

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3296IMPORTANT To restore SAP DB/MaxDB archive logs, select the Da

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 297If you select a Trans or a Diff backup session, you are give

Integrating Oracle and Data ProtectorIntegration ConceptChapter 110IDB The IDB where all the information about Data Protector sessions, including se

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3298to get a list of SAP DB/MaxDB objects.• omnidb -sapdb <obj

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 299Example To restore an instance named “inst1” (together with

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3300SAP DB/MaxDB Restore and RecoveryFollow the procedure on the

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 301OUTPUT /var/opt/omni/tmp/<inst_name>.bsi_outERROROUTPU

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3302Create SAP DB/MaxDB media in an SAP DB/MaxDB media group. Exe

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 303Windows recover_start BACKDP-Data[2] DATA EBID "<ins

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3304SAP DB/MaxDB Restore and Recovery OptionsSAP DB/MaxDB restore

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 305Restore to client / -destination <ClientName> When us

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3306When using the CLI, it is not possible to change the user nam

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 307IMPORTANT When using this option, make sure that the backup

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 11Configuring the IntegrationPrerequisites• It is assumed that you are famil

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3308NOTE The selected time is the system time on the system runni

Integrating SAP DB/MaxDB and Data ProtectorRestoring an SAP DB/MaxDB DatabaseChapter 3 309Disaster RecoveryDisaster recovery is a very complex process

Integrating SAP DB/MaxDB and Data ProtectorMonitoring an SAP DB/MaxDB Backup and RestoreChapter 3310Monitoring an SAP DB/MaxDB Backup and RestoreThe D

Integrating SAP DB/MaxDB and Data ProtectorMonitoring an SAP DB/MaxDB Backup and RestoreChapter 3 311NOTE All completed or aborted sessions are automa

Integrating SAP DB/MaxDB and Data ProtectorMonitoring an SAP DB/MaxDB Backup and RestoreChapter 3312Figure 3-17 Viewing a Previous Session

Integrating SAP DB/MaxDB and Data ProtectorTroubleshootingChapter 3 313TroubleshootingThis section lists problems you might encounter when using the D

Integrating SAP DB/MaxDB and Data ProtectorTroubleshootingChapter 3314Problem An SAP DB/MaxDB instance cannot be started after restore.Action Using th

Integrating SAP DB/MaxDB and Data ProtectorTroubleshootingChapter 3 315Action Start the SAP DB/MaxDB x_server. Refer to the SAP DB/MaxDB documentation

Integrating SAP DB/MaxDB and Data ProtectorTroubleshootingChapter 3316Action Set the TimeoutSuccess environment variable on the Cell Manager by runnin

G-1Glossaryaccess rights See user rights.ACSLS (StorageTek specific term) The Automated Cartridge System Library Server (ACSLS) software that manage

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 112See the Oracle Recovery Manager User’s Guide and References for more inform

G-2 Glossary(disk partitioning and logical volume configuration) and automatic recovery of the original system configuration and user data that was

G-3Glossarybackup object A backup unit that contains all items backed up from one disk volume (logical disk or mount point). The backed up items can

G-4 GlossaryRegistry for example. File selection lists such as include-lists and exclude-lists can be specified.backup system (ZDB specific term)A s

G-5GlossaryBC Process (EMC Symmetrix specific term)A protected storage environment solution that has defined specially configured EMC Symmetrix devi

G-6 GlossaryBRBACKUP (SAP R/3 specific term)An SAP R/3 backup tool that allows an online or offline backup of the control file, of individual data f

G-7Glossarycatalog protection Defines how long information about backed up data (such as file names and file versions) is kept in the IDB. See also

G-8 GlossaryIf the specified channel is of type ‘sbt_tape’ and Oracle is integrated with Data Protector, the server process will attempt to read bac

G-9GlossaryData Protector cells is highly recommended See also MoM.COM+ Registration Database (Windows specific term)The COM+ Registration Database

G-10 Glossarycontrols the object copy and object consolidation sessions and runs on the Cell Manager system.data file (Oracle and SAP R/3 specific t

G-11Glossarydatabase server A computer with a large database stored on it, such as the SAP R/3 or Microsoft SQL database. A server has a database th

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 13• The Data Protector Oracle integration does not support the RMAN disk bac

G-12 Glossarythe tape, and so on. In other words, if the data rate written to the tape is less or equal the data rate which can be delivered to the

G-13Glossaryit to the Media Agent, which then moves it to the device. During a restore session the Disk Agent receives data from the Media Agent and

G-14 GlossaryDistributed File System (DFS) A service that connects file shares into a single namespace. The file shares can reside on the same or on

G-15Glossaryemergency boot file (Informix Server specific term) The Informix Server configuration file ixbar.<server_id> that resides in the d

G-16 Glossaryfailover (HP StorageWorks EVA specific term)An operation that reverses the roles of source and destination in CA+BC EVA configurations.

G-17Glossaryfilesystem The organization of files on a hard disk. A filesystem is backed up so that the file attributes and the file contents are sto

G-18 Glossaryare no changes from the previous backup.See also incremental ZDB.global options file A file that allows you to customize Data Protector

G-19GlossaryHP ITO See OVO.HP OpC See OVO.HP OpenView SMART Plug-In (SPI) A fully integrated, out-of-the-box solution which "plugs into"

G-20 GlossaryHP StorageWorks Virtual Array LUN A logical partition of a physical disk within an HP StorageWorks Virtual Array. LUNs are entities tha

G-21Glossaryincremental1 mailbox backup An incremental1 mailbox backup backs up all the changes made to the mailbox after the last full backup.incre

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 114Cluster-Aware ClientsIf you intend to use the Data Protector CLI, set the D

G-22 Glossarytwo kinds of stores: mailbox stores and public folder stores. A mailbox store consists of mailboxes that belong to individual users. A

G-23GlossaryMarkup Language (HTML) pages by using the Hypertext Transport Protocol (HTTP).IP address Internet Protocol address is a numeric address

G-24 GlossaryLISTENER.ORA (Oracle specific term)An Oracle configuration file that describes one or more Transparent Network Substrate (TNS) listener

G-25Glossaryof the logging level used during backup. Data Protector provides four logging levels: Log All, Log Directories, Log Files, and No Log. T

G-26 Glossaryand recovery information between Lotus Domino Server and a backup solution, like Data Protector.LVM A Logical Volume Manager is a subsy

G-27Glossarymedia allocation policy Determines in which sequence media are used for backup. The Strict allocation policy directs Data Protector to p

G-28 Glossarymodification date is kept. Files not present on the disk are always restored. See also overwrite.Microsoft Exchange Server A “client-s

G-29Glossaryenvironment, this part of the database can be common to all cells. See also CMMDB, CDB.MoM Several cells can be grouped together and ma

G-30 Glossarybackup and at least one incremental backup, into a new, consolidated version of this object.object copy A copy of a specific object ver

G-31Glossarystandalone and SCSI library devices can be used for offline recovery. Recovery of the Cell Manager is always offline.offline redo log Se

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 15The filename for MML depends on the platform:Proceed as follows:1. Change

G-32 Glossaryonline redo log (Oracle specific term)Redo logs that have not been archived, but are either available to the instance for recording dat

G-33Glossarynumber of systems and applications on in a network. Data Protector provides an integration into this management product. This integratio

G-34 Glossary• SUSPENDED - The link between the mirrored disks is suspended. That means that both disks are accessed and updated independently. Howe

G-35GlossaryStandard HP StorageWorks Disk Array XP LDEVs that act as a primary volume for the CA and BC configurations. The P-VOL is located in the

G-36 GlossaryRDF1/RDF2 (EMC Symmetrix specific term)A type of SRDF device group. Only RDF devices can be assigned to an RDF group. An RDF1 group typ

G-37Glossaryrecycle A process that removes the data protection from all backed up data on a medium, allowing Data Protector to overwrite it during o

G-38 Glossaryreplica set (ZDB specific term)A group of replicas, all created using the same backup specification. See also replica and replica set r

G-39GlossaryScheduler A function that controls when and how often automatic backups occur. By setting up a schedule, you automate the start of backu

G-40 Glossaryon the network. Systems with shared disks can be backed up without a Data Protector Disk Agent installed.SIBF The Serverless Integratio

G-41Glossarycopying processes normally continue after creation.See also snapshot.source (R1) device (EMC Symmetrix specific term)An EMC Symmetrix de

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 116• 64-bit:ln -s /opt/omni/lib/libob2oracle8_64bit.sl libobk.slSolaris:• 32-b

G-42 Glossarysqlhosts file (Informix Server specific term) An Informix Server connectivity information file (on UNIX) or registry (on Windows) that

G-43Glossarystandard security (MS SQL specific term)Standard security uses the login validation process of the Microsoft SQL Server for all connecti

G-44 Glossaryconventional full backup in terms of data, without putting stress on the production servers or the network. A synthetic full backup is

G-45Glossarydisk/partition as the volume/disk/partition containing files required for the initial step of the boot process.SysVol (Windows specific

G-46 GlossaryTimeFinder (EMC Symmetrix specific term) A business continuation process that creates an instant copy of single or multiple Symmetrix L

G-47Glossaryapplication system and can be presented to the backup system which performs the backup.See also Microsoft Volume Shadow Copy service (VS

G-48 Glossaryfor reuse in subsequent backups. The vaulting procedure depends on your company's backup strategy and policies for data protection

G-49Glossaryone or more physical volumes. There can be more than one volume group on the system.volume mountpoint (Windows specific term)An empty di

G-50 GlossaryWINS server A system running Windows Internet Name Service software that resolves Windows networking computer names to IP addresses. Da

G-51Glossaryarray as a backup of the source volumes at a specific point in time, in the same way as with ZDB to disk. However, data in the replica i

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 17ora_olb:libcommon8/libgeneric8/libgeneric8/lib• ORA_RDBMS:LORACLE_64.COMEx

G-52 Glossary

I-1Aaborting backup sessionsSAP R/3 integration, 198advantagesSAP DB integration, 254SAP R/3 integration, 145architectureSAP DB integration, 258SAP

IndexI-2BRARCHIVE, 149, 187BRBACKUP, 149, 186, 202BRRESTORE, 150, 157, 208Cchecking configurationOracle integration, 33SAP DB integration, 276SAP R/3

Index I-3SAP DB integration, 251SAP R/3 integration, 148Mmanual balancingSAP R/3 integration, 193manual balancing, creating backup specificationsSAP

IndexI-4RRAC, configuring Oracle Serverson HP-UX, 14on other UNIX systems, 14recoveryOracle integration, options, 88recovery catalog, Oracle integrati

Index I-5instance objects, 252introduction, 252limitations, 251monitoring sessions, 310parallelism, 271prerequisites, 251restore, 290–309restore flow

IndexI-6SAP R/3 integration, 202standby databases, Oracle integrationrestore, 84starting backups, Oracle integration, 60–69using CLI, 61using GUI, 60u

ContentsivUsing Oracle After Removing the Data Protector Oracle Integration on UNIX and OpenVMS Systems. . . . . . . . . . . . . . . . . . . . . . . .

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 118‘oracore$$’-‘network$$’-‘rdbmslib_noshare$$’-‘otracelib$$’-‘oracore$$’-‘rdb

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 19When you are prompted for the root directory, enter DISK$ORADISK_ODS5:[ORA

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1209. Include Java Aurora external option? [Y/N] N The options marked by Y wil

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 212. Check the presence of the MML LIBOBK2SHR32.EXE in the SYS$SHARE: direct

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 122Figure 1-2 Finding the Oracle UserThe example above states that the user or

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 23$PIPE@DKC0:[ORACLE9i]ORAUSER.COM > NLA0:• ORATABDepending on the curren

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1244. Oracle 8i/9i If you use CLI commands for Oracle integration agents, exec

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 25Using the Data Protector GUIConfigure an Oracle database when you create f

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 126Figure 1-4 Configuring Oracle - General (UNIX)2. In the Primary page, speci

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 27Figure 1-5 Configuring Oracle - Primary3. In the Catalog page, select Use

Contents vBacking Up Using Recovery Manager. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191Manual Balancing of Files into

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 128Figure 1-6 Configuring Oracle - Catalog4. Oracle Data Guard: If you intend

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 29Figure 1-7 Configuring Oracle - Standby5. Click OK.The Oracle database is

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 130On Windows:perl -I..\lib\perl util_oracle8.pl -config -dbname <DB_NAME&g

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 31Parameter Description<CLIENT_NAME> Name of the Oracle Server system

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 132Example The following example represents configuration on HP-UX or Solaris

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 33If the recovery catalog was selected, util_oracle8.pl starts the Oracle RM

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 134On Windows:perl -I..\lib\perl util_oracle8.pl -CHKCONF -dbname <DB_NAME&

Integrating Oracle and Data ProtectorConfiguring the IntegrationChapter 1 35IMPORTANT On UNIX, it is possible that although the GUI check returns a su

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 136Configuring an Oracle BackupTo configure an Oracle backup, perform the fol

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 37To create a new backup template, proceed as follows:1. In the Data Protec

ContentsviSetting, Retrieving, and Listing Data Protector SAP DB/MaxDB Configuration File Parameters Using the CLI . . . . . . . . . . . . . . . . . .

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 138Database_Switch_ArchiveDel Backs up the database instance, switches the

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 39UNIX only: Type the username and user group of the Oracle user. See “Conf

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 140Figure 1-9 Specifying an Oracle Server System (UNIX)Click Next.5. If the O

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 41NOTE If your database uses a recovery catalog, it is backed up by default

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1428. Set the backup options.For information on the Backup Specification Opti

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 43Figure 1-11 Oracle Specific OptionsClick Next.9. Optionally, schedule the

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 144Figure 1-12 Saving the Backup SpecificationClick OK.To start the backup, s

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 45Disable Data Protector managed control file backupBy default, Data Protec

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 146Examples of Pre-Exec and Post-Exec Scripts on UNIXPre-Exec Example The fol

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 47($ORACLE_HOME/bin/sqlplus)."exit 1fiEditing the Oracle RMAN ScriptTh

viiPrinting HistoryManual updates may be issued between editions to correct errors or document product changes. To ensure that you receive updated o

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 148If the RMAN script contains additional manually entered backup commands, f

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 49• Depending on the backup objects selection, an RMAN backup statement for

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 150If an appropriate template was selected, or if the statement was manually

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 51backup format 'New1<DIPSI_%s:%t:%p>.dbf' current controlf

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 152Testing the IntegrationOnce you have created and saved a backup specificat

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 1 53Figure 1-13 Previewing a BackupTesting Using the CLIA test can be execute

Integrating Oracle and Data ProtectorConfiguring an Oracle BackupChapter 154•On HP-UX and Solaris: /opt/omni/bin/omnib -oracle8_list \ <backup_spec

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 55Backing Up an Oracle DatabaseThere are two strategies for backing up a d

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 156Oracle Online As opposed to an offline backup, an online backup is perfor

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 573. Start SQL*Plus and type:alter database archivelog; alter database ope

viii

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 158• Start a backup on the Oracle server using either Oracle Recovery Manage

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 59For example, you may decide to perform daily backups and make multiple c

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 160Figure 1-14 Scheduling BackupsClick OK and then Apply to save the changes

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 61Note that the backup type can be full or incremental, with the increment

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 162You can select among the following list_options:-protect {none | weeks n

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 63b. Execute $rman target <target_connect_string> catalog <catalo

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1642. Allocate the Oracle channels.Allocating a channel tells RMAN to initia

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 65For example, if you have created and saved a backup specification named

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 166Examples of the RMAN ScriptsSome examples of RMAN scripts that must be ex

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 67allocate channel 'dev_2' type 'sbt_tape' parms'

ixConventionsThe following typographical conventions are used in this manual.Table 2Convention Meaning ExampleItalic Book or manual titles, and manu

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 168parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)&apos

Integrating Oracle and Data ProtectorBacking Up an Oracle DatabaseChapter 1 69parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)&apo

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 170Restoring an Oracle DatabaseYou can restore the database objects using:• D

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 71Figure 1-16 Taking the Oracle Resource Group OfflineVerify that you have

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 172allocate channel dev1 type 'sbt_tape' parms'ENV=(OB2BARHOST

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 73• Oracle 9i/10g:1. Restore the control file from automatic backup. If no

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 174Restoring the Recovery Catalog DatabaseThe Oracle recovery catalog databas

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 75Figure 1-18 Recovery Catalog Settings Dialog5. In the Options page:In Use

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 176Restoring the Control FileThe control file contains all the information ab

Integrating Oracle and Data ProtectorRestoring an Oracle DatabaseChapter 1 77IMPORTANT Ensure that you have properly configured the RMAN autobackup an