Restoring an Oracle Database | HP OpenView Storage B6960-96008

Integrating Oracle and Data Protector

Restoring an Oracle Database

	Restoring an Oracle Database
	You can restore the database objects using:
	• Data Protector GUI. See “Restoring Oracle Using the Data Protector
		GUI” on page 72.
	• RMAN. See “Restoring Oracle Using RMAN” on page 93.
Restorable Items	You can restore the following database objects using both the Data
	Protector GUI or RMAN:
	•	Control files
	•	Datafiles
	•	Tablespaces
	•	Databases
	•	Recovery Catalog Databases
Duplicating	Using the Data Protector GUI, you can also duplicate a production
Databases	database. See “Duplicating an Oracle Database” on page 85.
MS Cluster Server	Before you start restoring a cluster-aware Oracle server, take the Oracle
Clients	Database resource offline using, for example, the Cluster
	Administrator utility. See Figure 1-16.

70

Chapter 1

Image 92

HP OpenView Storage B6960-96008 Restoring an Oracle Database, Restorable Items, Duplicating, Databases, MS Cluster Server

Contents

HP OpenView Storage Data Protector Integration Guide Copyright 2006 Hewlett-Packard Development Company, L.P Legal 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 Vii Viii When entering a You supply your login name Command Command names Use the grep command File and directoryNew terms Data Protector Cell Manager is the main Text and items on System replies Press Computer screen Protector graphical user interface Data Protector Graphical User Interface General Information Technical SupportDocumentation Feedback Xii Manuals Xiii HP OpenView Storage Data Protector Integration Guide XivPage Online Help Xvi Documentation Map AbbreviationsAbbreviation Manual Xvii Map Xviii Xix IntegrationsIntegration Guide Page Audience Xxi Organization Xxii Integrating Oracle and Data This Chapter Oracle Data Guard environment, backup of standby database Introduction Database Restore TypesDuplicating a Integration Concept Oracle Backup Manager User’s Guide Integration Concept Rman CLI Data Protector Oracle Integration Concept IDB where all the information about Data Protector sessions, including session messages, objectsData, used devices, and media is written Data Protector General Media Agent, which reads Configuring the Integration Prerequisites Limitations Before You Begin Oracle Data Guard Integration Media Management Library MML on Cluster-Aware ClientsLinking Oracle with the Data Protector Oracle Filenames for the MML on Different Platforms Linking Oracle with MML on OpenVMS Systems On Oracle Server systems running on OpenVMS, link the MMLSYS$SHARELIBOBK2SHR32.EXE Oracle9i with the Oracle Server Edit the following files 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 Configuring Oracle Users on Unix and OpenVMS After Relinking Finding the Oracle User OpenVMS Uncomment the following lines in OMNI$ROOTLOGLOGIN.COM Verify the changes of the group ID Configuring Oracle Databases ProcedureVerify that the -key Oracle8 entry is present If the entry is not present, copy it from Pathname of the Oracle Server home directory Using the Data Protector GUIConfiguring Oracle General Windows Configuring Oracle General Unix Configuring Oracle Primary Configuring Oracle Catalog Specify the login information to the standby databaseInstance Database instance Configuring Oracle Standby Using the Data Protector CLI On Windows Where Parameter Description What Happens After the Configuration? Syntax Checking the Configuration OpenVMS OMNI$ROOTBIN run To get the error description Windows On the Cell Manager, see the file Information, see Troubleshooting on Configuring an Oracle Backup Creating a New TemplateCluster-Aware Clients Creating a Data Protector Oracle Backup Specification DatabaseSwitchArchiveDel SMBBackupSetDatabaseDirectDatabase SMBProxyDatabase Specifying an Oracle Server System Windows Specifying an Oracle Server System Unix Specification Selecting Backup Objects Set the backup options Flash recovery area in the Pre-execor Post-exectext box.Data 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 Post-Exec Examples of Pre-Exec and Post-Exec Scripts on UnixPre-Exec Example Editing the Oracle Rman Script Limitations Data Protector Rman Script Structure BackupSpecificationNameDBNAME%s%t%p.dbf Whole database selection Rman current controlfile commandVariables and DBNAME, which are obligatory Oracle Duplex Mode Example Creating Copies of Backed Up Objects Testing the Integration Testing Using the Data Protector GUI 13Previewing a Backup Testing Using the CLI Run the omnib command with the -testbaroption as follows Configuring an Oracle Backup Backing Up an Oracle Database Oracle Online Start SQL*Plus and type alter database archivelog If Pfile is used Scheduling a Backup Backup ProcedureRecovery Catalog Backing Up an Oracle Database Click OK and then Apply to save the changes Running an Interactive BackupStarting a Backup Using the GUI OpenVMS To set up the CLI, run HP-UX and Solaris /opt/omni/bin Starting Oracle Backup Using Rman Following commandYou can select among the following listoptions See the omnib man page for details Target Database The format of the target database login is If you specify more than a single allocate channel command Commands is handled internally by RmanTape in the second case Allocated Use rcvcat instead of catalog in the above syntax Examples of the Rman Scripts Parallel Flash Recovery Backing UpParticular Archived Logs File in a Backup SpecificationIncluding Control Backing Up While On Windows Restoring an Oracle Database Restorable ItemsDuplicating Databases 16Taking the Oracle Resource Group Offline Restoring Oracle Using the Data Protector GUI Restoring Database Items in a Disaster Recovery Required Database States Item to restore Database state Changing The 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 After the restore, run the following script Restoring the Control File Ensure that you have properly configured the Rman autobackup Restoring Oracle Database Objects Results Area, select objects for restore Restore As dialog box, specify the new datafile locationOracle Data Guard If you restore a primary database from a Source Login information for the primary database. If you restore Same can be done if you set the DbfilenameconvertConverts them appropriately Will be used Options Devices If you are restoring a datafile enter Restoring Tablespaces and DatafilesIf you are restoring a tablespace enter Restoring and Recovering a Primary Database Restoring and Recovering a Standby Database Prerequisites Duplicating an Oracle DatabaseLimitation Restore Action drop-down list, select Perform Duplication 22Oracle Duplicate Options Restore, Recovery, and Duplicate Options Settings Restore modeGeneral Options Client This drop-down list allows you to specify which type Dorecover ParallelismDuplicate Options For Standby Nofilenamecheck Restore and Recovery Options Restore untilTo database name Recover until Restoring Oracle Using Rman Open database after recoveryOpens the database after a recovery is performed Reset logs Preparing the Oracle Database for Restore Windows Example Unix Example Connection Strings Used in the Examples Example of Full Database Restore and Recovery Start the full database restore and recovery run Example of Point-in-Time Restore Start the point-in-time restore run Example of Tablespace Restore and Recovery 100 Chapter 101 Example of Datafile Restore and Recovery 102 Unix Windows 104 Example of Archive Log Restore Start the archive log restore run 106 If you are using an sh like shell, run Restoring Oracle Using CLIRestoring the Recovery Catalog Restoring Using Another Device 108 Disaster Recovery 110 Monitoring an Oracle Backup and RestoreMonitoring Current Sessions Viewing Previous Sessions Windows DataProtectorhome\log\oracle8.log 112 Oracle Removing the Data Protector Oracle Integration LinkOn OpenVMS Systems 114 Cases Troubleshooting 116 General Troubleshooting ProblemChecking Prerequisites Related to the Oracle Side Integration on Unix Systems If this fails, open the recovery catalog Start SQL*Plus from the Oraclehome directoryIf this fails, open the Oracle target database 118 Then 120 Chapter 121 23Checking the Status of the Oracle Listener 122 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 Verify the inet startup parameters 128 Backup Problems on Unix Systems Check your Oracle Server configuration Data Protector reports Export of the Recovery Catalog Database Failed when backing up OracleFollowing errors are listed in the Data Protector monitor On other Unix systems Backup Fails After a Point in Time Restore and Recovery Data Protector reports Cannot allocate/attach shared memory Backup of Archive Logs on RAC Cannot be Performed 132 Backup Problems on Windows Data Protector reports errors when callingSYS.LTEXPORTPKG.schemainfexp during Oracle 9i/10g Backup Recovery catalog 134 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 Recovery Catalog was lost and the control file cannot be Restored from Data Protector managed backupTape Following SQL script Problem occurs with Oracle8i on HP-UX Shared library that provides thread local storage cannot beLoaded Following is displayed Problem occurs when the Radius Authentication Adapter is Radius Authentication AdapterLibrary 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 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 Brbackup Utilities Data Protector Zero Downtime Backup Administrator’s Guide Data ProtectorSoftware 150 SAP R/3 Backup Concept Architecture Backup Flow Using BackintSAP R/3 Architecture Backint Mode 152 Data Protector User Interface Data Protector Backup Media AgentData Protector Restore Media Agent Sapbackup Finished data transfer, the BSM waits for a timeoutDataProtectorhome\tmp on Windows if the variable is not Protector is limited to 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 This is an example of the file 160 Setting, Retrieving, Listing, and Deleting Data Protector SAP R/3 ConfigurationFile Parameters Using the CLI Command 162 Setting ParametersProtector SAP R/3 client HP-UX and Solaris SAP R/3 instance ICE, use the following command on the Data Listing ParametersDeleting 164 Overviewsteps SAP R/3 database using Data Protector SAP R/3 database backup with Data ProtectorGroup 166 Configuring an SAP R/3 Database Server Before You BeginClients on Windows/UNIX 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 Windows 172 Unix 174 Configuring an SAP R/3 Database Server on WindowsConfiguring an SAP R/3 Database Server on Unix Configuration What Happens?Checking Data Protector GUI Target database must be online during the check 176 Checking the SAP R/3 Configuration Data Protector CLI 178 Configuring an SAP R/3 Backup Creating a Data Protector SAP R/3 Backup Specification 180 BrbackupRMANOffline BrbackupRMANOnline 10Selecting Backup Objects 182 Specify any SAP R/3 backup options, the current settings Backing Up Using Recovery Manager on 11SAP R/3 Backup Options 184 Chapter 185 SAP R/3 Specific Backup Options BR BackupLogs? Log file Backup Objects BR ArchiveBalancing By Load Balancing By Time Balancing Manual Balancing NonePre-exec 188 Backup mode Post-exec Creating or Modifying the Parameter File on the SAP Database ServerObjects outside database 190 Incrementally Backing Up Using Recovery ManagerBenefits Backup 192 Incremental Backups if UsingManual Balancing of Files into Subsets 194 Creating an SAP /R3 Backup Specification for ManualBalancing Backup specification then looks like SID file Unix systems, or Testing Using the Data Protector CLI 196 Backup Methods Duplicate SIDs Backup Modes BackupsBacking Up an SAP R/3 Database Tools version 4.5 and later Aborting an SAP R/3 Backup Session Aborting aRunning Session 198 Session options. See Figure Starting a Backup Using the GUI 200 An interactive backup can also be started from the CLI Cluster-Aware Clients 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 16Restoring SAP R/3 Database Objects 206 Restoring Using the Data Protector CLI Using the CLI, execute the following commandWhere FileName must be specified as follows Set to restore from automatically 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 Restored Run the following script Monitoring an SAP R/3 Backup and Restore 212 Previous Sessions Scoping Pane, expand Sessions to display all the sessionsStored in the IDB ID consisting of a date in the YY/MM/DD format and a unique OpenView Storage Data Protector Troubleshooting Guide Oracle9iCorrectly 214 Troubleshooting on Windows Systems Prerequisites Concerning the Oracle Side of the Integration At the Svrmgr prompt, type 216 If you are not using the recovery catalog Prerequisites on the SAP R/3 Side of the Integration Configuration Problems 218 \\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 Examine system errors Backup ProblemsCheck your SAP R/3 Server configuration *RETVAL*0 indicates successful configuration If the test fails again, call support Restore Problems 222 Chapter 223 224 Verify the restore using backintActions Troubleshooting on Unix Systems Do not use non-ASCII or non-Latin 1 characters for filenames 226 At the Svrmgr Oracle8/8i or SQL Oracle9i prompt, typeIf it fails, open the Oracle Target Database If you use the Recovery Catalog An example of the rmanscript is listed below 228 Which is provided by Data Protector 230 Solaris platform Verify the permissions of the currently used user account 232 Chapter 233 234 Verify the backup using backintError UtilFileOnline SAP backup fails with semop error Verify a user for the restoreVerify that a backup object exists on the backup media IDB 236 BarbackupspecificationnameHP-UX and Solaris systems or Verify the restore using backint Run the following command Use SAP R/3 commands for example, brrestore to restore these 238 Examples of SAP R/3 Database Restore Preparing the SAP R/3 Database for Restore 240 Example of Full Database Restore and Recovery When the menu appears, select the Restore/Recovery option 242 Chapter 243 Was recovered, run the Alter Database Open command with 244 Example of Partial Restore Example of Lost Files Restore This means that the existing file can be used 246 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 Aware of before using the integration Architectures and how to install the Data ProtectorSAP DB/MaxDB Automatic Log Backup must be activated for an SAP DB/MaxDB instance to enable transactional backup log 252 Restore GUI Parallelism PermissionsSupported Platforms Chapter 255 Interfaces 256 Restore Flow SAP DB/MaxDB Backup and Restore Concept 258 Data Protector SAP DB/MaxDB Configuration File Setting, Retrieving, and Listing Data Protector SAP DB/MaxDB Configuration File Parameters UsingConfiguration File 260 Command output is written to. If the -localoption is not SAP DB/MaxDB configuration fileOptionname is the name of the parameter Optionvalue is the value for the parameter 262 Configuring Users 264 Configuring an SAP DB/MaxDB BackupCreating a Backup Specification Chapter 265 Selecting an SAP DB Server and Instance on Unix Systems 266 Selecting an SAP DB Server and Instance on Windows Systems To backup SAP DB/MaxDB archive logs, select the Data item Backup interactivelyInteractively. See Backing Up an SAP DB/MaxDB Database on Selecting SAP DB Objects Saving the Backup Specification SAP DB/MaxDB Specific Backup Options 270 Backup Options 272 Chapter 273 274 Modifying the Configuration of an SAP DB/MaxDB InstanceUsing the CLI Then execute the following command Specified during the installationInstance to be configured Described in Configuring Users on Checking the Configuration of an SAP DB/MaxDB Instance 276 Checking the Configuration of an SAP DB/MaxDB Instance Using the GUI To check the configuration, run the following command on If an error occurs, it is explainedIt before running a backup SAP DB/MaxDB Server system Previewing a Backup Description of these options, press F1 280 Backing Up an SAP DB/MaxDB Database Scheduling an Existing Backup SpecificationBackup Methods Scheduling Procedure 282 Scheduling the Backup Specification Running an Interactive Backup Using the Data Protector GUI 284 Running an Interactive Backup Using the Data Protector CLI 10Starting an Interactive Backup 286 Running an Interactive Backup Using SAPDB/MaxDB Utilities Chapter 287 288 Chapter 289 290 Restore and Recovery OverviewRestoring an SAP DB/MaxDB Database From the selected backup session is restored. The data on Selected backup session are restoredMode, SAP DB/MaxDB always checks whether such a gap exists SAP DB/MaxDB Server is overwritten SAP DB/MaxDB Restore Process 292 Chapter 293 SAP DB/MaxDB Migration Prerequisites 294 Chapter 295 Properties for Data Dialog Box 296 Finding Information Needed for a Restore Command Syntax an SAP DB/MaxDB instance To get a list of SAP DB/MaxDB objectsRestoring 298 Restoring Using SAP DB/MaxDB Utilities Finding Information Needed for Restore 300 Chapter 301 302 SAP DB/MaxDB Migration SAP DB/MaxDB Restore and Recovery Options 304 Chapter 305 Recovery Options 306 Refer to Restoring Using the Data Protector CLI on 308 Chapter 309 Monitoring an SAP DB/MaxDB Backup Restore 310 Media used for this session, respectively. See Figure 17Viewing a Previous Session 312 Restore ProblemsData Protector reports the following error during backup or An SAP DB/MaxDB instance cannot be started after restore Restore from an object copy hangsData Protector reports the following error 314 Documentation for information on how to do that Task command. Finish these tasksStart the SAP DB/MaxDB xserver. Refer to the SAP DB/MaxDB Start the SAP DB/MaxDB instance. Refer to the SAP DB/MaxDB SAP DB/MaxDB Cluster-Related Troubleshooting 316 Glossary Backup API Backup chain See restore chain Backup deviceBackup generation Backup ID Backup object Backup ownerBackup session See also incremental backup and full backup Backup set Backup system ZDB specific term See also replica, source volume, snapshot, and CA+BC EVAInstant copies of EMC Symmetrix standard devices See also BCV BC HP StorageWorks Disk Array XP specific term Boot volume/disk/partition See also SAPDBA, BrbackupBrrestore BC Process EMC Symmetrix specific term See also BC EVA, replica, and source volume See also SAPDBA, BrarchiveBrarchive BSM CA HP StorageWorks Disk Array XP specific term CDB Cmmdb CRS CSM Data protection See also catalog protection Data Protector Event LogData Protector user account Data stream Dcbf Differential backup See incremental backup Differential backup MS SQL specificSee also backup types Differential database backup Direct backup Disk image rawdisk backup See also virtual full backupDisk Agent concurrency Disk discovery DMZ DR OS Emergency boot file Informix Server Enhanced incremental backupEnterprise Backup Environment Event Logs File Replication Service FRS FC bridge See Fibre Channel bridgeFibre Channel bridge File depot See also recovery files Fnames.dat Full backupSee also backup types Full database backup Full mailbox backup See also incremental ZDB Global options file HeartbeatHierarchical Storage Management HSM Holidays file HP ITO HP OVO IDB LUNHP VPO Incremental1 mailbox backup Incremental restore EMC SymmetrixIncremental re-establish EMC Incremental ZDB Initializing See formatting Installation Server Informix Server Informix Server specific termRefers to Informix Dynamic Server Integration object IP address ITOJukebox See library Jukebox device Library Local and remote recovery Load balancingLock name Logfull shell script Informix Server Login information to the Oracle Target An interface for the exchange of backupLogical-log files Database Oracle and SAP R/3 specific term LVM Magic Packet See Wake OnlanMailbox Microsoft Exchange Server specific term Mailbox Store Microsoft Exchange Server specific term Media allocation policy Media conditionMedia condition factors Media ID MMD Mmdb MSM Offline backup Object copyObject copy session Object copying Onconfig Informix Server specific term Online backupSee also zero downtime backup ZDB and offline backup Offline redo log See archived redo log OVO Package MC/ServiceGuard and Veritas Cluster specific term OwnershipP1S file Pair status HP StorageWorks Disk Array XP specific term Parallel restore Pre- and post-exec commandsPrimary Volume P-VOL HP Physical device Rawdisk backup See disk image backup Public/private backed up dataRAID RAID Manager XP HP StorageWorks Disk Array XP specific term Recovery Catalog Oracle specific Recovery Catalog Database OracleSee also flash recovery area RecoveryInfo Recovery Manager Rman Oracle Recycle Removable Storage Management Restore session RSMScan Scanning Scheduler Session keySee also shadow copy Shadow copy set MS VSS specific term Smbf SibfSMB Creation Split mirror backup EMC Symmetrix Source R1 device EMC SymmetrixSee also target R2 device See also ZDB to tape, ZDB to disk+tape, and replica SRD file Sst.conf fileSt.conf file Stackers Switchover See failover Sybase Backup Server API Sybase Synthetic backupStandard security MS SQL specific See also integrated security Storage Group Synthetic full backup System Backup to Tape OracleSystem volume/disk/partition System databases Sybase specific Terminal Services Windows specific TablespaceTarget R2 device EMC Symmetrix See also source R1 device TLU Unattended operation See lights-out operation User account User disk quotasUser group User rights Volume group VerifyVirtual Controller Software VCS Virtual Device Interface MS SQL Server specific term VPO VSS Writer See also direct backupSee zero downtime backup ZDB Zero downtime backup ZDB ZDB to tape ZDB specific term Glossary Index Index BRARCHIVE, 149 Index 286 Index 281-289