Manuals / HP / Household Appliance / Garage Door Opener

HP OpenView Storage B6960-96008 manual

Models: OpenView Storage B6960-96008

1 396

Download 396 pages 29.22 Kb

Page 394

Index

R

RAC, configuring Oracle Servers on HP-UX,14

on other UNIX systems, 14 recovery

Oracle integration, options, 88 recovery catalog, Oracle integration

backup, 58 restore, 74

Recovery Manager See RMAN removing the Oracle integration, 112

from HP-UX,112

from Solaris and other UNIX systems, 113 restore flow

SAP DB integration, 257

SAP R/3 integration, backint mode, 157 SAP R/3 integration, RMAN mode, 157

restore options

SAP DB integration, 304 restore types

Oracle integration, 4 restoring Oracle, 70–109

control files, 76 database objects, 78 disaster recovery, 109 methods, 70

primary databases, Data Guard, 84 recovery catalog, 74, 107

restore flow, 8

standby databases, Data Guard, 84 tablespaces and datafiles, 83 using another device, 108

using GUI, 72 using RMAN, 93

restoring SAP DB, 290–309disaster recovery, 309 migration, 254, 294 overview, 290

restore flow, 257 restore options, 304 using another device, 308 using CLI, 297

using GUI, 295

using SAP DB utilities, 299 restoring SAP R/3, 204–209

archive log files, example, 247 disaster recovery, 209 examples, 239–248

full database, example, 241

lost files, example, 245 partial, example, 245

preparing database for restore, 239 restore flow, backint mode, 157 restore flow, RMAN mode, 157 using another device, 209

using BRRESTORE, 208 using CLI, 207

using GUI, 205 using sapdba, 208

RMAN, Oracle integration, 62 backup, 66

restore, 93

scripts, examples, 66 RMAN, SAP R/3 integration

backup, 191 backup flow, 155 restore flow, 157

running backups See starting backups

S

SAP DB backup, 281–289backup concepts, scheme, 258 backup flow, 256

backup methods, 281 backup modes, 252, 253 backup options, 270

backup specifications, creating, 264 differential backups, 252

full backups, 252 scheduling backups, 281 starting backups, 281–289starting backups, using CLI, 285 starting backups, using GUI, 284

starting backups, using SAP DB utilities,

286

transactional backups, 252 SAP DB configuration, 263–280

checking configuration, 276 overview, 263

users, configuring, 263 SAP DB integration

advantages, 254 backup, 281–289backup flow, 256 concepts, 256–258

concepts, parallelism, 254, 257 configuration, 263–280configuration files, 259–262

I- 4

Image 394

HP OpenView Storage B6960-96008 manual

Contents

HP OpenView Storage Data Protector Integration Guide Copyright 2006 Hewlett-Packard Development Company, L.PLegal Notices Contents Integrating SAP R/3 and Data Protector Integrating SAP DB/MaxDB and Data Protector Glossary Index Edition History Part Number Manual Edition Product ViiViii New terms Data Protector Cell Manager is the main When entering a You supply your login name CommandCommand names Use the grep command File and directory Text and items on System replies Press Computer screenProtector graphical user interface Data Protector Graphical User InterfaceDocumentation GeneralInformation Technical Support FeedbackXii Manuals XiiiHP OpenView Storage Data Protector Integration Guide XivPage Online Help XviAbbreviation Manual Documentation MapAbbreviations XviiMap XviiiIntegration Guide IntegrationsXix Page Audience XxiOrganization XxiiIntegrating Oracle and Data This Chapter Oracle Data Guard environment, backup of standby database IntroductionDuplicating a Restore TypesDatabase Integration Concept Oracle Backup Manager User’s GuideIntegration Concept Rman CLI Data Protector Oracle Integration Concept Data, used devices, and media is written IDB where all the information about DataProtector sessions, including session messages, objects Data Protector General Media Agent, which readsConfiguring the Integration PrerequisitesLimitations Before You Begin Oracle Data GuardLinking Oracle with the Data Protector Oracle Cluster-Aware ClientsIntegration Media Management Library MML on Filenames for the MML on Different Platforms SYS$SHARELIBOBK2SHR32.EXE Oracle9i with the Oracle Server Linking Oracle with MML on OpenVMS SystemsOn Oracle Server systems running on OpenVMS, link the MML Edit the following filesORARDBMSLORACLE64.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 Configuring Oracle Users on Unix and OpenVMS After RelinkingFinding the Oracle User OpenVMSUncomment the following lines in OMNI$ROOTLOGLOGIN.COM Verify the changes of the group IDVerify that the -key Oracle8 entry is present Configuring Oracle DatabasesProcedure If the entry is not present, copy it fromConfiguring Oracle General Windows Using the Data Protector GUIPathname of the Oracle Server home directory Configuring Oracle General Unix Configuring Oracle Primary Instance Configuring Oracle CatalogSpecify the login information to the standby database Database instanceConfiguring Oracle Standby Using the Data Protector CLIOn Windows WhereParameter Description What Happens After the Configuration? SyntaxChecking the Configuration OpenVMS OMNI$ROOTBIN runTo get the error description Windows On the Cell Manager, see the fileInformation, see Troubleshooting on Cluster-Aware Configuring an Oracle BackupCreating a New Template ClientsCreating a Data Protector Oracle Backup Specification DirectDatabase DatabaseSwitchArchiveDelSMBBackupSetDatabase SMBProxyDatabaseSpecifying an Oracle Server System Windows Specifying an Oracle Server System Unix Specification Selecting Backup ObjectsData Protector Oracle integration backup to tape Set the backup optionsFlash recovery area in the Pre-execor Post-exectext box. Application Options, see the online Help11Oracle 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 Editing the Oracle Rman Script LimitationsData Protector Rman Script Structure BackupSpecificationNameDBNAME%s%t%p.dbf Variables and DBNAME, which are obligatory Rman current controlfile commandWhole database selection Oracle Duplex Mode Example Creating Copies of Backed Up ObjectsTesting the Integration Testing Using the Data Protector GUI13Previewing a Backup Testing Using the CLI Run the omnib command with the -testbaroption as followsConfiguring an Oracle Backup Backing Up an Oracle Database Oracle Online Start SQL*Plus and type alter database archivelog If Pfile is usedRecovery Scheduling a BackupBackup Procedure CatalogBacking Up an Oracle Database Starting a Backup Using the GUI Running an Interactive BackupClick OK and then Apply to save the changes OpenVMS To set up the CLI, run HP-UX and Solaris /opt/omni/binYou can select among the following listoptions Starting Oracle Backup Using RmanFollowing command See the omnib man page for detailsTarget Database The format of the target database login is Tape in the second case If you specify more than a single allocate channel commandCommands is handled internally by Rman AllocatedUse rcvcat instead of catalog in the above syntax Examples of the Rman Scripts ParallelParticular Flash RecoveryBacking Up Archived LogsIncluding Control File in a BackupSpecification Backing Up WhileOn Windows Duplicating Restoring an Oracle DatabaseRestorable Items Databases16Taking the Oracle Resource Group Offline Restoring Oracle Using the Data Protector GUI Restoring Database Items in a Disaster RecoveryDatabase, ensure that the database is in the correct state Required Database States Item to restore Database stateChanging The Database State To put the database into NoMount state, runRestoring the Recovery Catalog Database 18Recovery Catalog Settings Dialog After the restore, run the following script Restoring the Control FileEnsure that you have properly configured the Rman autobackup Restoring Oracle Database Objects Oracle Data Guard If you restore a primary database from a Results Area, select objects for restoreRestore As dialog box, specify the new datafile location SourceConverts them appropriately Login information for the primary database. If you restoreSame can be done if you set the Dbfilenameconvert Will be usedOptions Devices If you are restoring a tablespace enter Restoring Tablespaces and DatafilesIf you are restoring a datafile enter Restoring and Recovering a Primary Database Restoring and Recovering a Standby DatabaseLimitation Duplicating an Oracle DatabasePrerequisites Restore Action drop-down list, select Perform Duplication 22Oracle Duplicate Options Restore, Recovery, and Duplicate Options General Options Client SettingsRestore mode This drop-down list allows you to specify which typeDuplicate Options DorecoverParallelism For StandbyTo database name Restore and Recovery Options Restore untilNofilenamecheck Recover until Opens the database after a recovery is performed Restoring Oracle Using RmanOpen database after recovery Reset logsPreparing the Oracle Database for Restore Windows Example Unix ExampleConnection Strings Used in the Examples Example of Full Database Restore and Recovery Start the full database restore and recovery runExample of Point-in-Time Restore Start the point-in-time restore run Example of Tablespace Restore and Recovery 100Chapter 101 Example of Datafile Restore and Recovery 102Unix Windows104 Example of Archive Log Restore Start the archive log restore run 106Restoring the Recovery Catalog Restoring Oracle Using CLIIf you are using an sh like shell, run Restoring Using Another Device 108Disaster Recovery Monitoring Current Sessions Monitoring an Oracle Backup and Restore110 Viewing Previous Sessions Windows DataProtectorhome\log\oracle8.log112 On OpenVMS Systems Removing the Data Protector Oracle Integration LinkOracle 114 Cases Troubleshooting 116Checking Prerequisites Related to the Oracle Side General TroubleshootingProblem Integration on Unix SystemsIf this fails, open the Oracle target database If this fails, open the recovery catalogStart SQL*Plus from the Oraclehome directory 118Then 120 Chapter 121 23Checking the Status of the Oracle Listener 122Connect 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 Verify the inet startup parameters 128Backup Problems on Unix Systems Check your Oracle Server configurationFollowing errors are listed in the Data Protector monitor Data Protector reports Export of the Recovery CatalogDatabase Failed when backing up Oracle On other Unix systemsBackup Fails After a Point in Time Restore and Recovery Data Protector reports Cannot allocate/attach shared memoryBackup of Archive Logs on RAC Cannot be Performed 132SYS.LTEXPORTPKG.schemainfexp during Oracle 9i/10g Backup Problems on WindowsData Protector reports errors when calling BackupRecovery catalog 134Verify 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 Tape Recovery Catalog was lost and the control file cannot beRestored from Data Protector managed backup Following SQL scriptLoaded Problem occurs with Oracle8i on HP-UXShared library that provides thread local storage cannot be Following is displayedLibrary libjava.sl that provides thread local storage Problem occurs when the Radius Authentication Adapter isRadius Authentication Adapter From the list of dynamic libraries for libclntsh.sl. See142 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 Brbackup UtilitiesSoftware Data Protector Zero Downtime Backup Administrator’s GuideData Protector 150SAP R/3 Backup Concept ArchitectureSAP R/3 Architecture Backint Mode Backup FlowUsing Backint 152Data Protector Restore Media Agent Data Protector Backup Media AgentData Protector User Interface DataProtectorhome\tmp on Windows if the variable is not SapbackupFinished data transfer, the BSM waits for a timeout Protector is limited toBackup 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 This is an example of the file 160File Parameters Using the CLI Setting, Retrieving, Listing, and Deleting DataProtector SAP R/3 Configuration Command162 Protector SAP R/3 client SettingParameters HP-UX and SolarisDeleting SAP R/3 instance ICE, use the following command on the DataListing Parameters 164Overviewsteps Group SAP R/3 database using Data ProtectorSAP R/3 database backup with Data Protector 166Clients on Configuring an SAP R/3 Database ServerBefore You Begin Windows/UNIX168 User Account on Data Protector InetUtilsap.exe Is the directory in which Oracle binaries are installed Using the CLI Unix Systems Only170 Chapter 171 Windows 172Unix Configuring an SAP R/3 Database Server on Unix Configuring an SAP R/3 Database Server on Windows174 Checking ConfigurationWhat Happens? Data Protector GUITarget database must be online during the check 176Checking the SAP R/3 Configuration Data Protector CLI178 Configuring an SAP R/3 Backup Creating a Data Protector SAP R/3 Backup Specification 180BrbackupRMANOffline BrbackupRMANOnline10Selecting Backup Objects 182Specify any SAP R/3 backup options, the current settings Backing Up Using Recovery Manager on11SAP R/3 Backup Options 184Chapter 185 Logs? SAP R/3 Specific Backup OptionsBR Backup Log fileBalancing By Load Backup ObjectsBR Archive Balancing By TimePre-exec Balancing ManualBalancing None 188Backup mode Post-execObjects outside database Creating or Modifying the Parameter File on the SAPDatabase Server 190Benefits Backing Up Using Recovery ManagerIncrementally Backup 192Manual Balancing of Files into Subsets Backups if UsingIncremental Balancing Creating an SAP /R3 Backup Specification for Manual194 Backup specification then looks like SID file Unix systems, orTesting Using the Data Protector CLI 196Backing Up an SAP R/3 Database Backup Methods Duplicate SIDs Backup ModesBackups Tools version 4.5 and laterRunning Session Aborting an SAP R/3 Backup SessionAborting a 198Session options. See Figure Starting a Backup Using the GUI 200An interactive backup can also be started from the CLI Cluster-Aware ClientsAccount 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 16Restoring SAP R/3 Database Objects 206Where FileName must be specified as follows Restoring Using the Data Protector CLIUsing the CLI, execute the following command Set to restore from automaticallyCommands 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 Restored Run the following scriptMonitoring an SAP R/3 Backup and Restore 212Stored in the IDB Previous SessionsScoping Pane, expand Sessions to display all the sessions ID consisting of a date in the YY/MM/DD format and a uniqueCorrectly OpenView Storage Data Protector Troubleshooting GuideOracle9i 214Troubleshooting on Windows Systems Prerequisites Concerning the Oracle Side of the IntegrationAt the Svrmgr prompt, type 216If you are not using the recovery catalog Prerequisites on the SAP R/3 Side of the IntegrationConfiguration Problems 218Run 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 Check your SAP R/3 Server configuration Examine system errorsBackup Problems *RETVAL*0 indicates successful configurationIf the test fails again, call support Restore Problems 222Chapter 223 Actions Verify the restore using backint224 Troubleshooting on Unix Systems Do not use non-ASCII or non-Latin 1 characters for filenamesIf it fails, open the Oracle Target Database At the Svrmgr Oracle8/8i or SQL Oracle9i prompt, type226 If you use the Recovery Catalog An example of the rmanscript is listed below 228Which is provided by Data Protector 230 Solaris platform Verify the permissions of the currently used user account 232Chapter 233 Error Verify the backup using backint234 Verify that a backup object exists on the backup media UtilFileOnline SAP backup fails with semop errorVerify a user for the restore IDB236 BarbackupspecificationnameHP-UX and Solaris systems or Verify the restore using backint Run the following commandUse SAP R/3 commands for example, brrestore to restore these 238Examples of SAP R/3 Database Restore Preparing the SAP R/3 Database for Restore240 Example of Full Database Restore and Recovery When the menu appears, select the Restore/Recovery option 242Chapter 243 Was recovered, run the Alter Database Open command with 244Example of Partial Restore Example of Lost Files RestoreThis means that the existing file can be used 246Lost 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 Automatic Log Backup must be activated for an Aware of before using the integrationArchitectures and how to install the Data Protector SAP DB/MaxDB instance to enable transactional backup log252 Restore GUISupported ParallelismPermissions PlatformsChapter 255 Interfaces 256Restore Flow SAP DB/MaxDB Backup and Restore Concept 258Data Protector SAP DB/MaxDB Configuration File Configuration File Setting, Retrieving, and Listing Data Protector SAPDB/MaxDB Configuration File Parameters Using 260Optionname is the name of the parameter Command output is written to. If the -localoption is notSAP DB/MaxDB configuration file Optionvalue is the value for the parameter262 Configuring Users Creating a Backup Specification Configuring an SAP DB/MaxDB Backup264 Chapter 265 Selecting an SAP DB Server and Instance on Unix Systems 266Selecting an SAP DB Server and Instance on Windows Systems Interactively. See Backing Up an SAP DB/MaxDB Database on To backup SAP DB/MaxDB archive logs, select the Data itemBackup interactively Selecting SAP DB ObjectsSaving the Backup Specification SAP DB/MaxDB Specific Backup Options 270Backup Options 272 Chapter 273 Using the CLI Modifying the Configuration of an SAP DB/MaxDB Instance274 Instance to be configured Then execute the following commandSpecified during the installation Described in Configuring Users onChecking the Configuration of an SAP DB/MaxDB Instance 276Checking the Configuration of an SAP DB/MaxDB Instance Using the GUIIt before running a backup To check the configuration, run the following command onIf an error occurs, it is explained SAP DB/MaxDB Server systemPreviewing a Backup Description of these options, press F1280 Backup Methods Scheduling Procedure Scheduling an Existing Backup SpecificationBacking Up an SAP DB/MaxDB Database 282 Scheduling the Backup Specification Running an Interactive Backup Using the Data Protector GUI 284Running an Interactive Backup Using the Data Protector CLI 10Starting an Interactive BackupDB/MaxDB Utilities Running an Interactive Backup Using SAP286 Chapter 287 288 Chapter 289 Restoring an SAP DB/MaxDB Database Restore and Recovery Overview290 Mode, SAP DB/MaxDB always checks whether such a gap exists From the selected backup session is restored. The data onSelected backup session are restored SAP DB/MaxDB Server is overwrittenSAP DB/MaxDB Restore Process 292Chapter 293 SAP DB/MaxDB Migration Prerequisites 294Chapter 295 Properties for Data Dialog Box 296Finding Information Needed for a Restore Restoring Command Syntax an SAP DB/MaxDB instanceTo get a list of SAP DB/MaxDB objects 298Restoring Using SAP DB/MaxDB Utilities Finding Information Needed for Restore300 Chapter 301 302 SAP DB/MaxDB Migration SAP DB/MaxDB Restore and Recovery Options 304Chapter 305 Recovery Options 306Refer to Restoring Using the Data Protector CLI on 308 Chapter 309 Monitoring an SAP DB/MaxDB Backup Restore 310Media used for this session, respectively. See Figure 17Viewing a Previous Session 312Data Protector reports the following error during backup or ProblemsRestore Data Protector reports the following error An SAP DB/MaxDB instance cannot be started after restoreRestore from an object copy hangs 314Start the SAP DB/MaxDB xserver. Refer to the SAP DB/MaxDB Documentation for information on how to do thatTask command. Finish these tasks Start the SAP DB/MaxDB instance. Refer to the SAP DB/MaxDBSAP DB/MaxDB Cluster-Related Troubleshooting 316Glossary Backup generation Backup APIBackup chain See restore chain Backup device Backup IDBackup session Backup objectBackup owner See also incremental backup and full backup Backup setInstant copies of EMC Symmetrix standard devices Backup system ZDB specific termSee also replica, source volume, snapshot, and CA+BC EVA See also BCV BC HP StorageWorks Disk Array XP specific termBrrestore Boot volume/disk/partitionSee also SAPDBA, Brbackup BC Process EMC Symmetrix specific termBrarchive BSM See also BC EVA, replica, and source volumeSee also SAPDBA, Brarchive CA HP StorageWorks Disk Array XP specific termCDB Cmmdb CRS CSMData Protector user account Data protectionSee also catalog protection Data Protector Event Log Data streamDcbf See also backup types Differential database backup Differential backupSee incremental backup Differential backup MS SQL specific Direct backupDisk Agent concurrency Disk image rawdisk backupSee also virtual full backup Disk discoveryDMZ DR OSEnterprise Backup Environment Emergency boot file Informix ServerEnhanced incremental backup Event LogsFibre Channel bridge File Replication Service FRSFC bridge See Fibre Channel bridge File depotSee also backup types Full database backup See also recovery files Fnames.datFull backup Full mailbox backupHierarchical Storage Management HSM See also incremental ZDB Global options fileHeartbeat Holidays fileHP ITO HP OVOHP VPO LUNIDB Incremental re-establish EMC Incremental1 mailbox backupIncremental restore EMC Symmetrix Incremental ZDBRefers to Informix Dynamic Server Initializing See formatting Installation ServerInformix Server Informix Server specific term Integration objectJukebox See library Jukebox device IP addressITO LibraryLock name Local and remote recoveryLoad balancing Logfull shell script Informix ServerLogical-log files Login information to the Oracle TargetAn interface for the exchange of backup Database Oracle and SAP R/3 specific termMailbox Microsoft Exchange Server specific term LVMMagic Packet See Wake Onlan Mailbox Store Microsoft Exchange Server specific termMedia condition factors Media allocation policyMedia condition Media IDMMD MmdbMSM Object copy session Offline backupObject copy Object copyingSee also zero downtime backup ZDB and offline backup Onconfig Informix Server specific termOnline backup Offline redo log See archived redo logOVO P1S file Package MC/ServiceGuard and Veritas Cluster specific termOwnership Pair status HP StorageWorks Disk Array XP specific termPrimary Volume P-VOL HP Parallel restorePre- and post-exec commands Physical deviceRAID Rawdisk backup See disk image backupPublic/private backed up data RAID Manager XP HP StorageWorks Disk Array XP specific termSee also flash recovery area RecoveryInfo Recovery Catalog Oracle specificRecovery Catalog Database Oracle Recovery Manager Rman OracleRecycle Removable Storage ManagementScan Restore sessionRSM ScanningSee also shadow copy SchedulerSession key Shadow copy set MS VSS specific termSMB SibfSmbf See also target R2 device Creation Split mirror backup EMC SymmetrixSource R1 device EMC Symmetrix See also ZDB to tape, ZDB to disk+tape, and replicaSt.conf file SRD fileSst.conf file StackersStandard security MS SQL specific Switchover See failover Sybase Backup Server API SybaseSynthetic backup See also integrated security Storage GroupSystem volume/disk/partition Synthetic full backupSystem Backup to Tape Oracle System databases Sybase specificTarget R2 device EMC Symmetrix Terminal Services Windows specificTablespace See also source R1 deviceTLU User group Unattended operation See lights-out operation User accountUser disk quotas User rightsVirtual Controller Software VCS Volume groupVerify Virtual Device Interface MS SQL Server specific termVPO VSSSee zero downtime backup ZDB See also direct backupWriter Zero downtime backup ZDB ZDB to tape ZDB specific termGlossary Index IndexBRARCHIVE, 149 Index 286 Index 281-289