Manuals / HP / Household Appliance / Garage Door Opener

HP OpenView Storage B6960-96008 manual Cases

Models: OpenView Storage B6960-96008

1 396

Page 137

	Integrating Oracle and Data Protector
	Oracle RMAN Metadata and Data Protector Media Management Database
	Synchronization

TIP	It is recommended that synchronization be performed in the following
	cases:
	• after a Data Protector import or export of media with Oracle objects
	and
	• whenever protection for media with Oracle objects has expired.

Chapter 1

115

Page 137

Image 137

HP OpenView Storage B6960-96008 manual Cases

Contents

Copyright 2006 Hewlett-Packard Development Company, L.P HP OpenView Storage Data Protector Integration GuideLegal 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 ProductViii Command names Use the grep command File and directory When entering a You supply your login name CommandNew terms Data Protector Cell Manager is the main Text and items on System replies Press Computer screenData Protector Graphical User Interface Protector graphical user interfaceInformation Technical Support GeneralDocumentation FeedbackXii Xiii ManualsXiv HP OpenView Storage Data Protector Integration GuidePage Xvi Online HelpAbbreviations Documentation MapAbbreviation Manual XviiXviii MapXix IntegrationsIntegration Guide Page Xxi AudienceXxii OrganizationIntegrating Oracle and Data This Chapter Introduction Oracle Data Guard environment, backup of standby databaseDatabase Restore TypesDuplicating a Integration Concept Manager User’s Guide Oracle BackupIntegration Concept Rman CLI Data Protector Oracle Integration Concept Protector sessions, including session messages, objects IDB where all the information about DataData, used devices, and media is written Data Protector General Media Agent, which readsPrerequisites Configuring the IntegrationLimitations Oracle Data Guard Before You BeginIntegration Media Management Library MML on Cluster-Aware ClientsLinking Oracle with the Data Protector Oracle Filenames for the MML on Different Platforms On Oracle Server systems running on OpenVMS, link the MML Linking Oracle with MML on OpenVMS SystemsSYS$SHARELIBOBK2SHR32.EXE Oracle9i with the Oracle Server Edit the following filesORARDBMSLORACLE64.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 OpenVMSOpenVMS Finding the Oracle UserVerify the changes of the group ID Uncomment the following lines in OMNI$ROOTLOGLOGIN.COMProcedure Configuring Oracle DatabasesVerify that the -key Oracle8 entry is present If the entry is not present, copy it fromPathname of the Oracle Server home directory Using the Data Protector GUIConfiguring Oracle General Windows Configuring Oracle General Unix Configuring Oracle Primary Specify the login information to the standby database Configuring Oracle CatalogInstance Database instanceUsing the Data Protector CLI Configuring Oracle StandbyWhere On WindowsParameter Description Syntax What Happens After the Configuration?OpenVMS OMNI$ROOTBIN run Checking the ConfigurationWindows On the Cell Manager, see the file To get the error descriptionInformation, see Troubleshooting on Creating a New Template Configuring an Oracle BackupCluster-Aware ClientsCreating a Data Protector Oracle Backup Specification SMBBackupSetDatabase DatabaseSwitchArchiveDelDirectDatabase SMBProxyDatabaseSpecifying an Oracle Server System Windows Specifying an Oracle Server System Unix Selecting Backup Objects SpecificationFlash recovery area in the Pre-execor Post-exectext box. Set the backup optionsData Protector Oracle integration backup to tape Application Options, see the online Help11Oracle 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 ScriptData 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 ExampleTesting Using the Data Protector GUI Testing the IntegrationRun the omnib command with the -testbaroption as follows 13Previewing a Backup Testing Using the CLIConfiguring an Oracle Backup Backing Up an Oracle Database Oracle Online If Pfile is used Start SQL*Plus and type alter database archivelogBackup Procedure Scheduling a BackupRecovery CatalogBacking 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, runFollowing command Starting Oracle Backup Using RmanYou can select among the following listoptions See the omnib man page for detailsTarget Database The format of the target database login is Commands is handled internally by Rman If you specify more than a single allocate channel commandTape in the second case AllocatedUse rcvcat instead of catalog in the above syntax Parallel Examples of the Rman ScriptsBacking Up Flash RecoveryParticular Archived LogsSpecification File in a BackupIncluding Control Backing Up WhileOn Windows Restorable Items Restoring an Oracle DatabaseDuplicating Databases16Taking the Oracle Resource Group Offline Restoring Database Items in a Disaster Recovery Restoring Oracle Using the Data Protector GUIChanging The Database State Required Database States Item to restore Database stateDatabase, ensure that the database is in the correct state To put the database into NoMount state, runRestoring the Recovery Catalog Database 18Recovery Catalog Settings Dialog Restoring the Control File After the restore, run the following scriptEnsure that you have properly configured the Rman autobackup Restoring Oracle Database Objects Restore As dialog box, specify the new datafile location Results Area, select objects for restoreOracle Data Guard If you restore a primary database from a SourceSame can be done if you set the Dbfilenameconvert Login information for the primary database. If you restoreConverts them appropriately Will be usedOptions 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 DatabasePrerequisites Duplicating an Oracle DatabaseLimitation Restore Action drop-down list, select Perform Duplication 22Oracle Duplicate Options Restore, Recovery, and Duplicate Options Restore mode SettingsGeneral Options Client This drop-down list allows you to specify which typeParallelism DorecoverDuplicate Options For StandbyNofilenamecheck Restore and Recovery Options Restore untilTo database name Recover until Open database after recovery Restoring Oracle Using RmanOpens the database after a recovery is performed Reset logsPreparing the Oracle Database for Restore Unix Example Windows ExampleConnection Strings Used in the Examples Start the full database restore and recovery run Example of Full Database Restore and RecoveryExample of Point-in-Time Restore Start the point-in-time restore run 100 Example of Tablespace Restore and RecoveryChapter 101 102 Example of Datafile Restore and RecoveryWindows Unix104 Example of Archive Log Restore 106 Start the archive log restore runIf you are using an sh like shell, run Restoring Oracle Using CLIRestoring the Recovery Catalog 108 Restoring Using Another DeviceDisaster Recovery 110 Monitoring an Oracle Backup and RestoreMonitoring Current Sessions Windows DataProtectorhome\log\oracle8.log Viewing Previous Sessions112 Oracle Removing the Data Protector Oracle Integration LinkOn OpenVMS Systems 114 Cases 116 TroubleshootingProblem General TroubleshootingChecking Prerequisites Related to the Oracle Side Integration on Unix SystemsStart SQL*Plus from the Oraclehome directory If this fails, open the recovery catalogIf this fails, open the Oracle target database 118Then 120 Chapter 121 122 23Checking the Status of the Oracle ListenerConnect 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 parametersCheck your Oracle Server configuration Backup Problems on Unix SystemsDatabase Failed when backing up Oracle Data Protector reports Export of the Recovery CatalogFollowing errors are listed in the Data Protector monitor On other Unix systemsData Protector reports Cannot allocate/attach shared memory Backup Fails After a Point in Time Restore and Recovery132 Backup of Archive Logs on RAC Cannot be PerformedData Protector reports errors when calling Backup Problems on WindowsSYS.LTEXPORTPKG.schemainfexp during Oracle 9i/10g Backup134 Recovery catalogSimulate 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 Restored from Data Protector managed backup Recovery Catalog was lost and the control file cannot beTape Following SQL scriptShared library that provides thread local storage cannot be Problem occurs with Oracle8i on HP-UXLoaded Following is displayedRadius Authentication Adapter Problem occurs when the Radius Authentication Adapter isLibrary libjava.sl that provides thread local storage From the list of dynamic libraries for libclntsh.sl. See142 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 BrbackupData Protector Data Protector Zero Downtime Backup Administrator’s GuideSoftware 150Architecture SAP R/3 Backup ConceptUsing Backint Backup FlowSAP R/3 Architecture Backint Mode 152Data Protector User Interface Data Protector Backup Media AgentData Protector Restore Media Agent Finished data transfer, the BSM waits for a timeout SapbackupDataProtectorhome\tmp on Windows if the variable is not Protector is limited toBackup 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 fileProtector SAP R/3 Configuration Setting, Retrieving, Listing, and Deleting DataFile Parameters Using the CLI Command162 Parameters SettingProtector SAP R/3 client HP-UX and SolarisListing Parameters SAP R/3 instance ICE, use the following command on the DataDeleting 164Overviewsteps SAP R/3 database backup with Data Protector SAP R/3 database using Data ProtectorGroup 166Before You Begin Configuring an SAP R/3 Database ServerClients on Windows/UNIX168 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 WindowsUnix 174 Configuring an SAP R/3 Database Server on WindowsConfiguring an SAP R/3 Database Server on Unix What Happens? ConfigurationChecking Data Protector GUI176 Target database must be online during the checkData Protector CLI Checking the SAP R/3 Configuration178 Configuring an SAP R/3 Backup 180 Creating a Data Protector SAP R/3 Backup SpecificationBrbackupRMANOnline BrbackupRMANOffline182 10Selecting Backup ObjectsBacking Up Using Recovery Manager on Specify any SAP R/3 backup options, the current settings184 11SAP R/3 Backup OptionsChapter 185 BR Backup SAP R/3 Specific Backup OptionsLogs? Log fileBR Archive Backup ObjectsBalancing By Load Balancing By TimeBalancing None Balancing ManualPre-exec 188Post-exec Backup modeDatabase Server Creating or Modifying the Parameter File on the SAPObjects outside database 190Incrementally Backing Up Using Recovery ManagerBenefits 192 BackupIncremental 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 like196 Testing Using the Data Protector CLIBackups Backup Methods Duplicate SIDs Backup ModesBacking Up an SAP R/3 Database Tools version 4.5 and laterAborting a Aborting an SAP R/3 Backup SessionRunning Session 198Session options. See Figure 200 Starting a Backup Using the GUICluster-Aware Clients An interactive backup can also be started from the CLIWindows 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 ObjectsUsing the CLI, execute the following command Restoring Using the Data Protector CLIWhere FileName must be specified as follows Set to restore from automatically208 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 Restored212 Monitoring an SAP R/3 Backup and RestoreScoping Pane, expand Sessions to display all the sessions Previous SessionsStored in the IDB ID consisting of a date in the YY/MM/DD format and a uniqueOracle9i OpenView Storage Data Protector Troubleshooting GuideCorrectly 214Prerequisites Concerning the Oracle Side of the Integration Troubleshooting on Windows Systems216 At the Svrmgr prompt, typePrerequisites on the SAP R/3 Side of the Integration If you are not using the recovery catalog218 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 Backup Problems Examine system errorsCheck your SAP R/3 Server configuration *RETVAL*0 indicates successful configurationIf the test fails again, call support 222 Restore ProblemsChapter 223 224 Verify the restore using backintActions Do not use non-ASCII or non-Latin 1 characters for filenames Troubleshooting on Unix Systems226 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 belowWhich is provided by Data Protector 230 Solaris platform 232 Verify the permissions of the currently used user accountChapter 233 234 Verify the backup using backintError Verify a user for the restore UtilFileOnline SAP backup fails with semop errorVerify that a backup object exists on the backup media IDB236 Verify the restore using backint Run the following command BarbackupspecificationnameHP-UX and Solaris systems or238 Use SAP R/3 commands for example, brrestore to restore thesePreparing the SAP R/3 Database for Restore Examples of SAP R/3 Database Restore240 Example of Full Database Restore and Recovery 242 When the menu appears, select the Restore/Recovery optionChapter 243 244 Was recovered, run the Alter Database Open command withExample of Lost Files Restore Example of Partial Restore246 This means that the existing file can be usedTo 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 Architectures and how to install the Data Protector Aware of before using the integrationSAP DB/MaxDB Automatic Log Backup must be activated for an SAP DB/MaxDB instance to enable transactional backup log252 GUI RestorePermissions ParallelismSupported PlatformsChapter 255 256 InterfacesRestore Flow 258 SAP DB/MaxDB Backup and Restore ConceptData Protector SAP DB/MaxDB Configuration File DB/MaxDB Configuration File Parameters Using Setting, Retrieving, and Listing Data Protector SAPConfiguration File 260SAP DB/MaxDB configuration file Command output is written to. If the -localoption is notOptionname is the name of the parameter Optionvalue is the value for the parameter262 Configuring Users 264 Configuring an SAP DB/MaxDB BackupCreating a Backup Specification Chapter 265 266 Selecting an SAP DB Server and Instance on Unix SystemsSelecting an SAP DB Server and Instance on Windows Systems Backup interactively To backup SAP DB/MaxDB archive logs, select the Data itemInteractively. See Backing Up an SAP DB/MaxDB Database on Selecting SAP DB ObjectsSaving the Backup Specification 270 SAP DB/MaxDB Specific Backup OptionsBackup Options 272 Chapter 273 274 Modifying the Configuration of an SAP DB/MaxDB InstanceUsing the CLI Specified during the installation Then execute the following commandInstance to be configured Described in Configuring Users on276 Checking the Configuration of an SAP DB/MaxDB InstanceUsing the GUI Checking the Configuration of an SAP DB/MaxDB InstanceIf an error occurs, it is explained To check the configuration, run the following command onIt before running a backup SAP DB/MaxDB Server systemDescription of these options, press F1 Previewing a Backup280 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 GUI10Starting an Interactive Backup Running an Interactive Backup Using the Data Protector CLI286 Running an Interactive Backup Using SAPDB/MaxDB Utilities Chapter 287 288 Chapter 289 290 Restore and Recovery OverviewRestoring an SAP DB/MaxDB Database Selected backup session are restored From the selected backup session is restored. The data onMode, SAP DB/MaxDB always checks whether such a gap exists SAP DB/MaxDB Server is overwritten292 SAP DB/MaxDB Restore ProcessChapter 293 294 SAP DB/MaxDB Migration PrerequisitesChapter 295 296 Properties for Data Dialog BoxFinding Information Needed for a Restore To get a list of SAP DB/MaxDB objects Command Syntax an SAP DB/MaxDB instanceRestoring 298Finding Information Needed for Restore Restoring Using SAP DB/MaxDB Utilities300 Chapter 301 302 SAP DB/MaxDB Migration 304 SAP DB/MaxDB Restore and Recovery OptionsChapter 305 306 Recovery OptionsRefer to Restoring Using the Data Protector CLI on 308 Chapter 309 310 Monitoring an SAP DB/MaxDB Backup RestoreMedia used for this session, respectively. See Figure 312 17Viewing a Previous SessionRestore ProblemsData Protector reports the following error during backup or Restore from an object copy hangs An SAP DB/MaxDB instance cannot be started after restoreData Protector reports the following error 314Task command. Finish these tasks Documentation for information on how to do thatStart the SAP DB/MaxDB xserver. Refer to the SAP DB/MaxDB Start the SAP DB/MaxDB instance. Refer to the SAP DB/MaxDB316 SAP DB/MaxDB Cluster-Related TroubleshootingGlossary Backup chain See restore chain Backup device Backup APIBackup generation Backup IDBackup owner Backup objectBackup session See also incremental backup and full backup Backup setSee also replica, source volume, snapshot, and CA+BC EVA Backup system ZDB specific termInstant copies of EMC Symmetrix standard devices See also BCV BC HP StorageWorks Disk Array XP specific termSee also SAPDBA, Brbackup Boot volume/disk/partitionBrrestore BC Process EMC Symmetrix specific termSee also SAPDBA, Brarchive See also BC EVA, replica, and source volumeBrarchive BSM CA HP StorageWorks Disk Array XP specific termCDB Cmmdb CSM CRSSee also catalog protection Data Protector Event Log Data protectionData Protector user account Data streamDcbf See incremental backup Differential backup MS SQL specific Differential backupSee also backup types Differential database backup Direct backupSee also virtual full backup Disk image rawdisk backupDisk Agent concurrency Disk discoveryDR OS DMZEnhanced incremental backup Emergency boot file Informix ServerEnterprise Backup Environment Event LogsFC bridge See Fibre Channel bridge File Replication Service FRSFibre Channel bridge File depotFull backup See also recovery files Fnames.datSee also backup types Full database backup Full mailbox backupHeartbeat See also incremental ZDB Global options fileHierarchical Storage Management HSM Holidays fileHP OVO HP ITOIDB LUNHP VPO Incremental restore EMC Symmetrix Incremental1 mailbox backupIncremental re-establish EMC Incremental ZDBInformix Server Informix Server specific term Initializing See formatting Installation ServerRefers to Informix Dynamic Server Integration objectITO IP addressJukebox See library Jukebox device LibraryLoad balancing Local and remote recoveryLock name Logfull shell script Informix ServerAn interface for the exchange of backup Login information to the Oracle TargetLogical-log files Database Oracle and SAP R/3 specific termMagic Packet See Wake Onlan LVMMailbox Microsoft Exchange Server specific term Mailbox Store Microsoft Exchange Server specific termMedia condition Media allocation policyMedia condition factors Media IDMmdb MMDMSM Object copy Offline backupObject copy session Object copyingOnline backup Onconfig Informix Server specific termSee also zero downtime backup ZDB and offline backup Offline redo log See archived redo logOVO Ownership Package MC/ServiceGuard and Veritas Cluster specific termP1S file Pair status HP StorageWorks Disk Array XP specific termPre- and post-exec commands Parallel restorePrimary Volume P-VOL HP Physical devicePublic/private backed up data Rawdisk backup See disk image backupRAID RAID Manager XP HP StorageWorks Disk Array XP specific termRecovery Catalog Database Oracle Recovery Catalog Oracle specificSee also flash recovery area RecoveryInfo Recovery Manager Rman OracleRemovable Storage Management RecycleRSM Restore sessionScan ScanningSession key SchedulerSee also shadow copy Shadow copy set MS VSS specific termSmbf SibfSMB Source R1 device EMC Symmetrix Creation Split mirror backup EMC SymmetrixSee also target R2 device See also ZDB to tape, ZDB to disk+tape, and replicaSst.conf file SRD fileSt.conf file StackersSynthetic backup Switchover See failover Sybase Backup Server API SybaseStandard security MS SQL specific See also integrated security Storage GroupSystem Backup to Tape Oracle Synthetic full backupSystem volume/disk/partition System databases Sybase specificTablespace Terminal Services Windows specificTarget R2 device EMC Symmetrix See also source R1 deviceTLU User disk quotas Unattended operation See lights-out operation User accountUser group User rightsVerify Volume groupVirtual Controller Software VCS Virtual Device Interface MS SQL Server specific termVSS VPOWriter See also direct backupSee zero downtime backup ZDB ZDB to tape ZDB specific term Zero downtime backup ZDBGlossary Index IndexBRARCHIVE, 149 Index 286 Index 281-289

TIP

cases: