HP OpenView Storage B6960-96008 instruction

Integrating SAP DB/MaxDB and Data Protector

Restoring an SAP DB/MaxDB Database

Disaster Recovery

Disaster recovery is a very complex process that involves products from several vendors. As such, successful disaster recovery depends on all the vendors involved. The information provided here is intended to be used as a guideline.

Check the instructions from the database/application vendor on how to prepare for a disaster recovery. Also refer to the HP OpenView Storage Data Protector Disaster Recovery Guide for instructions on how to approach system disaster recovery using Data Protector.

This is a general procedure for recovering an application:

1.Complete the recovery of the operating system.

2.Install, configure, and initialize the database/application so that data on the Data Protector media can be loaded back to the system. Consult the documentation from the database/application vendor for a detailed procedure and the steps needed to prepare the database.

3.Ensure that the database/application server has the required Data Protector client software installed and is configured for the database/application. Follow the procedures in this chapter and in the troubleshooting section.

4.Start the restore. When the restore is complete, follow the instructions from the database/application vendor for any additional steps required to bring the database back online.

Chapter 3

309

Image 331

HP OpenView Storage B6960-96008 manual

Contents

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