Integrating Oracle and Data | HP OpenView Storage B6960-96008

1	Integrating Oracle and Data
	Protector

Chapter 1

Page 23

Image 23

HP OpenView Storage B6960-96008 manual Integrating Oracle and Data

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 Xix IntegrationsIntegration Guide Page Xxi Audience Xxii Organization Integrating Oracle and Data This Chapter Introduction Oracle Data Guard environment, backup of standby database Database Restore TypesDuplicating a 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 Integration Media Management Library MML on Cluster-Aware ClientsLinking Oracle with the Data Protector Oracle 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 Documentation for OpenVMS When you are prompted for the root directory, enterUsername and password. For more information, see the Oracle Oracle documentation for OpenVMS Options marked by Y will be selectedRelinking process 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 Pathname of the Oracle Server home directory Using the Data Protector GUIConfiguring Oracle General Windows 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 Post-Exec Examples of Pre-Exec and Post-Exec Scripts on UnixPre-Exec Example Limitations Editing the Oracle Rman Script Data Protector Rman Script Structure BackupSpecificationNameDBNAME%s%t%p.dbf Whole database selection Rman current controlfile commandVariables and DBNAME, which are obligatory 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 Click OK and then Apply to save the changes Running an Interactive BackupStarting a Backup Using the GUI 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 datafile enter Restoring Tablespaces and DatafilesIf you are restoring a tablespace enter Restoring and Recovering a Standby Database Restoring and Recovering a Primary Database Prerequisites Duplicating an Oracle DatabaseLimitation 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 Nofilenamecheck Restore and Recovery Options Restore untilTo database name 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 If you are using an sh like shell, run Restoring Oracle Using CLIRestoring the Recovery Catalog 108 Restoring Using Another Device Disaster Recovery 110 Monitoring an Oracle Backup and RestoreMonitoring Current Sessions Windows DataProtectorhome\log\oracle8.log Viewing Previous Sessions 112 Oracle Removing the Data Protector Oracle Integration LinkOn OpenVMS Systems 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 Verify the permissions of the current user account Configuration Problems on Windows SystemsExamine the system errors 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 Simulate a restore session Restore ProblemsVerify that an object exists on the backup media 136 Other UnixEnsure that the database is in the correct state Restart Data Protector Try using the Rman CLI to restore the database itemsCheck your environment variables 138 Browsing Oracle 9i database for restore on LinuxBinary utilorarest failed error message is displayed when 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 Advantages Refer to the HP OpenView Storage Data Protector ProductAnnouncements, Software Notes, and References or 146 Software Notes, and References or Prerequisites and LimitationsHP OpenView Storage Data Protector Product Announcements 148 CommandsUser since the backups will not work 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 User Interface Data Protector Backup Media AgentData Protector Restore Media Agent 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 156 SAP R/3 Architecture Rman ModeData Protector Backup General Media Agent Restore Flow Using Recovery Manager 158 Data Protector SAP R/3 Configuration FileOn Windows 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 Utilsap.exe Data Protector InetUser Account on 170 Using the CLI Unix Systems OnlyIs the directory in which Oracle binaries are installed Chapter 171 172 Windows Unix 174 Configuring an SAP R/3 Database Server on WindowsConfiguring an SAP R/3 Database Server on Unix 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 Incrementally Backing Up Using Recovery ManagerBenefits 192 Backup Incremental Backups if UsingManual Balancing of Files into Subsets 194 Creating an SAP /R3 Backup Specification for ManualBalancing 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 Windows 202 Using SAP R/3 CommandsAccount on Chapter 203 204 Restoring an SAP R/3 DatabaseConsiderations To get a list of SAP R/3 objects Finding Information Needed for RestoreRestoring Using the Data Protector GUI 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 208 Restoring Using the SAP R/3 CommandsCommands Restoring Using the Data Protector CLI or SAP R/3 Commands Using Another DeviceRestoring Using the Data Protector GUI 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 \\clientname\sapmnt\ORACLESID\SYS\exe\run\brbackup or Perform a filesystem backup of the SAP R/3 Database ServerRun the following command if you use the default directory *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 224 Verify the restore using backintActions Do not use non-ASCII or non-Latin 1 characters for filenames Troubleshooting on Unix Systems 226 At the Svrmgr Oracle8/8i or SQL Oracle9i prompt, typeIf it fails, open the Oracle Target Database 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 234 Verify the backup using backintError 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 To restore the archive log files, follow the steps below Example of Archive Log Files RestoreLost files are restored using the SAP utility Brrestore 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 264 Configuring an SAP DB/MaxDB BackupCreating a Backup Specification 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 274 Modifying the Configuration of an SAP DB/MaxDB InstanceUsing the CLI 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 Backing Up an SAP DB/MaxDB Database Scheduling an Existing Backup SpecificationBackup Methods Scheduling Procedure 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 286 Running an Interactive Backup Using SAPDB/MaxDB Utilities Chapter 287 288 Chapter 289 290 Restore and Recovery OverviewRestoring an SAP DB/MaxDB Database 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 Restore ProblemsData Protector reports the following error during backup or 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 IDB LUNHP VPO 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 Smbf SibfSMB 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 Writer See also direct backupSee zero downtime backup ZDB ZDB to tape ZDB specific term Zero downtime backup ZDB Glossary Index Index BRARCHIVE, 149 Index 286 Index 281-289