manualshive.com logo in svg

HP Data Protector A.06.11, Integration Manual

Share
Download
HP Data Protector A.06.11 Integration Manual Download Page 147

2.

Start SQL*Plus from the

bin

directory in the

ORACLE_HOME

directory:

sqlplus /nolog

3.

Start SQL*Plus and type:

connect

user_name

/

password

@

service

as sysdba;

select * from dba_tablespaces;

exit

If this fails, open the Oracle target database.

•

On the application system, verify that you can access the recovery catalog (if
used) and that it is opened as follows:

1.

Export or set the

ORACLE_HOME

and

DB_NAME

variables as described in

Step 1

on page 146.

2.

Start SQL*Plus from the

bin

directory in the

ORACLE_HOME

directory:

sqlplus /nolog

3.

Start SQL*Plus and type:

connect

Recovery_Catalog_Login

select * from rcver;

exit

If this fails, open the recovery catalog.

•

Verify that the listener is correctly configured for the Oracle target database and
the recovery catalog database. This is required to properly establish network
connections:

1.

Export or set the

ORACLE_HOME

variable as described in

Step 1

on page 146.

Zero downtime backup integration guide

147

Summary of Contents for Data Protector A.06.11

Page 1: ...A 06 1 1 Zero downtime backup integration guide for Oracle SAP R 3 Microsoft SQL Server Microsoft Exchange Server and Microsoft Volume Shadow Copy Service B6960 90163 Part number B6960 90163 First edition September 2009 ...

Page 2: ...y statements accompanying such products and services Nothing herein should be construed as constituting an additional warranty HP shall not be liable for technical or editorial errors or omissions contained herein Intel Itanium Pentium Intel Inside and the Intel Inside logo are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries Mic...

Page 3: ...ort 29 Subscription service 30 HP websites 30 Documentation feedback 30 1 Data Protector Oracle ZDB integration 31 Introduction 31 Backup and restore types 32 Integration concepts 35 Oracle backup set ZDB concepts 39 Backup process 42 Oracle proxy copy ZDB concepts 44 Backup process 47 Configuring the integration 49 Prerequisites 49 Limitations 51 Before you begin 51 Backup set method 53 Enabling ...

Page 4: ...ost exec scripts on UNIX 92 Editing the Oracle RMAN script 93 Starting backup sessions 97 Considerations 97 Scheduling backup specifications 98 Running an interactive backup 100 Restore 102 Prerequisites 104 Restoring from backup media to the application system on LAN 104 Restoring Oracle using the Data Protector GUI 104 Restoring database items in a disaster recovery 104 Changing the database sta...

Page 5: ...gin 146 Checks and verifications 146 Problems 154 2 Data Protector SAP R 3 ZDB integration 163 Introduction 163 Integration concepts 164 ZDB flow 165 Data Protector SAP R 3 configuration file 167 Setting retrieving listing and deleting Data Protector SAP R 3 configuration file parameters using the CLI 170 Configuring the integration 173 Prerequisites 173 Before you begin 174 Cluster aware clients ...

Page 6: ...LI 209 Using the SAP BRTOOLS 209 Configuring SAP compliant ZDB sessions 211 Using the Data Protector GUI 211 Using the Data Protector CLI 213 Manual balancing 214 Restore 214 Considerations 216 Standard restore 216 Instant recovery 221 Considerations 221 Instant recovery using the Data Protector GUI 221 Instant recovery using the Data Protector CLI 225 Instant recovery from replicas containing the...

Page 7: ...Using the Data Protector GUI 252 Using the Data Protector CLI 253 Backup 254 Creating ZDB specifications 254 SQL Server Specific Backup Options 263 Scheduling backups 265 Scheduling example 265 Starting backup sessions 265 Using the Data Protector GUI 266 Using the Data Protector CLI 266 Restore 266 Before you begin 267 Standard restore 267 Restore options 271 Restoring to another SQL Serverinstan...

Page 8: ... 310 Rollforward recovery 314 Instant recovery 320 Point in time recovery 321 Rollforward recovery 321 Troubleshooting 323 Before you begin 324 Checks and verifications 324 Problems 325 5 Integrating the Data Protector ZDB integrations and Microsoft Volume Shadow Copy Service 329 Introduction 329 Volume Shadow Copy Service 329 VSS backup types 332 VSS restore 332 Integration concepts 332 Backup 33...

Page 9: ...orageWorks Enterprise Virtual Array 349 Prerequisites 351 Configuring the Integration 350 Configuring HP StorageWorks Disk Array XP 351 Prerequisites 351 Limitations 351 VSS and VDS provider configuration for ZDB and instant recovery 352 Configuring the VSS hardware provider for Enterprise Virtual Arrray 352 Configuring the VSS hardware provider for Disk Array XP 353 Configuration check 353 Micros...

Page 10: ...y using Microsoft Virtual Disk Service 393 Instant recovery using HP StorageWorks EVA SMIS S Agent 394 Instant recovery using HP StorageWorks Disk Array XP Agent 396 Microsoft Exchange Server writer instant recovery specifics 397 Instant recovery procedure 400 Troubleshooting 408 Before you begin 409 Checks and verifications 409 Common problems 409 Backup problems 410 Restore problems 415 User sce...

Page 11: ...le General UNIX 61 10 Configuring Oracle Primary 62 1 1 Configuring Oracle Catalog 63 12 Configuring Oracle Standby 64 13 Configuring Oracle ZDB 65 14 Setting environmental variables 73 15 Selecting an Oracle ZDB template and Split mirror backup 77 16 Selecting an Oracle ZDB template and Snapshot backup 78 17 EMC backup options 79 18 XP backup options 81 19 VA backup options 82 20 EVA backup optio...

Page 12: ...ions XP example 140 36 Oracle recovery options 141 37 Selecting the database for recovery 143 38 Checking the status of the Oracle listener 148 39 Restore after a switch between ZDB methods fails 156 40 SAP R 3 integration architecture 165 41 SAP R 3 ZDB session flow BRBACKUP started on the application system 166 42 Specifying an SAP R 3 system and Oracle instance 184 43 Configuring an SAP R 3 dat...

Page 13: ...220 60 SAP R 3 source options 222 61 SAP R 3 recovery options 225 62 Backup and restore concepts 245 63 SQL Server users 248 64 Configuring SQL Server 250 65 Checking configuration 253 66 Selecting a split mirror backup 255 67 Selecting a snapshot backup 256 68 EMC backup options 257 69 XP backup options 258 70 VA backup options 259 71 EVA backup options 260 72 Selecting user databases 261 73 Savi...

Page 14: ...ge database 316 91 Restoring log files 317 92 Selecting the application system 318 93 Selecting XP restore 319 94 XP Restore option 320 95 Selecting XP restore 322 96 XP Restore option 323 97 Disabling circular logging 326 98 Actors of the traditional backup model 331 99 Actors of the Data Protector VSS integration backup model 331 100 Local VSS backup 336 101 Transportable VSS backup 336 102 Sele...

Page 15: ...15 Selecting writers components for instant recovery 401 1 16 Restore to different location options Exchange Server 2007 Writer 404 1 17 Selecting instant recovery options EVA integration 406 1 18 Selecting instant recovery options XP integration 407 1 19 Error reported by registry 413 120 Microsoft Exchange Server 2003 storage groups 418 121 Oracle proxy copy ZDB and restore concepts when the ZDB...

Page 16: ...orted disk arrays and array configurations 164 9 SAP parameter file settings 190 10 What is backed up 191 1 1 Backup templates 194 12 SAP R 3 backup options 204 13 SAP recovery methods 215 14 Legend 215 15 SQL Server backup options 264 16 SQL Server restore options 271 17 General options 292 18 XP options 292 19 VA options 294 20 EVA options 296 21 Exchange Server options 298 22 Writer description...

Page 17: ...roduct support service See your HP sales representative for details Table 1 Edition history Product Guide edition Part number Data Protector Release A 05 50 October 2004 B6960 901 14 Data Protector Release A 06 00 July 2006 B6960 96013 Data Protector Release A 06 10 November 2008 B6960 96047 Data Protector Release A 06 1 1 September 2009 B6960 90163 Zero downtime backup integration guide 17 ...

Page 18: ...Publication history 18 ...

Page 19: ... to read the HP Data Protector zero downtime backup concepts guide for fundamentals of Data Protector integrations with disk arrays Documentation set Other documents and online Help provide related information Guides Data Protector guides are available in printed format and in PDF format Install the PDF files during the Data Protector setup procedure by selecting the English Documentation Help com...

Page 20: ... restore various databases and applications They are intended for backup administrators or operators There are four guides HP Data Protector integration guide for Microsoft applications SQL Server SharePoint Portal Server Exchange Server and Volume Shadow Copy Service This guide describes the integrations of Data Protector with the following Microsoft applications Microsoft Exchange Server Microso...

Page 21: ...rmance Agent This guide provides information about how to monitor and manage the health and performance of the Data Protector environment with HP Performance Manager PM and HP Performance Agent PA on Windows HP UX Solaris and Linux HP Data Protector zero downtime backup concepts guide This guide describes Data Protector zero downtime backup and instant recovery concepts and provides background inf...

Page 22: ... issues and workarounds HP Data Protector product announcements software notes and references for integrations to HP Operations Manager HP Reporter HP Performance Manager HP Performance Agent and HP Service Information Portal This guide fulfills a similar function for the listed integrations HP Data Protector Media Operations product announcements software notes and references This guide fulfills ...

Page 23: ...lications SQL Server SharePoint Portal Server Exchange Server and Volume Shadow Copy Service IG MS Integration guide for Oracle and SAP IG O S Integration guide for HP Operations Manager for UNIX IG OMU Integration guide for HP Operations Manager for Windows IG OMW Integration guide for HP Performance Manager and HP Performance Agent IG PM PA Integration guide for HP Reporter IG Report Integration...

Page 24: ...ia Operations user guide MO UG MPE iX system user guide MPE iX Product announcements software notes and references PA Troubleshooting guide Trouble ZDB administrator s guide ZDB Admin ZDB concepts guide ZDB Concept ZDB integration guide ZDB IG Map The following table shows where to find information of different kinds Shaded squares are a good place to look first About this guide 24 ...

Page 25: ... guides for details of the following integrations Guide Integration IG OMU IG OMW HP Operations Manager for UNIX for Windows IG PM PA HP Performance Manager IG PM PA HP Performance Agent Zero downtime backup integration guide 25 ...

Page 26: ...IBM IBM DB2 UDB IG IBM Informix IG IBM Lotus Notes Domino MO User Media Operations MPE iX MPE iX system IG MS ZDB IG Microsoft Exchange Server IG MS Microsoft Exchange Single Mailbox IG MS ZDB IG Microsoft SQL Server IG MS ZDB IG Microsoft Volume Shadow Copy Service VSS IG Var NDMP Server IG Var Network Node Manager NNM IG O S Oracle ZDB IG Oracle ZDB IG O S SAP DB IG O S ZDB IG SAP R 3 About this...

Page 27: ...text http www hp com Text emphasis Italic text File and directory names System output Code Commands their arguments and argument values Monospace text Code variables Command variables Monospace italic text Emphasized monospace text Monospace bold text CAUTION Indicates that failure to follow directions could result in damage to equipment or data IMPORTANT Provides clarifying information or specifi...

Page 28: ...phical user interface Data Protector provides a cross platform Windows and UNIX graphical user interface You can use the original Data Protector GUI Windows only or the Data Protector Java GUI For information about the Data Protector graphical user interface see the online Help About this guide 28 ...

Page 29: ...ort For worldwide technical support information see the HP support website http www hp com support Before contacting HP collect the following information Product model names and numbers Technical support registration number if applicable Product serial numbers Error messages Operating system type and revision level Detailed questions Zero downtime backup integration guide 29 ...

Page 30: ... other product resources HP websites For additional information see the following HP websites http www hp com http www hp com go software http www hp com support manuals http h20230 www2 hp com selfsolve manuals http www hp com support downloads Documentation feedback HP welcomes your feedback To make comments and suggestions about product documentation please send a message to DP DocFeedback hp c...

Page 31: ...unctionality offers online backup capabilities with minimal degradation of the application system performance Supported disk arrays The following disk arrays can be used for ZDB of Oracle EMC Symmetrix EMC HP StorageWorks Disk Array XP XP HP StorageWorks Virtual Array VA HP StorageWorks Enterprise Virtual Array EVA NOTE With the Data Protector EMC integration only ZDB to tape is supported Conseque...

Page 32: ...cedures for configuration of backup specifications and starting or scheduling backups are the same regardless of the Oracle ZDB method Backup and restore types Backup Using Data Protector you can perform the following types of backup Online ZDB to disk ZDB to tape and ZDB to disk tape During the creation of a replica the database on the application system is in hot backup mode If a ZDB to tape or ...

Page 33: ...egration requirement is that application binaries are installed on the application system only Restore Using Data Protector and the disk array integrations you can perform the following types of restore Restoring from backup media to the application system on LAN standard Data Protector restore and using RMAN on the application system you can recover a whole database recover a part of a database r...

Page 34: ...P VA EVA EMC Restore Restore1 Restore ZDB to tape offline N A Instant recovery database recovery Instant recovery database recovery ZDB to disk online XP VA EVA N A Instant recovery database recovery1 Instant recovery ZDB to disk offline Restore Restore or Instant recovery database recovery Restore or Instant recovery database recovery ZDB to disk tape online Restore Restore or Instant recovery da...

Page 35: ...r an overview of ZDB concepts and terminology Integration concepts The Data Protector Oracle integration links the Oracle database management software with Data Protector From the Oracle point of view Data Protector represents a media management software On the other hand the Oracle database management system can be seen as a data source for backup using media controlled by Data Protector Componen...

Page 36: ...les datafiles and Archived Redo Logs The interface from the Oracle server processes to Data Protector is provided by the Data Protector Oracle integration Media Management Library MML which is a set of routines that allows the reading and writing of data to General Media Agents Besides handling direct interaction with the media devices Data Protector provides scheduling media management network ba...

Page 37: ...mmand RMAN instructs the Oracle Server processes to perform the specified command The Oracle Server processes initialize the backup through MML which establishes a connection to the Data Protector Backup Session Manager The Backup Session Manager starts the General Media Agent sets up a connection between MML and the General Media Agent and then monitors the backup process The Oracle Server proces...

Page 38: ...ate devices and media starts the General Media Agent establishes a connection between MML and the General Media Agent and then monitors the restore and writes messages and information regarding the restore to the IDB The General Media Agent reads the data from the backup devices and sends it to the Oracle Server processes through MML The Oracle Server Processes write the data to the disks The conc...

Page 39: ... devices Oracle backup set ZDB concepts See the HP Data Protector zero downtime backup concepts guide for a general description of ZDB to disk ZDB to tape and ZDB to disk tape and instant recovery concepts With the Oracle backup set ZDB method the entire data to be backed up is provided to Data Protector through the Oracle API the data is streamed through the Data Protector Oracle integration MML ...

Page 40: ...rol file SPFILE and online redo logs are overwritten during instant recovery The Oracle archived redo log files do not have to reside on source volumes Figure 3 Oracle backup set ZDB concept Figure 3 on page 40 presents only the default integration behavior where Oracle control file online redo log files and SPFILE reside on a different volume group if LVM is used or source volume than Oracle data...

Page 41: ...controls backup and restore sessions and writes session information to the IDB Disk Array Agent The disk array Agents ZDB Agents are SYMA on EMC SSEA on XP SNAPA on VA and SMISA on EVA Data Protector MML The Data Protector Oracle integration Media Management Library which is a set of routines that enables data transfer between the Oracle Server and Data Protector This is a Data Protector software ...

Page 42: ...Backup process Figure 4 Oracle backup set ZDB flow NOTE ZDB Agents are SYMA on EMC SSEA on XP SNAPA on VA and SMISA on EVA Data Protector Oracle ZDB integration 42 ...

Page 43: ...ory on the application system This directory has to reside on a disk array source volume When performing an online ZDB session ob2rman pl then sets the Oracle target database into backup mode by issuing the sqlplus command ALTER TABLESPACE BEGIN BACKUP starts the procedure to create a replica of the source volumes on which the database is installed and after the replica is created takes the databa...

Page 44: ... data transfer the backup system is disabled filesystems are unmounted on all platforms and volume disk groups deactivated on UNIX systems and links are re established The recovery catalog and the control file are backed up automatically after the target database backup is finished on the backup system However you can disable this when creating a backup specification NOTE A replica of the archive ...

Page 45: ...s omnirc variables on page 425 IMPORTANT If you enable instant recovery by setting the above mentioned variables note that the control file SPFILE and online redo logs are overwritten during instant recovery The Oracle archived redo log files do not have to reside on source volumes Figure 5 on page 46 shows the architecture of the Data Protector Oracle ZDB integration The figure illustrates the co...

Page 46: ...d writes the session information to the IDB Disk Array Agent The disk array Agents ZDB Agents are SYMA on EMC SSEA on XP SNAPA on VA and SMISA on EVA MML The Data Protector Oracle integration Media Management Library which is a set of routines that enables data transfer between the Oracle Server and Data Protector This is a Data Protector software library that is linked to the Oracle software Data...

Page 47: ...he HP Data Protector zero downtime backup administrator s guide for a general description of the ZDB to disk ZDB to tape and ZDB to disk tape sessions flows and for an explanation of actions triggered by ZDB options Zero downtime backup integration guide 47 ...

Page 48: ...racle target database is switched into the backup mode ob2smbsplit or MML starts the procedure to create a replica of the source volumes on which the database is installed In the case of an online backup the database files are taken out of the backup mode after the replica is created In the case of an offline backup the Oracle database is started by ob2rman pl after the replica is created Data Pro...

Page 49: ...p from the application system following the standard Data Protector Oracle archive logs backup procedure Configuring the integration Prerequisites It is assumed that you are familiar with the Oracle database administration and the basic Data Protector functionality You need a license to use the Data Protector ZDB integration with Oracle Additional licenses are required for instant recovery and for...

Page 50: ...ide and References for more information about different connection options See Troubleshooting on page 145 for details about how to check the prerequisites listed above Note that the Data Protector Oracle integration uses RMAN for backup and restore RMAN connection to a target database requires a dedicated server process To ensure that RMAN does not connect to a dispatcher when the target database...

Page 51: ...ows The Oracle backup set ZDB method is supported on UNIX raw logical volumes only if these were created with LVM or VxVM The single host configuration BC1 TF 1 is not supported for Oracle backup set ZDB sessions Object copying and object mirroring is not supported for ZDB to disk Recovery files residing in the flash recovery area Oracle 10g 1 1g only cannot be backed up using ZDB For backing up t...

Page 52: ...on system using SQL Plus connect to the target database and recovery catalog by specifying the user password and net connect identifier Connect to the target database as the database administrator and to the recovery catalog database as the recovery catalog owner Example If the user name for the target database is system password manager net service name PROD and the user name and password for the...

Page 53: ... and to enable the archive log mode start SQL Plus and type startup mount alter database archivelog alter database open Example If the user name for the target database is system password manager instance name PROD and the user name and password for the recovery catalog is rman then the commands will look like sqlplus nolog SQL connect system manager PROD as sysdba Connected SQL startup mount SQL ...

Page 54: ...e Oracle net services on the application system and the backup system have the same directory structure This can be accomplished by either NFS sharing of the files manually copying the files from the application system to the backup system or by using the UNIX rdist or tar commands to distribute the files from the application system Test whether the Oracle user can log in to the Oracle target data...

Page 55: ...mple the user oracle can connect to the target database and the recovery catalog database using the RMAN command on the backup system 1 Log in as the Oracle database administrator to the backup system for example the user oracle 2 Execute the RMAN command and connect to the target database and the recovery catalog database Example If the DB_NAME of the target database is PROD the DB_NAME of the Or...

Page 56: ... the Data Protector environment variable OB2BARHOSTNAME to the virtual server name Set the variable on the Oracle Server system as follows Windows set OB2BARHOSTNAME virtual_server_name UNIX export OB2BARHOSTNAME virtual_server_name HP UX with RAC To enable instant recovery create an MC ServiceGuard package containing only the virtual IP and the virtual hostname parameters and distribute it among ...

Page 57: ...em user accounts on page 57 Oracle database user accounts For details see Configuring Oracle database users accounts on page 59 Configuring Oracle operating system user accounts For each Oracle database Data Protector requires an operating system user account that has Oracle rights to back up the database This user account usually belongs to the DBA user group OSDBA user The user account under whi...

Page 58: ...d to the Data Protector admin user group However if you have restarted the Data Protector Inet service on the application system and backup system under OSDBA user accounts you need to add the new users to the Data Protector admin or operator user group Windows clients For information on adding users to Data Protector user groups see the online Help index adding users NOTE The OSDBA user account f...

Page 59: ...owing Oracle database user accounts You need to provide these user accounts when you configure the Oracle database as described in Configuring Oracle databases on page 60 Table 4 Oracle database user accounts Description User Required to log in to the primary database Primary database user Zero downtime backup integration guide 59 ...

Page 60: ...overy catalog database Optionally login information to the standby database Backup method to be used and the related options During the configuration the util_oracle8 pl command which is started on the application system saves the specified parameters in the Data Protector Oracle database specific configuration file on the Cell Manager Ensure that the database is open during the configuration proc...

Page 61: ...cle dialog box and in the General page specify the pathname of the Oracle Server home directory Figure 9 Configuring Oracle General Windows Figure 10 Configuring Oracle General UNIX Zero downtime backup integration guide 61 ...

Page 62: ...ilege granted In Services type the net service name for the primary database instance The backup will be performed on the system where this database instance resides RAC List all net services names for the primary database separated by a comma Figure 1 1 Configuring Oracle Primary Data Protector Oracle ZDB integration 62 ...

Page 63: ...RMAN repository for backup history select Use recovery catalog and specify the login information to the recovery catalog Note that for ZDB you must use the recovery catalog The user specified must be the owner of the recovery catalog In Services type the net service name for the recovery catalog Figure 12 Configuring Oracle Catalog Zero downtime backup integration guide 63 ...

Page 64: ...tabase In the Standby page select Configure standby database and specify the login information to the standby database In Services type the net service name for the standby database instance RAC List all net services names for the standby database separated by a comma Figure 13 Configuring Oracle Standby Data Protector Oracle ZDB integration 64 ...

Page 65: ... you do not need to create an additional disk for this location if you do not need the control file copy on a replica If your backup method is backup set and if your database instance uses PFILE and not SPFILE select the Parameter file PFILE option and specify the pathname of PFILE residing on the application system Figure 14 Configuring Oracle ZDB Click OK The Oracle database is configured Exit t...

Page 66: ...RY_DB_LOGINCATALOG_DB_LOGIN ZDB_OPTIONS STANDBY_DB_LOGIN client CLIENT_NAME where PRIMARY_DB_LOGIN is prmuser PRIMARY_USERNAME prmpasswd PRIMARY_PASSWORD prmservice primary_net_service_name_1 primary_net_service_name_2 CATALOG_DB_LOGIN is rcuser CATALOG_USERNAME rcpasswd CATALOG_PASSWORD rcservice catalog_net_service_name STANDBY_DB_LOGIN is stbuser STANDBY_USERNAME stbpasswd STANDBY_PASSWORD stbs...

Page 67: ... Oracle Server home directory PRIMARY_USERNAME PRIMARY_PASSWORD Username and password for login to the target or primary database Note that the user must have the SYSDBA privilege granted primary_net_service_name_1 primary_net_service_name_2 Net services names for the primary database RAC Each net service name must resolve into a specific database instance CATALOG_USERNAME CATALOG_PASSWORD Usernam...

Page 68: ...age RETVAL 0 indicates successful configuration even if followed by additional messages Example The following example represents configuration on HP UX or Solaris of an Oracle database and its recovery catalog with the backup set method used and the parameter file location specified The following names are used in the example database name oracl primary user name system primary password manager pr...

Page 69: ...ification for the database If you use the Data Protector CLI a backup specification is not needed Using the Data Protector GUI 1 In the Context List select Backup 2 In the Scoping Pane expand Backup Specifications and then Oracle Server Click the backup specification to display the server with the database to be checked 3 Right click the server and click Check configuration IMPORTANT Data Protecto...

Page 70: ...msg 12 error_number HP UX Solaris opt omni lbin omnigetmsg 12 error_number IMPORTANT On UNIX it is possible that although you receive RETVAL 0 backup still fails because Data Protector does not check if the specified user has appropriate Oracle backup permissions Checking configuration for instant recovery Check if the Oracle configuration is suitable for instant recovery On the application system...

Page 71: ...and ZDB_ORA_NO_CHECKCONF_IR omnirc variables and ignore the warning However note that the control file SPFILE and online redo logs are overwritten during instant recovery See ZDB integrations omnirc variables on page 425 on how to set the omnirc variables Setting environmental variables Use environmental variables to modify backup environment to suit your needs Environmental variables are Oracle d...

Page 72: ...D_TIMEOUT This variable is applicable when Data Protector issues an SQL Plus query It specifies how long Data Protector waits for SQL Plus to respond that the query completed successfully If SQL Plus does not respond within the specified time Data Protector aborts the current session 300 s OB2_SQLP_SCRIPT_TIMEOUT To set environmental variables use the Data Protector GUI or CLI Using the Data Prote...

Page 73: ...e and click Add See Figure 15 Figure 15 Setting environmental variables Click OK Using the Data Protector CLI From the directory Windows Data_Protector_home bin HP UX Solaris and Linux opt omni lbin Other UNIX usr omni bin Zero downtime backup integration guide 73 ...

Page 74: ...llow the instructions given bellow to ensure a successful switch between both methods and to ensure that during a restore or recovery RMAN does not select backup objects backed up using different methods in one restore session If such a mixed set is used the restore procedure will fail To switch between the backup methods 1 Successfully back up the entire database using the currently selected meth...

Page 75: ...ackup To configure an Oracle ZDB perform the following steps 1 Configure the devices you plan to use for a backup See the online Help index configuring devices for instructions For a ZDB to disk you also need to configure a backup device as you will have to select it while configuring a backup specification Otherwise you cannot configure a backup specification for a ZDB to disk 2 Configure media p...

Page 76: ...mands in the Pre exec and Post exec commands for the client system in a particular backup specification or by using the Cluster Administrator You cannot perform a ZDB of the archived redo log files Therefore you need two create two backup specifications ZDB backup specification for backing up database files standard Data Protector Oracle integration backup specification for backing up the applicat...

Page 77: ...using the proxy copy method select the SMB_Proxy_Database template On EMC and XP In the Backup type drop down list select the Split mirror backup option and in the Sub type drop down list select the split mirror agent that is installed on the application and the backup systems EMC Symmetrix or HP StorageWorks XP See Figure 16 on page 77 Figure 16 Selecting an Oracle ZDB template and Split mirror b...

Page 78: ...Sub type drop down list select the snapshot agent you have installed on the application and the backup system HP StorageWorks VA or HP StorageWorks EVA SMI S See Figure 17 on page 78 Figure 17 Selecting an Oracle ZDB template and Snapshot backup Click OK Data Protector Oracle ZDB integration 78 ...

Page 79: ...8 on page 79 for EMC Figure 19 on page 81 for XP Figure 20 on page 82 for VA or Figure 21 on page 83 for EVA backup options For detailed information on the options press F1 On EMC In the EMC GeoSpan for Microsoft Cluster Service environment select the backup system for the active node and specify the TimeFinder configuration After a failover in EMC GeoSpan for MSCS select the backup system for the...

Page 80: ...ns On XP To enable instant recovery leave the Track the replica for instant recovery option selected Note that restore using Data Protector will not be possible if this option is cleared Data Protector Oracle ZDB integration 80 ...

Page 81: ...Figure 19 XP backup options On VA To enable instant recovery leave the Track the replica for instant recovery option selected Zero downtime backup integration guide 81 ...

Page 82: ...Figure 20 VA backup options On EVA To enable instant recovery select the Track the replica for instant recovery option Data Protector Oracle ZDB integration 82 ...

Page 83: ...Figure 21 EVA backup options Click Next Zero downtime backup integration guide 83 ...

Page 84: ...mple the user name ora group DBA This user must be configured as described in Configuring Oracle user accounts on page 57 Windows Server 2008 It is not mandatory to specify these options and if they are not specified the backup runs under the Local System Account In Username and Group Domain name specify the operating system user account under which you want the backup session to run for example t...

Page 85: ...Figure 22 Specifying an Oracle Server system Windows Zero downtime backup integration guide 85 ...

Page 86: ...BA user and group are also saved in both the Oracle database specific configuration file and Oracle client global configuration file overriding previous values if they exist 6 If the Oracle database is not configured yet for use with Data Protector the Configure Oracle dialog box is displayed Configure the Oracle database for use with Data Protector as described in Configuring Oracle databases on ...

Page 87: ... Protector do not back them up For more information see Oracle documentation Figure 24 Selecting backup objects Click Next If the backup method configured for this instance does not correspond to the method in the backup specification Data Protector will display a warning and abort the configuration Zero downtime backup integration guide 87 ...

Page 88: ...dditional copies mirrors of the backup during the backup session Specify the desired number of mirrors by clicking the Add mirror and Remove mirror buttons Select separate devices for the backup and for each mirror For detailed information on the object mirror functionality see the online Help index object mirroring NOTE Object mirroring is not supported for ZDB to disk Click Next to proceed Data ...

Page 89: ...option in the Application Specific Options dialog box This option stops the database before creating a replica and restarts it after the replica is created Note that if a ZDB to tape or ZDB to disk tape session is being performed the database is not offline during the actual backup to tape See Figure 25 on page 89 Figure 25 Backup offline option Zero downtime backup integration guide 89 ...

Page 90: ...mended that you save all Oracle backup specifications in the Oracle group IMPORTANT The word DEFAULT is a reserved word and therefore must not be used for backup specification names or labels of any kind Therefore do not use a punctuation in the names of backup specifications since the Oracle channel format is created from the backup specification name Figure 26 Saving the backup specification Cli...

Page 91: ...ape or ZDB to disk tape Select this option to disable backup of the recovery catalog Disable recovery catalog auto backup By default Data Protector backs up the Data Protector managed control file after every ZDB to tape or ZDB to disk tape Select this option to disable backup of the Data Protector managed control file Disable Data Protector managed control file backup This option is ignored for Z...

Page 92: ...base before creating a replica and restarts it after the replica is created See Figure 25 on page 89 Backup offline Examples of pre exec and post exec scripts on UNIX Pre exec example The following is an example of a script that shuts down an Oracle instance bin sh export ORACLE_HOME 2 export ORACLE_SQLNET_NAME 1 if f ORACLE_HOME bin sqlplus then ORACLE_HOME bin sqlplus EOF connect sys manager ORA...

Page 93: ...anual configuration convention must be used and not the Oracle automatic configuration convention Double quotes must not be used single quotes should be used instead By default RMAN scripts created by Data Protector contain instructions for backing up one or more of the following objects Databases tablespaces or datafiles the first backup command Archive logs the second backup command Control file...

Page 94: ... changing the concurrency number does not change the number of allocated channels in the RMAN script This has to be done manually by editing the RMAN script IMPORTANT On Windows systems a maximum of 32 or 64 if device is local channels can be allocated If the calculated number exceeds this limitation you have to manually edit the RMAN script and reduce the number of allocated channels When an Orac...

Page 95: ... RMAN backup statement for the backup of the whole database instance and or for any combination of RMAN commands to back up tablespaces and datafile The backup statement consists of the following The Oracle format of the backup file in the following format format Backup_Specification_Name DB_NAME_ s t p dbf database NOTE When an Oracle format of the backup file is manually defined or changed by ed...

Page 96: ...ckup_Specification_Name DB_NAME_ s t p dbf current controlfile NOTE When an Oracle format of the backup file is manually defined or changed by editing the RMAN script any user defined combination of the Oracle substitution variables can be added to the s t p substitution variables and DB_NAME which are obligatory The RMAN current controlfile command For Oracle proxy copy ZDB to disk or disk tape i...

Page 97: ...n must be started only after the preceding session that is using the same source volume on the application system has finished the ZDB session or restore otherwise the session will fail For the backup set method if the Oracle database is installed on symbolic links then these symbolic links have to be also created on the backup system On XP if the LVM mirroring configuration is used Data Protector...

Page 98: ...f a backup that starts unattended once the scheduling options are defined and saved in the backup specification For more information on scheduling see the online Help index scheduled backups To schedule an Oracle ZDB backup specification proceed as follows 1 In the Data Protector Manager switch to the Backup context 2 In the Scoping Pane expand Backup Specifications and then Oracle Server 3 Double...

Page 99: ...t mirror snapshot backup option See Figure 27 on page 99 NOTE You can run a ZDB to disk or a ZDB to disk tape session only if the Track the replica for instant recovery option is selected in the backup specification Figure 27 Selecting ZDB to disk or ZDB to disk tape session using the Data Protector scheduler Click OK and then Apply to save the changes Zero downtime backup integration guide 99 ...

Page 100: ...I Starting a backup using the GUI To start an interactive ZDB session of an Oracle database using the Data Protector GUI proceed as follows 1 In the Context List click Backup context 2 In the Scoping Pane expand Backup Specifications and then Oracle Server Right click the backup specification you want to start and click Start Backup Data Protector Oracle ZDB integration 100 ...

Page 101: ...is selected in the backup specification Figure 28 Selecting ZDB to disk or ZDB to disk tape session when starting an interactive backup Click OK Starting a backup using the CLI To start an Oracle ZDB to tape or ZDB to disk tape session using the Data Protector CLI run omnib oracle8_list Name To start an Oracle ZDB to disk session using the Data Protector CLI run omnib oracle8_list Name disk_only w...

Page 102: ...The following are the available methods in Data Protector for restoring database objects Standard restore from backup media to the application system on LAN See Restoring from backup media to the application system on LAN on page 104 Instant recovery See Instant recovery and database recovery on page 138 See also Table 3 on page 34 for an overview of recovery methods depending on the backup type a...

Page 103: ...and Do not restart for the DB_NAME world resource which is an Oracle Database resource Figure 30 Checking properties MC ServiceGuard clients When restoring the database from a backup performed on a virtual host you should set OB2BARHOSTNAME environment variable in the RMAN script For example Zero downtime backup integration guide 103 ...

Page 104: ... See Restoring Oracle using the Data Protector GUI on page 104 RMAN See Restoring Oracle using RMAN on page 123 Restoring Oracle using the Data Protector GUI For restore RMAN scripts are generated with necessary commands depending on selections made in the GUI To use additional commands use them manually from RMAN itself You can also use the workaround described in How to modify the RMAN restore s...

Page 105: ...into NoMount state run SQL startup nomount To put the database into Mount state run SQL startup mount Restoring the recovery catalog database The Oracle recovery catalog database is exported using the Oracle export utility to a binary file and backed up by Data Protector This file has to be restored back to the disk and then imported into the Oracle database using the Oracle import utility Data Pr...

Page 106: ...r Restore Objects expand Oracle Server expand the client on which the database for which you want to restore the recovery catalog resides and then click the database Data Protector Oracle ZDB integration 106 ...

Page 107: ...select RECOVERY CATALOG If you want to change the recovery catalog login information right click RECOVERY CATALOG and click Properties In Recovery Catalog Settings specify the login information for recovery catalog Figure 31 Recovery catalog settings dialog Zero downtime backup integration guide 107 ...

Page 108: ... control file Restoring from Data Protector managed control file backup CONTROLFILE FROM DP MANAGED BACKUP The control file was backed up automatically by ob2rman pl at the end of a backup session unless the option Disable Data Protector managed control file backup was selected The recovery catalog is not required for this restore option The control files ctrlDB_NAME dbf are restored to Windows Da...

Page 109: ...for the target database Set the other restore options See Restore recovery and duplicate options on page 119 for information 6 Click Restore Proceed with restoring the Oracle database objects Restoring Oracle database objects Before you restore Oracle database objects ensure that you have an up to date version of the recovery catalog database and the control file They contain the database structur...

Page 110: ...store recovery and duplicate options on page 119 IMPORTANT If you do not select Perform Restore and Recovery or Perform Recovery Only you will have to recover the database objects manually using RMAN For information see Restoring Oracle using RMAN on page 123 Figure 32 Source page Data Protector Oracle ZDB integration 1 10 ...

Page 111: ...atabase object click Restore As and in the Restore As dialog box specify the new datafile location NOTE When restoring to a new location current datafiles will be switched to the restored datafile copies only if you have selected Perform Restore and Recovery from the Restore action drop down list Zero downtime backup integration guide 1 1 1 ...

Page 112: ...l be started To restore the database objects to a different database than it is selected click Settings and specify the login information for the target database Set the other restore options See Restore recovery and duplicate options on page 119 for information Figure 33 Options page Data Protector Oracle ZDB integration 1 12 ...

Page 113: ...evice from which an item is restored select your desired device and click Change For more information on the Devices page press F1 Figure 34 Devices page 8 Click Restore After the restore 1 Put the database in the correct state If you selected Perform Restore and Recovery or Perform Recovery Only in the Source page then the database is automatically put into Open state by Data Protector Zero downt...

Page 114: ...if you have all archived redo logs on disk perform the following after the database is restored Open a command line window and enter the following commands sqlplus nolog SQL recover database SQL connect user password service as sysdba SQL alter database open Restoring tablespaces and datafiles To restore tablespaces and datafiles 1 Open a command line window and enter the following commands if you...

Page 115: ...re standby database Primary database control file was restored or recreated Database point in time recovery was performed on the primary database Switchover or failover of database roles occurred An independent copy with a unique DBID which can be used for data mining or testing purposes Prerequisites The whole primary database with the archived logs must be backed up Archive logs which have not b...

Page 116: ...e directory than the target database then the duplicate database name has to differ from other database names in that same Oracle home directory To duplicate a production database 1 On the client where the selected database will be duplicated put the Oracle auxiliary database instance in the nomount state See Changing the database state on page 105 2 In the Context List of the Data Protector GUI c...

Page 117: ...fail In User name and User group specify the user name and group for the OSDBA account which will be used by the Data Protector Oracle integration agent In Parallelism specify the number of RMAN auxiliary channels to be allocated for database duplication Set duplicate options For information see Duplicate options on page 120 or press F1 If you are creating a new database copy not for standby speci...

Page 118: ...n 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 Data Protector Oracle ZDB integration 1 18 ...

Page 119: ...recovering the database using RMAN see Restoring Oracle using RMAN on page 123 Perform Restore and Recovery Use this option to perform both the restore and recovery of the database objects using Data Protector Perform Recovery Only Use this option to only recover the database objects using Data Protector Perform RMAN Repository Restore Use this option to restore the recovery catalog or the control...

Page 120: ...g the Oracle RMAN proxy copy method such as ZDB of Oracle 9i This option is disabled when you perform recovery only Parallelism This field is used to specify the number of concurrent data streams that can read from the backup device The default value is one In case of Normal restore mode to optimize restore performance specify the same number of data streams as were used during the backup For exam...

Page 121: ...very options Restore until The options in this drop down list allow you to limit the selection to those backups that are suitable for an incomplete recovery to the specified time Now Use this option to restore the most recent full backup By default this option is selected Selected time Use this option to specify an exact time to which you wish the database to be restored Data Protector restores th...

Page 122: ... already reset and the backup will fail Login to the target and recovery catalog database and run rman target Target_Database_Login catalog Recovery_Catalog_Login RMAN RESET DATABASE RMAN exit Open database after recovery Opens the database after a recovery is performed Reset logs Resets the archive logs after the database is opened Always reset the logs After an incomplete recovery not Recover un...

Page 123: ...of restore are given Example of full database restore and recovery on page 126 Example of point in time restore on page 127 Example of tablespace restore and recovery on page 129 Example of datafile restore and recovery on page 131 Example of archive log restore on page 135 The restore and recovery procedure of Oracle control files is a very delicate operation which depends on the version of the O...

Page 124: ...tore them See the Oracle Recovery Manager User s Guide and References for more details If you have to perform a restore of the recovery catalog database you must perform this restore first Only then can you perform a restore of other parts of the Oracle database When you are sure that the recovery catalog database files are in place start the recovery catalog database Make sure that the following ...

Page 125: ...tabase sys manager PROD where sys is the username manager is the password and PROD is a net service name Recovery catalog connection string for recovery catalog database rman rman CATAL where rman is the username and password and CATAL is a net service name SBT_LIBRARY parameter On Windows and UNIX clients set the SBT_LIBRARY RMAN script parameter to point to the correct platform specific Data Pro...

Page 126: ...parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME restore database recover database sql alter database open release channel dev1 For a ZDB proxy copy session run allocate channel dev1 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2PROXYCOPY 1 OB2APPNAME DB_NAME restore database recover database sql alter database open...

Page 127: ...ni tmp restore_datafile Example of point in time restore To perform a point in time restore you also need to restore and apply the archive logs to the specified point in time To perform a point in time database restore and recovery 1 Log in to the Oracle RMAN On Windows ORACLE_HOME bin rman target sys manager PROD catalog rman rman CATAL On UNIX ORACLE_HOME bin rman target sys manager PROD catalog...

Page 128: ...el dev1 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2PROXYCOPY 1 OB2APPNAME DB_NAME allocate channel dev2 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME set until time Mar 14 2006 11 40 00 restore database release channel dev1 recover database sql alter database open release channel dev2 3 After you...

Page 129: ...need to perform a restore and recovery of the entire tablespace To restore a tablespace you may take only a part of the database offline so that the database does not have to be in the mount mode You can use either a recovery catalog database or control files to perform a tablespace restore and recovery Follow the steps below 1 Log in to the Oracle RMAN On Windows ORACLE_HOME bin rman target sys m...

Page 130: ...ecovery run allocate channel dev1 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2PROXYCOPY 1 OB2APPNAME DB_NAME allocate channel dev2 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME sql alter tablespace TEMP offline immediate restore tablespace TEMP release channel dev1 recover tablespace TEMP sql alte...

Page 131: ...restore using the saved files 1 Create a file restore_TAB in the var opt omni tmp UNIX systems or Data_Protector_home tmp Windows systems directory 2 Start the tablespace restore On Windows ORACLE_HOME bin rman target sys manager PROD catalog rman rman CATAL cmdfile Data_Protector_home tmp restore_TAB On UNIX ORACLE_HOME bin rman target sys manager PROD catalog rman rman CATAL cmdfile var opt omni...

Page 132: ...ev1 For a ZDB proxy copy session allocate one channel for restoring proxy copy sessions and one channel for database recovery Release the proxy copy channel before the recovery run allocate channel dev1 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME allocate channel dev2 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BA...

Page 133: ...sions and one channel for the recovery process Release the proxy copy channel before the recovery run allocate channel dev1 type sbt_tape parms SBT_LIBRARY Data_Protector_home bin orasbt dll ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME allocate channel dev2 type sbt_tape parms SBT_LIBRARY Data_Protector_home bin orasbt dll ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME OB2PROXYCOPY 1 sql alter database da...

Page 134: ...proxy copy channel before the recovery run allocate channel dev1 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME allocate channel dev2 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME OB2PROXYCOPY 1 restore datafile opt oracle data oradata DATA temp01 dbf release channel dev2 recover data...

Page 135: ... restore datafile Oracle_home data oradata DATA temp01 dbf release channel dev2 recover datafile Oracle_home data oradata DATA temp01 dbf release channel dev1 You can also save the script into a file and perform a datafile restore using the saved files 1 Create a file restore_dbf the var opt omni tmp or Data_Protector_home tmp Windows systems directory 2 Start the datafile restore On Windows ORACL...

Page 136: ...or_home tmp Windows systems directory 2 Start the archive log restore On Windows ORACLE_HOME bin rman target sys manager PROD catalog rman rman CATAL cmdfile Data_Protector_home tmp restore_arch On UNIX ORACLE_HOME bin rman target sys manager PROD catalog rman rman CATAL cmdfile var opt omni tmp restore_arch Example of database restore using a different device with the automatic device selection f...

Page 137: ...TO_DEVICE_SELECTION 1 disables the automatic device selection Restoring using another device Data Protector supports the restore of Oracle database objects from devices other than those on which the database objects were backed up Specify these devices in the etc opt omni server cell restoredev UNIX systems or Data_Protector_home Config server Cell restoredev Windows systems file in the following ...

Page 138: ...hive logs that do not reside on the target volumes are restored IMPORTANT If the Oracle control file online redo logs and SPFILE are on the same source volumes as datafiles and you enable instant recovery by setting the omnirc variables note that the control file SPFILE and online redo logs are overwritten during the instant recovery Prerequisites The control file that reflects the internal databa...

Page 139: ...ariable as the virtual hostname before running the configuration from the command line export OB2BARHOSTNAME virtual_hostname Instant recovery using the Data Protector GUI To perform an instant recovery 1 Shut down the Oracle database instance using sqlplus In case of RAC shut down all instances For example sqlplus sql shutdown immediate sql exit 2 In the Context List click Instant Recovery 3 Expa...

Page 140: ...t is recommended to leave the Keep the replica after the restore option set to enable a restart of an instant recovery session For HP StorageWorks Enterprise Virtual Array replica is kept on the array only if the Copy replica data to the source location is selected Figure 36 Selecting backup sessions XP example Data Protector Oracle ZDB integration 140 ...

Page 141: ...e database recovery after the instant recovery on page 142 To perform a database recovery immediately after an instant recovery click on the Options tab select Recovery and then select the database recovery options For a recovery until a selected time logseq thread number or SCN number it is recommended to reset the log files See Figure 37 on page 141 and Restore recovery and duplicate options on ...

Page 142: ...herwise Oracle will during the next backup try to use the logs that were already reset and the backup will fail Login to the target and recovery catalog database and run rman target Target_Database_Login catalog Recovery_Catalog_Login RMAN RESET DATABASE RMAN exit Oracle database recovery after the instant recovery To recover the Oracle database after the instant recovery has been performed perfor...

Page 143: ...ting the database for recovery b In the Options tab select the recovery options For details see Restore recovery and duplicate options on page 119 c Click Restore Perform a manual database recovery using RMAN Run the following RMAN script to recover the database run allocate channel dev1 type sbt_tape parms SBT_LIBRARY opt omni lib libob2oracle8 so ENV OB2BARTYPE Oracle8 OB2APPNAME DB_NAME recover...

Page 144: ...ffline application_resource_name sys system where application_resource_name is the name of the Veritas Cluster application resource for the Oracle application and system is the name of the active node hares offline mountpoint_resource_name sys system where mountpoint_resource_name is the name of the Veritas Cluster mountpoint resource for the Oracle database files and system is the name of the act...

Page 145: ...oint resource for the Oracle database files and system is the name of the active node Aborting sessions You can abort currently running sessions by clicking the abort button If during a session RMAN or SQL Plus do not respond when requested Data Protector automatically aborts the session By default Data Protector waits for the response for 5 minutes Using omnirc or environmental variables OB2_RMAN...

Page 146: ... recognized issues and workarounds See http www hp com support manuals for an up to date list of supported versions platforms and other information Checks and verifications For more detailed information about how to perform any of the following procedures see the Oracle documentation If your configuration backup or restore failed On the application system verify that you can access the Oracle targ...

Page 147: ...he ORACLE_HOME and DB_NAME variables as described in Step 1 on page 146 2 Start SQL Plus from the bin directory in the ORACLE_HOME directory sqlplus nolog 3 Start SQL Plus and type connect Recovery_Catalog_Login select from rcver exit If this fails open the recovery catalog Verify that the listener is correctly configured for the Oracle target database and the recovery catalog database This is req...

Page 148: ...ls Services Figure 39 Checking the status of the Oracle listener The status of the respective listener service in the Services window should be Started otherwise you must start it manually 3 Start SQL Plus from the bin directory in the ORACLE_HOME directory sqlplus nolog 4 Start SQL Plus and type connect Target_Database_Login exit and then connect Recovery_Catalog_Login exit If this fails see the ...

Page 149: ...See the Oracle documentation for how to set up a password file and parameters in the initDB_NAME ora file and how to add system privileges for a user See the section Recovery Manager Connection Options in the Oracle Backup and Recovery Guide for information If you use the recovery catalog database verify that the target database is registered in the recovery catalog 1 Export or set the ORACLE_HOME...

Page 150: ... backup try to restore the backed up tablespace by running the following restore script run allocate channel dev0 type disk sql alter tablespace tablespace_name offline immediate restore tablespace tablespace_name recover tablespace tablespace_name sql alter tablespace tablespace_name online If this fails see the Oracle documentation for details on how to execute a backup and restore directly to d...

Page 151: ...tive Tools Services Data Protector Inet The service must run under a specified user account Make sure that the same user is also added to the Data Protector admin or user group Examine the system errors reported in the following file on the application system Oracle proxy copy ZDB method or backup system Oracle backup set ZDB method HP UX Solaris var opt omni log debug log Windows Data_Protector_h...

Page 152: ...Protector operator or admin user group Check that the respective Data Protector user group has the See private objects user right enabled If backup failed Create an Oracle backup specification to back up to a null device or file If the backup succeeds the problem may be related to the backup devices See the HP Data Protector troubleshooting guide for instructions on troubleshooting devices If rest...

Page 153: ...down immediate SQL startup mount If there is a problem you cannot resolve while you are trying to restore a database item using the Data Protector GUI try using the RMAN CLI to restore the database items For information see Restoring Oracle using RMAN on page 123 Try putting the database into the Open state manually after using the Data Protector GUI to recover and restore a backup session If you ...

Page 154: ...to configure the application system in such a way that it consumes as little resources as possible This error can be reproduced without using Data Protector by starting SQL Plus on the application system and connecting to the target database on the application system Problem Backup set ZDB is aborted after 10 minutes While performing a backup set ZDB the following warning is displayed for each dat...

Page 155: ... displayed for example RMAN 06056 could not access datafile datafile The problem occurs because the physical schema of target database is not updated in the recovery catalog Action Manually re synchronize the recovery catalog database with the current control file Problem Proxy copy restore fails Proxy copy restore fails with the following error RMAN 10035 exception raised in RPC ORA 27197 skgfprs...

Page 156: ...annel allocated for backup files made using the previous method As a result the restore procedure fails Figure 40 Restore after a switch between ZDB methods fails Action Restore the backup session manually using RMAN scripts Add the required parameter to the allocated channels that is OB2PROXYCOPY 1 for the channel which will be used for restoring the backup made using the proxy copy ZDB method Th...

Page 157: ...a Protector reports 12 8422 error when using Data Protector Oracle integration after an upgrade of Oracle 8i to Oracle 9i After Oracle 8i is upgraded to Oracle 9i the following error is returned during the configuration of Oracle instance or during the backup RETVAL 8422 Action Rename the Oracle 8i svrmgrl binary to something else so that Data Protector will not find it The Oracle upgrade process ...

Page 158: ...granted beforehand sqlplus sys password CDB as sysdba SQL grant execute on sys lt_export_pkg to public Restart the failed backup session Problem On UNIX Data Protector reports Cannot allocate attach shared memory Backup fails and the following error message is displayed Cannot allocate attach shared memory IPC Cannot Allocate Shared Memory Segment System error 13 Permission denied aborting Action ...

Page 159: ...220 controlfile copy not found in the recovery catalog When running an online backup Data Protector adds the filename of the controlfilecopy to the RMAN backup script This filename has to be cataloged to the RMAN catalog prior to the backup command Action To catalog the controlfilecopy to the RMAN catalog 1 Connect to RMAN on the application system 2 Run the following command RMAN catalog controlf...

Page 160: ... INSTANCE_2 backup format RAC_arch QU_ s t p dbf archivelog all Problem The Recovery Catalog was lost and the control file cannot be restored from Data Protector managed backup The Recovery Catalog was not used the RMAN autobackup feature was not used and the control file cannot be restored from Data Protector managed backup A valid control file backup exists on tape Action Restore the control fil...

Page 161: ...Oracle_host 3 Restart Data Protector and try to restore the database items again 4 When the restore is complete close Data Protector and re set the following environment variable OB2_ORARESTHOSTNAME empty 5 Restart Data Protector Problem How to modify the RMAN restore script When you start a restore of an Oracle database using the Data Protector GUI or CLI an RMAN restore script is created which i...

Page 162: ...omnirc options To start a restore using Data Protector again clear the OB2RMANSAVE variable by deleting its content or commenting or removing the whole variable If you comment or remove the variable on a Windows client restart the Data Protector Inet service for the settings to take effect Data Protector Oracle ZDB integration 162 ...

Page 163: ...ata files control files online redo logs offline archived redo logs SAP R 3 logs and parameter files Data Protector supports offline and online backups During an online backup the SAP R 3 application is actively used Data Protector offers interactive and scheduled backups of the following types ZDB to disk ZDB to tape ZDB to disk tape Data Protector supports only a filesystem restore You can resto...

Page 164: ...k Array XP XP BC combined CA BC HP StorageWorks Enterprise Virtual Array EVA BC HP StorageWorks Virtual Array VA This chapter provides information specific to the Data Protector SAP R 3 ZDB integration For general Data Protector procedures and options see the online Help For details on ZDB terminology ZDB types advantages of offline and online backups and instant recovery concepts see the HP Data ...

Page 165: ...see ZDB integrations omnirc variables on page 425 ZDB flow For details on how ZDB options affect the ZDB flow including mounting activating volume disk groups and so on see the HP Data Protector zero downtime backup administrator s guide Zero downtime backup integration guide 165 ...

Page 166: ...de online backup or shuts down the database offline backup and starts the split command on the application system with the list of files to be included in the replica creation The database is put out of the backup mode online backup or is restarted offline backup after the replica is created NOTE Data Protector can use the splitint interface if BRTOOLS supports it to reduce the time during which t...

Page 167: ...backup is streamed to tape 6 When the data transfer completes the backup system is disabled filesystems are unmounted on all platforms and volume disk groups deactivated on UNIX 7 EMC and XP only Links are re established depending on how ZDB options are specified Data Protector SAP R 3 configuration file Data Protector stores the integration parameters for every configured SAP R 3 database in the ...

Page 168: ...le match the examples NOTE You can set up the parameters in the Environment section sublist of the file by referring to other environment variables in the following way SAPDATA_HOME ORACLE_HOME data Syntax The syntax of the Data Protector SAP R 3 configuration file is as follows ORACLE_HOME ORACLE_HOME ConnStr ENCODED_CONNECTION_STRING_TO_THE_TARGET_DATABASE BR_directory BRTOOLS_HOME SAPDATA_HOME ...

Page 169: ...Example This is an example of the file ORACLE_HOME app oracle805 product ConnStr EIBBKIBBEIBBFIBBGHBBOHBB QDBBOFBBCFBBPFBBCFBBIFBBGFBBDGBBBFBBCFBBDFBBCFBB BR_directory usr sap ABA SYS exe run SAPDATA_HOME sap ORA_NLS_CHARACTERSET USASCII7 OSUSER orasid OSGROUP dba Environment SAP_Parameters sap_weekly_offline concurrency 1 no_balance sap_daily_online concurrency 3 load_balance sap_daily_manual con...

Page 170: ...md putopt setting a parameter util_cmd getopt retrieving a parameter or util_cmd getconf listing all parameters command on the Data Protector SAP R 3 client The command resides in the Data_Protector_home bin Windows systems or opt omni lbin HP UX Solaris systems directory Cluster aware clients In a cluster environment the environment variable OB2BARHOSTNAME must be defined as the virtual hostname ...

Page 171: ... and its value are taken from the Data Protector SAP R 3 configuration file and then written to the standard output When it is used with the putopt ion option it specifies the filename for the output of the command to be written to If the local option is not specified the output is written to the Data Protector SAP R 3 configuration file NOTE If you are setting the option_value parameter as a numb...

Page 172: ... opt omni lbin util_cmd putopt SAP ICE OB2OPTS debug 1 200 debug txt sublist Environment opt omni lbin util_cmd putopt SAP ICE BR_TRACE 10 sublist Environment Retrieving parameters To retrieve the value of the OB2OPTS parameter for the Oracle instance ICE use the following command on the Data Protector SAP R 3 client On Windows Data_Protector_home bin util_cmd getopt SAP ICE OB2OPTS sublist Enviro...

Page 173: ...ntication password file See Authentication password file on page 178 5 Optionally set the archived logging mode to enable online backups See Enabling archived logging on page 179 6 Share directories on the application system See Sharing directories on the application system on page 180 7 Configure every SAP R 3 database you intend to back up from or restore to See Configuring SAP R 3 databases on ...

Page 174: ...r s guide For information on the Data Protector Cell Manager package configuration in the MC SG cluster see the online Help index MC ServiceGuard integration NOTE You cannot run ZDB sessions in the RMAN mode Before you begin Configure devices and media for use with Data Protector To test whether the SAP R 3 system and the Cell Manager communicate properly configure and run a Data Protector filesys...

Page 175: ...Data_Protector_home bin to the directory that stores the SAP backup tools and renames ob2smbsplit exe to splitint exe This is done only on the currently active node On the other node do it manually If you intend to use the Data Protector CLI set the Data Protector environment variable OB2BARHOSTNAME to the virtual server name as follows Windows set OB2BARHOSTNAME virtual_server_name UNIX export OB...

Page 176: ...User account root UNIX systems only Database user account granted at least the following Oracle roles sysdba sysoper For example user system Oracle database user account Add the following user accounts to the Data Protector admin or operator user group Oracle operating system user account UNIX systems only User account root for both the application system and backup system In cluster environments ...

Page 177: ..._HOME network admin Example Oracle instance PRO Application system alpha hp com LISTENER DESCRIPTION_LIST DESCRIPTION ADDRESS PROTOCOL TCP HOST alpha hp com PORT 1522 SID_LIST_LISTENER SID_LIST SID_DESC GLOBAL_DBNAME PRO SID_NAME PRO ORACLE_HOME app oracle815 product listener ora PRO DESCRIPTION ADDRESS_LIST ADDRESS PROTOCOL TCP HOST alpha hp com PORT 1522 CONNECT_DATA SERVICE_NAME PRO tnsnames or...

Page 178: ...then with the sysoper role Example For the following configuration Oracle instance PRO ORACLE_HOME app oracle816 product run id uid 102 oraprod gid 101 dba export ORACLE_SID PRO export ORACLE_HOME app oracle816 product export SHLIB_PATH app oracle816 product lib opt omni lbin sqlplus nolog SQLPLUS connect system manager PRO as sysdba Connected SQLPLUS connect system manager PRO as sysoper Connecte...

Page 179: ...he online backup immediately after BRBACKUP completes To protect the archive directory from overflowing clear the directory regularly To enable archived logging 1 In the initORACLE_SID ora file set log_archive_start true and specify the log_archive_dest option Example This is an example of the initORACLE_SID ora file for the Oracle instance PRO initSID ora 20 4 6 1 SAP 98 03 30 c Copyright SAP AG ...

Page 180: ...mount ORACLE instance started Total System Global Area 6060224 bytes Fixed Size 47296 bytes Variable Size 4292608 bytes Database Buffers 1638400 bytes Redo Buffers 81920 bytes Database mounted SQLPLUS alter database archivelog Statement processed SQLPLUS archive log start Statement processed SQLPLUS alter database open Sharing directories on the application system The following directories on the ...

Page 181: ...ystem Ensure that you have the same directory structure on both the application and backup system For example suppose that you have an HP UX application system app company com To mount the oracle SID sapbackup directory on the backup system add the following line to the file etc fstab on the backup system app company com oracle SID sapbackup oracle SID sapbackup nfs defaults 0 0 Windows applicatio...

Page 182: ...ata Protector SAP R 3 integration environment variables ORACLE_HOME SAPDATA_HOME SAPBACKUP SAPREORG Choosing authentication mode Data Protector SAP R 3 ZDB integration supports two authentication modes for accessing Oracle databases that are used by SAP R 3 database authentication mode operating system authentication mode With database authentication mode you need to re configure the SAP R 3 integ...

Page 183: ...e To configure an SAP R 3 database use the Data Protector GUI or CLI Before you begin Ensure that the SAP R 3 database is open Using the Data Protector GUI 1 In the Context List click Backup 2 In the Scoping Pane expand Backup Specifications right click SAP R 3 and click Add Backup 3 In the Create New Backup dialog box select the template In the Backup type drop down list select the Split mirror b...

Page 184: ...omain name type dba Windows Server 2008 In Username and Group Domain name specify the operating system user account under which you want the backup session to run for example the user name Administrator domain DP Ensure that this user has been added to the Data Protector admin or operator user group and has the SAP R 3 backup rights This user becomes the backup owner Figure 43 Specifying an SAP R ...

Page 185: ...ce empty For the remote operating system authentication mode specify only Service leave Username and Password empty The following are the option descriptions Username and Password Specify the user name and password of the Oracle database user account described in Configuring user accounts on page 175 Service Specify the Oracle service name In Backup and restore executables directory specify the pa...

Page 186: ...eating the backup specification at Step 7 on page 201 Using the Data Protector CLI 1 Log in to the SAP R 3 system using the Oracle operating system user account 2 At the command prompt change current directory to the following directory Windows systems Data_Protector_home bin HP UX Solaris systems opt omni lbin 3 Run util_sap exe CONFIG ORACLE_SID ORACLE_HOME targetdb_connection_string SAPTOOLS_DI...

Page 187: ...ication mode specify the login information to the target database in the format Oracle_service SAPTOOLS_DIR Pathname of the directory that stores the SAP backup utilities SAPDATA_HOME Pathname of the directory where the SAP R 3 data files are installed By default this parameter is set to ORACLE_HOME The message RETVAL 0 indicates successful configuration Handling errors If you receive the message ...

Page 188: ...configuration You can check the configuration of an SAP R 3 database after you have created at least one backup specification for this database Use the Data Protector GUI or CLI Using the Data Protector GUI 1 In the Context List select Backup 2 In the Scoping Pane expand Backup Specifications and then SAP R 3 Click the backup specification to display the Oracle instance to be checked 3 Right click...

Page 189: ...ORACLE_SID is the name of the Oracle instance A successful configuration check displays the message RETVAL 0 If you receive the message RETVAL error_number where error_number is different than zero an error occurred On how to get the error description see Handling errors on page 187 To check if the SAP R 3 configuration is suitable for instant recovery from the directory Windows Data_Protector_hom...

Page 190: ...itORACLE_SID sap Windows ORACLE_HOME database initORACLE_SID sap Table 10 SAP parameter file settings Value Description Parameter On the application system UNIX opt omni lbin ob2smbsplit Windows Data_Protector_home bin ob2smbsplit On the backup system you do not need to set the parameter BRBACKUP uses this parameter to trigger the replica creation At run time the optional sign is replaced with the...

Page 191: ...separate non ZDB backup specification for backing up archived logs What is backed up depends on your selection in the backup specification For details see Table 1 1 on page 191 Table 1 1 What is backed up Backed up files Selected items offline archived redo logs control files ARCHIVELOGS data files control files SAP R 3 logs and parameter files online redo logs only during offline backups DATABASE...

Page 192: ...imultaneously You cannot start a ZDB to disk session if another session is backing up the archived logs even if the Oracle data files and the archived logs reside on different source volumes ZDB to disk only BRBACKUP displays the following error which should be ignored Ignoring BRBACKUP return value 5 because it is disk only backup XP only If the LVM Mirroring configuration is used Data Protector ...

Page 193: ... 1 On how to set the omnirc variable see the online Help index omnirc options Creating backup specifications Create a backup specification using the Data Protector Manager 1 In the Context List click Backup 2 In the Scoping Pane expand Backup Specifications right click SAP R 3 and click Add Backup Zero downtime backup integration guide 193 ...

Page 194: ...shot backup The database is stopped during the creation of a replica Brbackup_SMB_Offline Used for an online ZDB split mirror or snapshot backup The database is active during the creation of a replica Brbackup_SMB_Online Used for an offline ZDB split mirror or snapshot backup using splitint The database is stopped Brbackup_SPLITINT_Offline during the creation of a replica The database is Data Prot...

Page 195: ...atabase is active during the creation of a replica The database is in the backup mode for a shorter period of time than if SMB_online was used but splitint must be supported by BRTOOLS Brbackup_SPLITINT_Online In Backup type select EMC and XP Split mirror backup VA and EVA Snapshot backup In Sub type select the appropriate disk array agent Zero downtime backup integration guide 195 ...

Page 196: ...k array specific backup options see Figure 48 on page 196 for EMC Figure 49 on page 197 for XP Figure 50 on page 198 for VA or Figure 51 on page 199 for EVA for EVA For details on the options press F1 NOTE XP VA and EVA only To enable instant recovery leave Track the replica for instant recovery selected Figure 48 EMC backup options Data Protector SAP R 3 ZDB integration 196 ...

Page 197: ...Figure 49 XP backup options Zero downtime backup integration guide 197 ...

Page 198: ...Figure 50 VA backup options Data Protector SAP R 3 ZDB integration 198 ...

Page 199: ...Figure 51 EVA backup options Click Next Zero downtime backup integration guide 199 ...

Page 200: ...oup Domain name specify the operating system user account under which you want the backup session to run for example the user name Administrator domain DP Ensure that this user has been added to the Data Protector admin or operator user group and has the SAP R 3 backup rights This user becomes the backup owner Click Next 6 If the SAP R 3 database is not configured yet for use with Data Protector t...

Page 201: ...acked up You can select individual tablespaces data files or archived logs NOTE If you plan to do instant recovery select the whole DATABASE item Figure 52 Selecting backup objects Click Next Zero downtime backup integration guide 201 ...

Page 202: ...r of parallel backup streams in the Concurrency tab and the media pool NOTE Parallelism the number of streams your SAP R 3 database is backed up with is set automatically If load balancing is used the number of streams equals the sum of concurrencies of the selected devices Click Next Data Protector SAP R 3 ZDB integration 202 ...

Page 203: ...3 on page 204 Figure 53 Application specific options Click Next 10 Optionally schedule the backup See Scheduling backup specifications on page 206 Click Next 1 1 Save the backup specification specifying a name and a backup specification group Zero downtime backup integration guide 203 ...

Page 204: ...atabase user than the one specified during the configuration type u user_name BR Backup Lists BRBACKUP options passed by omnisap exe The list is displayed after you save the backup specification Backup Objects Specifies BRARCHIVE options Not applicable for ZDB to disk BR Archive Groups files into subsets of approximately equal sizes The subsets are then backed up concurrently by Data Protector sap...

Page 205: ...e manual balancing section of the Data Protector SAP R 3 configuration file For more information see Manual balancing on page 214 Not applicable for ZDB to disk Balancing Manual No balancing is used The files are backed up in the same order as they are listed in the internal Oracle database structure To check the order use the Oracle Server Manager SQL command select from dba_data_files Balancing ...

Page 206: ...p index scheduled backups Scheduling example To schedule ZDB to disk tape at 8 00 13 00 and 18 00 during week days 1 In the Schedule property page select the starting date in the calendar and click Add to open the Schedule Backup dialog box 2 Under Recurring select Weekly Under Time options select 8 00 Under Recurring Options select Mon Tue Wed Thu and Fri In Split mirror snapshot backup drop down...

Page 207: ...1 In the Context List click Backup 2 In the Scoping Pane expand Backup Specifications and then SAP R 3 Right click the backup specification you want to preview and click Preview Backup 3 Specify Backup type and Network load Click OK The message Session completed successfully is displayed at the end of a successful preview Zero downtime backup integration guide 207 ...

Page 208: ...the necessary media are in the devices Starting backup sessions Interactive backups are run on demand They are useful for urgent backups or restarting failed backups Backup methods Start a backup of SAP R 3 objects in any of the following ways Using the Data Protector GUI Using the Data Protector CLI Using the SAP BR Tools Using the Data Protector GUI 1 In the Context List click Backup 2 In the Sc...

Page 209: ...otector CLI From the directory Windows Data_Protector_home bin HP UX Solaris opt omni bin run ZDB to tape ZDB to disk tape omnib sap_list backup_specification_name ZDB to disk omnib sap_list backup_specification_name disk_only For details see the omnib man page or the HP Data Protector command line interface reference Using the SAP BRTOOLS 1 Log in to the SAP R 3 backup system or SAP R 3 applicati...

Page 210: ...al if you want to specify a virtual server name in cluster environments OB2BACKUPHOSTNAME backup_system_name Required if you are logged in to the application system OB2SMB 1 Specifies a ZDB session OB2SMBIR 1 Specifies tracking replica for instant recovery ZDB_ORA_INCLUDE_CF_OLF 1 Required if you are logged in to the backup system For details see ZDB integrations omnirc variables on page 425 OB2DI...

Page 211: ...face BRBACKUP is started on the backup system and not on the application system You can configure Data Protector to comply with these standards by setting the Data Protector OB2_MIRROR_COMP environmental variable to 1 The variable is saved in the Data Protector SAP R 3 instance configuration file Consequently in all splitint ZDB sessions for this SAP R 3 instance BRBACKUP will be started on the ba...

Page 212: ...d Specifically the Data Protector instant recovery check fails In such a case clear the option first You can select the option later if needed when the OB2_MIRROR_COMP variable is already set and consequently the instant recovery check is no longer performed Right click the SAP R 3 instance at the top and click Set Environmental Variables 2 In the Advanced dialog box set OB2_MIRROR_COMP to 1 See F...

Page 213: ...e Data Protector CLI From the directory Windows Data_Protector_home bin HP UX Solaris and Linux opt omni bin Other UNIX usr omni bin run util_cmd putopt SAP instance_name OB2_MIRROR_COMP 1 sublist Environment Zero downtime backup integration guide 213 ...

Page 214: ...than the sum of the concurrencies of all devices specified for backup If the backup specification contains files that are not allocated to any subset Data Protector automatically adds these files to the list of files to be backed up using the load balancing principle Before the backup this list is logged in UNIX ORACLE_HOME sapbackup lst Windows SAPDATA_HOME sapbackup lst Restore You can restore S...

Page 215: ...ber Until now Restore Restore Restore ZDB to tape online XP VA EVA EMC Restore Restore Restore ZDB to tape offline N A Instant recovery database recovery Instant recovery database recovery ZDB to disk online XP VA EVA N A N A N A ZDB to disk offline Restore Instant recovery database recovery or Restore Instant recovery database recovery or Restore ZDB to disk tape online Restore Restore Restore ZD...

Page 216: ...r example brrestore If your Oracle database is localized you may need to set the appropriate Data Protector encoding before you start a restore For details see Localized SAP R 3 objects on page 228 Restore preview is not supported Standard restore Restore SAP R 3 objects using the Data Protector Manager 1 In the Context List click Restore 2 In the Scoping Pane expand SAP R 3 expand the client back...

Page 217: ...under a different name or to a different directory right click the file and click Restore As Into To restore a file from a specific backup session right click the file and click Restore Version Figure 56 Selecting objects for restore Zero downtime backup integration guide 217 ...

Page 218: ...tails on options press F1 Figure 57 Selecting the target client 5 In the Options page set the restore options For information press F1 6 In the Devices page select devices to use for the restore 7 Click Restore 8 In the Start Restore Session dialog box click Next 9 Specify Report level and Network load Data Protector SAP R 3 ZDB integration 218 ...

Page 219: ...metrix Agent and HP StorageWorks XP Agent components installed on the application system EMC Select EMC Symmetrix restore XP Select StorageWorks XP restore See Figure 58 on page 219 Figure 58 Selecting the XP restore Click Next Zero downtime backup integration guide 219 ...

Page 220: ...e restore from backup media to the application system directly See Figure 59 on page 220 Figure 59 EMC Selecting restore to the application system directly Figure 60 XP Selecting restore to the application system directly 12 Click Finish to start the restore Data Protector SAP R 3 ZDB integration 220 ...

Page 221: ...formed after the instant recovery procedure During database recovery archive log backups performed after the ZDB are restored from tape by the SAP BR Tools utilities If selected the logs are reset and the database is opened If the replica to be used for instant recovery contains the control file first see Instant recovery from replicas containing the control file on page 226 Instant recovery using...

Page 222: ...on The option is selected by default except for an offline backup where the database was in NOARCHIVELOG mode during the backup For HP StorageWorks Enterprise Virtual Array replica is kept on the array only if the Copy replica data to the source location is selected Set the HP StorageWorks Enterprise Virtual Array or HP StorageWorks Disk Array XP options For details press F1 Figure 61 SAP R 3 sour...

Page 223: ...ly Specifies the user name under which the instant recovery is performed The user needs to be a member of the DBA group User group UNIX systems only Specifies the user group the user in the User name field belongs to NOTE The User name and the User group must be the same as defined in the backup ownership Recovery Enables database recovery after instant recovery Recover until The options in this d...

Page 224: ...fault not selected if the Recover until option is set to Now The following are Oracle recommendations on when to reset the logs Always reset the logs After an incomplete recovery that is if not all archive redo logs are applied If a backup of the control file is used for recovery Do not reset the logs After a complete recovery when the control file is not used If the archive logs are used for a st...

Page 225: ...ng the Data Protector CLI From the directory Windows Data_Protector_home bin HP UX opt omni bin run omnir sap host ClientName session SessionID DISK_ARRAY_XP_OPTIONS ENTERPRISE_VIRTUAL_ARRAY_OPTIONS appname DB_Name Zero downtime backup integration guide 225 ...

Page 226: ... to be able to do a database recovery afterwards A replica contains the control file if it is created in any of the following sessions Online ZDB session with the omnirc variable ZDB_ORA_INCLUDE_CF_OLF set to 1 Online SAP compliant ZDB session Offline ZDB session any configuration NOTE An offline ZDB session also contains online redo logs You can use such a session to restore the SAP R 3 database ...

Page 227: ...Restoring using another device You can restore using a device other than that used for backup Using the Data Protector GUI On how to specify another device for restore using the Data Protector GUI see the online Help index restore selecting devices for Using the Data Protector CLI or SAP commands If you are restoring using the Data Protector CLI or SAP R 3 commands specify the new device in the fi...

Page 228: ...e ZDB restore or instant recovery sessions fail due to invalid characters in filenames on page 240 Monitoring sessions You can monitor currently running sessions in the Data Protector GUI When you run an interactive backup or a restore session a monitor window shows you the progress of the session Closing the GUI does not affect the session You can also monitor sessions from any Data Protector cli...

Page 229: ...m support manuals General troubleshooting Problem Data Protector reports 12 8422 error when using Data Protector Oracle integration after an upgrade of Oracle8i to Oracle9i After Oracle8i is upgraded to Oracle9i the following error is returned during the configuration of Oracle instance or during the backup RETVAL 8422 Action Rename the Oracle8i svrmgrl binary to something else so that Data Protec...

Page 230: ...tion steps in numerical order to verify that Oracle is installed properly 1 On the application system verify that the target database is online as follows UNIX export ORACLE_SID Oracle_SID export ORACLE_HOME Oracle_home_path ORACLE_HOME bin sqlplus Windows set ORACLE_SID Oracle_SID set ORACLE_HOME Oracle_home_path ORACLE_HOME bin sqlplus At the SQLPlus prompt type connect user passwd service selec...

Page 231: ...ORACLE_SID Oracle_SID set ORACLE_HOME Oracle_home_path ORACLE_HOME bin sqlplus At the SQLPlus prompt type connect user passwd service exit If it fails refer to the Oracle documentation on how to create the TNS configuration file TSNAMES ORA Verifying the prerequisites SAP side Before you begin the steps in this section be sure you have completed all the steps in Verifying the prerequisites Oracle ...

Page 232: ...es required by the SAP SAPDATA_HOME SAPBACKUP and then start the command with the backup owner user brbackup t offline_split d util_file u user password c or if Data Protector uses splitint brbackup t offline_mirror d util_file u user password c If you receive arguments from backint that means SAP is properly configured for backup using backint Otherwise you should reconfigure SAP Verifying the co...

Page 233: ...ify the permissions of the SAP user on application system SAP user permissions must be set to enable you to perform an SAP backup or restore with Data Protector See Configuring user accounts on page 175 Use the testbar2 to check the permissions Login in as an SAP user Execute opt omni bin testbar2 perform checkuser If the user account has all the required permissions you will see only the usual me...

Page 234: ...aris opt omni lbin omnigetmsg 12 error_number 2 Verify the SAP user Check that the respective user group has the See Private Objects user right selected Also refer to Configuring user accounts on page 175 3 On the application system verify the backup using testbar2 Execute the following to ensure that communication within Data Protector is established Create a non ZDB backup specification on the a...

Page 235: ...em or call a support representative for assistance Verifying restore Before you begin this section be sure that you completed all the steps provided in the sections Verifying the prerequisites Oracle side on page 230 and Verifying the prerequisites SAP side on page 231 Perform the following verification steps in numerical order to verify that Data Protector is configured properly 1 Verify the user...

Page 236: ...nt f inquiry u ORACLE_SID or alternatively you can just specify NULL as backint_ID_1 in the input_file In this case the latest backup session for the file is used for the restore If it fails proceed as follows Check the backup session was it successful Check the user rights Was the query started under the correct SAP user account Call a support representative for assistance 3 Verify the restore us...

Page 237: ... i input_file where input_file specifies what will be restored backint expects the list of files in the following format backint_ID_1 pathName_1 targetDirectory_1 backint_ID_2 pathName_2 targetDirectory_2 backint_ID_3 pathName_3 targetDirectory_3 To retrieve the backint_ID numbers enter the following command echo NULL NULL backint f inquiry u ORACLE_SID or alternatively you can just specify NULL a...

Page 238: ...em using Oracle Server Manager If you cannot log in then perform the following actions Check whether sysoper and sysdba rights are set for the Oracle administrator user Examine system errors reported in On UNIX var opt omni log debug log var opt omni log sap log var opt omni log oracle8 log On Windows Data_Protector_home log debug log Data_Protector_home log sap log Data_Protector_home log oracle8...

Page 239: ...Check whether the Cell Manager is correctly set on the application system The file etc opt omni client cell_server UNIX systems or HKEY_LOCAL_MACHINE SOFTWARE Hewlett Packard OpenView OmniBackII Site CellServer Windows systems must contain the name of the Cell Manager Check that the primary_db parameter in the initORACLE_SID sap file on the application system is set to LOCAL On UNIX systems check ...

Page 240: ... see Before you begin on page 174 If the SAP R 3 database is located on a UNIX system resolve the problem by reviewing the user account configuration For details see Configuring user accounts on page 175 Restore problems Problem ZDB restore or instant recovery sessions fail due to invalid characters in filenames On Windows systems where the Oracle Database Character Set DBCS is not set to the same...

Page 241: ...ns using the Data Protector GUI the restore fails with a message similar to the following Major From VRDA joca company com SAP Time 5 9 06 3 33 51 PM dev sapdata rsapdata Cannot restore rawdisk section Warning From VRDA joca company com SAP Time 5 9 06 3 42 45 PM Nothing restored Action Use SAP commands for example brrestore to restore these tablespaces Zero downtime backup integration guide 241 ...

Page 242: ...Data Protector SAP R 3 ZDB integration 242 ...

Page 243: ... cached so the database is highly available online backup The I O to it is suspended during the time it takes to create a replica split the mirror disks or create snapshots NOTE SQL Server snapshot is an SQL Server related term and does not mean the same as a disk array snapshot The following disk arrays and array configurations are supported Supported configurations Supported array Dual host Time...

Page 244: ...s guide Integration concepts Data Protector integrates with SQL Server through the Data Protector sql_bar exe executable installed on SQL Server During backup sql_bar exe started on the application system connects to SQL Server to find the locations of the database files The integration then backs up SQL Server database s which are replicated within a disk array During restore sql_bar exe connects...

Page 245: ...ms devices and other information see the latest support matrices at http www hp com support manuals For information on installing configuring and using SQL Server see the SQL Server documentation Ensure that you correctly installed Data Protector For information on installing Data Protector in various architectures and installing a Data Protector disk array integration EMC XP VA or EVA with SQL Se...

Page 246: ...you will have to select it when configuring a backup specification For information on configuring standalone devices see the online Help index standalone devices If you plan to use Integrated authentication to connect to an SQL Server instance you need to restart the Data Protector Inet service under a Windows domain user account that has the appropriate SQL Server permissions for running backups ...

Page 247: ...hat the syntax of your configuration file matches the examples Examples SQL Server authentication Login sa Domain Password jsk74yh80fh43kdf Windows authentication Login Administrator Domain IPR Password dsjf08m80fh43kdf Integrated authentication Login Domain Password kf8u3hdgtfh43kdf Configuring users If you have restarted the Data Protector Inet service on the SQL Server system under a different ...

Page 248: ...OTE Ensure that the user account to be used has appropriate SQL Server permissions for running backups and restores Check the permissions using SQL Server Enterprise Manager You can change configuration by following instructions described in Changing and checking configuration on page 252 Prerequisites SQL Server must be online during configuration Configuration must be performed for every SQL Ser...

Page 249: ... template and specify backup type For details see Step 3 on page 255 Click OK 4 Specify the ZDB specific options For details see Step 4 on page 257 5 In Application database select or specify the name of the SQL Server instance Windows Server 2008 only If you intend to use the Integrated authentication option specify the User and group domain options For information on the options press F1 Click N...

Page 250: ...Data Protector to connect to the SQL Server instance with the following Windows domain user account Windows Server 2008 The account specified in the User and group domain options in the previous step or in the Client selection page Other Windows systems The account under which the Data Protector Inet service on the SQL Server system is running Ensure that the user account you specify has the appro...

Page 251: ...Windows_user password password domain domain Parameter description appsrv SQL_Server_client Client system on which the SQL Server instance is running This option is not required if you run the command locally instance instance_name SQL Server instance name If you omit this option the default SQL Server instance is configured dbuser SQL_Server_user password password SQL Server user account SQL Serv...

Page 252: ...p 2 In the Scoping Pane expand Backup Specifications and then MS SQL Server Click a backup specification for which you want to change the configuration 3 In the Source property page right click the SQL Server name and select Configure 4 Configure SQL Server as described in Configuring SQL Server instances on page 248 Data Protector Microsoft SQL Server ZDB integration 252 ...

Page 253: ...tances again entering different data To check configuration run sql_bar chkconf instance instance_name If the optional parameter instance instance_name is not specified the default instance is checked If the integration is not properly configured the command returns RETVAL 8523 To get the information about the existing configuration run sql_bar getconf instance instance_name Zero downtime backup i...

Page 254: ...s on the application and backup systems must be the same also in case of nested mount points Considerations Your session will fail if You start ZDB restore or instant recovery using the same source volume on the application system at the same time A session must be started only after the preceding session using the same source volume on the application system finishes SQL Server services are not r...

Page 255: ... Sub type drop down list select either EMC Symmetrix or HP StorageWorks XP See Figure 67 on page 255 Figure 67 Selecting a split mirror backup VA EVA In the Backup type drop down list select Snapshot backup In the Sub type drop down list select either HP StorageWorks VA or HP StorageWorks EVA SMI S See Figure 68 on page 256 Zero downtime backup integration guide 255 ...

Page 256: ...Figure 68 Selecting a snapshot backup Click OK Data Protector Microsoft SQL Server ZDB integration 256 ...

Page 257: ... 260 for VA or Figure 72 on page 260 for EVA For detailed information on options press F1 EMC In the EMC GeoSpan for Microsoft Cluster Service environment select the backup system for the active node and specify the TimeFinder configuration After a failover in EMC GeoSpan for MSCS select the backup system for the currently active node and save the backup specification Figure 69 EMC backup options ...

Page 258: ...Figure 70 XP backup options VA To enable instant recovery leave Track the replica for instant recovery selected Data Protector Microsoft SQL Server ZDB integration 258 ...

Page 259: ...Figure 71 VA backup options EVA To enable instant recovery select Track the replica for instant recovery Zero downtime backup integration guide 259 ...

Page 260: ...ify the name of the SQL Server instance Windows Server 2008 only If you intend to use the Integrated authentication option specify the User and group domain options For information on the options press F1 Click Next Data Protector Microsoft SQL Server ZDB integration 260 ...

Page 261: ... as described in Configuring SQL Server instances on page 248 7 Select the databases to be backed up IMPORTANT To enable instant recovery create different backup specifications for user and system databases Figure 73 Selecting user databases Click Next Zero downtime backup integration guide 261 ...

Page 262: ...object mirroring see the online Help NOTE Object mirroring is not supported for ZDB to disk Click Next 9 Select backup options For information on Backup Specification Options and Common Application Options see the online Help For information on Application Specific Option see SQL Server Specific Backup Options on page 263 Click Next 10 Optionally schedule the backup For information on scheduler pr...

Page 263: ...ackup specification SQL Server Specific Backup Options SQL Server specific backup options are specified by clicking the Advanced tab in the Application Specific Options group box Zero downtime backup integration guide 263 ...

Page 264: ...ils the session completes with warnings Check database integrity Specifies a command with arguments or a script started by sql_bar exe on SQL Server before backup Resides in the Data_Protector_home bin directory Only the filename must be provided in the backup specification Pre exec Specifies a command with arguments or a script started by sql_bar exe on SQL Server after backup Resides in the Data...

Page 265: ...0 and 18 00 during week days 1 In the Schedule property page select the starting date in the calendar and click Add to open the Schedule Backup dialog box 2 Under Recurring select Weekly Under Time options select 8 00 Under Recurring Options select Mon Tue Wed Thu and Fri Click OK 3 Repeat Step 1 on page 265 and Step 2 on page 265 to schedule backups at 13 00 and 18 00 4 Click Apply to save the ch...

Page 266: ... specify the Split mirror snapshot backup option Figure 76 Starting interactive backups Using the Data Protector CLI To start ZDB to tape or ZDB to disk tape run omnib mssql_list ListName To start ZDB to disk run omnib mssql_list ListName disk_only where ListName is the name of the backup specification For more information on omnib see its man page Restore Data Protector offers restore from backup...

Page 267: ...pty database before restore because the database and its files are generated automatically by SQL Server Proceed as follows using the Data Protector Manager 1 In the Context List click Restore 2 In the Scoping Pane expand Restore Objects MS SQL Server and then select the client backup system from which you want to restore A list of backed up objects is displayed in the Results Area Zero downtime b...

Page 268: ...objects that you want to restore See Figure 77 on page 268 Figure 77 Restore objects To select backup object specific options right click the object and select Properties Data Protector Microsoft SQL Server ZDB integration 268 ...

Page 269: ...e version backup date from which you want to restore and choose SQL Server specific restore options Note that some options are not available for restore of data files See Restore options on page 271 for details Click OK Zero downtime backup integration guide 269 ...

Page 270: ...s disabled and the message There are no instances on this client system is displayed Select one of the following Restore actions Restore data default Select to restore the whole database Restore and display file list only Select if you do not know the original filenames In this case the files backed up in a particular session are displayed Restore and display headers only Select if you need specif...

Page 271: ...dex selecting devices for restore 6 Click Restore MS SQL Server and then Next to select Report level and Network load Click Finish to start restore Restore options Table 17 SQL Server restore options Description Option Specifies the backup session from which the selected objects will be restored Backup version This option is only available for database objects Specifies a point in time to which th...

Page 272: ...t differential up to the selected version Full restore of the database Overwrites the existing database residing on the target SQL Server instance If a database with the same name as the one you are restoring already exists and has a different internal structure SQL Server does not let you rewrite the database unless you select this option If you are restoring a data file from the PRIMARY group to...

Page 273: ...letion state Force restore over existing database Restoring to another SQL Serverinstance or and another SQL Server Prerequisites Both SQL Servers must have the same local settings code page and sort order This information is displayed in the session monitor for each backup The target SQL Server must be configured and reside in the same Data Protector cell as the original SQL Server For configurat...

Page 274: ...ing the database and click Action 3 Select all tasks and take them offline If you restore system databases put SQL Server offline by starting SQL Server Enterprise Manager right clicking SQL Server and clicking Stop Perform instant recovery using the Data Protector Manager 1 In the Context List click Instant Recovery 2 Expand MS SQL Server and select the backup session replica from which you want ...

Page 275: ... list select the point in time to which the transactions should be applied and click OK If no transaction logs are available this option is disabled Figure 80 Point in Time restore To restore the database under a different name click Advanced and select Restore database with new name See Figure 81 on page 276 IMPORTANT If the logical filename and physical filename are not listed add them to the li...

Page 276: ...y running or view previous sessions in the Data Protector GUI When you run an interactive session the monitor window shows you the session progress Closing the GUI does not affect the session You can also monitor sessions using the Monitor context from any Data Protector client with the User Interface component installed For information on monitoring sessions see the online Help index viewing curr...

Page 277: ...recognized issues and workarounds See http www hp com support manuals for an up to date list of supported versions platforms and other information Checks and verifications If your configuration backup or restore failed Check that SQL Server services are running Examine system errors reported in Data_Protector_home log debug log on the SQL Server client Additionally check errorlog and VDI log files...

Page 278: ...oft ODBC SQL Server Driver SQL Server SQL Server is terminating this process note that this is the expected behavior when the master database is restored in a single user mode Problems Problem The integration is properly configured but the database backup fails after a timeout With an error similar to Warning From OB2BAR computer1 com MSSQL70 Time 3 14 2000 8 19 22 PM Error has occurred while exec...

Page 279: ...ould not be mounted to Q Program Files Microsoft SQL Server MSSQL 1 MSSQL DATA 87 The parameter is incorrect Backup fails because SSE agent tries to mount the filesystem to the drive letter which does not exist on the backup system The drive letter must be the same as on the application system SSE or SMIS agents always mount the filesystems to the same drive letters on the backup systems as if the...

Page 280: ...SQL Server Driver SQL Server Exclusive access could not be obtained because the database is in use Microsoft ODBC SQL Server Driver SQL Server RESTORE DATABASE is terminating abnormally Action To put the database offline start SQL Server Enterprise Manager go to the database and click Action Select all tasks and put them offline Problem Transaction logs cannot be restored from tape The recovery co...

Page 281: ...B2BAR_Main qawin46 dpqaexch com DEFAULT Time 4 8 2006 7 01 42 PM Microsoft SQL Server reported the following error during login The object was not open Warning From OB2BAR_Main qawin46 dpqaexch com DEFAULT Time 4 8 2006 7 01 42 PM 152 9208 Data Protector is probably not configured for use with SQL Server on this host These errors are displayed because SQL Server is offline Action After the recover...

Page 282: ...split mirror backup in a Business Copy XP configuration on a Microsoft Cluster Server system fails with the following error Microsoft ODBC SQL Server Driver SQL Server Device activation error The physical file name Data Log filename may be incorrect Action Perform the following steps 1 Using Microsoft SQL Server Enterprise Manager detach the Microsoft SQL Server database that you want to recover 2...

Page 283: ...estore 3 In the Results Area double click the bar name corresponding to the particular Microsoft SQL Server instance A list of backed up objects gets displayed 4 Select the desired Microsoft SQL Server database right click it and click Properties 5 In the Properties window click the Advanced tab 6 Select the Restore database with new name option and enter the new database name in the text box 7 Fo...

Page 284: ... to close the Properties window 12 In the Options Devices and Media property pages specify the appropriate options For details see Standard restore on page 267 13 Click Restore and then Next to select the Report level and Network load 14 Click Finish to start the restore session Data Protector Microsoft SQL Server ZDB integration 284 ...

Page 285: ...p is subsequently performed offline on the backup system The following disk arrays and array configurations are supported Supported configurations Supported array BC CA combined BC CA HP StorageWorks Disk Array XP XP BC combined CA BC HP StorageWorks Enterprise Virtual Array EVA BC HP StorageWorks Virtual Array VA All ZDB types ZDB to tape ZDB to disk and ZDB to disk tape are supported by this int...

Page 286: ...hange ZDB integration backs up Microsoft Information Store MIS Key Management Service KMS and Site Replication Service SRS which are replicated within a disk array Data Protector integrates with Exchange Server through The Data Protector ese_bar exe executable installed on Exchange Server and used for retrieving locations of files and folders pertaining to a storage group store The omniEx2000 exe ...

Page 287: ...r ZDB integration See the HP Data Protector installation and licensing guide for information Ensure that you correctly installed and configured Exchange Server For supported versions platforms devices and other information see the latest support matrices at http www hp com support manuals For information on installing configuring and using Exchange Server see the Exchange Server documentation Ensu...

Page 288: ...he online Help for instructions Before performing transaction logs backups disable circular logging for all storage groups If the application is cluster aware disable circular logging on all cluster nodes Add the Exchange_home bin directory to the Windows Path environment variable 1 In the Windows Explorer right click My Computer and click Properties 2 In the Properties dialog box click Advanced a...

Page 289: ... Exchange Server database and transaction log files see the following documents available at http support microsoft com How to Move Exchange Databases and Logs in Exchange Server 2003 821915 XADM How to Move Exchange Databases and Logs in Exchange 2000 Server 257184 HOW TO Add New Mailbox Stores in Exchange Server 2003 821748 HOW TO Add New Mailbox Stores in Exchange 2000 319218 Backup To run ZDB ...

Page 290: ...very using the same source volume on the application system at the same time A session must be started only after the preceding session using the same source volume on the application system finishes otherwise the session fails Transaction logs must be backed up using the common filesystem backup functionality When backing up log files select either Log all or Log files logging level in the Advanc...

Page 291: ... by post exec configured on the backup specification level in the backup specification for database files backup recommended or started manually after the backup specification for database files backup is started For more information see the online Help index pre and post exec commands The following is the synopsis of the omnicreatedl command omnicreatedl ex2000 datalistName deviceName DISK_ARRAY_...

Page 292: ...d on the Cell Manager in Data_Protector_home config server datalists Windows or etc opt omni server datalists UNIX datalist Name Specifies the backup device If this option is not used specify the backup device using the Data Protector GUI device Name Forces overwriting of an existing ZDB specification with the same name force In cluster configurations specifies the name of the Exchange Server virt...

Page 293: ...ch the replicas are used The algorithm of using replicas is described in the HP Data Protector zero downtime backup concepts guide A range must be specified in ascending order If this option is not specified MU 0 is set mirrors MU_Numbers This parameter is optional If split is selected mirrored disks in the replica are resynchronized with P VOLs at the backup start If establish is selected and the...

Page 294: ...ca is set by mirrors MU_Numbers If more than one replica is set the disks remain split If this option is not specified you cannot specify leave_enabled_bs keep_version Table 20 VA options Description Parameter Instructs omnicreatedl to create a snapshot ZDB specification snapshot Specifies the application system app_sys and the backup system bck_sys va app_sys bck_sys By default this option is aut...

Page 295: ...est replica is reused Default 1 Maximum 1024 snapshots number This parameter is optional By default this option is automatically selected if instant_recovery is set For ZDB to tape select it to keep the replica on a disk array after backup This replica is not available for instant recovery but can be reused for future backups using the same backup specification use_existing_snapshotselected If thi...

Page 296: ... automatically selected If this option is not set you cannot perform instant recovery from the replica created or reused in this session instant_recovery This parameter is optional During ZDB Data Protector creates a new replica and leaves it on the array until the specified snapshots number is reached After that the oldest replica is reused Default 1 The maximum number for vsnaps and standard sna...

Page 297: ...ce volumes already exist in a replica set it creates either vsnaps or snapclones instead of standard snapshots Note that Data Protector can use only one type of snapshots in a backup session For example if the source volumes used in a session have existing standard snapshots vsnaps the session is aborted snapshot_policy strict loose Available if snapshot_type clone is selected Specify to prevent d...

Page 298: ... _ r e p l i c a _ l o c a t i o n Table 22 Exchange Server options Description Parameter Specifies Exchange Server annotations Microsoft Information Store MIS Site Replication Service SRS and Key Management Service KMS Default MIS annotation MIS SRS KMS Creates a backup specification for all databases relating to MIS specified by annotation MIS all_storage_groups Creates a backup specification fo...

Page 299: ...es and examples of omnicreatedl usage You can modify omniex2000SM bat using any text editor Uncomment delete REM before the command the line with the appropriate command and edit parameters See Figure 83 To create an Exchange ZDB specification and a transaction logs backup specification using omniex2000SM bat make the necessary modifications and run Data_Protector_home bin omniex2000SM bat Zero do...

Page 300: ...Figure 83 omniex2000SM bat file Examples of using omnicreatedl Example 1 XP Data Protector Microsoft Exchange Server ZDB integration 300 ...

Page 301: ...res Public and Mailbox part of First Storage Group running on Exchange Server on the application system computer_app company com and backup system computer_bck company com using the BC CA configuration run omnicreatedl ex2000 datalist BS3 device dev1 storage_group First Storage Group store Public Mailbox split_mirror sse combined computer_app company com computer_bck company com Example 4 VA To cr...

Page 302: ...trict storage_group First Storage Group The omnicreatedl creates a transaction logs backup specification file First Storage Group LOGS computer1 company com for First Storage Group log files backup if it does not already exist Data Protector attempts to create vsnaps and if they cannot be created the session aborts Example 7 EVA To create a ZDB to disk specification Exchange_example to back up Sit...

Page 303: ...ecifications After you created an Exchange ZDB specification and a transaction logs backup specification using omnicreatedl you can modify them using the Data Protector GUI NOTE To add remove storage groups from a ZDB specification create a new backup specification rather than modify the existing one Changing the saved ZDB specification manually can impact Stop quiesce the application and Restart ...

Page 304: ...Select separate devices for backup and each mirror For information on object mirroring see the online Help index object mirroring NOTE Object mirroring is not supported for ZDB to disk Checking Exchange files for consistency Exchange Server allows you to perform a page level integrity check of the database files It is run on the Exchange offline database during ZDB using esefile Exchange 2000 and ...

Page 305: ...e utility to the backup system The esefile resides on the Exchange 2000 Installation CD at CD ENGLISH EXCH2000 ENT SUPPORT UTILS I386 ESEFILE The eseutil resides in Exchange_Server_home bin once the Exchange Server 2003 is installed NOTE On XP do not mirror the location where the utility resides to prevent the file from being overwritten when the mirror is synchronized Zero downtime backup integra...

Page 306: ...om H First Public edb Figure 85 Example script for MS Exchange Server 2000 See the HP Data Protector zero downtime backup administrator s guide for information on the mountpoint creation The commands in the script ensure that edb database files specified in the backup specification are checked for consistency 3 Modify the ZDB specification to include integritycheck bat as post exec Execute the scr...

Page 307: ...elect the starting date in the calendar and click Add to open the Schedule Backup dialog box 2 Under Recurring select Weekly Under Time options select 8 00 Under Recurring Options select Mon Tue Wed Thu and Fri Click OK 3 Repeat Step 1 and Step 2 to schedule backups at 13 00 and 18 00 4 Click Apply to save the changes NOTE For ZDB sessions the backup type is set to Full For ZDB to disk and ZDB to ...

Page 308: ...cation you want to start and select Start Backup 3 Select Network load For information on network load click Help Click OK For ZDB sessions the backup type is set to Full For ZDB to disk or ZDB to disk tape specify the Split mirror snapshot backup option Figure 86 Starting interactive backups Click OK Using the Data Protector CLI To start ZDB to tape or ZDB to disk tape run omnib datalist Name To ...

Page 309: ...ate source volumes Transaction logs must be backed up to perform rollforward recovery NOTE In case of a disaster Exchange Server must be installed and configured with the same database names and locations as before the disaster Standard restore You can restore Exchange objects to any Exchange Server with the same configuration as the original system within the Data Protector cell You can recover E...

Page 310: ...p and Restoration Procedures for Exchange 296788 at http support microsoft com For a detailed procedure on performing filesystem restore see the online Help index standard restore procedure The procedures below provide only a general description of the restore process Point in time recovery IMPORTANT The procedure described below gives instructions on how to copy edb and stm files to the appropria...

Page 311: ... Figure 87 Restoring Exchange database Exchange database consists of two files name edb and name stm For a particular database select both files You can restore a storage group by selecting the storage group folder when the entire storage group was backed up and all databases reside in the same directory Zero downtime backup integration guide 31 1 ...

Page 312: ...ore options 5 In the Devices page select devices to use for the restore Note that you can use a different device for restore than the one used for backup For information see the online Help index selecting devices for restore 6 Click Restore The Start Restore Session dialog box is displayed 7 Specify Report level and Network load Data Protector Microsoft Exchange Server ZDB integration 312 ...

Page 313: ...8 XP EMC Select StorageWorks XP restore Click Next Figure 89 Selecting XP restore Zero downtime backup integration guide 313 ...

Page 314: ... how to copy edb stm and log files to the appropriate database location and only part of the procedure described in the Offline Backup and Restoration Procedures for Exchange 296788 When following the Microsoft procedure use the procedure below to copy edb stm and log files to the appropriate database location The procedure below needs to be utilized twice for the database and for transaction logs...

Page 315: ...1 In the Context List select Restore Zero downtime backup integration guide 315 ...

Page 316: ...hen select the Exchange 2000 object as shown in Figure 91 To restore transaction logs expand Restore Objects Filesystem and the name of the backed up server Then select the Exchange 2000 Logs object as shown in Figure 92 Figure 91 Restoring Exchange database Data Protector Microsoft Exchange Server ZDB integration 316 ...

Page 317: ...select edb and stm files For a particular database select both files You can restore a storage group by selecting the storage group folder when the entire storage group was backed up and all databases reside in the same directory To restore transaction logs select log files Zero downtime backup integration guide 317 ...

Page 318: ...Selecting the application system 5 Set restore options For information see the online Help index restore options 6 Click Restore The Start Restore Session dialog box is displayed 7 Specify Report level and Network load Click Next Data Protector Microsoft Exchange Server ZDB integration 318 ...

Page 319: ...8 XP EMC Select StorageWorks XP restore Click Next Figure 94 Selecting XP restore Zero downtime backup integration guide 319 ...

Page 320: ...pts guide and HP Data Protector zero downtime backup administrator s guide for general information on instant recovery You can recover Exchange databases using Point in time recovery Databases are restored to their state at the backup time and all data modified after that is lost Rollforward recovery Restores Exchange database files and transaction logs and then replays the transaction logs Databa...

Page 321: ...r zero downtime backup administrator s guide for information on copying backed up edb and stm files to the appropriate database using instant recovery The procedure below gives instructions on how to restore Exchange transaction logs using the Data Protector GUI when following the Microsoft procedure 1 In the Context List select Restore 2 In the Scoping Pane expand Restore Objects Filesystem and t...

Page 322: ...7 XP EMC Select StorageWorks XP restore Click Next Figure 96 Selecting XP restore Data Protector Microsoft Exchange Server ZDB integration 322 ...

Page 323: ...and verifications plus problems you might encounter when using the Data Protector Exchange Server integration Start at Problems If you cannot find a solution there perform general checks and verifications For general Data Protector troubleshooting information see the HP Data Protector troubleshooting guide For general ZDB restore and instant recovery related troubleshooting see the HP Data Protect...

Page 324: ...ails fix Exchange Server problems first and then perform a backup using Data Protector Ensure that the Cell Manager is correctly set on Exchange Server by checking the following registry entry HKEY_LOCAL_MACHINE SOFTWARE Hewlett Packard OpenView OmniBack II Site Its name and value must be CellServer and Cell Manager hostname respectively Examine system errors reported in Data_Protector_home log de...

Page 325: ...fy another existing directory To restore to another system make sure Exchange Server is installed on that system and has the same organization and site names as the restored server Problems Problem Exchange integration is unable to initiate clsEx2000 class The following error is reported in the debug log file Unable to initiate clsEx2000 class Error 2147221164 Action Register omniex2000 dll by run...

Page 326: ...from host app_sys Make sure the Exchange server is running and Data Protector Exchange Integration installed Actions If the application is cluster aware specify the virtualSrv parameter Check the user rights on the application system client You must have the Save backup specification user right to create and save a backup specification Data Protector Microsoft Exchange Server ZDB integration 326 ...

Page 327: ...rvice password is not kept on disk the following error is reported Major From OB2BAR_main machine com Time 10 20 2003 5 17 24 PMError starting service Reconfigure KMS to store the KMS service password on disk See XADM How to Change the KMS Service Password Startup Location 196129 for information Then restart the backup Zero downtime backup integration guide 327 ...

Page 328: ...Data Protector Microsoft Exchange Server ZDB integration 328 ...

Page 329: ...oducing a coordinator among the actors of the backup and restore process Volume Shadow Copy Service Volume Shadow Copy Service VSS is a software service introduced by Microsoft on Windows operating systems During backup the service collaborates with a backup application for example Data Protector applications to be backed up usually database applications shadow copy providers and the operating sys...

Page 330: ...application does not need to handle each application to be backed up specifically However the production application as well as the backup application must conform to the VSS specification Figure 99 on page 331 and Figure 100 on page 331 show the differences between the traditional backup model and the model with the Data Protector Microsoft Volume Shadow Copy integration Integrating the Data Prot...

Page 331: ...g the Volume Shadow Copy Service Data Protector has to communicate with each application to be backed up individually The Data Protector VSS integration introduces a unified backup and restore interface and provides the coordination among the participants of the backup and restore process Zero downtime backup integration guide 331 ...

Page 332: ...m A VSS hardware provider that supports transportable snapshots is required VSS restore Using Data Protector you can perform the restore From backup media to the application system on LAN standard restore Using the instant recovery functionality During instant recovery the data is restored from backup replica to the source volumes on the application system Only the needed differential and transact...

Page 333: ...rdinating backup and restore VSSBAR agent is responsible for the following actions detecting VSS writers examining and analyzing Writer Metadata Document WMD Writer Metadata Document WMD is metadata provided by each writer Writers identify themselves by the metadata and instruct the backup application what to back up and how to restore the data Thus Data Protector follows the requirements provided...

Page 334: ...passes the list back to the coordinator for preparing a shadow copy 5 The VSSBAR agent notifies the writers about the shadow copy creation The VSS mechanism ensures that there are no writes on the volume while the shadow copy is being created NOTE When the VSSBAR agent creates a shadow copy of the volume this volume is marked in order to avoid attempts to simultaneously create another shadow copy ...

Page 335: ...kup system transportable backup Presented and mounted to the backup system specified in the backup specification It can be mounted in read only or read write mode If not kept on the array destroyed after the backup session completes after data in the replica is moved to a backup medium Manipulated using the Data Protector omnidbvss command Figure 101 on page 336 shows the relationships between the...

Page 336: ...up does not guarantee application data consistency only filesystem consistency Application data consistency can be achieved only by using supported application writers such as Microsoft Exchange Server writer Integrating the Data Protector ZDB integrations and Microsoft Volume Shadow Copy Service 336 ...

Page 337: ...ume P VOL and its replica S VOL are in simplex unpaired state after backup Therefore the number of replicas S VOLs per P VOL rotated is not limited Restore from a backup in such a configuration is possible only by switching disks Resync mode When the XP provider is in the resync mode the source volume P VOL and its replica S VOL are in a suspended mirror relationship after backup The maximum numbe...

Page 338: ...very concepts see the HP Data Protector zero downtime backup concepts guide and HP Data Protector zero downtime backup administrator s guide Standard restore from tape Data Protector offers two restore modes component restore using the VSS service file restore using the DMA instead of VSS By default Data Protector restores writer components using the VSS service Instant recovery is also available ...

Page 339: ...single file fails the restore of the a whole component fails Data Protector offers an additional restore mode for restoring single files that does not use the Microsoft Volume Shadow Copy Service thus solving this problem This mode can also be used for restoring to systems that do not support VSS or do not have a VSS writer installed When restoring files or a group of files DMA is started and the ...

Page 340: ...t ZDB to tape sessions and sessions created using the software provider are always recorded only to the persistent part of the VSSDB You can query and manage the items of the VSSDB using the omnidbvss command For information on the command syntax description and examples see the HP Data Protector command line interface reference The following tasks can be performed using the omnidbvss command Quer...

Page 341: ... session identified by the session ID All instant recovery enabled sessions based on a specific backup specification Changes in the environment During a VSS instant recovery sessions or the VSSDB maintenance sessions using the omnidbvss command remove disable enable the state of target volumes in a replica is checked prior to restore remove disable and enable operations Before restore the state of...

Page 342: ...s If an LCR copy is used for backup and is located on a different disk from the original data the load on a production database is minimal cluster continuous replication CCR CCR has the same characteristics as LCR The only difference is that in the CCR environment databases and transaction logs are replicated to separate servers Therefore CCR copies can be used for disaster recovery You can perfor...

Page 343: ...e original storage group content Furthermore if the whole server is destroyed restoring to a different Exchange Server system recovery server will minimize the time window during which your mailboxes will be unavailable Microsoft Hyper V VSS writer concepts Microsoft Hyper V writer is the successor to the Microsoft Virtual Server 2005 writer and is supported on Microsoft Windows Server 2008 It is ...

Page 344: ... integration Writers and shadow copy providers documentation for instructions on how to install and configure writers and providers on your system To be able to perform instant recovery enabled backups and instant recovery ensure that the source volumes do not reside on GPT GUID Partition Table disks If the system where you want to install an application database has GPT disks change them to MBR M...

Page 345: ...up and restore sessions VSS backups with hardware provider are only supported for volumes on disk arrays This is also valid for system disks Instant recovery of system disks backups is not possible If the backup system is in a cluster and if you select the Mount the replica on backup system option note that the replica disks are mounted to the active cluster node In the case of a backup system fai...

Page 346: ...the period in seconds for which the Data Protector agent waits for mirrors that are created in one session to become fully synchronized If the OB2VSS_WAIT_TIMEOUT variable is set to more than 2 hours 7200 seconds you should additionally increase the value of the global variable SmIdleTimeout past the value of OB2VSS_WAIT_TIMEOUT The value of SmIdleTimeout should be specified in minutes rather than...

Page 347: ...iders are installed and registered on your system using the following Windows operating system command For a list of writers VSSadmin list writers For a list of VSS providers VSSadmin list providers For instant recovery enabled backups VDS hardware providers should be present in the list of installed software Check Control Panel Add Remove Programs For instant recovery enabled backups only non sys...

Page 348: ...anged for example you have modify the existing source volumes or you have presented new source volumes You have added a new storage object for example a Microsoft Exchange Server storage group To resolve the application system run the following on any VSS client in the Data Protector cell omnidbvss resolve apphost ApplicationSystem all where ApplicationSystem is the name of the application system ...

Page 349: ...nate paths solution is used install HP MPIO DSM for EVA An EVA license for at least basic and snapshot operation Install Data Protector components and licenses An instant recovery license HP StorageWorks EVA SMI S Agent If this agent is not installed only Restore using Microsoft Virtual Disk Service switch of disks is possible For installation and licensing information see the HP Data Protector in...

Page 350: ...onnection the default port number is 5989 User name and encoded password for SMI S EVA provider login SMISDB resides on the Cell Manager in Data_Protector_home db40 smisdb Considerations If a failover from the active to the standby management system happens proceed as follows If standby and failed management systems have the same hostname no action is needed If standby and failed management system...

Page 351: ...instant recovery license The HP StorageWorks XP Agent If this agent is not installed it is not possible to restore data from the disk array XP For installation and licensing information see the HP Data Protector installation and licensing guide Make sure the same operating system and version is installed on both application and backup systems Connect the application and backup systems to the same ...

Page 352: ...ovider see the hardware provider documentation Configuring the VSS hardware provider for Enterprise Virtual Arrray Open the HP StorageWorks VSS Configuration Utility for EVA and follow the steps below 1 Ensure that the correct management appliance IP address is specified 2 Click Login and in the Login dialog box enter the username and password 3 Select SnapClone as the Snapshot Type 4 Click Select...

Page 353: ...er there is any other data besides the component s data At backup time Data Protector can check whether the individual components can be selectively restored using the instant recovery functionality At instant recovery time Data Protector can check whether the data required for the components restore is available In case of the Microsoft Exchange Server Writer it is checked whether the whole stora...

Page 354: ...nge Server writers may create temporary files on components volumes during backup and instant recovery causing the check failure In such cases instant recovery is not possible without disabling the check Microsoft Exchange Server writer specific configuration A backup of the Microsoft Exchange database is considered successful only when consistency check of the replicated data files succeeds For i...

Page 355: ... are not met failed presentation of replicas to the backup system causes entire backup session to fail In cases where the application and backup systems are the same ensure that the VSS VDS hardware provider is configured for the same Command View on both EVAs Otherwise rotation and deletion of old replicas from other EVA disk array is not possible If a failover occurs the backup using the same ba...

Page 356: ... 356 provides a description of VSS writers Table 23 Writer description Restore method Description Writer name Files are restored after a reboot This is a system writer used to back up and restore Certificate Authority CA Service database This service issues revokes and manages certificates employed in public key based cryptography technologies Certificate Authority Writer Custom restore method Thi...

Page 357: ...so replicate data for Distributed File System Dfs copy and maintain shared files and folders on multiple servers simultaneously FRS Writer Files are restored after a reboot This is a system writer used to back up and restore Microsoft Internet Information Server IIS IIS is a network file and application server that supports multiple protocols Primarily IIS transmits information in Hypertext Markup...

Page 358: ...ly individual nodes can be backed up Microsoft Virtual Server 2005 Writer Standard VSS restore and instant recovery This is a writer used to back up and restore Microsoft Virtual Server 2008 Hyper V configuration and individual or all virtual machines running on the server Software and hardware providers are supported during online and offline backup Cluster aware backups are not supported Microso...

Page 359: ...iles are restored after a reboot This is a system writer that backs up a specific set of Windows dynamic link libraries DLL System Writer Files are restored after a reboot This is a system writer that backs up Windows Terminal Services These services provide a multi session environment that allows client systems to access a virtual Windows desktop session and Windows based programs running on the ...

Page 360: ...SDE Writer or Microsoft Exchange Server Writer the Microsoft SQL Server or Microsoft Exchange Server has to be running on the application system for a backup to start Replica types The two basic families of replicas available with Data Protector are split mirror and snapshot Split mirror replica This type of replica is produced using mirroring technology provided by HP StorageWorks Disk Array XP M...

Page 361: ...wn particular merits from the storage and data processing points of view Data Protector supports the following snapshot replica types using the EVA hardware provider Snapshot with pre allocation of disk space standard snapshot Snapshot without pre allocation of disk space vsnap or virtually capacity free snapshot A full copy of the source volume original virtual disk independent of the original vi...

Page 362: ...volume on the database copy system with a different specification Together this would create six replicas However Data Protector limits the number and supports only three replicas together in such a case Therefore you can choose to back up source volumes only on the production database system or only on the database copy system Otherwise after three replicas are created with one backup specificati...

Page 363: ...3 Right click MS Volume Shadow Copy Writers and click Add Backup Zero downtime backup integration guide 363 ...

Page 364: ...are provider Otherwise no hardware provider is required for this type of backup VSS transportable backup Use this option to create shadow copies on the application system and present them to the backup system which can perform the backup to tape A hardware provider is required for this type of backup Figure 103 Selecting VSS transportable backup Integrating the Data Protector ZDB integrations and ...

Page 365: ...or instant recovery and does not apply to the tape backup For information on the options see Configuration check on page 353 If you do not select Track the replica for instant recovery you can specify the replica type Default The replica type created depends on the VSS hardware provider configuration Mirror Clone Plex A shadow copy independent from its source volume is created With EVA hardware pr...

Page 366: ...p options 6 In this page the selection of your VSS client is displayed On Windows Server 2008 you can specify the User and group domain options For information on these options press F1 Click Next Integrating the Data Protector ZDB integrations and Microsoft Volume Shadow Copy Service 366 ...

Page 367: ... selecting the top level item the name of the client a single writer or a writer s component backup by selecting a lower level item If full client is selected Data Protector checks which writers exist on the client and backs up all of them at backup time NOTE On EVA disk array to perform an instant recovery do not select too many objects because they might reside on more than four source volumes I...

Page 368: ... client is selected The Filesystem item displays all mounted disks If another disk is mounted to a directory on a disk the parent disk name is displayed twice The first name represents the parent disk name for example c while the second name represents the container for the mountpoint for example c mnt 1 To select the mounted disk select the container for the mountpoint Microsoft Exchange Writer O...

Page 369: ...k Help If you do not select a device only backup to disk will be available IMPORTANT If you do not configure devices and do not select the option Track the replica for instant recovery you will not be able to restore the data with Data Protector In case of backup to tape you can also specify whether you want to create additional copies mirrors of the backup during the backup session Specify the de...

Page 370: ...riters backup specification using the Data Protector Scheduler Start an interactive backup of an existing Microsoft Volume Shadow Copy Writers backup specification VSS specific backup options Table 24 VSS specific backup options Description Option Specify a command that will be started by vssbar exe on the application system before the backup Do not use double quotes Type only the name of the comm...

Page 371: ... be running on the same application system at once With Exchange Server 2007 only one VSS backup session backing up a specific storage group can be running on the same application system at once Consequently if you start such a backup session while another one is in progress the latter waits until the first one finishes Recommendations With the HP StorageWorks EVA provider an Exchange storage grou...

Page 372: ... the Source tab and then click Additional options In this page you can also specify to throttle the consistency check for a second after the specified number of input output operations The consistency check can also be run before instant recovery Figure 108 Selecting Microsoft Exchange Server 2003 storage groups Microsoft Exchange Server 2007 writer backup specifics In LCR and CCR environments the...

Page 373: ...ss of which instance Information Store or Replication Service resides on this node If you select the cluster node Data Protector backs up any available instance on this node ignoring the selection of the instance in the GUI even if for example you select the replicated storage group Exchange Replication Service as backup object To specify the cluster node from which you want to perform a backup of...

Page 374: ...d for backup no other VSS writer for example filesystem writer or SQL Server writer can be selected to be backed up in the same backup session Because in this case two writers would be located on different systems but Data Protector limits VSS backup sessions to involve only one system In LCR and CCR environments each storage group can have only one store CCR clusters can have only two nodes Consi...

Page 375: ...he virtual machine is always turned off regardless of the state in which it was before the restore Offline backup Offline backup is performed in the following cases The guest operating system any other non Microsoft guest operating system that is supported by Hyper V is not VSS enabled The guest operating system does not have Hyper V VSS integration services installed The virtual machine to be bac...

Page 376: ... is not supported using the XP VSS hardware provider Backup from a physical cluster node When backing up from a cluster node consider the following Offline backups trigger a failover During offline backups the virtual machine to be backed up is suspended for a moment The cluster server recognizes this as a failure and initiates the cluster failover To avoid such a failover perform one of the follo...

Page 377: ...ckup then Backup Specifications Click MS Volume Shadow Copy Writers A list of available backup specifications is displayed in the Results Area 3 Double click the backup specification you want to schedule and click the Schedule tab to open the Schedule property page 4 In the Schedule property page select a date in the calendar and click Add to open the Schedule Backup dialog box Zero downtime backu...

Page 378: ... ZDB to disk tape session specify the Split mirror snapshot backup option Figure 1 10 Scheduling a backup 6 Click OK to return to the Schedule property page 7 Click Apply to save the changes Running an interactive backup An interactive backup can be started using the Data Protector GUI by following these steps Integrating the Data Protector ZDB integrations and Microsoft Volume Shadow Copy Service...

Page 379: ...ppears Restoring writers data You can restore the Data Protector Microsoft Volume Shadow Copy Service integration backup objects using the Data Protector GUI Data Protector offers two methods for restoring the writers From backup media to the application system on LAN standard restore Refer to Restore procedure on page 380 Using the instant recovery functionality with the Microsoft Exchange Server...

Page 380: ...SDE writer restore specifics on page 384 To restore Microsoft VSS objects using the Data Protector GUI proceed as follows 1 In the HP Data Protector switch to the Restore context 2 Expand Restore Objects expand MS Volume Shadow Copy Writers expand the client from which you want to restore the data and then click MS Volume Shadow Copy Writers In the Results Area a list of writers which were backed ...

Page 381: ...e last available backup version is selected by default however you can select a different version from the drop down list Exchange Server Writer Optionally to specify options for the consistency check of a Microsoft Exchange writer right click the writer and click Additional options You can perform point in time or rollforward restore of Microsoft Exchange Server writer For more information see Mi...

Page 382: ...u can manually create an RSG after the restore session completes First select the target system from the Target server name drop down list and then choose the desired stores using the Original drop down list Restore to a non Exchange location and create RSG Select this option to restore your data to a non Exchange location After restore Data Protector will create a Recovery Storage Group called DP...

Page 383: ...estore Therefore you have the possibility of using a different device for a restore than the one that was used for the backup See the online Help index selecting devices for restore 7 Click Restore Review your selection and then click Finish to start a restore session The restore session messages are displayed in the Results Area 8 If you are restoring a VSS writer that requires a custom restore c...

Page 384: ... MS Volume Shadow Copy Integration software component installed For file restore the MS Volume Shadow Copy Integration software component is not required Restore into the following directory By default you restore the data to the same directory from which it was backed up it can be on the original client or on some other client which you selected However if you specify the Restore into the followi...

Page 385: ...TANT If system databases are restored the whole internal database structure will be changed NOTE Only point in time restore is possible Rollforward restore is not supported User databases will be restored only if it is possible to overwrite the files MSDE writer will take the user databases offline before the restore while SQL service will have to be stopped manually in order to restore the system...

Page 386: ... not possible See Point in time restore after loss of a log file on page 387 Microsoft Exchange Server 2003 limitations Shadow copies cannot be restored to alternate locations on the backup system You cannot restore the shadow copy to the Recovery Storage Group Rollforward recovery cannot be performed after a point in time restore Restore to Microsoft Exchange Server 2007 from backup made with Mic...

Page 387: ...orage group state Figure 1 14 Selecting Microsoft Exchange Server 2007 stores for rollforward recovery 3 Proceed as with general VSS writer restore See Restore procedure on page 380 for the general VSS writer restore procedure 4 Mount all stores from the storage group in which they reside using Exchange System Manager Selected stores are recovered Point in time restore after loss of a log file To ...

Page 388: ... general VSS writer restore procedure 4 Mount the stores from the storage group in which the target stores reside using Exchange System Manager All stores are mounted and put in the state as they were at the last selected full incremental or differential backup Microsoft Exchange Server 2007 writer restore specifics Microsoft Exchange Server 2007 writer offers an additional restore option Restore ...

Page 389: ...can be restored to a target directory and another one to a different storage group in the same session if the target client system is the same Individual stores can also be restored to a non Exchange location During the restore data is restored into target component destination path In this scenario the restored data is not managed by Exchange Server Restore to a non Exchange location with creatio...

Page 390: ... options IMPORTANT During a restore to a non Exchange location and creation of a Recovery Storage Group RSG Data Protector deletes an RSG that may already exists at the target location Limitations Due to Microsoft Exchange Server limitations Restore to an LCR or CCR storage group copy Exchange Replication Service instance is not supported Restore of an LCR or CCR copy to original location will be ...

Page 391: ...sessions from a physical cluster node can be restored to any cluster node using a standard restore procedure To successfully restore such a session to a cluster node perform the following steps 1 Delete the cluster group of the virtual machine to be restored using Failover Cluster Management 2 Perform standard restore of the virtual machine on the cluster node where the virtual machine disk is act...

Page 392: ...writer specifics prerequisites and limitations see Microsoft Exchange Server 2007 instant recovery prerequisites and limitations on page 398 Overview Instant recovery restores data directly from a replica to source volumes All data in the replica is restored regardless of selections during backup For instant recovery concepts see the HP Data Protector zero downtime backup concepts guide Instant re...

Page 393: ...lication system must be performed serially For instant recoveryof Exchange Server 2007 data to a different location the Microsoft Virtual Disk Service HP StorageWorks EVA and HP StorageWorks Disk Array XP restore options are not available For additional Exchange Server 2007 writer limitations see Microsoft Exchange Server 2007 instant recovery prerequisites and limitations on page 398 Instant reco...

Page 394: ...tions you select in the Data Protector GUI instant recovery can be performed in three different ways Switch of disks For description on this method see Switch of disks on page 394 To use this method of instant recovery in the Data Protector GUI select the Restore using HP StorageWorks EVA and Switch to the replica options Copy of replica data with the source volume retained With this method a new ...

Page 395: ...mes is lost If you try to abort the session at this point the abort operation is rejected and the session continues You can select to retain the replica and thus enable to perform another restore from this backup Advantages Disk group of the source volume is not changed after instant recovery Physical location of the application production data remains the same Another restore from the same backup...

Page 396: ...l restore before making the source volume available If this option is not selected the source volume is immediately available while the re synchronization or copy process is running in the background quick restore If you try to abort the session after the copy process has started the abort operation is rejected and the session continues IMPORTANT The original source volumes are not retained after ...

Page 397: ...pecification in different modes and you run a switch of disks restore before a copy of replica data restore Under such circumstances perform one of the following prior to restore On the application system manually present the P VOL Set the variable OB2VSS_FORCE_INSTANT_RECOVERY in the omnirc file The following restore considerations apply to restore using Disk Array XP Agent only You cannot start ...

Page 398: ...overed separately provided that it resides alone on the target volume to be recovered Otherwise all stores residing on the target volume must be selected for restore If transaction logs are lost whole storage group should be recovered In this case you can perform either point in time or rollforward recovery To perform a point in time recovery of Microsoft Exchange Server writer data select the who...

Page 399: ... enable such restore process set the omnirc variable OB2VSS_FORCE_INSTANT_RECOVERY to 1 perform restore and after it manually set up the LCR or CCR environment With Microsoft Exchange Server 2007 running in a CCR environment whose database copy resides on the backup system there are particular situations where you need to consider additional steps for performing instant recovery When XP VSS hardwa...

Page 400: ... backup specification for Incremental Differential backup with the same object and description as you have in the backup specification for instant recovery Such an Incremental Differential backup is based on the Full backup with the selected instant recovery option You can select an Incremental Differential backup in the Instant Recovery context and start restore Instant recovery will be performed...

Page 401: ...iters under Restore Objects expand the backup specification from which you want to restore and click the backup session from which you want to restore Figure 1 16 Selecting writers components for instant recovery Zero downtime backup integration guide 401 ...

Page 402: ...iter If you restore an LCR or CCR copy to the original location note that restore will be performed to the original database Exchange Information Store and not to the database copy Exchange Replication Service a Right click a storage group a store or logs and click Restore as b In the MS Exchange Additional options dialog box select the target location for the components you want to restore target...

Page 403: ... Select the target server first and then from the Original drop down list select the stores to be restored Optionally specify the mount point for the storage group to be restored in Mount backup volume to the path Click Browse to specify the desired mount point By default the storage group is mounted to the C Omni_Mnt directory IMPORTANT The selected directory must be either empty or you can speci...

Page 404: ...Figure 1 17 Restore to different location options Exchange Server 2007 Writer Integrating the Data Protector ZDB integrations and Microsoft Volume Shadow Copy Service 404 ...

Page 405: ...the source storage the copy is then switched with the source volume A virtual copy is created and immediately available for use However in the background the copy process runs for some time to copy all data from the replica to the source storage To avoid the slowdown of the copy process caused by application use or the integrity check process Exchange Server use this option The restore resumes aft...

Page 406: ...Figure 1 18 Selecting instant recovery options EVA integration Integrating the Data Protector ZDB integrations and Microsoft Volume Shadow Copy Service 406 ...

Page 407: ...ginal database perform additional steps In case of an LCR restore it is recommended to seed the restored database to synchronize the original database with its copy For more information see the web page http technet microsoft com en us library aa995973 aspx In case of a CCR restore you may need to perform additional steps For details see Additional steps after restore of a Microsoft Exchange Serve...

Page 408: ...mpleting the procedure below If you move the server at this point data loss may occur Perform the following steps to enable normal operation of the original and copy databases 1 On the application system mount the restored store 2 On the passive node where the copy of the database exists delete transaction logs 3 On the passive node use the Update StorageGroupCopy cmdlet to seed the storage group ...

Page 409: ...ecks and verifications On the application and backup systems examine system errors reported in Data_Protector_home log debug log With the XP integration ensure that RAID Manager Library is correctly installed on both the application and backup systems In addition check if the libsvrrm dll file exists in the RMLIB_home directory Common problems Problem Backup or instant recovery aborts due to VDS p...

Page 410: ...a Protector components including Microsoft Exchange Server and VSS One of the factors is timing which in turn is impacted by environmental conditions such as I O loads storage device activity and concurrent Data Protector actions To inhibit potential issues it is recommended that you balance Data Protector activity across the available activity or maintenance window If you encounter issues review ...

Page 411: ...00 ms Action The following can help to solve the problem Limit the number of users that are accessing the management system Reduce the number of volumes in a snapshot set Create a backup specification dedicated to each storage group instead of one specification for the whole server See Microsoft Exchange Server writer backup specifics on page 370 Problem Snapshots volume shadow copies creation fai...

Page 412: ...smis ompasswd add HostName ssl port PortNumber namespace Namespace user Username passwd Password Problem Configuration of an HP StorageWorks SMI S EVA CIMOM failed Action Run the following command to perform a health check of you environment which may help identify any potential problems that occurred during the configuration omnidbsmis ompasswd check HostName Problem Volume shadow copies cannot b...

Page 413: ...ty provided by Microsoft contact Microsoft Product Support Services It is recommended to perform registry management tasks periodically to prevent the registry from filling Problem Data Protector reports that a volume was not removed During a backup session the following error is reported Volume StorageID which is part of backup backupID was not removed This error may appear if a replica on the di...

Page 414: ...ction To make the Exchange Management Console show the real status of a database copy perform either of the following actions Update Microsoft Exchange Server 2007 with Service Pack 1 Perform re seeding procedure as follows 1 On the passive node suspend the replication by using Suspend StorageGroupCopy cmdlet 2 Delete all log files from the Logs directory of the database copy 3 Seed the database c...

Page 415: ...ystem writers was aborted the Windows operating system is corrupted when you restart it If the restore of some system writers for example System Writer is aborted for any reason hardware or software failure manually aborted etc the Windows operating system may be corrupted after the restart for example the GUI or some system services cannot be started etc Action Depending on the nature of the corr...

Page 416: ...ted and the files are not visible to the writer As a result an error is reported and the database can not be brought online after restore Action To recover the database after such session 1 Detach from the database 2 Attach to the database Problem Creation of an RSG fails when an RSG for the same storage group already exists When you start a standard restore or instant recovery of the Microsoft Ex...

Page 417: ...mple setup is possible A Microsoft Exchange Server 2003 is running on the application system and is connected to a HP StorageWorks Enterprise Virtual Array A tape drive is connected to the application system for restore purposes A separate backup system is connected to a tape library Two storage groups are configured on the Microsoft Exchange Server 2003 each containing two stores The first storag...

Page 418: ...to start a VSS transportable backup at night In the Recurring box specify Full backup Weekly on Wednesdays and Fridays and Incremental backup Weekly on other days Set the backup protection to 2 days For the second storage group Mailbox_Group create the backup specification that can be used for instant recovery 1 Select VSS transportable backup as the backup type Select the application and backup s...

Page 419: ...lboxes is damaged but the transaction logs and other stores are not damaged Therefore a rollforward recovery will be performed only for this store To perform a rollforward recovery proceed as follows 1 Start the Microsoft Exchange Manager and unmount all stores in Mailbox_Group but do not unmount the stores from the first storage group 2 Start Data Protector go to the Instant Recovery context and ...

Page 420: ...mplete Lists_Group storage group perform the following steps 1 Start Exchange System Manager and check if the first storage group Lists_Group is already unmounted If not unmount the whole group 2 Start Data Protector In the Restore context expand the application system Select the last backup session and then Microsoft Exchange Server 2003 Writer Select the first storage group Lists_Group Start the...

Page 421: ... want to reconfigure the Oracle instance Refer to Oracle backup set ZDB concepts on page 39 and to Oracle proxy copy ZDB concepts on page 44 for details on the required configuration For additional examples on how to move the redo logs and control files refer to Examples for moving the control files and redo logs to different locations on page 423 Moving Online Redo Logs To move the online redo lo...

Page 422: ...locations 1 Determine if the database uses the SPFILE parameter SQL show parameter SPFILE 2 If the database does not use SPFILE a Shut down the database SQL shutdown b Move the control files to a different location using operating system tools c Edit the CONTROL_FILES parameter in the database s initialization parameter file usually located in the ORACLE_HOME dbs initSID ora directory to change th...

Page 423: ... replicated 1 List the online redo log files sqlplus SQL select member from v logfile opt oracle product 9 2 0 oradata redo01 log opt oracle product 9 2 0 oradata redo02 log opt oracle product 9 2 0 oradata redo03 log List the filenames and tablespaces to check whether they are on the same source volumes as the control files SQL select FILE_NAME TABLESPACE_NAME BYTES from dba_data_files FILE_NAME ...

Page 424: ...file opt oracle product 9 2 0 oradata redo01 log to oracle logs redo01 log Database altered alter database rename file opt oracle product 9 2 0 oradata redo02 log to oracle logs redo01 log Database altered alter database rename file opt oracle product 9 2 0 oradata redo03 log to oracle logs redo01 log Database altered 6 Open the database in normal mode SQL alter database open Example Moving Contro...

Page 425: ... integrations omnirc variables The Data Protector ZDB integrations use environment variables which can be set in the opt omni omnirc on UNIX systems or Data_Protector_home omnirc file on Windows systems on both the application and backup systems These variables are used for Data Protector ZDB integrations customizing See the online Help index omnirc options for information on how to use the omnirc...

Page 426: ...ZDB and restore concepts when this variable is set to 0 see Oracle backup set ZDB concepts on page 39 and Oracle proxy copy ZDB concepts on page 44 For SAP R 3 backup and restore concept when this variable is set to 0 see Integration concepts on page 164 If this variable is set to 1 Data Protector creates target volumes for all source volumes containing Oracle datafiles Oracle control file and if ...

Page 427: ...d on a disk array Data Protector SAP R 3 integration Oracle datafiles and Oracle control file must be installed on a disk array See Figure 122 on page 428 and Figure 123 on page 429 for Oracle backup and restore concepts when this variable is set to 1 See Figure 124 on page 430 for SAP R 3 backup and restore concepts when this variable is set to 1 Zero downtime backup integration guide 427 ...

Page 428: ...Figure 122 Oracle proxy copy ZDB and restore concepts when the ZDB_ORA_INCLUDE_CF_OLF variable is set to 1 Appendix 428 ...

Page 429: ...Figure 123 Oracle backup set ZDB and restore concept when the ZDB_ORA_INCLUDE_CF_OLF variable is set to 1 Zero downtime backup integration guide 429 ...

Page 430: ... backup is performed using the Data Protector SAP R 3 integration By default if this variable is set to 0 during a ZDB session Data Protector checks if Oracle datafiles and the SPFILE are on the same source volumes If the SPFILE and datafiles are on the same volumes and instant recovery is enabled the ZDB session is aborted If the ZDB_ORA_INCLUDE_SPF variable set to 1 Data Protector skips the chec...

Page 431: ...e control file online redo logs and the SPFILE OB2MARAWREAD_KB This variable sets the read block size for Oracle and SAP R 3 ZDB integrations on UNIX systems with Oracle tablespaces or datafiles installed on disk images and when using the proxy copy method when using DMA The default value is 64KB The specified value must be in the range between 1KB an 1MB The specified size is automatically adjust...

Page 432: ...Appendix 432 ...

Page 433: ...andom keys of 256 bit length The same key is used for both encryption and decryption With AES 256 bit encryption data is encrypted before it is transferred over a network and before it is written to media AML EMASS GRAU specific term Automated Mixed Media library application agent A component needed on a client to back up or restore online database integrations See also Disk Agent application syst...

Page 434: ...ked up during the full client backup These files are stored as an ASR archive file on the Cell Manager in the directory Data_Protector_program_data Config Server dr asr Windows Server 2008 Data_Protector_home Config Server dr asr other Windows systesm or etc opt omni server dr asr UNIX systems as well as on the backup medium After a disaster occurs the ASR archive file is extracted to diskettes wh...

Page 435: ...reation searching and removing the backup files backup chain See restore chain backup device A device configured for use with Data Protector which can write data to and read data from storage media This can be for example a standalone DDS DAT drive or a library backup generation One backup generation includes one full backup and all incremental backups until the next full backup backup ID An ident...

Page 436: ...n to also called the backup or media set See also backup specification incremental backup and full backup backup set A complete set of integration objects associated with a backup backup set Oracle specific term A logical grouping of backed up files that are created using the RMAN backup command A backup set is a complete set of files associated with a backup The files can be multiplexed to increa...

Page 437: ...StorageWorks Disk Array XP LDEVs for purposes such as data backup or data duplication The copies secondary volumes or S VOLs can be separated from the primary volumes P VOLs and connected to a different system for various purposes such as backup and development For backup purposes P VOLs should be connected to the application system and one of the S VOL mirror sets should be connected to the backu...

Page 438: ...to be protected See also BC and BC Process Boolean operators The Boolean operators for the full text search functionality of the online Help system are AND OR NOT and NEAR Used when searching they enable you to define your query precisely by creating a relationship between search terms If no operator is specified in a multi word search AND is used by default For example the query manual disaster r...

Page 439: ...mote secondary disk arrays The main disk arrays contain the CA primary volumes P VOLs which contain the original data and are connected to the application system The remote disk arrays contain the CA secondary volumes S VOLs connected to the backup system See also BC HP StorageWorks Disk Array XP specific term Main Control Unit and HP StorageWorks Disk Array XP LDEV CA BC EVA HP StorageWorks EVA s...

Page 440: ...the systems on a site or an organizational entity which are connected to the same LAN Central control is available to administer the backup and restore policies and tasks Cell Manager The main system in the cell where the essential Data Protector software is installed and from which all backup and restore activities are managed The GUI used for management tasks can be located on a different system...

Page 441: ...data is committed to the database Circular logging reduces disk storage space requirements client backup A backup of all volumes filesystems mounted on a Data Protector client What is actually backed up depends on how you select objects in a backup specification If you select the check box next to the client system name a single backup object of the Client System type is created As a result at the...

Page 442: ...ication Service and can be backed up using VSS like an ordinary storage group See also Exchange Replication Service and local continuous replication CMD Script for Informix Server Informix Server specific term A Windows CMD script that is created in INFORMIXDIR when an Informix Server database is configured The CMD script is a set of system commands that export environment variables for Informix S...

Page 443: ...N See also Virtual Library System VLS concurrency See Disk Agent concurrency control file Oracle and SAP R 3 specific term An Oracle data file that contains entries specifying the physical structure of the database It provides database consistency information used for recovery copy set HP StorageWorks EVA specific term A pair that consists of the source volumes on a local EVA and their replica on ...

Page 444: ...nstallation time See also Data_Protector_program_data Data_Protector_ program_data On Windows Vista and Windows Server 2008 the directory containing Data Protector data files Its default path is ProgramData OmniBack but the path can be changed in the Data Protector Setup Wizard at installation time See also Data_Protector_home database library A Data Protector set of routines that enables data tra...

Page 445: ... Data Protector medium used for backup Its maximum size is limited by the file system settings delta backup A delta backup is a backup containing all the changes made to the database from the last backup of any type See also backup types device A physical unit which contains either just a drive or a more complex unit such as a library device chain A device chain consists of several standalone devi...

Page 446: ...al database backup A differential database backup records only those data changes made to the database after the last full database backup direct backup A SAN based backup solution in which data movement directly from disk to tape or to other secondary storage is facilitated by the SCSI Extended Copy Xcopy command Direct backup lessens the backup I O load on systems in a SAN environment The data m...

Page 447: ...ored on the disk but stores a disk image structure on byte level You can perform a disk image backup of either specific disk sections or a complete disk disk quota A concept to manage disk space consumption for all or a subset of users on a computer system This concept is used by several operating system platforms disk staging The process of backing up data in several phases to improve the perform...

Page 448: ...ured before the Data Protector disaster recovery can be performed DR OS can be either temporary or active A temporary DR OS is used exclusively as a host environment for some other operating system restore along with the target operating system configuration data It is deleted after the target system is restored to the original system configuration An active DR OS not only hosts the Data Protector...

Page 449: ...r encryption key KeyID StoreID Combined identifier used by the Data Protector Key Management Server to identify and administer encryption keys used by Data Protector KeyID identifies the key within the keystore StoreID identifies the keystore on the Cell Manager If Data Protector has been upgraded from an earlier version with encryption functionality there may several StoreIDs used on the same Cel...

Page 450: ...R technology See also cluster continuous replication and local continuous replication exchanger Also referred to as SCSI Exchanger See also library exporting media A process that removes all data about backup sessions such as systems objects and file names which reside on the media from the IDB Information about the media and their relation to a pool is also removed from the IDB The data on the me...

Page 451: ...y device A device which resides on a disk emulating a library with several media hence containing multiple files referred to as file depots File Replication Service FRS A Windows service that replicates the domain controller store logon scripts and group policies FRS also enables replication of Distributed File System DFS shares between systems and allows any server to perform replication activity...

Page 452: ...ader Data Protector media with protected data are not formatted until the protection expires or the media are unprotected recycled free pool An auxiliary source of media for use by media pools when they run out of media The media pools must be configured to use free pools full backup A backup in which all selected objects are backed up whether or not they have been recently modified See also backu...

Page 453: ...rosoft Exchange Server specific term A Microsoft Exchange Server database recovery that is performed after a restore by the database engine using transaction log files heartbeat A cluster data set with a time stamp carrying information about the operational status of a particular cluster node This data set or packet is distributed among all cluster nodes Hierarchical Storage A method for optimizin...

Page 454: ...ger HP StorageWorks Disk Array XP LDEV A logical partition of a physical disk within an HP StorageWorks Disk Array XP LDEVs are entities that can be replicated in the Continuous Access XP CA and Business Copy XP BC configurations or can be used as standalone entities See also BC CA HP StorageWorks Disk Array XP specific term and replica HP StorageWorks EVA SMI S Agent A Data Protector software mod...

Page 455: ...h devices and libraries are configured IDB recovery file An IDB file obrindex dat with information about IDB backups media and devices used for the backup This information can significantly simplify IDB recovery It is recommended to relocate the file together with IDB transaction logs to a separate physical disk from other IDB directories and additionally to make an additional copy of the file imp...

Page 456: ...ir However the standard devices are updated with only the data that was written to the BCV device during the time of the original pair split and the data that was written to the standard device during the split is overwritten with data from the BCV mirror In SRDF control operations an incremental restore reassigns a target R2 device as the next available mirror of the source R1 device in the pair ...

Page 457: ... term A process in which a replica produced by a ZDB to disk or a ZDB to disk tape session is used to restore the contents of the source volumes to their states at the time at which the replica was created avoiding the need to perform a restore from tape Depending on the application or database concerned this may be all that is required or other steps such as the application of transaction log fil...

Page 458: ...ain A tool that eliminates the supply of a passphrase manually when decrypting the private key It needs to be installed and configured on the Installation Server if you perform remote installation using secure shell Key Management Service Microsoft Exchange Server specific term The Microsoft Exchange Server service that provides encryption functionality for enhanced security See also Information S...

Page 459: ...be used If you do not want to use load balancing you can select which device will be used for each object in the backup specification Data Protector will access the devices in the specified order local and remote recovery Remote recovery is performed if all Media Agent hosts specified in the SRD file are accessible If any of them fails the disaster recovery process fails over to the local mode Thi...

Page 460: ...se to start backing up logical log files when Informix Server issues a logfull event alarm The Informix Server ALARMPROGRAM configuration parameter defaults to the INFORMIXDIR etc log_full sh where INFORMIXDIR is the Informix Server home directory If you do not want logical logs to be backed up continuously set the ALARMPROGRAM configuration parameter to INFORMIXDIR etc no_log sh logging level The...

Page 461: ...to the Recovery Oracle Catalog Database is user_name password service where the description of the user name password and service name is the same as in the Oracle SQL Net V2 login information to the Oracle target database In this case service is the name of the service to the Recovery Catalog Database not the Oracle target database Note that the Oracle user specified here must be the owner of the...

Page 462: ... boots directly from the Ignite UX server Booting directly from the Ignite UX server can be automated with the Ignite UX bootsys command or interactively specified on the boot console make_tape_ recovery make_tape_recovery is a command on Ignite UX which creates a bootable recovery installation tape customized for your system and enables you unattended disaster recovery by connecting the backup de...

Page 463: ... condition factors The user assigned age threshold and overwrite threshold used to determine the state of a medium medium ID A unique identifier assigned to a medium by Data Protector media label A user defined identifier used to describe a medium media location A user defined physical location of a medium such as building 4 or off site storage media management session A session performing some ac...

Page 464: ...nts It provides a simple consistent and integrated administration user interface allowing management of many applications through the same GUI provided that the applications adhere to the MMC model Microsoft SQL Server A database management system designed to meet the requirements of distributed client server computing Microsoft Volume Shadow Copy Service VSS A software service that provides a uni...

Page 465: ...ltiple cells from a central point mount request A screen prompt that tells you to insert a specific medium into a device Once you respond to the mount request by providing the required medium and confirm the mount request the session continues mount point The access point in a directory structure for a disk or logical volume for example opt or d On UNIX the mount points are displayed using the bdf...

Page 466: ...ring an object copy session the selected backed up objects are copied from the source to the target media object copying The process of copying selected object versions to a specific media set You can select object versions from one or several backup sessions to be copied object ID Windows specific term The object IDs OIDs enable access to NTFS 5 files no matter where in the system the files resid...

Page 467: ...See also zero downtime backup ZDB and online backup offline recovery Offline recovery is performed if the Cell Manager is not accessible for example due to network problems Only standalone and SCSI library devices can be used for offline recovery Recovery of the Cell Manager is always offline offline redo log See archived redo log ON Bar Informix Server specific term A backup and restore system fo...

Page 468: ... specific term Redo logs that have not been archived but are either available to the instance for recording database activity or are filled and waiting to be archived or reused See also archived redo log OpenSSH A set of network connectivity tools used to access remote machines securely by using a variety of authentication and encryption methods It needs to be installed and configured on the Insta...

Page 469: ... that starts an interactive backup the account under which the CRS process is running or the user specified as the owner in the backup specification options If a user starts an existing backup specification without modifying it the backup session is not considered as interactive If a modified backup specification is started by a user the user is the owner unless the following is true The user has ...

Page 470: ... mirrored volume contain identical data SUSPENDED The link between the mirrored disks is suspended That means that both disks are accessed and updated independently However the mirror relationship is still maintained and the pair can be re synchronized without transferring the complete disk parallel restore Restoring backed up data to multiple disks at the same time that is in parallel by running ...

Page 471: ... additional action before and after a backup or restore session They are not supplied by Data Protector You need to create your own commands They can be written as executables or batch files on Windows and as shell scripts on UNIX prealloc list A subset of media in a media pool that specifies the order in which media are used for backup pre exec A backup option that executes a command or script be...

Page 472: ...StorageWorks Disk Array XP features through the use of function calls translated into a sequence of low level SCSI commands RAID Manager XP HP StorageWorks Disk Array XP specific term The RAID Manager XP application provides an extensive list of commands to report and control the status of the CA and BC applications The commands communicate through a RAID Manager instance with the HP StorageWorks ...

Page 473: ...acking up Windows configuration files Data Protector collects the information about the current system configuration information on disk layout volume and network configuration This information is needed for disaster recovery Recovery Manager RMAN Oracle specific term An Oracle command line interface that directs an Oracle Server process to back up restore or recover the database it is connected t...

Page 474: ...ular point in time of the data in source volumes that contain user specified backup objects Depending on the hardware or software with which it is created the image may be an independent exact duplicate clone of the storage blocks at the physical disk level for example a split mirror or snapclone or a virtual copy for example a snapshot From perspective of a basic operating system the complete phy...

Page 475: ...nization of an S VOL with its P VOL See also VSS compliant mode source volume primary volume P VOL replica secondary volume S VOL MU number and replica set rotation RMAN Oracle specific term See Recovery Manager RSM The Data Protector Restore Session Manager controls restore and object verification sessions This process always runs on the Cell Manager system RSM Windows specific term Removable Sto...

Page 476: ...dia management session consisting of the date when the session ran and a unique number session key This environment variable for the pre exec and post exec script is a Data Protector unique identification of any session including preview sessions The session key is not recorded in the database and it is used for specifying options for the omnimnt omnistat and omniabort commands shadow copy Microso...

Page 477: ...eferences each slot with a number To read a medium a robotic mechanism moves the medium from a slot into the drive SMB See split mirror backup smart copy VLS specific term A copy of the backed up data created from the virtual tape to the physical tape library The smart copy process allows Data Protector to distinguish between the source and the target medium thus enabling media management See also...

Page 478: ...nd copying processes normally continue after creation See also snapshot source R1 device EMC Symmetrix specific term An EMC Symmetrix device that participates in SRDF operations with a target R2 device All writes to this device are mirrored to a target R2 device in a remote EMC Symmetrix unit An R1 device must be assigned to an RDF1 group type See also target R2 device source volume ZDB specific t...

Page 479: ...t mirror replica which is then synchronized to the source volumes Individual backup objects or complete sessions can be restored using this method See also ZDB to tape ZDB to disk tape and replica sqlhosts file Informix Server specific term An Informix Server connectivity information file on UNIX or registry on Windows that contains the names of each of the database servers and any aliases to whic...

Page 480: ...ent A single SCSI entry is required for a single drive device and multiple SCSI entries are required for a multi drive library device stackers Devices with multiple slots for media storage usually with only one drive A stacker selects media from the stack sequentially In contrast a library can randomly select media from its repository standalone file device A file device is a file in a specified d...

Page 481: ...MC Symmetrix environment for backup and restore operations synthetic backup A backup solution that produces a synthetic full backup an equivalent to a conventional full backup in terms of data without putting stress on the production servers or the network A synthetic full backup is created from a previous full backup and any number of incremental backups synthetic full backup The result of an obj...

Page 482: ...opy of the domain s public files which are replicated among all domain controllers in the domain tablespace A part of a database structure Each database is logically divided into one or more tablespaces Each tablespace has data files or raw volumes exclusively associated with it tapeless backup ZDB specific term See ZDB to disk target database Oracle specific term In RMAN the target database is th...

Page 483: ...onfigured SLDs called BCVs and is accessible via a separate device address to the system s TLU Tape Library Unit TNSNAMES ORA Oracle and SAP R 3 specific term A network configuration file that contains connect descriptors mapped to service names The file may be maintained centrally or locally for use by all or individual clients transaction A mechanism for ensuring that a set of actions is treated...

Page 484: ...s of containers where you want backups to begin It is a text file located in the SYS SYSTEM TSA directory on the server where TSANDS NLM is loaded UIProxy The Java GUI Server UIProxy service runs on the Data Protector Cell Manager It is responsible for communication between the Java GUI Client and the Cell Manager moreover it performs business logic operations and sends only important information ...

Page 485: ...ly user rights User rights or access rights are the permissions needed to perform specific Data Protector tasks Configuring a backup starting a backup session or starting a restore session are typical user rights Users have the access rights of the user group to which they belong vaulting media The process of storing media to a safe and remote place The media are brought back to the data center wh...

Page 486: ... domain by a network IP name and address Its address is cached by the cluster software and mapped to the cluster node that is currently running the virtual server resources This way all requests for a particular virtual server are cached by a specific cluster node virtual tape VLS specific term An archival storage technology that backs up data to disk drives in the same way as if it were being sto...

Page 487: ...the source volume P VOL and its replica S VOL are in simplex unpaired state after a backup Therefore the number of replicas S VOLs per a P VOL rotated is not limited Restore from a backup in such a configuration is possible only by switching of the disks See also resync mode source volume primary volume P VOL replica secondary volume S VOL and replica set rotation VxFS Veritas Journal Filesystem V...

Page 488: ...ically applications or system services that write persistent information on a volume Writers also participate in the shadow copy synchronization process by assuring data consistency XBSA interface Informix Server specific term ON Bar and Data Protector communicate with each other through the X Open Backup Services Application Programmer s Interface XBSA XCopy engine direct backup specific term A S...

Page 489: ...dard Data Protector restore from tape or on split mirror arrays split mirror restore See also zero downtime backup ZDB ZDB to disk ZDB to tape instant recovery replica and replica set rotation ZDB to tape ZDB specific term A form of zero downtime backup where data in the replica produced is streamed to a backup medium typically tape Instant recovery is not possible from such a backup so the replic...

Page 490: ...Glossary 490 ...

Page 491: ... types 32 backup set ZDB concepts 39 44 backup set ZDB session flow 42 44 backup specifications creating 76 proxy copy ZDB concepts 44 49 proxy copy ZDB session flow 47 49 scheduling backups 98 starting backups 100 102 starting backups using CLI 101 starting backups using GUI 100 backing up SAP R 3 191 209 214 backup specifications creating 193 backup templates 194 backup types 191 backup specific...

Page 492: ...fications modifying MS Exchange Server integration 303 SAP R 3 integration 206 backup specifications scheduling MS SQL Server integration 265 backup templates SAP R 3 integration 194 backup types 332 Oracle integration 32 SAP R 3 integration 163 191 VSS integration 332 BRBACKUP 166 C checking configuration MS SQL Server integration 252 Oracle integration 69 SAP R 3 integration 188 VSS integration ...

Page 493: ...ecifications MS SQL Server integration 254 Oracle integration 76 SAP R 3 integration 193 VSS integration 362 D Data Guard Oracle integration limitations 51 database recovery Oracle integration after instant recovery 138 database recovery Oracle integration options 119 SAP R 3 integration 221 database recovery options SAP R 3 integration 223 disaster recovery Oracle integration 104 Disk Array XP wi...

Page 494: ...3 integration 208 interactive backups Oracle integration 100 VSS integration 378 introduction MS Exchange Server integration 285 MS SQL Server integration 243 Oracle integration 31 SAP R 3 integration 163 VSS integration 329 L limitations VSS integration 345 local continuous replication 342 local VSS backup 364 M manual balancing SAP R 3 integration 214 SAP R 3 integration 205 Media Management Lib...

Page 495: ...84 O OB2_MIRROR_COMP SAP R 3 integration 211 OB2RMANSAVE Oracle integration 161 offline backup Hyper V writer 375 omnirc variables 425 431 online backup Hyper V writer 375 Oracle backup backup types 32 proxy copy ZDB session flow 47 49 scheduling backups 98 Oracle configuration backup methods 74 example CLI 68 Oracle integration concepts 35 Oracle restore database items 102 restorable items 102 da...

Page 496: ...le instance for instant recovery 421 recovery Oracle database after instant recovery 138 Oracle integration options 119 SAP R 3 integration 221 recovery catalog Oracle integration restore 105 recovery options SAP R 3 integration 223 related documentation 19 restore 379 408 instant recovery procedure 400 problems 415 procedure 400 troubleshooting 415 restore flow VSS integration 338 restore methods...

Page 497: ...3 running backups See starting backups S SAP R 3 backup backup templates 194 backup types 191 manual balancing 214 SAP compliant ZDB 211 scheduling backups 206 starting backups 208 verifying backups 233 ZDB flow 165 SAP R 3 configuration authentication modes 182 listener configuring 177 SAP R 3 integration introduction 163 monitoring sessions 228 SAP R 3 restore verifying restores 235 SAP R 3 trou...

Page 498: ...rd snapshot EVA 361 starting backups VSS integration 378 starting backups SAP R 3 integration 208 starting backups Oracle integration using CLI 101 using GUI 100 starting backups Oracle integration 100 102 storage groups 372 Subscriber s Choice HP 30 T technical support HP 29 technical support service locator website 30 transportable VSS backup 364 transportable backup 366 troubleshooting 409 back...

Page 499: ...tarting backups 378 transportable 364 types 332 VSS configuration 347 354 VSS database 339 VSS integration prerequisites 344 advantages 333 architecture 331 336 checking configuration 353 concepts 332 338 configuration 347 354 354 configuring 347 352 introduction 329 limitations 345 troubleshooting 408 417 VSS provider configuring 352 VSS restore 379 408 example MS Exchange Server 2003 419 instant...

Page 500: ...86 Microsoft Exchange Server 2007 388 Microsoft Hyper V writer 375 391 MSDE 384 X XP agent instant recovery considerations 397 Z ZDB session flow Oracle integration proxy copy 47 49 ZDB flow SAP R 3 integration 165 ZDB session flow Oracle integration backup set 42 44 500 ...

Reviews:

No comments

Brands by name

Popular brands

Load more brands