22Oracle Duplicate Options | HP OpenView Storage B6960-96008

Integrating Oracle and Data Protector

Restoring an Oracle Database

Figure 1-22Oracle Duplicate Options

6.Click Restore.

When the standby database is created, it is left mounted. Start the managed recovery process (log apply services) manually.

For information on how to use the RMAN commands to duplicate a database, see Oracle documentation.

Chapter 1

87

Image 109

HP OpenView Storage B6960-96008 manual 22Oracle Duplicate Options

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 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 screen Data Protector Graphical User Interface Protector graphical user interface Information Technical Support GeneralDocumentation Feedback Xii Xiii Manuals Xiv HP OpenView Storage Data Protector Integration GuidePage Xvi Online Help Abbreviations Documentation MapAbbreviation Manual Xvii 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 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 reads 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 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 files 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 Procedure Configuring Oracle DatabasesVerify that the -key Oracle8 entry is present If the entry is not present, copy it from Configuring Oracle General Windows Using the Data Protector GUIPathname of the Oracle Server home directory Configuring Oracle General Unix Configuring Oracle Primary Specify the login information to the standby database Configuring Oracle CatalogInstance 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 Creating a New Template Configuring an Oracle BackupCluster-Aware Clients Creating a Data Protector Oracle Backup Specification SMBBackupSetDatabase DatabaseSwitchArchiveDelDirectDatabase SMBProxyDatabase Specifying an Oracle Server System Windows Specifying an Oracle Server System Unix Selecting Backup Objects Specification Flash recovery area in the Pre-execor Post-exectext box. Set the backup optionsData Protector Oracle integration backup to tape Application Options, see the online Help 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 Backup Procedure Scheduling a BackupRecovery Catalog 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 Following command Starting Oracle Backup Using RmanYou can select among the following listoptions See the omnib man page for details Target 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 Allocated Use rcvcat instead of catalog in the above syntax Parallel Examples of the Rman Scripts Backing Up Flash RecoveryParticular Archived Logs Specification File in a BackupIncluding Control Backing Up While On Windows Restorable Items Restoring an Oracle DatabaseDuplicating Databases 16Taking the Oracle Resource Group Offline Restoring Database Items in a Disaster Recovery Restoring Oracle Using the Data Protector GUI Changing 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, run 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 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 Source Same can be done if you set the Dbfilenameconvert Login information for the primary database. If you restoreConverts them appropriately Will be used 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 Restore mode SettingsGeneral Options Client This drop-down list allows you to specify which type Parallelism DorecoverDuplicate Options For Standby To database name Restore and Recovery Options Restore untilNofilenamecheck Recover until Open database after recovery Restoring Oracle Using RmanOpens the database after a recovery is performed Reset logs 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 Problem General TroubleshootingChecking Prerequisites Related to the Oracle Side Integration on Unix Systems Start SQL*Plus from the Oraclehome directory If this fails, open the recovery catalogIf this fails, open the Oracle target database 118 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 Database Failed when backing up Oracle Data Protector reports Export of the Recovery CatalogFollowing errors are listed in the Data Protector monitor On other Unix systems 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 Data Protector reports errors when calling Backup Problems on WindowsSYS.LTEXPORTPKG.schemainfexp during Oracle 9i/10g Backup 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 Restored from Data Protector managed backup Recovery Catalog was lost and the control file cannot beTape Following SQL script Shared library that provides thread local storage cannot be Problem occurs with Oracle8i on HP-UXLoaded Following is displayed Radius 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. See 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 Data Protector Data Protector Zero Downtime Backup Administrator’s GuideSoftware 150 Architecture SAP R/3 Backup Concept Using Backint Backup FlowSAP R/3 Architecture Backint Mode 152 Data Protector Restore Media Agent Data Protector Backup Media AgentData Protector User Interface Finished data transfer, the BSM waits for a timeout SapbackupDataProtectorhome\tmp on Windows if the variable is not Protector is limited to 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 Protector SAP R/3 Configuration Setting, Retrieving, Listing, and Deleting DataFile Parameters Using the CLI Command 162 Parameters SettingProtector SAP R/3 client HP-UX and Solaris Listing Parameters SAP R/3 instance ICE, use the following command on the DataDeleting 164 Overviewsteps SAP R/3 database backup with Data Protector SAP R/3 database using Data ProtectorGroup 166 Before You Begin Configuring an SAP R/3 Database ServerClients on Windows/UNIX 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 What Happens? ConfigurationChecking Data Protector GUI 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 BR Backup SAP R/3 Specific Backup OptionsLogs? Log file BR Archive Backup ObjectsBalancing By Load Balancing By Time Balancing None Balancing ManualPre-exec 188 Post-exec Backup mode Database Server Creating or Modifying the Parameter File on the SAPObjects outside database 190 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 Backups Backup Methods Duplicate SIDs Backup ModesBacking Up an SAP R/3 Database Tools version 4.5 and later Aborting a Aborting an SAP R/3 Backup SessionRunning Session 198 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 Using the CLI, execute the following command Restoring Using the Data Protector CLIWhere FileName must be specified as follows Set to restore from automatically 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 Scoping 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 unique Oracle9i OpenView Storage Data Protector Troubleshooting GuideCorrectly 214 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 Backup Problems Examine system errorsCheck your SAP R/3 Server configuration *RETVAL*0 indicates successful 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 Verify a user for the restore UtilFileOnline SAP backup fails with semop errorVerify that a backup object exists on the backup media IDB 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 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 log 252 GUI Restore Permissions ParallelismSupported Platforms Chapter 255 256 Interfaces Restore Flow 258 SAP DB/MaxDB Backup and Restore Concept Data Protector SAP DB/MaxDB Configuration File DB/MaxDB Configuration File Parameters Using Setting, Retrieving, and Listing Data Protector SAPConfiguration File 260 SAP 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 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 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 Objects 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 Specified during the installation Then execute the following commandInstance to be configured Described in Configuring Users on 276 Checking the Configuration of an SAP DB/MaxDB Instance Using the GUI Checking the Configuration of an SAP DB/MaxDB Instance If an error occurs, it is explained To check the configuration, run the following command onIt before running a backup SAP DB/MaxDB Server system 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 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 overwritten 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 To get a list of SAP DB/MaxDB objects Command Syntax an SAP DB/MaxDB instanceRestoring 298 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 Restore from an object copy hangs An SAP DB/MaxDB instance cannot be started after restoreData Protector reports the following error 314 Task 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/MaxDB 316 SAP DB/MaxDB Cluster-Related Troubleshooting Glossary Backup chain See restore chain Backup device Backup APIBackup generation Backup ID Backup owner Backup objectBackup session See also incremental backup and full backup Backup set See 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 term See also SAPDBA, Brbackup Boot volume/disk/partitionBrrestore BC Process EMC Symmetrix specific term See also SAPDBA, Brarchive See also BC EVA, replica, and source volumeBrarchive BSM CA HP StorageWorks Disk Array XP specific term CDB Cmmdb CSM CRS See also catalog protection Data Protector Event Log Data protectionData Protector user account Data stream Dcbf See incremental backup Differential backup MS SQL specific Differential backupSee also backup types Differential database backup Direct backup See also virtual full backup Disk image rawdisk backupDisk Agent concurrency Disk discovery DR OS DMZ Enhanced incremental backup Emergency boot file Informix ServerEnterprise Backup Environment Event Logs FC bridge See Fibre Channel bridge File Replication Service FRSFibre Channel bridge File depot Full backup See also recovery files Fnames.datSee also backup types Full database backup Full mailbox backup Heartbeat See also incremental ZDB Global options fileHierarchical Storage Management HSM Holidays file HP OVO HP ITO HP VPO LUNIDB Incremental restore EMC Symmetrix Incremental1 mailbox backupIncremental re-establish EMC Incremental ZDB Informix Server Informix Server specific term Initializing See formatting Installation ServerRefers to Informix Dynamic Server Integration object ITO IP addressJukebox See library Jukebox device Library Load balancing Local and remote recoveryLock name Logfull shell script Informix Server An interface for the exchange of backup Login information to the Oracle TargetLogical-log files Database Oracle and SAP R/3 specific term Magic Packet See Wake Onlan LVMMailbox Microsoft Exchange Server specific term Mailbox Store Microsoft Exchange Server specific term Media condition Media allocation policyMedia condition factors Media ID Mmdb MMD MSM Object copy Offline backupObject copy session Object copying Online backup Onconfig Informix Server specific termSee also zero downtime backup ZDB and offline backup Offline redo log See archived redo log OVO Ownership Package MC/ServiceGuard and Veritas Cluster specific termP1S file Pair status HP StorageWorks Disk Array XP specific term Pre- and post-exec commands Parallel restorePrimary Volume P-VOL HP Physical device Public/private backed up data Rawdisk backup See disk image backupRAID RAID Manager XP HP StorageWorks Disk Array XP specific term Recovery Catalog Database Oracle Recovery Catalog Oracle specificSee also flash recovery area RecoveryInfo Recovery Manager Rman Oracle Removable Storage Management Recycle RSM Restore sessionScan Scanning Session key SchedulerSee also shadow copy Shadow copy set MS VSS specific term SMB SibfSmbf 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 replica Sst.conf file SRD fileSt.conf file Stackers Synthetic backup Switchover See failover Sybase Backup Server API SybaseStandard security MS SQL specific See also integrated security Storage Group System Backup to Tape Oracle Synthetic full backupSystem volume/disk/partition System databases Sybase specific Tablespace Terminal Services Windows specificTarget R2 device EMC Symmetrix See also source R1 device TLU User disk quotas Unattended operation See lights-out operation User accountUser group User rights Verify Volume groupVirtual Controller Software VCS Virtual Device Interface MS SQL Server specific term 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