HP StorageWorks P9000 Replication Manager Software CLI User Guide Part number: TB584-96026 First edition: April 2011
Legal and notice information © Copyright 2011 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents Preface .............................................................................................. 25 1 Overview of Application Agent .......................................................... 27 Application Agent features ........................................................................................................ Application Agent functions ...................................................................................................... Backing up data ........................
Precautions on backing up and restoring data between storage systems .................................... Configuration for restoring SQL Server database backup data on a host different from the backup host ........................................................................................................................................ Configuration when using the SQL Server log-shipping function ......................................................
3 Preparation for using Application Agent ............................................ 101 Setting up an environment for Application Agent ......................................................................... 101 Setting up RAID Manager ........................................................................................................ 104 Backing up one primary volume to multiple generations ........................................................
Creating a database list file or mount point directory list file .................................................. Commands that support a target definition file ............................................................... File name of the list file ............................................................................................... List file storage location .............................................................................................. Contents of the list file ..............
Definition files created after the installation of Application Agent ...................................... Application Agent backup information .......................................................................... Recovering the operating environment ................................................................................. Recovering operating environment (common among servers) ........................................... Recovering backup information (file server) .............................
Backing up and restoring by using a tape device ........................................................................ 249 System configuration ......................................................................................................... 249 Flow of processing ........................................................................................................... 251 Backing up a file system to tape .........................................................................................
Database status ......................................................................................................... Database type ........................................................................................................... Backing up and restoring data between volumes ......................................................................... System configuration ......................................................................................................... Processing flow .....
Operation at the remote site ........................................................................................ Recovering data from the remote site to the local site ............................................................ Operation at the local site .......................................................................................... Operation at the remote site ........................................................................................ Operation at the local site .............
Perform database recovery .......................................................................................... Prepare to restart operations ....................................................................................... Setting and checking the 'sync with backup' option .............................................................. How to set the 'sync with backup' option ...................................................................... How to check the 'sync with backup' option ........
Backing up and restoring in a CCR configuration ........................................................................ 441 Using different backup servers for the active and standby servers ............................................ 443 Performing a backup on the active server ...................................................................... 444 Performing a backup on the standby server ...................................................................
Verifying dictionary map files ............................................................................................. Restoring key definition files (.KDF) ..................................................................................... Restoring key files (.K01 or .Knn) ........................................................................................ Restoring missing data files (.DRF or .DAT) ........................................................................... When data file (.
Procedure for restoring from tape directly to the primary volume .................................................... 551 F Note on a firewall on the local host .................................................. 553 Note on a firewall on the local host ........................................................................................... 553 G Notes on using the Remote Desktop functionality ............................... 555 Notes on using the Remote Desktop functionality ...........................
Figures 1 Overview of Application Agent ................................................................................. 28 2 Logical volume consisting of multiple copy groups ...................................................... 30 3 Data management at a remote site ........................................................................... 32 4 Backing up multiple generations ..............................................................................
27 Configuration in Which an Active Mailbox Database Copy Is Backed Up and Restored ................................................................................................................ 62 28 Configuration in Which a Passive Mailbox Database Copy Is Backed Up and Restored ................................................................................................................
52 Example of specifying a RAID Manager instance number in the RAID Manager-linkage definition file (default.dat) ...................................................................................... 120 53 Example of creating dictionary map files in an Active-Passive cluster configuration ......... 134 54 Example of creating dictionary map files in an Active-Active cluster configuration .......... 136 55 Cluster group definition (when a backup target and shared disks are in the same cluster group) .......
83 Procedure for restoring an SQL Server database to the primary volume ........................ 291 84 System configuration for backing up an SQL Server database to tape and restoring it from tape .................................................................................................................... 295 85 Procedure for restoring an SQL Server database to the primary volume ........................ 297 86 Procedure for restoring an SQL Server database from its backup tape .....................
112 Processing flow for restoring storage groups on the primary volume ............................. 400 113 System configuration for backing up and restoring storage groups to and from tape ...... 402 114 Processing flow for backing up storage groups to tape ............................................... 404 115 Processing flow for restoring storage groups from tape ............................................... 405 116 System configuration for backup of a storage group to tape ..........................
Tables 1 OSs that can run Application Agent (for x86) ............................................................. 35 2 OSs that can run Application Agent (for IPF or x64) .................................................... 35 3 Node Combinations Supported by Application Agent ................................................. 37 4 Memory required to run Application Agent on a virtual machine of VMware ESX ............ 39 5 Guest OS of Windows Server 2008 Hyper-V supported by Application Agent ............
26 Parameter in CLU_MSCS_RESTORE and cluster resource Status (SQL Server database 2) ....................................................................................................................... 116 27 Parameter in CLU_MSCS_RESTORE and cluster resource status (Exchange database) ...... 117 28 Parameter in init.conf (setup of parallel execution of verification processes) ................... 117 29 Parameter in init.conf (setting the communication timeout period for the Protection Manager service) .
53 Parameters defined in the definition file for the cascade configuration .......................... 152 54 How the -cascade option and the sections are evaluated ............................................ 155 55 Parameters to be defined in the configuration definition file for tape backup (for NetBackup) .......................................................................................................... 157 56 Parameters defined in the configuration file for tape backup (for Backup Exec) .........
83 Correspondence between extended commands and basic commands (commands used for backing up and restoring file systems) ................................................................. 222 84 Correspondence between extended commands and basic commands (Common commands) .......................................................................................................... 222 85 Correspondence between extended commands and basic commands (Tape commands) ..................................................
111 Application Agent information ................................................................................ 503 112 RAID Manager information .................................................................................... 505 113 Database information (when the backup is of an SQL Server database or Exchange database) ............................................................................................................ 506 114 Other information ...............................................
Preface This guide describes how to manage HP StorageWorks P9000 Replication Manager.
Preface
1 Overview of Application Agent Application Agent is designed to provide efficient and reliable data protection while easing the workload on system administrators. This chapter describes the features and functions of Application Agentsoftware, as well as the system requirements. The descriptions in this chapter apply to the Application Agent CLI.
The following figure provides an overview of how Application Agent interacts with various storage media. Figure 1 Overview of Application Agent The following describes how Application Agent controls other software components. The numbers below correspond to those in the figure above: 1. Application Agent quiesces (pauses) file systems or databases in storage systemsin order to ensure reliable backup operations. 2.
User script files are used to perform a series of backup operations to copy data from a primary volume to a secondary volume, and then from the secondary volume to a tape device. Using these scripts allows system administrators to accomplish a series of commands in just one command. Restoring data Application Agent provides various commands that use volume replication functions to restore a database or file system from a backup. You can use whichever restore command most suits your specific needs.
If you execute Application Agent commands in a cluster configuration, you must specify the location of the dictionary map files to be used for each virtual server. For details on cluster configurations, see “ Cluster support ” on page 30. For details on how to create the dictionary map files in a cluster configuration, see “Creating dictionary map files” on page 132.
Application Agent supports mutual standby cluster configurations (Active-Active) as well as operational standby cluster configurations (Active-Passive). For details on cluster configurations see “Operation standby configuration” on page 45 or “Mutual standby configuration” on page 46. In a cluster environment using MSCS, you can choose whether to perform a restore operation while the cluster resources that monitor the DBMS are in the online or offline state.
Figure 3 Data management at a remote site Managing data at a remote site allows you have a secondary volume in a storage system that is physically different from the storage system where the primary volume resides. Application Agent uses the Continuous Access Software or Continuous Access Journal copy type to back up or restore volumes to or from a remote site.
When selecting a secondary volume for a backup, you can either manually select the volume you want to use or have Application Agent choose it for you. In order to have Application Agent choose a secondary volume for you, you need to use the volume copy function. When manually selecting a volume, specify the generation name unique to the desired volume.
Figure 5 Backing up multiple generations when a copy group is locked The order in which secondary volumes are used for backups does not change regardless of which generation you might decide to restore at some point in time. The number of generations that Application Agent can manage, and the backup and restore operations available are all dependent on the volume replication functions of the particular storage system.
Application Agent system requirements This section describes the requirements for a host and server to run Application Agent. This section also describes the required user permissions for executing commands.For details about supported storage systems, see the HP StorageWorks P9000 Replication Manager Software Configuration Guide. Requirements for a host that has Application Agent installed on it The tables below list OSs that can run Application Agent.
--: Application Agent cannot run on the OS. #1 Runs in SP2 or higher. #2 Backup using VSS is not supported. #3 Runs in the 32-bit emulation mode. The following applications must be installed and set up on the host that you want to install Application Agent onto: • RAID Manager Application Agent uses RAID Manager's CLI. As such, RAID Manager must be installed before using Application Agent. • Logical volume manager Windows standard LDM#1 or Veritas Volume Manager for Windows#2 must be installed.
System configurations compatible with IPv6 This section describes the conditions for system configurations that use IPv6. Node combinations supported by Application Agent Application Agent supports IPv6 in configurations that use dual stack nodes. The following table lists the nodes on the server side and the corresponding nodes on the client side that Application Agent supports.
Linking Application Agent to othersoftware Application Agentcan be linked to backup management and cluster software, and automating tape backups. This section describes the software products that can be linked to Application Agent.
To run Application Agent on a virtual machine of VMware ESX, you must allocate the memory shown below to the virtual machine and then configure the system to match the recommended configuration for the product.
• The version of SQL Server is SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2. #2 SP3 or later of SQL Server 2005 is supported. Windows Server 2008 Hyper-V support depending on the connection method used for the guest OS Windows Server 2008 Hyper-V support depends on the connection method used for the guest OS. The following table shows the support information depending on the guest OS connection method.
Memory required for running Application Agent on a virtual machine of Windows Server 2008 Hyper-V The required memory is the same as for VMware ESX. For details, see “VMware ESX” on page 38.
Overview of Application Agent
2 Application Agent system configurations This section describes the main system configuration patterns when using Application Agent. It also describes the requirements for backing up a database and what precautions need to be taken before running Application Agent. The descriptions in this chapter apply to the Application Agent CLI.
Figure 6 Example of a system configured to back up and restore data between volumes Configuration for backing up and restoring data using tape To store data backed up to tape by using Application Agent, the system needs two servers: a file server or a database server that manages the primary volume, and a backup server connected to the tape device.
Figure 7 Example of a system configured to store backed-up data to tape Operation standby configuration Application Agent can handle a two-node cluster configuration of the operation standby type (Active-Passive) on a database server and file server. The following is an example of a cluster configuration of the operation standby type (Active-Passive). You can build a cluster configuration using file servers or database servers.
Figure 8 Example of a cluster configuration of the operation standby type (Active-Passive) To execute Application Agent commands in a cluster configuration of the operation standby type (Active-Passive), you need to assign a storage destination for the dictionary map files used by each virtual server. For about the dictionary map files in a cluster configuration, see “Creation in an Active-Passive cluster configuration” on page 133.
Figure 9 Example of a cluster configuration of the mutual standby type (Active-Active) To execute Application Agent commands in a cluster configuration of the mutual standby type (Active-Active), create a dictionary map files for each virtual server. Additionally, you need to assign a storage destination for the dictionary map files used by each virtual server. For details about the dictionary map files in a cluster configuration, see “Creation in an Active-Active Cluster Configuration” on page 135.
• Business Copy (multi-generation), Continuous Access Software, or Continuous Access Journal configuration The following explains each of these configurations. Continuous Access Software or Continuous Access Journal configuration Application Agent supports the Continuous Access Software or Continuous Access Journal configuration as the basic configuration for backing up and restoring data between storage systems.
Figure 11 Business Copy and Continuous Access Software multi-target configuration Business Copy and Continuous Access Journal multi-target configuration Application Agent supports a multi-target configuration for Business Copy and Continuous Access Journal. The following figure shows the Business Copy and Continuous Access Journal multi-target configuration diagram.
Figure 13 Continuous Access Software and Continuous Access Journal multi-target configuration Business Copy (multi-generation), Continuous Access Software, or Continuous Access Journal configuration Application Agent supports a system configuration for Business Copy (multi-generation), and Continuous Access Software, or Continuous Access Journal. The following figure shows the Business Copy (multi-generation) and Continuous Access Software, or Continuous Access Journal configuration diagram.
Figure 14 Business Copy (multi-generation), Continuous Access Software, or Continuous Access Journal configuration Precautions on backing up and restoring data between storage systems • Regarding pair creation of paired volumes between storage system Application Agent does not automatically create paired volumes when it backs up data between a local site and a remote site. Users must create a pair of paired volumes in advance.
Figure 15 Example of configuration for concurrent backup from multiple primary volumes to multiple secondary volumes (remote copy) • Regarding start of RAID Manager instances between storage systems RAID Manager instances between a local site and a remote site are not automatically started. Start the RAID Manager instances on the remote site in advance.
Figure 16 Example of a system configured to restore data on a host that differs from the host used for backup Configuration when using the SQL Server log-shipping function You can use the log-shipping function in Microsoft SQL Server 2005 or Microsoft SQL Server 2008 to back up an SQL Server database. When you use this function, the system needs two servers: a source server that distributes log files, and a destination server to which the log files are distributed.
Figure 17 Example of a system configuration for the log-shipping functionality Cascade configuration for SQL Server database backup When the backup is of an SQL Server database, Application Agent can handle the backup to a secondary volume at a remote destination. The backup configuration in this case is called a cascade configuration because backup configuration has multiple hierarchies. For data backup and restoration in a cascade configuration, use user scripts.
Figure 18 Example of a Cascade configuration (when the backup is of an SQL Server database) Multi-target configuration for SQL Server database backup When the backup is of an SQL Server database, Application Agent can handle a multi-target configuration that backs up data to a remote destination and to a secondary volume with a local environment at the same time. For data backup and restoration in multi-target configuration, use user scripts.
how to store data in a tape, see “Backing up a file system to tape” on page 253 or “Backing up storage groups to tape” on page 405. The following figure is an example of a system configuration where Application Agent uses VSS to back up data. Figure 20 Example of System configuration where Application Agent uses VSS to back up data Cascade configuration for Exchange database backup When you back up Exchange databases, Application Agent can back up data concurrently at both the local and remote sites.
Figure 21 Example of a Cascade configuration (when backing up Exchange databases) CCR configurations Application Agent supports backup in a CCR configuration. CCR is a high availability function of Exchange Server 2007, and includes the following features: • Ability to ship logs (transaction log replication) between active and standby server volumes. • When VSS backup is used with SCC, backups can be performed only at the active server.
Figure 22 CCR configuration example (backups performed only at the active server) Performing backup only at the standby server The following figure shows an example of a CCR configuration in which backups are performed only at the standby server.
Figure 24 CCR configuration example (backups performed using different backup servers for the active and standby servers) Using the same backup server for the active and standby servers The following figure shows an example of a CCR configuration in which backups are performed using the same backup server for the active and standby servers.
Figure 26 Example of an SCR configuration Application Agent's restore processing provides the SCR seed function that executes seed processing (data resync) in an SCR configuration. The user can set whether the SCR seed function is to be used. The SCR seed function is used in the following cases: • When a point-in-time restore operation is performed. • When data integrity between the source and target is known to have been lost when a roll-forward restore operation was performed.
multiple Exchange databases, and back up mailbox databases within a group. If an error occurs in an active mailbox database copy, you can use the data in a passive mailbox database copy to continue operation. Application Agent provides backup and restore functionalities for mailbox database copies in the event of a logical error occurring due to issues such as incorrect email transmission and viruses.
Figure 27 Configuration in Which an Active Mailbox Database Copy Is Backed Up and Restored Primary volume 1 is the active mailbox database copy, primary volume 2 is the passive mailbox database copy, and the secondary volume is managed by the backup server. The active side manages all the services and backup and restore operations, and the passive side temporarily takes over execution of the active side's services if needed.
Figure 28 Configuration in Which a Passive Mailbox Database Copy Is Backed Up and Restored Primary volume 1 is the active mailbox database copy, primary volume 2 is the passive mailbox database copy, and the secondary volume is managed by the backup server. The active side manages services, and the passive side takes over execution of the active side's services if needed and also performs backup and restore operations.
Figure 29 Configuration in Which an Active Mailbox Database Copy and a Passive Mailbox Database Copy Are Backed Up and Restored by Different Backup Servers Primary volume 1 is the active mailbox database copy, and primary volume 2 is the passive mailbox database copy. Secondary volume 1 is managed by backup server 1, and secondary volume 2 is managed by backup server 2. The data synchronization between the active side and the passive side is accomplished via log shipping.
Backing up and restoring at the same backup server The following figure shows an example of a DAG configuration in which an active mailbox database copy and a passive mailbox database copy are backed up and restored by the same backup server. Figure 30 Configuration in Which an Active Mailbox Database Copy and a Passive Mailbox Database Copy Are Backed Up and Restored by the Same Backup Server Primary volume 1 is the active mailbox database copy, and primary volume 2 is the passive mailbox database copy.
Comparison of DAG configurations The following table compares the four types of DAG configurations that use Application Agent. Refer to this table when setting up your system. Table 7 Comparison of DAG Configurations Item Configuration 1 Configuration 2 Configuration 3 Configuration 4 Backup and restore operations are still available if an error occurs on one backup volume. Backup and restore operations are not available if an error occurs on one backup server.
• You cannot configure a paired volume so that the same server manages both the primary volume and secondary volume as physical disks. Figure 31 Configuration for managing the primary volume and secondary volume from the same server (without using Application Agent) • A copy group must consist of pair volumes for the same application.
• When using Continuous Access Software, do not enter an MU number in the MU# setting in the RAID Manager configuration definition file (horcmn.conf). If 0 is defined for the MU# setting, volume information for the Continuous Access Software pair will not be stored in the dictionary map when you execute a drmXXdisplay# command with the -refresh option specified. Therefore, the volume information cannot be displayed by the Application Agent command, and the pair volume cannot be backed up.
Figure 32 System configuration (when the primary volume for Business Copy and the primary volume for Continuous Access Software are the same LDEV) When using the configuration shown in Figure 32 to restore the paired volume for Business Copy by using Application Agent, set the status of the paired volume for Continuous Access Software to SMPL or PSUS (SSUS).
Figure 33 System configuration (when the secondary volume for Business Copy and the primary volume for Continuous Access Software are the Same LDEV) When using the configuration shown in Figure 2-27 to back up or restore the paired volume for Business Copy using Application Agent, set the status of the paired volume for Continuous Access Software to SMPL or PSUS (SSUS).
Figure 34 System configuration (In a Business Copy cascade configuration, when the volume subject to backup operates both as the primary volume and the secondary volume) In a Business Copy cascade configuration, Application Agent only supports backup and restore operations for the pair volumes of the primary volumes used in the database or the file system.
If restoring multiple storage groups together: If not using VSS: It is possible to define consistency groups to make files of the same file types of multiple storage groups that are always restored together are in a same consistency group. However, if rolling forward is not performed when restore and recovery operations are performed, it is possible to define consistency groups to make all files of the storage groups that are always restored together are in a same consistency group.
Figure 35 In Continuous Access-Async/Continuous Access Journal configuration: restoring UserDB1 and UserDB2 together or separately Figure 36 In Continuous Access-Async/Continuous Access Journal configuration: restoring UserDB1 and UserDB2 together • For information about precautions to take when changing a volume configuration, see “Precautions when changing a volume configuration” on page 79.
Volume configurations usable by Application Agent The table below describes volume configurations that Application Agent can back up and restore.
Figure 37 Examples of a disk set configuration and of a relationship between a disk group and a disk set In this manual, unless it is necessary to distinguish between VxVM and LVM disk groups, both groups are generically referred to as a disk group. Application Agent can also simultaneously back up a basic disk and a disk group. When a dynamic disk is being used, Application Agent supports both of the following configurations: • One disk group is used as one logical volume.
Examples of disk group configurations usable by Application Agent If you configure a disk group with logical volume manager, Application Agent can be used only when one or more physical volumes constitute one disk group. You cannot divide one physical group into multiple disk groups. The following figure shows examples of disk group configurations usable by Application Agent.
Figure 39 Data backup and restoration in a system configuration where multiple disk groups exist in a file system In this figure, disk groups DG01 and DG02 each of which consists of two physical volumes are configured. Three logical volumes are created on DG01 and one logical volume is created on DG02. Mount points D:, E:, and F:, are assigned to DG01 and mount point G: assigned to DG02.
Example: Restore only the file system created in disk group DG02 after backing up disk groups DG01 and DG02. PROMPT> drmfsrestore 0000000001 -resync -target G: KAVX0001-I The drmfsrestore command will now start. KAVX0019-I Copying file(s) now... KAVX0002-I The drmfsrestore command will now end. PROMPT> Precautions for volume configuration • You cannot use Application Agent in a configuration where a physical volume is divided into multiple disk groups using logical volume manager.
Figure 40 Configuration example of a mounted directory that becomes a backup target The following shows a configuration example of a mounted directory that does not become a backup target. When the configuration places a mount point directory on a directory below a volume, higher-level volumes that contain a volume that was mounted to a directory cannot be specified as a backup target.
uration for the logical volume manager and file system to the state that was in place at the time the backup was created, and then perform restoration. Note that if you perform restoration incorrectly, a system inconsistency might occur. To review the configuration that was in place at the time the backup was created, use the drmfscat, drmsqlcat, or drmexgcat command. For details about how to use these commands, see the HP StorageWorks P9000 Replication Manager Software CLI Reference Guide.
making it impossible for Application Agent to recognize the disk configuration correctly. If there is an application that is using the appropriate disk, an unexpected write error may occur. If Application Agent is unable to recognize the disk configuration correctly, restore the disk configuration in the following procedures. However, restoration of application data being executed when disk information is being rescanned is not guaranteed. 1.
Requirements and precautions when backing up file systems Using VSS This subsection explains requirements and precautions when using VSS to back up file systems. • RM Shadow Copy Provider must be installed both in the file server and backup server in advance. Note that, if RM Shadow Copy Provider has not been installed on those servers when Application Agent is installed, RM Shadow Copy Provider will be installed together with Application Agent.
Requirements and precautions when backing up SQL Server databases Application Agent supports the following SQL Server database products: • • • • • • SQL SQL SQL SQL SQL SQL Server Server Server Server Server Server 2005 Enterprise Edition 2005 Standard Edition 2005 Workgroup Edition 2008 Enterprise Edition 2008 Standard Edition 2008 Workgroup Edition The table below describes the types of data subject to backup in the SQL Server database.
Database subject to backup#1 Distribution database Type of file subject to backup Backup file name Storage destination for backup files Data file Same as the backup source file name Secondary volume Transaction log file Same as the backup source file name Secondary volume Metafile#2 Depends on the VDI metafile storage directory specified in the -drmsqlinit command#3 #1 When the -system option is not specified, only user databases are backed up.
• Backup for the transaction log cannot be executed during execution of the drmsqlinit command when there is no registered directory for storing the transaction log backup file. • If the system databases (master, model, and msdb) are to be backed up, specify, as the output destination for SQL Server error log files, a volume different than the one that contains the system databases. • Storetempdb in a volume other than the user database to be backed up.
Application Agent can back up only the database configuration files (the *.mdf and *.ndf data files and the *.ldf transaction log file) and metafiles. Metafiles are generated when the backup command is executed. For database configuration files that are not subject to backup and for general files, no freezing processing is executed.
When you back up to tape, you need to use FTP or a similar method to transfer the metafile created in the metafile storage directory in the database server to the backup server. In this situation, transfer the file in the directory using the same name as in the metafile storage directory in the backup server and allocate the same drive characters. Metafile allocation on the database server and the backup server is shown in the figure below.
Figure 45 Metafile allocation (in the cluster configuration) Using a dynamic disk configuration • Do not allocate a data file made up of multiple instances to a file system (drive) of a disk group subject to backup and restoration. • Allocate the following directories and files to a file system (drive) of a disk group different from the one to which data files (*.mdf and *.ndf) are allocated.
Using the Veritas Cluster Server for Windows configuration The file system that stores registry replication data should not be backed up by Application Agent. Make sure that you allocate such a file system to a disk group or physical disk that is not subject to backup.
• For online backup and VSS backup, data files (*.edb, *.stm) and checkpoint files (*.chk) cannot be allocated to the same volume. In Exchange Server 2010: • When you back up a database, you cannot put the transaction log file (*.log) on the same volume that holds a data file (*.edb). Data is restored in physical volumes units so you will not be able to perform a roll-forward restore operation if you put both the transaction log file and the database file on the same physical volume.
• In a cluster environment, when restoring data in a physical node different from that used during backup, an Exchange virtual server that uses the same shared disk as that used during backup must be running. Application Agent cannot restore data for an Exchange virtual server, such as one at a remote site, that uses a disk different from the one used during backup. Using VSS This section describes requirements and precautions used when VSS is used to back up an Exchange database.
• Set the environment of Application Agent to use VSS. For details on environment settings required to use VSS, see “Specifying settings for using VSS” on page 148. • The Information Stores of the storage group that are to be backed up must all be mounted in advance. • When Protection Manager version 4.4 or earlier is used to back up storage groups, the Information Stores of storage groups to be restored must all be mounted in advance. When Protection Manager version 5.
the approximate amount listed in the table only apply under certain conditions, and are not a guarantee product performance. Table 11 Approximate amount required to verify Exchange Server 2003 database for backup by using VSS System configuration for the database server Capacity of the data file (*.edb) Number of transaction log files (*.log) Amount of time required for database verification • CPU: Pentium 4 1.
Restoring backup data obtained using vss in units of Information Stores When using Exchange Server 2003 and Exchange Server 2007, you can restore backup data obtained using VSS in units of Information Stores (in units of *.edb and *.stm data files). Restoring backup data in units of Information Stores makes it possible to quickly restore just the required data files. To restore backup data in units of Information Stores, you must partition the disk into units of data to be restored.
Figure 46 Restoration in units of Information Stores (when the backup target is an Exchange database) In the above example, Information Stores from IS11 to IS14 belong to the storage group SG1.
• The recovery storage groups for Exchange Server 2003 cannot be backed up. Allocate files and folders that comprise a recovery storage group to a file system (drive or mount point directory) of a disk group different from a storage group subject to backup. • Dynamic disks cannot be used in Exchange Server 2007 or Exchange Server 2010, in which VSS is necessary for backup processing, because dynamic disks do not support the use of VSS.
• You must create a definition file for the cascade configuration. For details about creating a definition file for the cascade configuration, see “Creating a cascade configuration definition file for Exchange database backup” on page 152. • You must store the dictionary map files and backup catalog on different disks at both the local and remote sites. These disks must be accessible regardless of whether the virtual server is online or offline.
If you use the automatic seed function, all seed processing is performed automatically during restoration. If you do not use this function, you must manually perform seed processing for each storage group. If an error occurs during restoration using the automatic seed function, you must manually perform seed processing on the storage group that resulted in the seed processing error. The following describes how to perform manual seed processing: • Stop the replication function.
• Gigabit Ethernet is employed for the network that is used for seed processing. • The CPU and disks have sufficient performance. Note that depending on CPU or disk performance, the actual processing time might be shorter than the result calculated by the following formula. The calculation result should be used for estimation, and it does not guarantee the product performance.
• Even when you execute seed processing after performing a point-in-time restore operation, the copy queue length might not be 0. To switch over mailbox database copies in this state, use Exchange Management Shell.
3 Preparation for using Application Agent This chapter explains the flow of environment setup required for using Application Agent, and gives details on each step in the environment setup. The descriptions in this chapter apply to the Application Agent CLI. Setting up an environment for Application Agent Table 4-1 shows the procedures for setting up an environment for Application Agent and the tasks required for each server.
Environment setup task File server or database server Backup server File name Sections and documents for reference Specify settings for linkage with RAID Manager. Needed Needed RAID Manager-linkage definition file DEFAULT.dat Application AgentSetting up Application Agent for linkage with RAID Manager, page 118 Create dictionary map files. Needed Needed -- Creating dictionary map files, page 132 Cluster information configuration definition file (cluster-name.
Environment setup task File server or database server Backup server Sections and documents for reference File name Configuration definition file for tape backup Specify settings for batch operations. Needed Needed Update the dictionary map files. Needed Needed#4 Creating a list file, page 161 Any file -- Updating a dictionary map file, page 165 -- Preparations required before executing extended commands, page 181 Perform preparation for executing extended commands.
Setting up RAID Manager To back up data by using Application Agent, you need to create a RAID Manager configuration definition file (horcmn.conf, when n is the instance number) for each instance, to match the intended usage. The location of the RAID Manager configuration definition file (horcmn.conf) is as follows: In Windows Server 2003 or Windows Server 2008: system-drive\Windows Note Do not specify a path to the configuration definition file in the HORCM_CONF environment variable.
Backing up one primary volume to multiple generations This subsection describes the configuration in which one primary volume is to be backed up to multiple generations. This configuration is used when, for example, all the files and databases to be backed up are stored in one volume and multiple backup generations are obtained at set time intervals. To back up one primary volume to multiple generations: 1. 2. Define the given primary volume and a secondary volume pair from each generation.
Figure 48 Volume configuration and configuration definition to back up multiple primary volumes to a single generation Backing up multiple primary volumes to multiple generations This subsection describes the configuration in which multiple primary volumes are to be backed up to multiple generations.
Figure 49 Volume configuration and configuration definition to back up multiple primary volumes to multiple generations Backup or restore between storage systems Application Agent allows you to backup or restore with mixed volume replication functionalities between storage systems such as Business Copy and Continuous Access Software or Continuous Access Journal. In this case, setup to enable a remote copy is required in the RAID Manager configuration definition file (horcmn.conf).
Figure 50 Example of a configuration definition for backup or restore between storage systems The following shows an example of the RAID Manager configuration definition file for a database server Host0 in the local site in the above configuration example. In this example, multiple secondary volumes are allocated to one primary volume, and a separate configuration definition file is created for each backup target server. • RAID Manager configuration definition file (horcm0.
• RAID Manager configuration definition file (horcm1.conf) HORCM_DEV ##dev_group Cnt Ac01 Cnt Ac01 HORCM_INST ##dev_group Cnt Ac01 dev_name DEV31 DEV32 port# TargetID CL2-C 8 CL2-C 8 ip_address Host2 LU# MU# 6 7 service 12502/udp • RAID Manager configuration definition file (horcm2.
than one volume. You need to take this into consideration when specifying the RAID Manager configuration definition file. The following shows an example of coding in a configuration definition file for a multi-target configuration and cascade configuration. Figure 51 Configuration definition for a multi-target configuration and a cascade configuration Setting up operation of Application Agent Application Agent operation settings are specified in the Application Agent configuration definition file (init.
checking the status of the cluster resource, change the following parameters. In a non-cluster environment, these parameter must not be changed. Leave the default settings as is. Table 16 Parameters in init.conf (to set the retry count and retry interval for checking the status of cluster resources) Parameter Specifiable values (default) Description • In this parameter, specify the maximum retry count for checking the status of cluster resources. Generally, specify a value other than 0.
the service, it checks the active/inactive status of the process. You can change the retry count and retry interval for checking the status of a process by using the following parameters. In a cluster environment, you do not need to change this parameter because Application Agent does not reference this parameter. Table 18 Parameters in init.
Parameter Description COM_RETRY_WAIT For this parameter, specify the same number of seconds as the retry interval for checking the command status. Specifiable values (default) 0 to 3600 (10) Setting up the backup option for SQL Server database backup To shorten the time required for backup when the drmsqlbackup command is executed, you can skip the confirmation of the SQL Server database status. If you want to shorten the time required for backup, specify the following parameter.
Setting up the dictionary map synchronization option for SQL Server database backup If you specify that the dictionary map should be updated asynchronously, you can shorten the time required for backup command execution. If you want to shorten the time for backup command execution, specify the following parameter.
Setting up restoration while cluster resources are online In a cluster environment using MSCS, you can use the following parameter to specify whether to enable restoration while the cluster resources are in the online state. Table 23 Parameter in init.
that restoration is performed while the cluster resources are in the offline state. If you are using VCS as the cluster software, restoration will be performed while the cluster resources are in the offline state. The following table shows the cluster resource status when the backup is of an SQL Server database.
you are using Veritas Cluster Server as the cluster software, restoration will be performed while the cluster resources are in the offline state. The following table shows the cluster resource status when the backup is of an Exchange database.
Setting communication timeout periods for the Protection Manager service When an Exchange database is being backed up, you can specify the communication timeout period for the Protection Manager service, using the following parameter. Table 29 Parameter in init.conf (setting the communication timeout period for the Protection Manager service) Parameter SERVICE_TIMEOUT Description Default (specifiable value) Specify a number of minutes for the Protection Manager service communication timeout period.
• To utilize, for example, the volume replication function within the storage system when the RAID Manager instance for managing the primary volumes and the RAID Manager instance for managing the secondary volumes are on the same server, specify the instance numbers as indicated below: • Specify both HORCMINST and HORCMINST_AUX. For instance numbers to specify for HORCMINST and HORCMINST_AUX, see Table 30.
Even when multiple HORCMINST parameters are specified, if a RAID Manager instance number is specified in the DRM_HORCMINST environment variable, only the RAID Manager instance specified by the environment variable is used. #3 Even when multiple HORCMINST_AUX parameters are specified, if a RAID Manager instance number is specified in the DRM_HORCMINST_AUX environment variable, only the RAID Manager instance specified by the environment variable is used.
• A RAID Manager instance (instance number: 1) has already been activated on the file/database server. • A RAID Manager instance (instance number: 2) has already been activated on the backup server. • RAID Manager configuration definition files (horcm1.conf and horcm2.conf) have already been created on the file/database server and on the backup server. In this example, the parameters are specified as follows: • In the RAID Manager-linkage definition file (DEFAULT.
amounts between the primary and secondary volumes. See the following table to set the appropriate value: Table 32 Values in the RETRY_WAIT parameter set for each storage system storage system Description Recommended value (Units: seconds) For a pair status to change, a wait time of at least one second is needed. 1 XP1024/XP128 series XP12000/XP10000/SVS200 HP XP24000 HP XP20000 Depending on the purpose of the processing, you can set the retry count and retry interval for checking the pair status.
Parameter Specifiable values (default) Description Specifies the retry interval (in 10 milliseconds) for checking the completion of pair resynchronization. Specify this parameter to check the pair status to make sure that backup processing or resynchronization finishes (the completion of paircreate#1 or pairresync).
Parameter Description Specifiable values (default) Specifies the maximum number of times a retry can be performed for checking whether resynchronization on restoration has finished. RESTORE_RETRY_TIME If you specify 0, Application Agent continues to retry checking until it succeeds in checking the pair status. When adding this parameter, make sure that the product of the RESTORE_RETRY_TIME-value and RESTORE_RETRY_WAIT-value is sufficiently larger than the time required to complete resynchronization.
Specifiable values (default) Parameter Description RESTORE_DELAY_RETRY_WAIT Specify the interval between retries that will be performed to confirm whether the volume is ready for resynchronization. This value must be specified in units of 10 milliseconds. You need to specify this parameter if you want to check whether the pair status allows execution of pairresync -restore for restoration.
Parameter Specifiable values (default) Description Specifies the retry interval for checking the pair status when the RAID Manager command returns a busy status. You can specify a value in units of 10 milliseconds. Specify this parameter to check the pair status if the RAID Manager command returns a busy status.
Parameter Description Specifiable values RETRY_WAIT In this parameter, specify the same number of seconds as the retry interval for checking the status of a pair. 0 to 3600 RESYNC_RETRY_TIME Specifies the maximum number of retries for checking the completion of pair resynchronization. 0 to 3600 RESYNC_RETRY_WAIT Specifies the retry interval for checking the completion of pair resynchronization (in units of 10 milliseconds).
Parameter Description Specifiable values RESTORE_DELAY_RETRY_WAIT Specify the interval between retries that will be performed to confirm whether the volume is ready for resynchronization. This value must be specified in units of 10 milliseconds. You need to specify this parameter if you want to check whether the pair status allows execution of pairresync -restore for restoration.
When you execute a command, you can use the DRM_COPY_SIZE environment variable to change the track size. The change is also applied to the COPY_SIZE parameter.
When you use SnapShot in XP12000/XP10000/SVS200, HP XP24000, or HP XP20000 and pair creation is executed automatically because PAIR_CREATE=ENABLE is specified in the RAID Manager-linkage definition file (DEFAULT.dat), there must be a pool area whose pool ID is 0.
In a remote copy backup session, a generation number (MU#s) that does not always refer to the same generation causes an error regardless of this parameter definition. Table 39 Parameter in the RAID Manager-linkage definition file (default.
If RAID Manager is to be installed on the same drive as Application Agent, the installation path for RAID Manager is set automatically when Application Agent is installed. Table 40 Parameter in the RAID Manager-linkage definition file (DEFAULT.dat) (specifying the installation path for RAID Manager) Parameter Description Default INSTALLPATH If RAID Manager is to be installed on a different drive than Application Agent, specify the installation destination for RAID Manager.
Note Unnecessary dictionary map files may remain after the uninstallation of an old version of Application Agent. If they do, remove the previous dictionary map files and then create new files. This subsection describes the procedure for creating dictionary map files for different system configurations.
Figure 53 Example of creating dictionary map files in an Active-Passive cluster configuration To create dictionary map files in an Active-Passive cluster configuration: 1. Change the locations of the dictionary map files and backup catalog. In the init.conf configuration definition files of Application Agent on the active and standby servers respectively, add the DRM_DB_PATH=directory-on-the-shared-disk;virtual-server-name entry.
2. Place the dictionary map files and backup catalog on the shared disk. Execute the drmdbsetup utility on the active server. You do not need to execute the utility on the standby server by switching the cluster. Before you execute the drmdbsetup utility, you must set the virtual server name in the DRM_HOSTNAME environment variable.
Figure 54 Example of creating dictionary map files in an Active-Active cluster configuration To create dictionary map files in an Active-Active cluster configuration: 136 Preparation for using Application Agent
1. Set the locations of the dictionary map files and backup catalog. In the init.conf configuration definition files of Application Agent on the active and standby servers respectively, add a DRM_DB_PATH=directory-in-shared-disk;virtual-server-name entry for each virtual server. When editing the files, note the following points: • Add the entry to the last line of the init.conf file. • In directory-in-shared-disk, specify a cluster resource of virtual-server-name.
3. When Veritas Cluster Server is used, execute the drmclusinit command to register cluster resource information. For details, see “Creating a cluster information configuration definition file when using Veritas cluster server” on page 140. Creation in a cascade configuration for Exchange database backup To back up an Exchange database in a cascade configuration, you must create dictionary map files in an arbitrary directory at both the local and remote sites.
• How to create a cluster information configuration definition file (when Veritas Cluster Server is used) A cluster information configuration definition file needs to be created only when Veritas Cluster Server is used as the cluster software. If you are using Microsoft Cluster Service, you do not need to create a cluster information configuration definition file.
Figure 55 Cluster group definition (when a backup target and shared disks are in the same cluster group) Creating a cluster information configuration definition file when using Veritas cluster server When you are using Veritas Cluster Server, execute the drmclusinit command on the database or file server to register cluster resource information.
2. Register the following items according to the output messages: Table 43 Parameters for the Cluster software Entry name Explanation Virtual server name (required) Enter the virtual server name to be managed by the cluster software. Resource group name (required) Enter the service group name. • When the backup is of a file system: Enter a hyphen (-). Name of the instance or application to be backed up (required) • When the backup is of an SQL Server database: Enter the SQL instance name.
• Execute the drmclusinit command on both the active server and standby server. • The resource information to be registered by using the drmclusinit command must exactly match the information registered in the cluster software. • The virtual server name to be registered by using the drmclusinit command must satisfy the following conditions: - The specified virtual server name is the same as VirtualName in the Lanman resource of Veritas Cluster Server.
• • • • Storage directory for the VDI metafiles VDI generation timeout period Storage directory for the UNDO log files Storage directory for the backup files (for transaction logs) For details on the SQL Server database information to be registered, see the description of the drmsqlinit command in the manual HP StorageWorks P9000 Replication Manager Software CLI Reference Guide.
4. Check the registration. To check your registration, execute the drmsqlinit command with the -v option specified: PROMPT> drmsqlinit -v instance-name Notes • If your system is in a cluster configuration. or if you use Continuous Access Software or Continuous Access Journal functionality, you need to execute the drmsqlinit command on each server. • Execute the drmsqlinit command after setting up the SQL Server instance.
Specify this option if the command that operates the SQL Server database terminates with an error due to an SQL Server login request timeout (error message: KAVX1008-E, detailed message DRM11013, Code: 0). You can use the SQL_LOGIN_TIMEOUT parameter to specify the SQL Server login timeout option in sqlinit_instance-name.conf. A login request timeout is likely to occur in environments with high network loads, which may result from a large-scale database.
Restored object S U Restoration type SQL Server automatic recovery processing Parameter specification Restoration while the cluster resources are online Not performed Not needed -- Not performed Not needed Restoration while the cluster resources are offline Performed Needed# Restoration while the cluster resources are online Not performed Not needed -- Not performed Not needed System configuration Non-cluster Cluster -- Yes (partial) Non-cluster Legend Yes: Can be restored --: Not a
2. Specify the parameter in the sqlinit_instance-name.conf file. Write the parameter starting from the far left, without spaces. Delimit the parameter name and timeout value by an equal sign (=), and do not enter space or tab characters before or after the equal sign. Lines beginning with # are assumed to be comment lines. If a parameter is specified two or more times, the earliest value written is effective. • To specify the SQL Server login timeout option Add the SQL_LOGIN_TIMEOUT=login-timeout-value.
Specifying settings for using VSS If you want to use VSS to perform an online backup of a file system or an Exchange database, the following settings are required: • The Application Agent and RAID Manager environments must be set up so that Application Agent can perform VSS backups. Moreover, it is necessary to create a pair before backup. When creating a pair, specify the -m noread option in the paircreate command.
Application-Agent-installation-directory\conf Table 48 vsscom.conf Parameters Parameter Description Values that can be set BACKUP_SERVER Specifies the host name or IP address of the backup server. 1 to 256 one-byte characters Specifies the number of times backup is retried if a Writer timeout occurs during backup. If 0 is specified, backup is not retried. The retry count should be increased in the following cases: WRITER_TIMEOUT_RETRY_COUNT • The error message KAVX5004-E appears during backup.
• If you plan to back up Exchange databases, install Exchange Management Console on the backup server. If Exchange Server 2003 is used, also install the ESEUTIL command. You do not need to install the USEUTIL command if you are using Exchange Server 2007 or Exchange Server 2010. Installing Exchange Management Console Install Exchange Management Console on the backup server.
• Set system environment variables for the backup server, as shown in the table below. Table 50 System environment variables required to use VSS (backupserver) System environment variable Description VSHTCHORCMINST_REMOTE Specifies the instance number of the RAID Manager that manages the secondary volume used in VSS backup. The specified value must be specified in the HORCMINST parameter of the RAID Managerlinkage definition file (DEFAULT.dat).
• When you use VSS in a cluster environment, define the primary volume to be used in all virtual servers in a single RAID Manager instance, and use the same instance number on all physical nodes. Creating a cascade configuration definition file for Exchange database backup To back up an Exchange database in a cascade configuration, you must edit the definition file for the cascade configuration on the database server.
#1 Parameter Description #2 Maximum character length Omission Specify the number of the RAID Manager instance that is managing Remote Copy in the cascade configuration. INSTANCE_NUMBER COPY_GROUP_NUM All of the Remote Copy copy groups must be managed by this instance. If you are using VSS to perform the backup, the instance specified in this parameter must be the same as the instance that is being managed by Application Agent. Enter the number of Remote Copy copy groups in the cascade configuration.
#1 Parameter Description #2 Maximum character length Omission Specify the timeout value for the pair resynchronization processing at the remote site as a value between 0 and 86400 (in seconds). If you specify 0, this processing does not time out. If you omit this specification, 3600 is assumed. PRESPLIT_TIMEOUT Only parameter values in sections that are considered to be for the remote site are used. As a rule, set this value to roughly 1.
The following table provides details about the handling of the backup command's -cascade option and sections. Table 54 How the -cascade option and the sections are evaluated Local site Remote site Option Database server -cascade When the server specified in the DB_SERVER parameter is evaluated as being the local server, the values in that section are used. Backup server Database server Backup server The value specified for the BK_SERVER parameter defined in the section described to the left is used.
2. When the following message appears, enter the name of the tape backup management software. KAVX0411-I Enter the backup management product name. Enter one of the following values: If you are using NetBackup: NBU If you are using Backup Exec: BEWS 3. When the following message appears, enter the number of backup catalog storage days. KAVX0417-I Enter the number of days to store the backup catalog. For details on the value to be specified, see the notes at the end of this procedure. 4.
Application-Agent-installation-directory\conf\tape\NBU_sample.dat • Backup Exec Application-Agent-installation-directory\conf\tape\BEWS_sample.dat Configuration parameters The parameters in the configuration definition file for tape backup are in the order indicated in the table below.
Parameter Description Specify the absolute path of the mount point of the volume to be backed up (use a maximum of 255 bytes). If no entry for the mount point to be backed up can be found, values specified for CLASS or POLICY and for SCHEDULE under "MOUNT_POINT=default" will be used. Specify the mount point in the tape backup configuration definition file in the order in which Application Agent automatically mounts them during a tape backup.
Parameter Description Specify the absolute path of the mount point of the volume to be backed up (use a maximum of 255 bytes). If no entry for the mount point to be backed up can be found, a value specified for SCRIPT_FILE under "MOUNT_POINT=default" will be used. If the value of this parameter is set to default, the value specified by SCRIPT_FILE will be used for all directories. Specify the mount point to be mounted during a tape backup.
PATH1= SUBDIRS1= Parameters other than INST_PATH, NBU_MASTER_SERVER, INCLUDE_EXEC, and PARALLEL_COUNT can be specified multiple times for a mount point. However, note the following: • Always leave the line before the MOUNT_POINT line blank. • Specify the configuration definition parameters in the order listed in the table above. • When entering default ("default" must be lowercase) for MOUNT_POINT, the entry must come after all the other entries.
User-defined configuration definition file When you execute the drmmediabackup command or the drmmediarestore command with the -bup_env option (that is, when specifying a specific configuration definition file for each command), make sure that you create the corresponding configuration definition file in advance. When you execute the drmmediabackup or drmmediarestore command without the -bup_env option, do not delete the default configuration definition file.
• File name You can use alphanumeric characters to specify any name. • File storage location This file can be stored in any location. In a cluster environment, however, this file should be stored in a shared directory that can be accessed from both servers. • Contents of a file Specify copy group names, following the rules listed below: Write each copy group name from the leftmost column. Copy group names are case-sensitive. A line beginning with a number sign (#) is handled as a comment line.
• drmsqllogbackup File name of the list file Use alphanumeric characters to specify the file name. List file storage location List files are stored in the following locations: • For a database list file: This file can be stored in any location. However, in a cluster environment, HP recommends that you store this file in a shared directory that can be accessed from both servers.
In a cluster environment, however, this file should be stored in a shared directory that can be accessed from both servers. Contents of the transaction log list file The contents of the file must follow these coding rules: • • • • • • • Enter the name of the database, followed by the name of the transaction log file. Enclose the name of the database in square brackets "[" and "]". Enter the transaction log files for each database in the order in which they are to be applied.
Updating a dictionary map file After environment setup is complete, the next step is to update the dictionary map files. By updating the dictionary map files, you can confirm that the environment has been set up appropriately. To update the dictionary map files: • When the backup is of a file system: Execute the drmfsdisplay command with the -refresh option specified. • When the backup is of an SQL Server database: Execute the drmsqldisplay command with the -refresh option specified.
You can create a copy group mount definition file even if the configuration is other than the above. If a copy group mount definition file does not exist, Application Agent determines a mount point automatically. Once you create a copy group mount definition file, you can perform the following operations: • You can mount the secondary volume to a specified mount point.
1. Conceal all secondary volumes from the backup server. To conceal all secondary volumes from the backup server, execute the drmdevctl command on the backup server. BKServer > drmdevctl -detach BKServer > 2. Use the Windows disk management functionality or a RAID Manager command to confirm that the secondary volumes are concealed. The following example, uses the inqraid command of RAID Manager: BKServer >echo hd0-1 | inqraid -CLI DEVICE_FILE PORT SERIAL LDEV CTG Harddisk0 Harddisk1 BKServer > 3.
4. Confirm that backup catalogs have been created for all generations. To confirm that the backup catalogs are created for all generations, on the file server or database server execute a command to display backup information (drmfscat command, drmsqlcat command, or drmexgcat command). The number of backup information items should match the number of generations. When the backup is of a file system: FSServer > drmfscat mp_on_dg01.dat INSTANCE: mp_on_dg01.
START-TIME: 2004/12/15 10:20:00 END-TIME: 2004/12/15 10:23:00 HOSTNAME: DB_SVR1 : : When the backup is of an Exchange database: DBServer > drmexgcat STORAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: ONLINE STORAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2004/12/15 10:00:00 END-TIME: 2004/12/15 10:01:00 HOSTNAME:EXG_SRV1 : : STORAGEGROUP: STR1 BACKUP-ID:0000000002 BACKUP-MODE: ONLINE STORAGEGROUP: STR1 ORIGINAL-ID:0000000002 START-TIME:2004/12/15 10:10:00 END-TIME: 2004/12/15 10:11:00 HOSTNAME:EXG_SR
6. Transfer exported backup catalog information from the file server or database server to the backup server. Transfer the temporary file exported from the file server or the database server to the backup server. To transfer, execute the ftp (file transfer protocol) command. In the following example, the FTP root folder is assumed to be C:\FTP_ROOT: FSServer> ftp backup-server-name ftp> Username: (Enter the login name) ftp> password: (Enter the password) ftp> binary ftp> put C:\tmp\0000000001.
9. Unmount the secondary volume. To unmount the secondary volume on the backup server, execute the drmumount command. The secondary volume becomes concealed as the drmumount command is executed. BKServer > drmumount 0000000001 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished. Mount point = X: KAVX0002-I The drmumount command will now end. 10.
11. Check the contents of the created copy group mount definition file. The created copy group mount definition file is stored in the Application-Agent-installation-directory\conf\vm. Use a text editor to open the created copy group mount definition file, and check the contents of the file. Change the FS values (mount point of the mount target) as necessary. If you do not create a copy group mount definition file, this step is not necessary.
#configuration file for copy-group mounting [CG_DEF] COPY-GROUP-NUM=6 COPY-GROUP=Grp1,dev11 BUID=0000000001 DATETIME=20041201123456 COPY-GROUP=Grp1,dev12 BUID=0000000001 DATETIME=20041201123456 COPY-GROUP=Grp2,dev21 BUID=0000000002 DATETIME=20041201123456 COPY-GROUP=Grp2,dev22 BUID=0000000002 DATETIME=20041201123456 COPY-GROUP=Grp3,dev31 BUID=0000000001 DATETIME=20041201123456 COPY-GROUP=Grp3,dev32 BUID=0000000003 DATETIME=20041201123456 [DG_DEF] DISK-GROUP-NUM=2 BUID=0000000001 DATETIME=20041123225248 COPY
COPY-GROUP-NUM=2 COPY-GROUP=Grp3,dev31 COPY-GROUP=Grp3,dev32 P-DG=DG01 S-DG=DG01 FS-NUM=3 LVM-DEVICE=\Device\HarddiskDmVolumes\Dg01\Volume1 LABEL=Volume1 FS=X: LVM-DEVICE=\Device\HarddiskDmVolumes\Dg01\Volume2 LABEL=Volume2 FS=Y: LVM-DEVICE=\Device\HarddiskDmVolumes\Dg01\Volume3 LABEL=Volume3 FS=Z: 12. Execute the drmdevctl command to conceal all secondary volumes from the backup server. To perform a backup or restore, conceal all secondary volumes from the backup server.
2. Confirm that a backup catalog has been created. To confirm that the backup catalog has been created, execute a command (drmfscat, drmsqlcat, or drmexgcat) to display backup information on the file server or database server. When the backup is of a file system: FSServer > drmfscat mp_on_dg01.dat INSTANCE: mp_on_dg01.dat BACKUP-ID:0000000001 BACKUP-MODE: COLD INSTANCE: mp_on_dg01.
4. Transfer the backup catalog information exported from the file server or the database server to a backup server. Transfer the temporary file exported from the file server or the database server to the backup server. To transfer, execute the ftp (file transfer protocol) command. In this case, set the FTP route folder C:\FTP_ROOT. FSServer> ftp backup-server-name ftp> Username: (Enter the login name) ftp> password: (Enter the password) ftp> binary ftp> put C:\tmp\0000000001.drm ftp> quit FSServer> 5.
7. Create a copy group mount definition file. To create a copy group mount definition file, on the backup server execute the drmmount command with the backup ID and -conf option specified. If you do not create a copy group mount definition file, execute the drmmount command without the -conf option specified to confirm that a mount operation can be performed. BKServer > drmmount 0000000001 -conf KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start.
9. Check the contents of the created copy group mount definition file. Use a text editor to open the created copy group mount definition file, and check the contents of the file. Change the FS value (mount point of the mount destination) as necessary. If you do not create a copy group mount definition file, this step is not necessary.
Determination of a mount point The following table describes how Application Agent determines a mount point when executing the command for mounting a second volume. The following explains separately when the command is executed with a backup ID specified in the option, and when the command is executed with a copy group specified in the option.
The system uses a mount point specified in FS=mountpoint that corresponds to a copy group to be backed up, in the copy group mount definition file.
If you specify an absolute path that begins with the drive letter as a mount point directory name in the -mount_pt option, the mount point should be absolute-path-specified-as-a-mount-pointdirectory-name\mount-point-in-the-copy-group-mount-definition-file For example, when W:\ is specified in the -mount_pt option and FS=D:\ is specified in the copy group mount definition file, the system mounts the unoccupied drives from the W drive.
File server or database server Tasks Backup server Location in this manual Specify how the extended commands are to be started. Needed Needed Specifying how to start the extended commands, page 184 Create host environment settings files.
Execution permissions for extended commands To execute the extended commands, you need system administrator permissions. Make sure that you have these permissions. Automatic execution of extended commands A backup or restoration process that uses extended commands may be performed across more than one server. It is difficult to execute extended commands at each of physically remote servers. Therefore, you need to perform remote execution of the extended commands.
3. Delete the operation-ID directory created in the script_work directory in the same level of the directory that you checked in step 2. (Perform the following steps on the backup server:) 1. Confirm the name of the temporary directory for extended commands. Check whether FTP_HOME_DIR-value\FTP_SUB_DIR-value exists. 2. Delete the operation-ID directory created in the directory that you checked in step 1.
Creating a host environment settings file Host environment settings files are created depending on the configuration of the system using extended commands. These files must be located on each server. The host environment settings file is created automatically during installation. Check the contents of the file as necessary. The host environment settings file is created in the following location: Application-Agent-installation-directory\script\conf\host.
On the backup server: EX_DRM_HOST_DEF_CHECK -bk -f host-environment-settings-file If an error is found, revise the contents of the file, and then re-execute the check tool. Creating operation IDs An operation ID is a unique character string given to each resource that is to be the processing target of an extended command. You must define beforehand the information that the extended command will reference during execution in the operation definition file.
After storing the operation definition file in the stipulated directory, execute the check tool for operation definition files to check the content of the operation definition file and automatically create a temporary directory for extended commands. Deployment of operation definition files Create two same operation definition files for each target mount point or file. Place one operation definition file on the file server and the other on the backup server.
The following table shows the entries of an operation definition file, their contents, and the maximum value length (in bytes). Specification of these entries is required. Table 62 Example: contents and maximum value length of each entry in an operation definition file (when the backup is of a file system) Maximum number of characters Specification item Information to be specified BACKUP_OBJECT Specify a character string identifying the type of the backup object. Specify FILESYSTEM.
Example of creating operation definition files (in a cluster configuration) The following is an example of creating an operation definition file when the file server is a cluster system. This example assumes the system configuration shown in Figure 4-11. The following prerequisites apply to this example: • There are two file servers and a backup server to which a tape device is connected.
Operation ID Target file server name Target mount point or file Operation_B VServer_C Mount point directories specified in app.txt (M: and N:) To create an operation definition file for a cluster configuration: 1. Create an operation definition file on the active server (file server A), and then set the required items. Create the following two files. Application-Agent-installation-directory\script\conf\_Operation_A.dat Application-Agent-installation-directory\script\conf\_Operation_B.
4. On the backup server, execute EX_DRM_FS_DEF_CHECK, which is a check tool for operation definition files. EX_DRM_FS_DEF_CHECK operation-ID -bk The operation definition file is checked. In addition, a temporary directory for extended commands is automatically created. If an error occurs, change the backup server configuration depending on the contents of the operation definition file, or change the contents of the operation definition file depending on the backup server configuration.
Figure 57 Example of locations of operation definition files (when the backup is of an SQL Server database) In this example, the virtual server (server name: VServer_C) is running on the database server A (server name: DBServer_A) and the database server B (server name: DBServer_B), which make up a cluster. The SQL Server instance INSTANCE_1 exists on the databases A and B, and the virtual server C has been defined as a cluster resource.
Maximum number of characters Specification item Information to be specified DB_SERVER_NAME Specify the database server name. In a cluster configuration, specify the name of the virtual server that corresponds to the cluster resource. This virtual server name must be defined in DRM_DB_PATH=directory-on-the-shared-disk;virtual-server-name in the Application Agent configuration definition file (init.conf). 128 This entry specifies an SQL Server instance name.
Example of creating operation definition files The following gives an example of creating operation definition files for a system that has a cluster configuration. This example assumes the following conditions: • The virtual server (server name: VServer_C) is running on the database server A (server name: DBServer_A) and the database server B (server name: DBServer_B), which make up the cluster.
In this example, you create an operation definition file for each of the operation IDs listed in the following table. Table 68 Operation IDs for which to create operation definition files (when the backup is of an SQL Server and in a cluster configuration) Operation ID Target database server Target instance and database Operation_A VServer_C Entire INSTANCE_1 To create operation definition files (in a cluster configuration): 1.
4. On the backup server, execute EX_DRM_SQL_DEF_CHECK, which is a check tool for operation definition files. EX_DRM_SQL_DEF_CHECK operation-ID -bk The operation definition file is checked. In addition, a temporary directory for extended commands or VDI metafile storage directory is automatically created.
Figure 58 Example of locations of operation definition files (when the backup is of an Exchange database) In this example, the virtual server (server name: VServer_C) is running on the database server A (server name: DBServer_A) and the database server B (server name: DBServer_B), which make up the cluster. The storage group STORAGE_1 exists on the databases A and B, and the virtual server C has been defined as a cluster resource.
Maximum number of characters Specification item Information to be specified DB_SERVER_NAME Specify the database server name. In a cluster configuration, specify the name of the virtual server that corresponds to the cluster resource. This virtual server name must be defined in DRM_DB_PATH=directory-on-the-shared-disk;virtual-server-name in the Application Agent configuration definition file (init.conf)#1. 63 INSTANCE_NAME Enter a hyphen (-).
server is Exchange Server 2003 Enterprise Edition or Exchange Server 2007, do not specify a recovery storage group. If the server is Exchange Server 2010, do not specify a recovery database. #3 The specified subdirectory must satisfy the following: • The subdirectory name must not contain a delimiter character (\). • The subdirectory name must not be specified as only one period (.) or two periods (..). • The root directory must not be specified.
This example creates operation definition files corresponding to the operation IDs listed in the following table. Table 71 Operation IDs for which an operation definition file is created (when the backup is of an Exchange database and in a cluster configuration) Operation ID Virtual server Target storage group Operation_A VServer_C STORAGE_1 To create an operation definition file for a cluster configuration: 1.
4. On the backup server, execute EX_DRM_EXG_DEF_CHECK, which is a check tool for operation definition files. EX_DRM_EXG_DEF_CHECK operation-ID -bk The operation definition file is checked. In addition, a temporary directory for extended commands is automatically created. If an error occurs, change the backup server configuration depending on the contents of the operation definition file, or change the contents of the operation definition file depending on the backup server configuration.
For example, if the dictionary map file directory is L:\PTM, the temporary directory name is L:\ script_work\operation-ID\DB. Temporary files created during execution of the extended command: • Backup ID record file • Backup information file • SQL Server's metafile (When the backup is of an SQL Server database) CheckingChecking the copy-group list file Certain extended commands allow you to specify a copy-group list file as an option value.
Creating a user script By specifying a user script when executing the backup command, you can simplify the backup operation because the commands specified in the user script will execute during the backup operation. You can enter the desired commands in a user script according to the coding rules for scripts. A user script file is a file that contains user scripts.
Applicable items Rules • The value of an item must be specified after the one-byte equal sign (=) that follows the item name. Do not enter a linefeed code between an item's name and value. Item values • The item value begins after the one-byte equal sign (=) that follows the item name and ends at the linefeed code. • If an item name is specified alone (without a value), an error results. • A line that begins with a one-byte hash mark (#) is regarded as a comment line.
Entry name Meaning and specifiable values Multiple specification#1 [SPLIT_PROC]#2, User processing section: Indicates the beginning of the "user processing for pair splitting". In this section, define commands to be executed as part of user processing for pair splitting. Not allowed Allowed#3 User processing section: Indicates the beginning of the "user processing for termination". In this section, define commands to be executed as part of user processing for termination.
Entry name Meaning and specifiable values Multiple specification#1 Omission Not allowed Not allowed Specifies a command line to be executed. • If you want to specify an option, separate the command name and the option with a one-byte space character. • One command definition section must contain only one command line. • A maximum of 2048 characters can be specified on a command line.#6 • A path or file name containing one or more spaces must be enclosed in double quotation marks (").
Entry name Meaning and specifiable values Multiple specification#1 Omission Allowed#4 Allowed Not allowed Allowed Specifies the environment variables to be applied for execution of the specified command. • Only one environment variable is allowed per line. • The name and value of an environment variable must be separated by a one-byte equal sign (=). • One environment variable definition can consist of up to 2048 characters.
Entry name Meaning and specifiable values Multiple specification#1 Omission Not allowed Allowed Not allowed Allowed Not allowed Allowed Specifies the command timeout value. Specifiable values are as follows: Timeout value (in seconds)#8 • The range of specifiable values is from 0 to 86400. • Use one-byte numeric characters only. • No timeout will occur if 0 is specified here. TIMEOUT#5 NOWAIT Once a command starts successfully, there is no wait for the command to finish.
#1 "Multiple specification is not allowed" means that multiple entries cannot be specified in the command definition section (CMD). #2 The [PRE_PROC], [RESYNC_PROC], [SPLIT_PROC], [FINISH_PROC], and [POST_PROC] can be defined in any order. #3 This item can be omitted if there is no command to be executed within the user processing section. #4 This item can be used more than once within a user script file.
Script environment variables The table below shows the Application Agent script environment variables that can be referenced by commands in the user post-processing section. These script environment variables can be referenced from the local server and the backup server. Table 78 Script environment variables Environment variable Description Remarks This environment variable is valid in the following cases: DRMENV_L_BACKUPID Backup ID of local server • The command is being executed in the local server.
Do not specify a command that is not listed. Doing so might prevent the system from running normally.
Examples of user script usage The following table provides references to the sections in which examples of user script usage are explained.
Parameter SMTP_SERVER Description Specifies the host name or IP address of the SMTP server to be used for sending the e-mail. The IP address can be specified in either IPv4 format or IPv6 format. Default (value after installation) mailserver Specify as a string of up to 64 one-byte characters. Specifies an e-mail send destination address. TO Specify as a string of up to 255 one-byte characters.
Application Agent message: Hostname=flora1 DRM_HOSTNAME=ExchangeServer1 2005/10/08 19:22:32(00003896) drmexgbackup -mode vss 2005/10/08 19:22:32(00003896) KAVX0001-I The drmexgbackup command will now start. 2005/10/08 19:22:33(00003896) KAVX0256-I A connection to the Protection Manager service will now be established. Host name = 10.106.136.125 2005/10/08 19:22:33(00003896) KAVX1600-I Backup processing will now start. 2005/10/08 19:22:58(00003896) KAVX5108-I Resynchronizing a copy group.
• Copy-group list file For details on the file name and location of the copy group list file, see “Creating a copy-group list file” on page 161. • Database list file or mount point directory list file For details on the file names and locations of the database list files and mount point directory list files, see “Creating a database list file or mount point directory list file” on page 162.
Execute EX_DRM_FS_BACKUP, and then carry out the following procedure on the file server: 1. Execute EX_DRM_DB_EXPORT. Backup information is exported and recorded in the backup information file, which is in the temporary directory for extended commands. Back up the files in the temporary directory for extended commands# to a location such as tape.
Figure 60 Protecting backup information for tape backups Back up the tape, and then carry out the following procedure: Execute EX_DRM_TAPE_BACKUP, and then carry out the following procedure on the backup server: • Use a tape backup product to back up all the files in the dictionary map file directory#. # For details on the dictionary map file directory on the backup server, see “Creation in a noncluster configuration or on a backup server” on page 133.
Recovering backup information (file server) This section explains how to recover backup information and restore the file system after restoring the operating environment when the backup information on the file server is damaged. To recover backup information (file server): 1. From the backup data that was backed up in “Application Agent backup information” on page 215, decide the generation and backup information to be restored. 2.
4. Carry out the procedure described in this manual for restoration. Creating the Exchange environment configuration file The Exchange environment configuration file is used to specify the information required for Exchange Server linkage. If you use the automatic seed function in a CCR configuration, you must create the Exchange environment configuration file.
Parameter Description Default Maximum Character String (bytes) In Exchange Server 2007: If you have specified ON in the EXG_SCR_SEED parameter, specify whether seed processing is to be executed even if a connection cannot be established with some of the targets set for the storage group. Specify ON to execute seed processing even if connections with some of the targets fail. Specify OFF if an error is to result when a connection with even one of the targets fails.
4 Application Agent operations Application Agent operations differ depending on the object to be backed up. This chapter provides an outline of and precautions on extended commands and basic commands used when operating Application Agent. It also gives precautions common to all objects subject to backup. The descriptions in this chapter apply to the Application Agent CLI.
Basic commands Basic commands provide data protection functions such as backup and restore. Extended commands execute basic commands internally for processing. Therefore, you need to have an understanding of basic commands before you use extended commands. If an error occurs during extended command operation, log information of the basic command being executed in the extended command is output.
Corresponding basic command Function -- Collects a backup information file from the backup server. If the backup is of an SQL Server database, the metafile is also collected. EX_DRM_FTP_PUT -- Transfers a backup information file to the backup server. If the backup is of an SQL Server database, the metafile is also transferred. EX_DRM_HOST_DEF_CHECK -- Checks the contents of the host environment setup file. EX_DRM_RESYNC drmresync Resynchronizes a copy group.
Extended command Corresponding basic command Function EX_DRM_UMOUNT drmumount Unmounts a secondary volume. -- drmtapecat Displays a listing of backup information for a tape. -- drmtapeinit Registers the parameters for a tape backup management software. Legend: -- The corresponding command does not exist.
Extended command Corresponding basic command Function • Displays a listing of SQL Server database information. -- drmsqldisplay • Updates the SQL Server database information in the dictionary map files. -- drmsqlinit Registers SQL Server parameters. -- drmsqlrecover Recovers a restored SQL Server database. -- drmsqlrecovertool Recovers a restored SQL Server database via a GUI. Legend: -- The corresponding command does not exist.
Backing up and restoring a file system, page 245 • When the backup is of an SQL Server database: Backing up and restoring an SQL Server database, page 275 • When the backup is of an Exchange database: Backing up and restoring a storage group, page 395 PrecautionsPrecautions on operations • Do not use an LVM command to change the configuration while a Application Agent command is executing.
The objects subject to backup are as follows: When the backup is of a file system: mount point. When the backup is of an SQL Server database: database. When the backup is of an Exchange database: storage group or Information Store.
• If you execute a backup command when information about the operation target object is not created in the dictionary map files, the dictionary map files are created by the command. In this case, the processing time required to create the dictionary map files is added to the total backup processing time. • Make sure no other volume is mounted on the directory of the volume to be backed up when performing an online backup. For details, see “Precautions for volume configuration” on page 78.
The following message will be displayed: DiskPart successfully offlined the selected disk. 5. To display the current disk statuses, enter list disk. Make sure that the disk statuses of the secondary volumes are Offline in the Status column. 6. Enter exit to end the diskpart command. Precautions on restoration • Make sure that the pair statuses of the copy group to be restored are PSUS (for primary volume) and SSUS (for secondary volume).
Precautions when executing commands simultaneously While a command is executing, if a user attempts to execute another command that cannot be executed concurrently with the executing command, the system will attempt to execute the latter command indefinitely until the former command terminates. To prevent the system from attempting to execute such a command indefinitely (until the former command terminates), you will need to edit the init.conf file.
If the -raw option is used in the drmmediabackup command, either do not specify the -mount_pt option in the immediately preceding drmmount command, or else specify the drive letter in the -mount_pt option. • If an arbitrary directory is specified in the drmmount command’s -mount_pt option and the backup data obtained using the drmmediabackup command is to be restored, the drmmount command executed before the drmmediarestore command must specify an arbitrary directory in the -mount_pt option.
• • • • • • • When When When When When When When an SQL Server instance has been created or deleted. an SQL Server database has been added or deleted. the name of an SQL Server database has been changed. an SQL Server database configuration file has been added or deleted. the name of SQL Server database configuration file has been changed. an SQL Server database configuration file has been moved. a dynamic volume has been expanded.
Disk group configuration that does not allow backup (dynamic disk configuration) In a dynamic disk configuration, you cannot back up a file system or database if, as shown in the following figure, there is a logical volume that has not been mounted in the disk group in which the target file system or database was created.
• OS administrator permissions and administrator privileges In a Windows Server 2008 operating environment, the user must also have OS administrator privileges. If the user does not have OS administrator privileges, an error message appears, indicating that the user has insufficient permissions to execute the command, and command execution fails. A user executing a Application Agent command must have local Administrator authorization on the server on which the command is to be executed.
Extended command name OS administrator permissions#1 Database access permissions EX_DRM_HOST_DEF_CHECK Needed Not Needed EX_DRM_RESYNC Needed Not Needed drmappcat Needed Not Needed drmcgctl Needed Not Needed drmclusinit Needed Not Needed drmdbexport Needed Not Needed drmdbimport Needed Not Needed drmdevctl Needed Not Needed drmhostinfo Needed Not Needed drmresync Needed Not Needed #1 In a Windows Server 2008 operating environment, this also includes OS administrator privileg
In a Windows Server 2008 operating environment, this also includes OS administrator privileges. Table 92 Required permissions for each command (utility commands) Extended command name OS administrator permissions# Database access permissions Needed drmdbsetup Not Needed # In a Windows Server 2008 operating environment, this also includes OS administrator privileges.
Extended command name OS administrator permissions# Database access permissions drmexgbackup Needed Needed drmexgcat Needed Not Needed drmexgdisplay Needed Needed drmexgrestore Needed Needed drmexgverify Needed Not Needed # In a Windows Server 2008 operating environment, this also includes OS administrator privileges. PossibilityPossibility of concurrent execution with other commands Parallel execution (parallelize, then execute) of commands is not available.
Command Function summary Possible to run with other commands? • Locks copy groups. drmcgctl • Unlocks copy groups. No#2 • Displays a list of copy groups. drmclusinit Registers the parameters of the cluster software. Yes drmdevctl Enables or disables concealment of a device in the secondary volume. No drmdbexport Exports backup information to a file. No drmdbimport Imports backup information from a file. No drmhostinfo Displays a list of host information.
These commands can execute concurrently with any other command only when the tape backup management software is running. #2 When these commands are executed with the -delete option, these commands cannot execute concurrently with other commands. When these commands are executed with options other than the -delete option, these commands can execute concurrently with any other command.
• The -no_cat option is not specified. • The -v option is not specified. • The -lsn option is not specified. • The -d option is not specified. • The instance name is specified. Table 100 Possibility of concurrent execution with other commands (when the backup is of an Exchange database) Possible to run with other commands? Command Function summary drmexgbackup Backs up an Exchange database to a disk. No drmexgcat Displays a listing of the backup information for an Exchange database.
init.conf file format COM_RETRY_TIME=number-of-retry-attempts COM_RETRY_WAIT=duration-between-retry-attempts The following values can be specified: • Number of retry attempts: 0 to 3,600, with 0 representing indefinite retries. If you want to stop indefinite retries, specify a value other than 0. • Duration between retry attempts: 0 to 3,600 between each retry attempt (in ten-second intervals).
Configurations That Requires RAID Manager User Authentication Application Agent commands support RAID Manager user authentication when the RAID Manager version is 01-25-03/01 or later. For details about the conditions for using Application Agent in a configuration that requires user authentication, see the HP StorageWorks P9000 Replication Manager Software Configuration Guide.
Restarting the Protection Manager service When the contents of the Application Agent init.conf and default.dat definition files are changed, you must use the Services pane in the Windows Computer Management console (for Windows Server 2003) or Server Manager console (for Windows Server 2008) to restart the Protection Manager service. Stopping the Protection Manager service When Application Agent is uninstalled, the Protection Manager service stops and is deleted from Windows.
Application Agent operations
5 Operation for file systems This chapter describes the procedures for running Application Agent when backing up a file system. The descriptions in this chapter apply to the Application Agent CLI. For details on setting up commands, see the manual HP StorageWorks P9000 Replication Manager Software CLI Reference Guide. Backing up and restoring a file system This section provides notes on backing up and restoring a file system.
• Do not use the drmfsrestore command in the following situations: • When you back up a file system from a secondary volume to tape device by using the drmmediabackup command. • When you restore a file system from the tape device to a secondary volume by using the drmmediarestore command. • When you mount a secondary volume by using the drmmount command.
Figure 63 System configuration for backing up and restoring data between volumes (when the backup is of a file system) Processing flow The processing flow for backing up a file system to a secondary volume and restoring it to the primary volume on a single-server system is shown below. Execute commands on the file server.
Figure 64 Procedure for backing up a file system to the secondary volume Figure 65 Procedure for restoring a file system to the primary volume Backing up a file system to a secondary volume This section provides an example of backing up the mount point E: on the file server FSServer to a secondary volume in an online backup operation. Use Operation_A as an operation ID to identify the object to be backed up. To back up the file system: • Back up the file system to the secondary volume.
1. Check the backup ID of the backup data. Check the backup ID of the backup data used to restore the file system, by executing the drmfscat command on the file server with a mount point name or mount point directory target definition file name specified as an argument.
Figure 66 System configuration for backing up a file system to tape and restoring it from tape With Application Agent, file servers can be clustered. With file servers configured in a failover cluster, if the active server fails, a standby server is available to take over operations from the active server. This example assumes the following conditions: • The system is equipped with a file server (server name: FSServer), and a backup server (server name: BKServer) with a tape device connected to it.
Flow of processing This section describes the processing flow of backing up a file system to tape and restoring it to the primary volume on a multi-server system. A single-file-server system is used in this example, but a multi-file-server system may be used as appropriate. • When usual operation is in the split state, resynchronize the copy group before backing up the data. • When usual operation is in the pair status, there is no need to resynchronize the copy group before backing up data.
Figure 67 Procedure for backing up a file system to tape Figure 68 Procedure for restoring a file system from tape 252 Operation for file systems
Backing up a file system to tape This section gives an example of backup of a file system to a tape. In this example, we back up the file server FSServer to a secondary volume in an online backup operation before backing it up from a secondary volume to tape. As a mount point, we use E:. The example uses Operation_A as the operation ID that identifies the file system to be backed up.
3. Export the information about the backup to temporary files. To back up data from the secondary volume to a tape, you must copy information about the backup that was performed from the primary volume to the secondary volume. Copy this information to the backup server. To export information about backup to temporary files, execute EX_DRM_DB_EXPORT. The temporary files are stored in the temporary directory for extended commands, on the file server. FSServer > EX_DRM_DB_EXPORT Operation_A 4.
To use VSS to back up a file system: 1. Back up the file system to the secondary volume. Use VSS to back up the file system to the secondary volume. To do this, execute EX_DRM_FS_BACKUP. Specify the operation ID Operation_A as the argument. FSServer > EX_DRM_FS_BACKUP Operation_A -mode vss 2. Check that backup was performed correctly.
7. Back up the data from the secondary volume to a tape. To back up the data, execute EX_DRM_TAPE_BACKUP on the backup server. Here, the drive letter of the secondary volume is E:. BKServer > EX_DRM_TAPE_BACKUP Operation_A -mount_pt E: When backup is performed, information about these backup operations is registered in the backup catalog with the new backup ID 0000000002. 8. Check that the file system has been backed up correctly.
3. Check that the file system has been restored correctly from tape to the secondary volume. To check that backup information with the date of the backup from the primary volume to the secondary volume has been restored to the backup server, execute the drmfscat command on the backup server. 4. Export backup information to temporary files.
Figure 69 System configuration for backup of a file system to tape Processing flow In this example, the processing flow of the drmfsbackup command that specifies a user script is as follows: • All application programs that are using the F drive are stopped (this is a step in the user pre-processing section). • The cache of the secondary volume is cleared (this is a step in the user pre-processing section).
Figure 70 Processing flow User script example The table below shows the user script that is created for the example. Table 102 User script creation example Script text Explanation LOCAL_BACKUP=YES ...(1) (1) YES is required. #Pre-processing section [PRE_PROC] ...
Script text Explanation #Stop the application programs that are using the file system CMDLINE=C:\tmp\stop_app.bat ENV=VAL=ApplicationName ...(3) (3) Pass the environment variable VAL= ApplicationName to the command. TIMEOUT=60 ...(4) (4) Take a 60-second timeout. END_CODE=100 ...(5) (5) Treat a command return value of 100 or greater as an error. LOCATION=LOCAL ...(6) #Clearing of the secondary volume cache (mounting and unmounting) (6) Execute on the local server.
Script text Explanation [POST_PROC] ...(8) #Tape backup of the secondary volume (8) Start of the user post-processing section [CMD] CMDLINE=C:\tmp\tapebackup.bat TIMEOUT=NOWAIT ...(9) (9) Execute the next command without waiting for the command to terminate. END_CODE=TERMINATE_NZ ...(10) (10) Treat a command return value of a value other than 0 as an error. LOCATION=REMOTE PARENT_STAT=NORMAL ...(11) [CMD] #Application recovery processing if there is a backup error CMDLINE=C:\tmp\recovery.
Script text Explanation #Re-start the application programs that use the file system CMDLINE=C:\tmp\restart_app.bat ENV=VAL=ApplicationName TIMEOUT=60 END_CODE=100 LOCATION=LOCAL The following is an example of backing up the secondary volume to tape by using tapebackup.bat: rem Use NTBACKUP to execute the job Job1,and perform a copy backup of G:\ to tape Tape1 rem Set the backup comment passed to the DRMENV_COMMENT environment variable as the backup job explanation "C:\Windows\system32\ntbackup.
PROMPT> drmfsbackup F: -mode cold -script C:\tmp\script.txt -s BKHOST -auto_import -auto_mount G: -comment TEST1 KAVX0001-I The drmfsbackup command will now start. KAVX0256-I A connection to the Application Agent will now be established. Host name = BKHOST KAVX0210-I The user script will now start. Procedure section = [PRE_PROC] KAVX0263-I A command in the user script will now be executed. Host name = LOCAL Command line = C:\tmp\stop_app.bat KAVX0213-I A command from the user script has ended.
Backing up and restoring between local sites and remote sites This section shows examples for using volume replication functionality between storage systems, such as Continuous Access Software or Continuous Access Journal, to back up a file system from the primary volume in the local site to the secondary volume in the remote site, and for performing restoration from the secondary volume in the remote site to the primary volume in the local site.
• The system is equipped with a file server in the local site (server name: FSServer), and has a backup server (server name: BKServer) with a tape device connected to it. • An FTP service is running on the backup server of the remote site, and is set such that users who can log on to the OS on each file server can be used to log on to the FTP server and transfer files. The FTP user ID must be admin, and the FTP user password must be password.
3. Check that backup was performed correctly. On the file server, execute the drmfscat command, and check the backup information.
2. Check that the temporary files have been imported correctly. To check that backup information bearing the date on which the temporary files had been backed up from the primary volume to the secondary volume has been imported on the backup server, execute the drmfscat command on the backup server.
Restoring a file system to the local site This subsection explains an example for restoring a file system to a local site, when the local site is running normally, without failure. Procedures at the local site and remote site are explained separately. Operations at the remote site 1. Split the Continuous Access Software pair (usual operation is in the pair status). BKServer > pairsplit -g Cnt Ac01 -d FS11 -rw BKServer > 2. Check the backup ID of the backup data.
5. Export the backup information to temporary files. To perform restoration from the secondary volume to the primary volume, you need to copy backup information about the restoration operations from tape to the secondary volume, to the file server. To export the backup information to temporary files in the temporary directory for extended commands, execute EX_DRM_DB_EXPORT. BKServer > EX_DRM_DB_EXPORT Operation_A Operations at the local site 1.
5. Resynchronize the copy group. To resynchronize the copy group, execute EX_DRM_RESYNC on the file server. FSServer > EX_DRM_RESYNC Operation_A Restoring a file system to a remote site This subsection explains an example for restoring a file system in a remote site when failure occurs in the local site. Operations at the remote site 1. Split the Continuous Access Software pair (usual operation is in the pair status). BKServer > pairsplit -g TC01 -d FS11 -S BKServer > 2.
5. Use the disk management function to mount the restored volume. The mount is to the G: drive. Recovering a file system from a remote site to the local site This subsection explains how to recover restored data in the remote site to the local site, after the file system is restored in the remote site and recovery has been performed for the failure in the local site. Procedures at the local site and remote site are explained separately.
2. When usual operation is in the split state, execute EX_DRM_RESYNC to resynchronize the copy group. 3. Execute EX_DRM_FS_BACKUP to back up the file system to the secondary volume. 4. Execute EX_DRM_DB_EXPORT to export the backup information to temporary files. 5. Execute EX_DRM_FTP_PUT to transfer the temporary files to the backup server. 6. Execute EX_DRM_DB_IMPORT to import the temporary files transferred from the file server to the backup catalog on the backup server. 7. Check the backup ID.
1. Check the temporary directory for extended commands that was created automatically by the check tool for operation definition files. For more information about the temporary directory for extended commands, see “CheckingChecking the temporary directory for extended commands” on page 201. 2. When running Explorer or any other tool, put the temporary directory for extended commands that is on the backup server in a shared state. 3.
Example of restoring a file system by using a file share This section explains how to restore a file system on the backup server via file sharing. For more operational details on steps 1 to 3 and step 5 and subsequent steps, see “Restoring a file system from tape” on page 256. To restore a file system by using a file share: 1. Execute the drmtapecat command to check the backup ID of the backup data. 2. Execute EX_DRM_TAPE_RESTORE to restore the backup data from the tape to the secondary volume. 3.
6 Operation for SQL Server databases This chapter describes how to operate Application Agent when backing up an SQL Server database, focusing on actual procedures. The descriptions in this chapter apply to the Application Agent CLI. For details on setting up commands, see the .HP StorageWorks P9000 Replication Manager Software CLI Reference Guide Backing up and restoring an SQL Server database This section provides notes on backing up and restoring an SQL Server database.
PPrecautions when restoring a database • When you attempt to restore an SQL Server system database (master, model, msdb, or distribution), the SQL Server service to be restored needs to be stopped to recover the system database. The database to be restored cannot be accessed temporarily. • During restoration of the SQL Server system databases (master, model, and msdb), do not connect to the SQL Server.
For example, when ODBC sections cannot be established, if an application that performs retries is running, since an ODBC section establishment request is issued during the roll-forward after metafile application, the roll-forward will fail. • When using Enterprise Manager to view a database to be backed up, before performing restoration, either cut the connection to the database in Enterprise Manager, or terminate Enterprise Manager.
Figure 72 Backing up and restoring multiple databases (same volume configuration) When multiple databases are stored in multiple volumes You can specify database names to back up or restore particular user databases within an instance#. The following figure shows backup and restoration for databases stored on the multiple volume.
Figure 74 Tape restoring multiple databases (multiple volume configuration) In the operations shown in the above figure, the data restored from tape is stored on secondary volume 2, but when data on secondary volume 1 is restored to primary volume 1, Application Agent treats this as a completed restoration. As such, EX_DRM_SQL_RESTORE cannot be used to restore DB2 on secondary volume 2 to primary volume 2.
Figure 75 Database statuses during restoration and recovery Note that when a database in the standby status is viewed by Enterprise Manager, before executing the drmsqlrecover command or drmsqlrecovertool command, either cut the connection to the database in Enterprise Manager, or terminate Enterprise Manager.
The following figure shows the example when LOCAL_BACKUP is set to YES and the secondary volume on the local site is backed up. In this example, the point A is used as the start point and log backup 1 and 2 are obtained. Subsequently, the secondary volume on the remote site is backed up when LOCAL_BACKUP is set to NO. The log backup 3 is obtained, with the backup ID 0000000001. When the drmsqllogbackup -v command is executed, log backup 1, 2, and 3 are displayed for the backup ID 0000000001.
Figure 76 Transaction log backups after roll-forward (1) • After performing roll-forward, use Application Agent to perform backup from the primary volume to the secondary volume, and then obtain a backup of the transaction log files. Figure 77 Transaction log backups after roll-forward (2) In this case, when the second backup from the primary volume to the secondary volume is performed, the contents of the secondary volume are updated.
Figure 78 Transaction log backup error after roll-forward Precautions regarding application of transaction logs Application of transaction logs enables a database to be recovered from a backup at a certain point, or when the metafile is damaged. For such a recovery, the transaction logs must be backed up continuously. Also, a recovery cannot be performed if any transaction logs are missing. In addition, transaction log files must be applied in the order they were backed up.
2. Transaction log backups at point C can be applied after the previous transaction log backup (point B) is applied. Recovering the SQL Server database from backup data existing prior to the last backup data You can recover the SQL Server database from backup data existing prior to the last backup data when there is a problem in the latest backup data.
Service status Commands Running Stopping drmsqldisplay (when the -refresh option is specified) Executable (Not applicable) drmsqldisplay (when the -refresh option is not specified) Executable Executable drmsqlinit Executable (Not applicable) drmsqllogbackup Executable (Not applicable) drmsqlrecover Executable (Not applicable) drmsqlrecovertool Executable (Not applicable) Executable Executable Executable (Not applicable) drmsqlrestore (when the system database# is included) drmsqlrest
SQL Server database status Commands Online Offline Reading Read-only Unconfirmed drmsqllogbackup (when the -no_truncate option is not specified) Yes (DB) No No Yes No (becomes read-only) No Yes (DB) Yes (DB) Yes (DB) Yes No (becomes online) (becomes online) No No Yes (DB) (becomes reading) No No Yes (DB) (becomes read-only) Yes (DB) Yes (DB) (becomes online) No Yes (DB)#2 (becomes read-only) drmsqlrecovertool No No (becomes online) Yes (DB) Yes (DB) Conditional#1 Yes (D
If you restore the user database only, delete the database in a state where a restoration command cannot be executed, and then re-execute the restoration. #2 If the database is in the unconfirmed status, it will be deleted and then restored automatically.
SQL Server database status Offline and unconfirmed Reading and unconfirmed Read-only and offline Read-only and unconfirmed Read-only, offline, and unconfirmed No No No No No No No No No No drmsqlrestore Yes (DB)# Yes (DB)# Yes (DB) Yes (DB)# Yes (DB)# (when the -undo option is specified) (becomes read-only) (becomes read-only) (becomes read-only) (becomes read-only) (becomes read-only) drmsqlrestore Yes (DB)# Yes (DB)# Yes (DB) Yes (DB)# Yes (DB)# (when the -undo option is n
SQL Server database type Commands System database User database master drmsqlrecover drmsqlrecovertool drmsqlrestore msdb model No No No (No operation is performed) (No operation is performed) (No operation is performed) tempdb No (terminates with an error) Yes (DB) No No No (No operation is performed) (No operation is performed) (No operation is performed) (terminates with an error) Yes (DB) Yes (DB) Yes (DB) Yes (DB) Yes Yes (DB) No Legend: Yes (DB): The command can be execute
Figure 81 System configuration for backing up and restoring data between volumes (when the backup is of an SQL server database) Processing flow The processing flow for backing up an SQL Server database to the secondary volume and restoring it to the primary volume on a single-server system is shown below. Commands are executed on the database server.
Figure 82 Procedure for backing up an SQL Server database to the secondary volume Figure 83 Procedure for restoring an SQL Server database to the primary volume Backing up an SQL Server database to a secondary volume This section provides an example of performing an online backup of an SQL Server database between volumes. To back up the SQL Server database: • Back up the SQL Server database onto the secondary volume. Perform an online backup of the SQL Server database.
1. Check the backup ID of the backup you want to use for restoration. Check the backup ID of the backup data to be used for restoring. To check the backup ID, execute the drmsqlcat command on the database server. Here, the predetermined instance (default) is used as the instance name of SQL Server.
• Specify an instance name to execute the drmsqlrecover command. The following command illustrates execution of the drmsqlrecover command to recover an SQL Server database: DBServer > drmsqlrecover default KAVX0001-I The drmsqlrecover command will now start. KAVX0002-I The drmsqlrecover command will now end. DBServer > When you execute the drmsqlrecover command with an instance name specified, the database becomes accessible, and the recovery is complete.
3. Check the status of the database after recovery. For Recovery mode, select the status of the recovered database. Standby: Select this to perform recovery in the standby status (read-only and usable). Note that you cannot select Standby unless the UNDO file storage directory is set using the drmsqlinit command. Loading: Select this to perform recovery in the loading status. Online: Select this to make the database fully accessible. 4. Select whether to perform roll-forward.
Figure 84 System configuration for backing up an SQL Server database to tape and restoring it from tape Application Agent allows you to use a cluster configuration for database servers. If a failover cluster configuration is used for the database servers, the active server can be switched to the standby server when a failure occurs on the active server. The examples in this section assume the following conditions: • The primary volume is NTFS-formatted.
• Temporary directory for Extended Commands and the VDI metafile storage directory are created by the database server and backup server. • The secondary volume is not always mounted. It is mounted on the E drive (drive character E:) only while it is operating. • The primary volume configured as a pair with the secondary volume to be backed up will not be backed up until the secondary volume is backed up onto tape.
Figure 85 Procedure for restoring an SQL Server database to the primary volume CLI User Guide 297
Figure 86 Procedure for restoring an SQL Server database from its backup tape Backing up an SQL Server database to tape This section provides an example of performing an online backup of an SQL Server database onto tape. In this example, an online backup of the INSTANCE_1 instance of the DBServer database server is first performed to place a backup on the secondary volume, and then a backup is performed from the secondary volume to tape. The operation ID is Operation_A.
Resynchronize the copy group. 1. For the copy pair configuration of multiple generations, check the copy group to be used next. To check the copy group to be used next, execute the drmsqlcat command on the backup server. If the copy group is not locked, the least recently backed up copy group is overwritten. You can execute the drmcgctl command to check the lock status of a copy group. 2. Clear the cache of the secondary volume. Before backing up SQL Server, clear the system cache on the backup server.
4. Back up the SQL Server's metafile created at the backup to the temporary folder. Back up the SQL Server's metafile created at the backup to the temporary folder for extended commands that is on the database server so that the SQL Server's metafile and temporary files can be transmitted collectively to the backup server. To back up the SQL Server's metafile, execute EX_DRM_SQLFILE_PACK. DBServer > EX_DRM_SQLFILE_PACK Operation_A After EX_DRM_SQLFILE_PACK is executed, an a backup-ID_database-ID.
Restoring an SQL Server database from tape This section provides an example of restoring an SQL Server database backed up to tape. This example restores the data from tape to a secondary volume, and then restores the data from the secondary volume to the the primary volume by resynchronizing the volumes. The operation ID is Operation_A. Restoring an SQL Server database To restore the SQL Server database: 1. Check the backup ID of the backup you want to use for restoration.
4. Back up the metafile created at the restoration to the temporary folder. Back up the metafile created at the restoration to the temporary folder for extended commands that is on the backup server, so that the metafile and temporary files can be transmitted collectively to the database server. To back up the metafile, execute EX_DRM_SQLFILE_PACK on the backup server.
Recovering an SQL Server database with the drmsqlrecover command The drmsqlrecover command is useful for recovering particular databases and recovering multiple volumes at once. • Specify an instance name to execute the drmsqlrecover command. The following command illustrates execution of the drmsqlrecover command to recover the SQL Server database: DBServer > drmsqlrecover default KAVX0001-I The drmsqlrecover command will now start. KAVX0002-I The drmsqlrecover command will now end.
To use the drmsqlrecovertool dialog box to recover an SQL Server database: 1. Specify an instance name to execute the drmsqlrecovertool command. DBServer > drmsqlrecovertool default When you execute the command, the drmsqlrecovertool dialog box is displayed. 2. Select a recovery destination database in Target database. 3. Check the status of the database after recovery. For Recovery mode, select the status of the recovered database.
System configuration The example is based on the system configuration shown in the figure below. Figure 87 System configuration for backup of an SQL Server database to tape Processing flow In this example, the processing flow of the drmsqlbackup command that specifies a user script is as follows: • The cache of the secondary volume is cleared (this is a step in the user pre-processing section). • An online backup of SQL Server's DEFAULT instance is performed.
By not specifying the VDI metafile storage location in drmsqlinit, the VDI metafile is written to the primary volume and can be backed up at the same time as the data files. Figure 88 Processing flow User script example The table below shows the user script that is created for the example. Table 107 User script creation example Script text Explanation LOCAL_BACKUP=YES ...(1) (1) YES is required. #Pre-processing section [PRE_PROC] ...
Script text Explanation [CMD] ...(3) (3) Mounting of the first volume CMDLINE="C:\program files\CVXPAE\drm\bin \drmmount.exe" -copy_group vg01,vol01 LOCATION=REMOTE ...(4) (4) Execute on a remote server. [CMD] ...(5) CMDLINE="C:\program files\CVXPAE\drm\bin \drmmount.exe" -copy_group vg01,vol02 (5) Mounting of the second volume LOCATION=REMOTE [CMD] ...(6) CMDLINE="C:\program files\CVXPAE\drm\bin \drmumount.exe" -copy_group vg01,vol01 (6) Unmounting of the first volume LOCATION=REMOTE [CMD] ...
Script text Explanation #Tape backup of the secondary volume [CMD] CMDLINE=C:\tmp\tapebackup.bat TIMEOUT=NOWAIT ...(9) (9) Execute the next command without waiting for the command to terminate. END_CODE=TERMINATE_NZ ...(10) (10) Treat a command return value that is a value other than 0 as an error. LOCATION=REMOTE PARENT_STAT=NORMAL ...(11) (11) Execute only when the backup command is normal. The following is an example of backing up the secondary volume to tape using tapebackup.
Operation using SQL Server transaction logs Backing up an SQL Server database entails either backing up all databases, or backing up transaction log files. When formulating a plan for backing up an SQL Server database, if the database is fairly large so that the time required to perform backup is significant, or if the database is updated regularly, HP recommends a combination of database backup and transaction log backup. There are several precautions to keep in mind when backing up transaction logs.
• The primary volume and the secondary volume are pair defined in the database server and the backup server. • The tape backup management software is installed on the backup server. • The parameters of the tape backup management software have been registered by using the drmtapeinit command. • The FTP service on the backup server is started, and the system is set up so a user who has logged onto the OS of the database server can log onto the FTP server and transfer files to the FTP server.
Procedures for restoration and recovery are as follows after failure occurs at point D. 1. Restore the data in the SQL Server database backed up at point A. The database is recovered to point A. For details about how to restore the SQL Server database backed up at point A, see “Restoring SQL Server databases” on page 313. Also, for the order to apply the transaction logs, see “Precautions regarding application of transaction logs” on page 283. 2.
Backing up an SQL Server database To back up an SQL Server database: 1. Back up the SQL Server database from the primary volume to the secondary volume. DBServer > EX_DRM_SQL_BACKUP Operation_A 2. Export the backup information to temporary files. DBServer > EX_DRM_DB_EXPORT Operation_A 3. Save the metafile created when backing up in the temporary folder. DBServer > EX_DRM_SQLFILE_PACK Operation_A 4. Transfer the metafile and the temporary file to the backup server.
Restoring SQL Server databases Restore the SQL Server database backed up at "point A". To restore the SQL Server database: • Restore the SQL Server database. To restore the SQL Server database, execute EX_DRM_SQL_RESTORE. DBServer > EX_DRM_SQL_RESTORE Operation_A -resync -undo When restoration is complete, make sure that the database has reverted to the status at "point A".
4. Select Standby for Recovery mode and Yes for Roll forward?, and click the Recovery button. The transaction log obtained at point B and point C is applied, and the database is restored to the status at point C. At this point, the status of the database after recovery changes based on the selection for Recovery mode.
Example of operation using transaction log backup If a failure occurs, you can restore the database up to the point of the last backup by using the data and transaction logs backed up during regular operation before the failure occurred. However, when you use only backups under normal operation, since operations performed after the last backup is truncated, such operations cannot be restored.
• Obtain transaction logs, without truncating those subsequent to point C. To obtain transaction logs without truncating, execute the EX_DRM_SQL_TLOG_BACKUP with the -no_truncate option specified. DBServer > EX_DRM_SQL_TLOG_BACKUP Operation_A -no_truncate When the -no_truncate option is specified, transaction logs are obtained from after transaction log backup acquisition at point B, until failure occurred.
System configuration The examples in this section assume the system configuration shown in the following figure. Figure 92 Backing up SQL Server transaction log backup files The system prerequisites for this example are as follows: • A pair is defined for each of the volumes on which the E, F, and G drives are mounted. • SQL Server data files are placed on the E drive and SQL Server transaction log files are placed on the F drive.
FTP_HOME_DIR=C:\FTP_ROOT FTP_SUB_DIR=script SET_DRM_HOSTNAME=1 • The operation definition file used to back up the file system is named FS1. The backup target is the G drive that contains the transaction log backup file storage directory. Contents of _FS1.dat: BACKUP_OBJECT=FILESYSTEM DB_SERVER_NAME=FILESERV1 INSTANCE_NAME=G: TARGET_NAME=G:\Logbackup FTP_HOME_DIR=C:\FTP_ROOT FTP_SUB_DIR=script SET_DRM_HOSTNAME=1 Backing up the transaction log backup file 1. Back up the transaction logs.
4. Back up the backed up transaction log file to the secondary volume. This step backs up the transaction log file online. To do this, execute EX_DRM_FS_BACKUP. DBServer > EX_DRM_FS_BACKUP FS1 DBServer > When executes this command, places backup information with a new backup ID (the next unused ID) in the backup catalog on the database server. It is assumed here that this new backup ID is 0000000003. 5. Check the backup execution results.
10. Back up the data of the secondary volume to tape. To back up the data of the secondary volume, execute EX_DRM_TAPE_BACKUP on the backup server. Specify the G: drive as the mount point. BKServer > EX_DRM_TAPE_BACKUP FS1 -mount_pt G: BKServer > When this backup operation is performed, information on this operation is entered into the backup catalog, with a new backup ID 0000000004. 11. Check the backup to tape execution results.
4. Export the backup information to temporary files. To restore data from the secondary volume to the primary volume, the backup information about the restore operation from tape to the secondary volume needs to be copied to the database server. To export the backup information to temporary files in the temporary directory for extended commands, execute EX_DRM_DB_EXPORT. BKServer > EX_DRM_DB_EXPORT FS1 BKServer > 5. On the database server, receive the temporary files.
• Backups obtained for a volume are kept, while the usual backups are obtained for the other two volumes. Example of operation using lock functionality and generation management The following figure shows an example of operation in which a particular copy group is locked. Figure 93 Example of operation in which a particular copy group is locked 1. Back up the primary volume to secondary volume 1 (generation 1), and then lock copy group 1 (generation 1).
For the following, Operation_A is used as the operation ID. To lock the copy group: 1. Checking the secondary volume status. Display the list of copy groups and make sure that none are locked. To check the lock status of a copy group, execute the drmcgctl command with no parameters. If UNLOCKED is displayed in the LOCK STATUS column, the copy group is not locked. DBServer > COPY GROUP VG01,VOL11 VG01,VOL12 VG01,VOL13 VG02,VOL21 VG02,VOL22 VG02,VOL23 VG03,VOL31 VG03,VOL32 VG03,VOL33 DBServer > 2.
4. Lock secondary volume 1. To keep the backup data (generation 1), lock the copy group (generation 1) by executing the drmcgctl command with the -mode lock option specified. You can specify the item to be locked by backup ID or copy group. At this point, execute the drmcgctl command, specifying 0000000004 as the backup ID. DBServer > KAVX0001-I KAVX0302-I KAVX0002-I drmcgctl -backup_id 0000000004 -mode lock The drmcgctl command will now start.
2. Check the copy group status. Display the copy group list and check that the copy group has been unlocked.
Figure 94 System configuration for backing up and restoring an SQL Server database between a local site and a remote site The system prerequisites for this example are as follows: • The system includes a local-site database server (server name: DBServer) and a remote-site backup server (server name: BKServer) to which a tape device is attached.
• The remote-site volume is not usually mounted. When necessary, it will be mounted at the G: drive on the backup server. • The SQL Server data files and transaction log files are stored in the same directory structures on the local and remote sites. • Use Operation_A as the operation ID. Backing up an SQL Server database to a remote site The example provided below explains the operation used to back up a file system to a remote site. Procedures at the local site and remote site are explained separately.
3. Check that backup was performed properly. To check the backup information, execute drmsqlcat on the database server. DBServer > drmsqlcat default INSTANCE: default BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: default START-TIME: 2004/08/05 10:00:00 END-TIME: 2004/08/05 10:03:00 T DB OBJECT FILE COPY-GROUP M UserDB1 METAFILE F:\MSSQL\meta\0000000131_0000000005.dmp D UserDB1 DATAFILE G:\UserDB1_Data.MDF Cnt Ac01,SQL11 - Cnt Ac01,SQL11 T UserDB1 TRANSACT G:\UserDB1_Log.
2. Check that the import operation has been performed correctly. To confirm that backup information with the date of the backup from the primary volume to the secondary volume has been correctly imported to the backup server, execute the drmsqlcat command on the backup server.
Restoring an SQL Server database to the local site The example provided below explains the operation used to restore an SQL Server database to the local site if the local site is normally active and is free from any problem. Procedures at the local site and remote site are explained separately. Operation at the remote site 1. Split the Continuous Access Software pair (usual operation is in the pair status).
5. Export the backup information to temporary files. Before you can restore an SQL Server database from the secondary volume to the primary volume, you need to copy backup information on the tape-to-secondary-volume restore operation to the file server. BKServer > EX_DRM_DB_EXPORT Operation_A Operation at the local site 1. In the local site database server, obtain the temporary files. To receive the temporary files collectively from the backup server, execute EX_DRM_FTP_GET on the database server.
6. Resynchronize the copy group. To resynchronize the copy group, execute EX_DRM_RESYNC on the database server. DBServer > EX_DRM_RESYNC Operation_A Restoring an SQL Server database to a remote site The example provided below explains the operation used to restore an SQL Server database in a remote site if the local site has encountered a problem. Operation at the remote site 1. Split the Continuous Access Software pair (usual operation is in the pair status). Change the pair status from PAIR to SMPL.
4. Check that correct data is restored from the tape to the secondary volume. To check that backup information with the date of the backup from the primary volume to the secondary volume is restored on the backup server, execute the drmsqlcat command on the backup server.
2. Use the disk management function to unmount the volume that was mounted using the disk management function. The G: drive is unmounted. 3. To create a backup catalog, create a pair the primary volume of which should reside in the local site. BKServer > paircreate -g Cnt Ac01 -d SQL11 -vl -f never -c 15 BKServer > Operation at the local site 1. Swap the primary volume and the secondary volume. DBServer > pairresync -g Cnt Ac01 -d SQL11 -swaps DBServer > 2. Resynchronize the copy group.
Figure 95 System configuration for backing up an SQL Server database to tape and restoring it from tape in a multi-target configuration This example assumes the following conditions: • The primary volume is NTFS-formatted. • Both of the primary volumes in the local site and in the remote site are defined as a pair by Continuous Access Software. In each site, the primary volume and the secondary volume are also defined as a pair by Business Copy.
• The FTP service on the backup server is started, and the system is set up so a user who has logged onto the OS of the database server can log onto the FTP server and transfer files to the FTP server. • Data for which an online back up was performed from the primary volume to the secondary volume was backed up to tape. • Two SQL Server instances (INSTANCE_1 and INSTANCE_2) exist, and services are running on database server (hostB). • The secondary volume is not always mounted.
ENV=HORCMINST=0 END_CODE=TERMINATE_NZ TIMEOUT=0 [SPLIT_PROC] # Target pair volume: BC01,dev01 [CMD] CMDLINE=C:\HORCM\etc\pairsplit.exe -g Cnt Ac01 -d sql01 -FBC 0 ENV=HORCMINST=0 ENV=HORCC_MRCF= END_CODE=TERMINATE_NZ TIMEOUT=10 [CMD] CMDLINE=C:\HORCM\etc\pairevtwait.
4. Transmit the temporary files to the backup server at the local site. Collectively transmit the temporary files from the database server to the backup server at the local site. To transmit the temporary files, execute EX_DRM_FTP_PUT on the database server. In this example, the user ID to log on to the FTP server is admin and the login password is password. The temporary files are stored in the temporary directory for extended commands, on the backup server.
3. Export the backup information to temporary files. To restore data from the secondary volume to the primary volume, the backup information about the restore operation from tape to the secondary volume needs to be copied to the database server. To export the backup information to temporary files in the temporary directory for extended commands, execute EX_DRM_DB_EXPORT on the backup server at the local site. hostA > EX_DRM_DB_EXPORT opid_SQL 4. Receive the temporary files on the database server.
7. Recover the SQL Server database. To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool command on the database server at the local site. The following command illustrates execution of the drmsqlrecover command to recover the SQL Server database: hostB > drmsqlrecover DEFAULT KAVX0001-I The drmsqlrecover command will now start. KAVX0002-I The drmsqlrecover command will now end.
Figure 96 System configuration for restoring and recovering from a host not used for backup (when backing up) CLI User Guide 341
Figure 97 System configuration for restoring and recovering from a host not used for backup (when restoring) The following conditions are assumed: • The primary volumes are formatted with NTFS, and are mounted on the D and E drives. Both volumes are used for the SQL Server database. A volume used for storing data files cannot also be used to store logs. • The primary and secondary volumes are mirrored (as set by the volume replication function and RAID Manager).
1. Back up the SQL Server database to the secondary volumes. To perform an online backup of the SQL Server database, execute the drmsqlbackup command. PROMPT> drmsqlbackup SQL1 KAVX0001-I The drmsqlbackup command will now start. KAVX1017-I SQL Server information is being collected now. KAVX1207-I Backing up the database... KAVX0040-I The backup ID has been assigned as follows: Backup ID = 0000000001 KAVX0002-I The drmsqlbackup command will now end.
4. Transfer the exported temporary file from database server 1 to database server 2. Use the ftp (file transfer protocol) command to transfer the exported temporary file C:\temp\ EX-FILE1.drm from database server 1 to database server 2. PROMPT> ftp database-server2-name ftp> Username: (Enter the login name) ftp> password: (Enter the password) ftp> binary ftp> put C:\temp\EX-FILE1.drm ftp> quit PROMPT> 5.
7. Restore the data from the secondary volume to the primary volume. Restore the data by resynchronizing the primary and secondary volumes. To restore the data, execute the drmsqlrestore command on database server 2. PROMPT> drmsqlrestore 0000000001 -resync -nochk_host KAVX0001-I The drmsqlrestore command will now start. KAVX1316-I Performing restore pre-processing... KAVX1000-I Logged on to the SQL Server system. KAVX1300-I Restore processing will now start. KAVX1000-I Logged on to the SQL Server system.
Server 2005 or SQL Server 2008. This explanation assumes the system configuration shown in the following figure. Figure 98 System configuration for log-shipping operations The following conditions are assumed:: • The primary volumes on the source server and the volumes on the distribution target server are formatted with NTFS, and are mounted on the D and E drives, respectively.
1. Back up the SQL Server database to the secondary volumes. To perform an online backup of the SQL Server database, execute the drmsqlbackup command on the source server. PROMPT> drmsqlbackup SQL1 KAVX0001-I The drmsqlbackup command will now start. KAVX1017-I SQL Server information is being collected now. KAVX1207-I Backing up the database... KAVX0040-I The backup ID has been assigned as follows: Backup ID = 0000000001 KAVX0002-I The drmsqlbackup command will now end.
4. Transfer the metafile and the temporary file from the source server to the distribution target server. Use the ftp (file transfer protocol) command to transfer the metafile C:\METADIR\Meta1 and the exported temporary file C:\temp\EX-FILE1.drm from the source server to the distribution target server. PROMPT> ftp distribution-destination-server-name ftp> Username: (Enter the login name) ftp> password: (Enter the password) ftp> binary ftp> put C:\temp\EX-FILE1.
8. Restore the backup data to the distribution target server volumes. Check that the backup data has been copied to the distribution target server volumes, and then restore the backup data from the distribution target server. When restoring, apply the metafile to the backup data without recovering the backup data from the secondary volumes to the primary volumes, and place the database into standby status.
Figure 99 System configuration for setting a distribution target server to be an operating server The following conditions are assumed: • The distribution target server volumes are formatted with NTFS, and are mounted on the D and E drives. • The drmsqlinit command has been executed on the distribution target server. • The system databases (master, model, and msdb) are not specified when restoring. • The database on the distribution target server is in the standby status.
2. Place the standby database online. To use a Application Agent command after restoring the database, execute the drmsqldisplay command with the -refresh option. Backing up and restoring in a cascade configuration or multi-target configuration Application Agent supports backups to and restorations from a secondary volume at a remote site (in a cascade configuration).
• The primary volume at the local site and the primary volume at the remote site must be defined as a pair in Continuous Access Software. The primary and secondary volumes at each site must be defined as a pair in Business Copy. • The same RAID Manager instance number is defined at both the local and remote sites. • The SQL Server data files and transaction log files must have the same directory structure at both the local and remote sites.
4. After the pair status of the Continuous Access Software pair volume is changed to PAIR, perform takeover. To perform takeover, execute the RAID Manager command at the remote site. PROMPT> paircreate -g Cnt Ac01 -vr ( or pairresync -g Cnt Ac01 ) PROMPT> pairevtwait -g Cnt Ac01 -t 600 -s pair PROMPT> horctakeover -g Cnt Ac01 5. Mount the Continuous Access Software pair volume at the remote site and restart SQL Server. The mount point name to mount must be same as the mount point name at the local site.
12. Create a user script file. To obtain the information required to create a user script file, execute the drmsqldisplay command on the database server at the local site. For details on how to create a user script file, see “Creating a User Script to Perform a Backup in a Cascade Configuration” on page 356. PROMPT> drmsqldisplay default -remote INSTANCE: default T DB OBJECT FILE TID# LUN# MU# LDEV# P/S SERIAL# D UserDB1 DATAFILE Z:\UserDB1_Data.
18. Create a template catalog at the remote site. To create a template catalog, execute the drmsqlbackup command on the database server at the remote site. The drmsqlbackup command does not perform backup when it is used to create a template catalog. PROMPT> drmsqlbackup default -template KAVX0001-I The drmsqlbackup command will now start. KAVX1017-I SQL Server information is being collected now. KAVX0085-I Now making backup information...
Creating a User Script to Perform a Backup in a Cascade Configuration To perform backup in a cascade configuration, you need to create a user script file.
• If you set TIMEOUT to 0, the drmsqlbackup command does not finish unless the command executed by the user script file finishes. Keep this in mind when you specify the timeout setting. • When you want to stop an executing command (for example, when a command executed by a user script file does not respond), enter Ctrl+C from the keyboard, or use the Windows Task Manager to terminate the command processing. (The command processing is executed by the user script file, and not by the drmsqlbackup command.
- C D UserDB P - - - - C T UserDB P - - - - C PROMPT> - 55555 DATAFILE 55014 - - - - 55555 TRANSACT 55014 - - - - 55555 Cnt Ac01,sql01 P:\UserDB_Data.NDF - BC01,sql02 BC02,sql02 BC03,sql02 Cnt Ac01,sql02 O:\UserDB_Log.
Figure 103 Flow of script-specified operations performed when local backup is not involved Script code LOCAL_BACKUP=NO ...(1) Description (1) Specifies that the database should not be backed up to the local site secondary volume (backed up only to the remote site secondary volume). [RESYNC_PROC] ...
Script code Description CMDLINE=C:\HORCM\etc\pairresync.exe -g Cnt Ac01 -FBC 0 ...(3) (3) Batch resynchronization with a pair group specified ENV=HORCC_MRCF= ...(4) (4) Specifies HORC environment execution. ENV=HORCMINST=0 ...(5) (5) Specifies an instance number. END_CODE=TERMINATE_NZ ...(6) TIMEOUT=10 ...(7) [CMD] CMDLINE=C:\HORCM\etc\pairevtwait.exe -g Cnt Ac01 -d sql01 -s pair -t 600 -FBC 0 ...(8) ENV=HORCMINST=0 ...(9) END_CODE=TERMINATE_NZ ...
Script code TIMEOUT=0 ...(15) Description (15) Waits for command termination. [SPLIT_PROC] ...(16) # Target pair volumes: SI11 dev group (16) User processing for pair splitting. [CMD] CMDLINE=C:\HORCM\etc\pairsplit.exe -g Cnt Ac01 -FBC 0 ...(17) (17) Batch splitting with a pair group specified ENV=HORCC_MRCF= ...(18) (18) Specifies HORC environment execution. ENV=HORCMINST=0 ...(19) (19) Specifies an instance number. END_CODE=TERMINATE_NZ ...
Script code CMDLINE=C:\HORCM\etc\pairevtwait.exe -g Cnt Ac01 -d sql02 -s psus -t 600 -FBC 0 ...(26) ENV=HORCMINST=0 ...(27) Description (26) Checks the sql02 pair status. Waits until the sql02 status becomes PSUS. (27) Specifies an instance number. END_CODE=TERMINATE_NZ ...(28) (28) If a non-zero return value returns, the script will terminate with an error. TIMEOUT=0 ...(29) (29) Waits for command termination. [FINISH_PROC] ...
Figure 104 Flow of script-specified operations performed when local backup is involved Table 108 Example of writing a sample script when local backup is involved Script code LOCAL_BACKUP=YES ...(1) Description (1) Specifies that the database should also be backed up at the local site secondary volume (backup in a multi-target configuration). [RESYNC_PROC] ...
Script code Description CMDLINE=C:\HORCM\etc\pairresync.exe -g Cnt Ac01 -FBC 0 ...(3) (3) Batch resynchronization with a pair group specified ENV=HORCC_MRCF= ...(4) (4) Specifies HORC environment execution. ENV=HORCMINST=0 ...(5) (5) Specifies an instance number. END_CODE=TERMINATE_NZ ...(6) TIMEOUT=10 ...(7) [CMD] CMDLINE=C:\HORCM\etc\pairevtwait.exe -g Cnt Ac01 -d sql01 -s pair -t 600 -FBC 0 ...(8) ENV=HORCMINST=0 ...(9) END_CODE=TERMINATE_NZ ...
Script code TIMEOUT=0 ...(15) Description (15) Waits for command termination. [SPLIT_PROC] ...(16) # Target pair volumes: SI11 dev group (16) User processing for pair splitting. [CMD] CMDLINE=C:\HORCM\etc\pairsplit.exe -g Cnt Ac01 -FBC 0 ...(17) (17) Batch splitting with a pair group specified ENV=HORCC_MRCF= ...(18) (18) Specifies HORC environment execution. ENV=HORCMINST=0 ...(19) (19) Specifies an instance number. END_CODE=TERMINATE_NZ ...
Script code CMDLINE=C:\HORCM\etc\pairevtwait.exe -g Cnt Ac01 -d sql02 -s psus -t 600 -FBC 0 ...(26) ENV=HORCMINST=0 ...(27) Description (26) Checks the sql02 pair status. Waits until the sql02 status becomes PSUS. (27) Specifies an instance number. END_CODE=TERMINATE_NZ ...(28) (28) If a non-zero return value returns, the script will terminate with an error. TIMEOUT=0 ...(29) (29) Waits for command termination. [FINISH_PROC] ...
1. Prepare the user script file. This sample procedure uses the following user script file: LOCAL_BACKUP=NO [RESYNC_PROC] [CMD] CMDLINE=C:\HORCM\etc\pairresync.exe -g Cnt Ac01 -d sql01 -FBC 0 ENV=HORCMINST=0 END_CODE=TERMINATE_NZ TIMEOUT=0 [SPLIT_PROC] [CMD] CMDLINE=C:\HORCM\etc\pairsplit.exe -g Cnt Ac01 -d sql01 -FBC 0 ENV=HORCMINST=0 END_CODE=TERMINATE_NZ TIMEOUT=0 [FINISH_PROC] 2. Back up the SQL Server database. PROMPT> drmsqlbackup default -script C:\Uscrip.
5. Transfer the exported temporary file from the database server to the backup server. To transfer the exported file C:\tmp\EX-FILE1.drm from the database server to the backup server, execute the ftp (file transfer protocol) command on the database server at the remote site. It is assumed here that the FTP root directory is C:\FTP_ROOT. The temporary file is named C:\ FTP_ROOT\EX-FILE1.drm and transferred to the backup server.
8. Mount the secondary volume. This step must be performed on the backup server at the remote site. It is assumed here that the mount point is "E:". PROMPT> drmmount 0000000002 -mount_pt E: KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start. Mount point = E: KAVX0401-I Mounting has finished. Mount point = E: KAVX0002-I The drmmount command will now end. PROMPT> 9. Back up the secondary volume to tape.
Backing up transaction logs in a cascade configuration without a backup catalog This section explains the steps for backing up transaction logs in a cascade configuration when the backup catalog does not exist. Here, because the starting point for backing up transaction logs is an SQL Server database that is backed up only to a secondary volume of a remote site by the drmsqlbackup command with the -script option, the -no_cat option is used. • Back up the transaction logs. Back up the transaction logs.
5. To restore data from the tape, mount the secondary volume. To mount the secondary volume, specify backup ID 0000000002. The following assumes that the mount point for the secondary volume is E:. This step must be performed on the backup server at the remote site. PROMPT> drmmount 0000000002 -mount_pt E: KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start. Mount point = E: KAVX0401-I Mounting has finished. Mount point = E: KAVX0002-I The drmmount command will now end.
8. Check the execution results of the restoration from the tape to the secondary volume. To confirm that the restoration finished successfully, execute the drmsqlcat command on the backup server at the remote site. PROMPT> drmsqlcat default -template INSTANCE: default BACKUP-ID: 0000000003 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001 START-TIME: 04.02.04 13:01:35 END-TIME: 04.02.
11. Import the temporary file into the backup catalog on the database server. To import the temporary file C:\EX-FILE1.drm (transferred from the backup server in step 10) into the backup catalog on the database server, execute the drmdbimport command on the database server of the remote site. PROMPT> drmdbimport -f C:\EX-FILE1.drm KAVX0001-I The drmdbimport command will now start. KAVX0418-I Backup information from the specified file was imported into the backup catalog.
16. Apply the transaction log file. Apply the transaction log backup file to the database to recover the SQL Server database. Execute the drmsqlrecovertool command at the remote site database server. PROMPT> drmsqlrecovertool default The drmsqlrecovertool dialog box appears. 17. Recover the SQL Server database. Recover the SQL Server database by following the instructions displayed on the dialog box.
Backing up and restoring using a backup management product that cannot link with Application Agent When using a tape backup management software that is unable to link with Application Agent, carry out the following procedure to back up an SQL Server database to tape, or restore an SQL Server database from tape. For details on operations from step 1 to step 6 in the backup procedure, see “Backing up an SQL Server database to tape” on page 298.
11. Check the storage location of the metafile. If you registered the VDI metafile storage directory when executing the drmsqlinit command, the metafile (original-ID_database-ID.dmp) is stored in the following directory: FTP_HOME_DIR-value\FTP_SUB_DIR-value\operation-ID\AP \original-ID_database-ID.dmp If you did not register the VDI metafile storage directory when executing the drmsqlinit command, the metafile is stored in the drive containing data files and transaction log files. 12.
Figure 105 System Configuration Using File Sharing to Back Up and Restore an SQL Server Database Preparing to Back Up or Restore by Using a File Share This subsection describes the preparations for backing up or restoring an SQL Server database by using file share. To prepare for backing up or restoring an SQL Server database by using a file share: 1. Check the temporary directory for extended commands that was created automatically by the check tool for operation definition files.
3. Use Explorer on the database server to allocate the temporary directory for extended commands as a network drive. In this case, C:\FTP_ROOT\script\Operation_A\BK is allocated to network drive X:. 4. On the backup server, set the permissions for the automatically generated temporary directory for extended commands, so that users executing extended commands from the database server can read and write to the directory.
To restore an SQL Server database on the backup server by using a file share: 1. Execute the drmtapecat command to check the backup ID of the backup data. 2. Execute EX_DRM_TAPE_RESTORE to restore the backed up data from tape to the secondary volume. 3. Execute EX_DRM_DB_EXPORT to export the backup information to a temporary file. 4. Execute EX_DRM_SQLFILE_PACK to back up the SQL Server metafile created at the restoration to the temporary folder. 5.
Figure 106 System configuration for restoring data to an SQL Server instance different from the backup source For example, if only the user database backed up from the SQL Server instance instA of database server 1 is restored and recovered to SQL Server instance instB of database server 2, the user database from database server 2 becomes available. System databases such as master, model, and msdb cannot be restored to a different SQL Server instance.
Additionally, execute the drmsqlinit command on database server 2 to create a database configuration definition file. In this case, do not specify the VDI metafile storage directory. Operations for restoration (recovery) To check the backup ID of the backup data before performing restoration, specify the name of the backed up SQL Server instance name isntA as an argument of the drmsqlcat command. At the time of restoration, the database is restored to SQL Server instance instB on database server 2.
To restore (recover) backup data from tape to the secondary volume: 1. Execute EX_DRM_TAPE_RESTORE to restore the SQL Server database from tape to the secondary volume. 2. Execute the drmsqlcat command with instA specified to check the backup ID. 3. Execute the drmsqlrestore command with instB specified as the -instance argument to restore the SQL Server database on the secondary volume. 4.
• Execute the drmresync command, specifying the backup ID of the data to be deleted. PROMPT> drmresync -backup_id backup-ID KAVX0001-I The drmresync command will now start. KAVX0002-I The drmresync command will now end. PROMPT> When you execute this command, the primary volume and the secondary volume are resynchronized and mirrored. Now the backup information of the specified backup ID is deleted from the backup catalog.
Figure 107 System configuration for restoring to an SQL Server instance that is different from the backup source (using a user script) The following system prerequisites apply to this example: Server configuration • The same version of SQL Server version is installed in Database Server 1 and Database Server 2. • The database file path configurations are the same in Database Server 1 and Database Server 2.
• The copy groups are composed of the following two generations: Generation 1 (VG01, VOL11 and VG01, VOL12): Used for data mining Generation 2 (VG02, VOL21 and VG02, VOL22): Used for backup User script example The following two user scripts are used in this example: script1.txt (used for data mining) LOCAL_BACKUP=YES #Pre-backup user script section [PRE_PROC] #The Protection Manager service will be started. [CMD] CMDLINE=C:\user\detach_databases.
[POST_PROC]: Executes the remote_sqlrestore.bat batch file. The contents of remote_sqlrestore.bat mount the secondary volume and execute the restore command with the -no_resync specification and the recovery command. • remote_sqlrestore.
@echo off @bpbackup -k "%DRMENV_COMMENT%" -p ptm_plc -s ptm_schd -i -S BackupServer -w -t 0 -L C:\temp \nbu.log if NOT "%ERRORLEVEL%"=="0" GOTO ABEND @drmumount %DRMENV_R_BACKUPID% if NOT "%ERRORLEVEL%"=="0" GOTO ABEND GOTO END :ABEND exit 1 :END exit 0 Example This section shows the examples used for data mining and backup. • Execute the drmsqlbackup command on the DBServer1 server to make a backup (generation 1) on the secondary volume on the DBServer2 server.
Figure 108 Configuration for using the SQL Server replication function Requirements for the publication database and the distribution database The publication database and the distribution database used in the processing of a single replication must be allocated to satisfy the following requirements: • Because backups of these two databases must be made at the same time, they must be allocated to the same SQL Server instance.
Figure 109 Configuration of backup server for the publisher/distributor server Requirements for the subscription database Because the subscription database must be restored separately from the system databases (master, model, and msdb), it must be allocated to a different volume from the system databases.
PROMPT > drmsqlbackup instA -target PubUserDB1,distribution PROMPT > • Back up the subscription database Execute the drmsqlbackup command on the subscriber server. PROMPT > drmsqlbackup instC PROMPT > • Back up the databases, including the system databases Execute the drmsqlbackup command with the -system option specified in the publisher/distributor server or the subscriber server.
Restore the databases • Restore the publication database Specify the backup ID used when the publication database and the distribution database were backed up, and execute the drmsqlrestore command on the publisher/distributor server.
Specify the backup ID used when the databases, including the system databases, were backed up, and execute the drmsqlrestore command on the publisher/distributor server or the subscriber server. PROMPT > drmsqlrestore 0000000005 -resync -target master,model,msdb PROMPT > • Restore the subscription database On the subscriber server, execute the drmsqlrestore command.
sp_replicationdboption 'database-name', 'sync with backup', 'true' For the database-name argument, specify the name of the publication database or distribution database. How to check the 'sync with backup' option To ensure that the option has been set, execute the following SQL statement: select databasepropertyex('database-name', 'IsSyncWithBackup') For the database-name in the SQL statement, specify the name of the publication database or distribution database.
Operation for SQL Server databases
7 Operation for Exchange databases This chapter explains the procedures for running Application Agent when backing up Exchange databases. The descriptions in this chapter apply to the Application Agent CLI. For details on setting up commands, see the HP StorageWorks P9000 Replication Manager Software CLI Reference Guide. The term storage group refers to a database management unit created on Exchange Server.
Event source: ftdisk Event ID: 57 or Event type: warning Event source: disk Event ID: 51 This event information is logged during a VSS backup when the secondary volume becomes temporarily hidden. However, this will not influence the backup operation.
transactions log files, a roll-forward will be completed when the drmexgrestore command is executed, but the Information Store will not be mounted. In this case, the KAVX1510-E message is output. For details on this message, contact your HP support representative for assistancè. Notes on restoring data obtained with a VSS backup • While restoring data obtained in a VSS backup, you must not open the physical disk resource properties on the cluster administrator window.
Precautions on recovery storage groups and recovery databases If you are using Exchange Server 2003 or Exchange Server 2007 as the database management system, do not specify a recovery storage group when specifying a storage group. If you are using Exchange Server 2010 as the database management system, do not specify a recovery database when specifying a database.
Figure 110 System configuration for backing up and restoring data between volumes (when the backup is of an Exchange database) Processing flow The processing flow for backing up storage groups to a secondary volume and restoring them to the primary volume on a single-server system is shown below. Execute commands on the database server.
Figure 111 Processing flow for backing up storage groups to a secondary volume Figure 112 Processing flow for restoring storage groups on the primary volume Backing up storage groups to a secondary volume This section describes the processing flow for backing up storage groups to a secondary volume on a single-server system. To back up a storage group: • Back up the storage group to a secondary volume. Back up the storage group. To perform backup, execute EX_DRM_EXG_BACKUP.
1. Check the backup ID of the backup data. To check the backup ID of the backup data used to restore it from a secondary volume to the primary volume, execute the drmexgcat command on the database server.
Figure 113 System configuration for backing up and restoring storage groups to and from tape With Application Agent, database servers can be clustered. With database servers configured in a failover cluster, if the active server fails, a standby server is available to take over operations from the active server. The examples in this section assume the following conditions: • The primary volume is NTFS-formatted.
• The primary volume configured as a pair with the secondary volume to be backed up will not be backed up until the secondary volume is backed up onto tape. • The cscript //H:Cscript command is executed from the command prompt and the host parameters are updated. Processing flow This section describes the processing flow for backing up storage groups to tape and restoring them on a multi-server system. Use extended commands to execute cold backups and backups with VSS.
Figure 114 Processing flow for backing up storage groups to tape 404 Operation for Exchange databases
Figure 115 Processing flow for restoring storage groups from tape Backing up storage groups to tape Resynchronizing copy groups When usual operation is in the split state, resynchronize the copy group before backing up the data. When usual operation is in the pair status, there is no need to resynchronize the copy group before backing up data. Instead, when the tape backup is complete, resynchronize the copy group to initialize it. To resynchronize a copy group: • Clear the cache of the secondary volume.
To back up a storage group in a cold backup: 1. Back up the storage group to a secondary volume. Perform a cold back up of the storage group. To perform backup, execute EX_DRM_EXG_BACKUP. Specify the operation ID Operation_A as the argument. In the following example, the command deletes the transaction log file and backs up the database: DBServer > EX_DRM_EXG_BACKUP Operation_A -mode cold -transact_log_del 2. Check that the storage group has been backed correctly.
6. Back up the data of the secondary volume to a tape. To back up the data, execute EX_DRM_TAPE_BACKUP on the backup server. In this example, the drive containing the secondary volume is E:. BKServer > EX_DRM_TAPE_BACKUP Operation_A -mount_pt E: When you execute backup, information about this backup is registered in the backup catalog with the new backup ID 0000000002. Online backup An example of backing up a storage group to tape in an online backup operation is described below.
4. Transfer the temporary files to the backup server. Transfer the temporary files from the database server to the backup server all at once. To transfer these files, execute the EX_DRM_FTP_PUT command on the database server. In the following example, the command uses the user ID admin and the password password to log on to the FTP server. The temporary files are stored in the temporary folder for extended commands, on the backup server.
2. Check that the storage group has been backed up correctly. To check that backup information bearing the date on which the storage group had been backed up from the primary volume to the secondary volume is available, execute the drmexgcat command on the database server.
(recovers) the data from the secondary volume to the the primary volume by resynchronizing the volumes. This example uses Operation_A as the operation ID. To perform restoration of data from a VSS backup, the Protection Manager service must be running on the backup server. To restore a storage group: 1. Check the backup ID of the backup data. To check the backup ID of the backup data used to restore the data from tape to the secondary volume, execute the drmtapecat command on the backup server.
6. Restore the data from the secondary volume to the primary volume. Restore the data by resynchronizing the primary and secondary volumes. To restore the data, execute EX_DRM_EXG_RESTORE on the database server. DBServer > EX_DRM_EXG_RESTORE Operation_A -resync -recovery Supplementary information If data was backed up using VSS, the data can be restored in units of Information Stores. To restore data in units of Information Stores, specify the Information Store name in the -target option.
Figure 116 System configuration for backup of a storage group to tape Processing flow In this example, the processing flow of the drmexgbackup command that specifies a user script is as follows: • A VSS backup of the storage group is performed. • Once the backup from the primary volume to the secondary volume has been completed, the backup catalog is transferred to the backup server. • On the backup server, the secondary volume is mounted on the G and H drives.
Figure 117 Processing flow User script example The table below shows the user script that is created for the example. Table 109 User script creation example Script text Explanation LOCAL_BACKUP=YES ...(1) #Pre-processing section (1) YES is required. #None #Post-processing section [POST_PROC] ...
Script text Explanation [CMD] CMDLINE=C:\tmp\tapebackup.bat TIMEOUT=NOWAIT ...(3) (3) Execute the next command without waiting for the command to terminate. END_CODE=TERMINATE_NZ ...(4) (4) Treat a command return value that is a value other than 0 as an error. LOCATION=REMOTE ...(5) PARENT_STAT=NORMAL ...(6) (5) Execute on the remote server. The -s option is required for the backup command. (6) Execute only when the backup command is normal.
rolled forward by specifying the -recovery option. In this case, by applying the transaction logs after backup, the database can be recovered to the state it was in immediately before the error occurred. The procedure for using the transaction logs of Exchange Server to restore backup data by using roll-forward is described below. The figure below shows a flow of operation using transaction logs.
and rolling forward transaction logs. (If restoration is executed in units of Information Stores, you must roll forward transaction logs at the time of restoration.) Figure 119 System configuration for restoring data in units of Information Stores by applying transaction logs The prerequisites for this example are the same as for backup and restoration using VSS plus the prerequisites that follow: • Only the data files (*.edb and *.stm) in the Information Store are stored on the same disk.
1. Check the backup ID and Information Store name of the backup data. To check the backup ID and Information Store name, execute the drmexgcat command. The backup ID is displayed in BACKUP-ID and the Information Store name is displayed in INFORMATIONSTORE. Since this example restores the mailbox store, check the Information Store name of the item for which OBJECT is MAILBOXSTORE.
volume replication functionality such as Continuous Access Software or Continuous Access Journal, which allows you to copy data between storage systems. The following examples are provided: • Backing up storage groups to a remote site. • Restoring the storage groups backed up in the remote site to the local site (if the local site is operating properly) The examples in this section assume the system configuration shown in the following figure.
• Continuous Access Software volume is configured as a pair (usual operation is in the pair status) with the copy group names Cnt Ac01,EXG11 and Cnt Ac02,EXG12. • A storage group STR1 exists on the database server (DBServer) in the local site, and services are running. • The volume (usual operation is in the pair status) Cnt Ac01,EXG11 for Continuous Access Software or Continuous Access Journal contains the data files for the storage group STR1.
Operations at the local site 1. Check the volume on which the database will be backed up and the generation identifier. Execute the drmexgdisplay command on the database server. DBServer > drmexgdisplay -cf STORAGEGROUP: STR1 T OBJECT INFORMATIONSTORE FILE FS COPY-GROUP COPY-FUNC GEN-NAME M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: BC01,EXG01 Business Copy local_0 - BC01,EXG01 Business Copy local_0 M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.
3. Check that the storage group has been backed correctly. To check that backup information on which the storage group had been backed up is available, execute the drmexgcat command on the database server. DBServer > drmexgcat STORAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: COLD STORAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2004/08/05 10:00:00 END-TIME: 2004/08/05 10:01:00 HOSTNAME:DBServer T OBJECT INFORMATIONSTORE FILE FS DG DEVICE COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.
2. Check that the temporary file has been imported correctly. To check that backup information bearing the date on which the storage groups had been backed up from the primary volume to the secondary volume has been imported into the backup server, execute the drmexgcat command on the backup server.
Restoring a storage group to a local site This section explains how to restore a storage group to a local site when the local site is operating normally without any failures. The procedures for restoring the data to a local site and to a remote site are explained separately. Operations at the remote site To restore a storage group to a local site: 1. Split the Continuous Access Software pair (usual operation is in the pair status).
4. Check that the storage group has been stored from the tape to the second volume correctly. To check that backup information bearing the date on which the storage group had been backed up from the primary volume to the second volume has been restored, execute the drmexgcat command on the backup server.
2. Import the temporary files, which were transmitted from the database server, into the backup catalog on the database server. To import the temporary files, which were transmitted from the database server, into the backup catalog on the database server, execute EX_DRM_DB_IMPORT. DBServer >EX_DRM_DB_IMPORT Operation_A 3. Check that the temporary file has been imported correctly.
• Performing backups using VSS concurrently at both the local and remote sites (backup data is created on secondary volumes). In this example, the backup data on the secondary volumes is then backed up to a tape device at both the local and remote sites. • Restoring data using the backup data on the tape device at the local site. • Restoring data using the backup data on the tape device at the remote site. The examples in this section assume the system configuration shown in the following figure.
• Disks P2 and P4 are mounted as E: drives. • An information storage configuration file for the active server storage group (STR1) is stored on disk P1. • A transaction log file and a checkpoint file for the active server storage group (STR1) are stored on disk P2. • Continuous Access Synchronous Software is configured between disks P1 and P3, and between disks P2 and P4.
Host name = name-of-backup-server-B KAVX5404-I Processing to resynchronize a copy group was performed by using name-of-database-server-B. KAVX1610-I Verification of the database on the backup server will now be performed. Storage group name = 1st File size = 3 MB KAVX1611-I Verification has finished successfully. KAVX5405-I Backup post-processing will now be performed by using name-of-database-server-B. KAVX0256-I A connection to the Protection Manager service will now be established.
Operation at both the local and remote sites 1. Confirm that the backups were performed correctly. Execute the drmexgcat command on database server A to check the backup catalog information: DBServer A > drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.
2. Confirm that the files were imported correctly.
3. Back up the backup data on the secondary volumes to tape. Execute the drmmediabackup command on backup server A to back up the backup data on the secondary volume to tape: BKServer A > drmmediabackup 0000000001 KAVX0001-I The drmmediabackup command will now start. KAVX0402-I Backup processing will now start. To see more details on backup progress, use the monitoring method of the backup management product. Source = W: KAVX0402-I Backup processing will now start.
4. Confirm that the data was correctly backed up to tape.
5. Unmount the secondary volumes on which the backup data is stored. Execute the drmumount command on backup server A to unmount the secondary volume: BKServer A > drmumount 0000000001 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = W: KAVX0407-I Unmounting has finished. Mount point = W: KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished. Mount point = X: KAVX0232-I Hid EXG001,B001. KAVX0232-I Hid EXG002,B001.
2. Mount the secondary volume to which the backup data will be restored. Execute the drmmount command on backup server A to mount the secondary volume: BKServer A > drmmount 0000000002 -mount_pt W: KAVX0001-I The drmmount command will now start. KAVX0233-I Made EXG001,B001 open. KAVX0233-I Made EXG002,B001 open. KAVX0234-I Rerecognizes the physical volume. KAVX0235-I Rerecognized the physical volume. KAVX0400-I Mounting will now start. Mount point = W: KAVX0401-I Mounting has finished.
4. Confirm that the data was restored correctly from the tape to the secondary volume.
7. Transfer the temporary file to the database server. Using ftp on database server A, transfer the temporary file from backup server A to database server A: BKServer A > ftp name-of-database-server-A ftp> Username: (Enter the login name) ftp> password: (Enter the password) ftp> get 0000000003.drm ftp> quit BKServer A > 8. Import the temporary file transferred from the backup server into the backup catalog on the database server.
10. Separate the Continuous Access Software pair.
2. Check the backup ID of the backup data. To check the backup ID, execute the drmtapecat command on backup server B: BKServer B > drmtapecat BACKUP-ID BACKUP-OBJECT 0000000012 MSEXCHANGE BKServer B > 3. SNAPSHOT TIME 2007/11/01 11:00:00 EXPIRATION TIME 2007/11/01 11:30:00 BACKUP-MEDIA MEDIA1 Mount the secondary volume to which the backup data will be restored.
5. Confirm that the data was restored correctly from the tape to the secondary volume.
8. Transfer the temporary file to the database server. Using ftp on database server B, transfer the temporary file from backup server B to database server B: BKServer B > ftp name-of-database-server-A ftp> Username: (Enter the login name) ftp> password: (Enter the password) ftp> get 0000000013.drm ftp> quit BKServer B > 9. Import the temporary file transferred from the backup server into the backup catalog on the database server.
11. Separate the Continuous Access Software pair.
• Performing a VSS backup on the standby server (backup data is created on a secondary volume). In this example, the backup data on the secondary volume is then backed up to a tape device. • Restoring on the active server backup data that was acquired on the active server • Performing a fail-over of the active server, and switching the standby server to the active server.
• Initially, database server A is the active server (the one on which the Exchange virtual server is running). Database server B is the standby server. • NetBackup is installed as the tape backup management software on the backup servers, and the configuration definitions for the tape library devices are defined. • The dictionary map files on both the active and standby servers are updated with the latest information. • Disks P1 and P3 are mounted as D: drives. • Disks P2 and P4 are mounted as E: drives.
Performing a backup on the active server 1. Clear the system cache on the backup server. To clear the system cache, execute the drmmount command on backup server A to temporarily mount the secondary volume. Then, use the drmumount command to unmount the volume. BKServer A > drmmount -copy_group EXG001,B001 -mount_pt W: KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start. Mount point = W: KAVX0401-I Mounting has finished.
3. Confirm that the data was backed up correctly. Execute the drmexgcat command on database server A, and check the backup information. DBServer A > drmexgcat -target STR1 STRAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.
7. Confirm that the file was imported correctly. Execute the drmexgcat command on backup server A to check whether the backup information for the date on which backup from the primary volume to the secondary volume was performed was imported to backup server A.
9. Back up the backup data on the secondary volume to tape. Execute the drmmediabackup command on backup sever A to back up the backup data on the secondary volume to tape. An unused backup ID of 0000000002 is assigned. BKServer A > drmmediabackup 0000000001 KAVX0001-I The drmmediabackup command will now start. KAVX0402-I Backup processing will now start. To see more details on backup progress, use the monitoring method of the backup management product.
Performing a backup on the standby server 1. Clear the system cache on the backup server. To clear the system cache, execute the drmmount command on backup server B to temporarily mount the secondary volume. Then, use the drmumount command to unmount the volume. BKServer B > drmmount -copy_group EXG003,B001 -mount_pt W: KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start. Mount point = W: KAVX0401-I Mounting has finished.
3. Confirm that the data was backed up correctly. Execute the drmexgcat command on database server B, and check the backup information. DBServer B > drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: EXG003,B001 - EXG003,B001 P PUBLICSTORE PUBLIC1(STR1) D:\STR1\pub1.
7. Confirm that the file was imported correctly. Execute the drmexgcat command on backup server B to check whether the backup information for the date on which backup from the primary volume to the secondary volume was performed was imported to backup server B.
9. Back up the backup data on the secondary volume to tape. Execute the drmmediabackup command on backup server B to back up the backup data on the secondary volume to tape. An unused backup ID of 0000000002 is assigned. BKServer B > drmmediabackup 0000000001 KAVX0001-I The drmmediabackup command will now start. KAVX0402-I Backup processing will now start. To see more details on backup progress, use the monitoring method of the backup management product.
Restoring data when using the automatic seed function The following subsections provide examples of restoring data using different backup servers for the active and standby servers. This example uses the automatic seed function during the restore operation. Restoring backup data acquired on the active server (when the automatic seed function is used) This subsection gives an example of performing a point-in-time restore operation on a storage group, using backup data that was acquired on the active server.
3. Restore the backup data from the tape to the secondary volume. Execute the drmmediarestore command on backup server A to restore the backup data on tape to the secondary volume. BKServer A > drmmediarestore 0000000002 KAVX0001-I The drmmediarestore command will now start. KAVX0404-I Restoration will now start. To see more details on restoration progress, use the monitoring method of the backup management product. Source = W: Target = W: KAVX0404-I Restoration will now start.
5. Unmount the secondary volume after restoration of the backup data is finished. Execute the drmumount command on backup server A to unmount the secondary volume. BKServer A > drmumount 0000000002 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = W: KAVX0407-I Unmounting has finished. Mount point = W: KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished. Mount point = X: KAVX0002-I The drmumount command will now end.
9. Confirm that the file was imported correctly. Execute the drmexgcat command on database server A to check whether the backup information for the date on which backup from the primary volume to the secondary volume was performed was imported to database server A.
Restoring backup data acquired on the standby server (when the automatic seed function is used) This subsection gives an example of performing a roll-forward restore operation on a storage group, using backup data that was acquired on the standby server. 1. Perform a failover operation so that the Exchange virtual server running on database server A fails over to database server B. 2. Check the backup ID of the backup data. To check the backup ID, execute the drmtapecat command on backup server B.
4. Restore the backup data from the tape to the secondary volume. Execute the drmmediarestore command on backup server B to restore the backup data on tape to the secondary volume. BKServer B > drmmediarestore 0000000002 KAVX0001-I The drmmediarestore command will now start. KAVX0404-I Restoration will now start. To see more details on restoration progress, use the monitoring method of the backup management product. Source = W: Target = W: KAVX0404-I Restoration will now start.
6. Unmount the secondary volume after restoration of the backup data is finished. Execute the drmumount command on backup server B to unmount the secondary volume. BKServer B > drmumount 0000000002 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = W: KAVX0407-I Unmounting has finished. Mount point = W: KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished. Mount point = X: KAVX0002-I The drmumount command will now end.
10. Confirm that the file was imported correctly. Execute the drmexgcat command on database server B to check whether the backup information for the date on which backup from the primary volume to the secondary volume was performed was imported to database server B.
Restoring data when not using the automatic seed function The following subsections provide examples of restoring data using different backup servers for the active and standby servers. Restoring Data Using Different Backup Servers for the Active and Standby Servers.
3. Restore the backup data from the tape to the secondary volume. Execute the drmmediarestore command on backup server A to restore the backup data on tape to the secondary volume. BKServer A > drmmediarestore 0000000002 KAVX0001-I The drmmediarestore command will now start. KAVX0404-I Restoration will now start. To see more details on restoration progress, use the monitoring method of the backup management product. Source = W: Target = W: KAVX0404-I Restoration will now start.
5. Unmount the secondary volume after restoration of the backup data is finished. Execute the drmumount command on backup server A to unmount the secondary volume. BKServer A > drmumount 0000000002 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = W: KAVX0407-I Unmounting has finished. Mount point = W: KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished. Mount point = X: KAVX0002-I The drmumount command will now end.
9. Confirm that the file was imported correctly. Execute the drmexgcat command on database server A to check whether the backup information for the date on which backup from the primary volume to the secondary volume was performed was imported to database server A.
Restoring backup data acquired on the standby server (when the automatic seed function is not used) This subsection gives an example of performing a roll-forward restore operation on a storage group, using backup data that was acquired on the standby server. 1. Perform a failover operation so that the Exchange virtual server running on database server A fails over to database server B. 2. Check the backup ID of the backup data. To check the backup ID, execute the drmtapecat command on backup server B.
4. Restore the backup data from the tape to the secondary volume. Execute the drmmediarestore command on backup server B to restore the backup data on tape to the secondary volume. BKServer B > drmmediarestore 0000000002 KAVX0001-I The drmmediarestore command will now start. KAVX0404-I Restoration will now start. To see more details on restoration progress, use the monitoring method of the backup management product. Source = W: Target = W: KAVX0404-I Restoration will now start.
6. Unmount the secondary volume after restoration of the backup data is finished. Execute the drmumount command on backup server B to unmount the secondary volume. BKServer B > drmumount 0000000002 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = W: KAVX0407-I Unmounting has finished. Mount point = W: KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished. Mount point = X: KAVX0002-I The drmumount command will now end.
10. Confirm that the file was imported correctly. Execute the drmexgcat command on database server B to check whether the backup information for the date on which backup from the primary volume to the secondary volume was performed was imported to database server B.
System configuration A system configuration example is shown below. Figure 123 System configuration for an SCR system For the backup and restoration examples below, please assume the following: • If a backup operation is backing up a secondary volume to a tape device, another primary volume cannot be backed up until the current operation finishes. • NetBackup is the tape backup management software on the backup servers, and the configuration definitions for the tape library devices are defined.
• Each disks contains the following. Disk number Object Disk P1 The information storage configuration file for the source storage group (STR1). Disk P2 The transaction log file and checkpoint file for the source storage group (STR1). Disk P3 The information storage configuration file for the target storage group (STR1). Disk P4 The transaction log file and checkpoint file for the target storage group (STR1).
2. Clear the system cache right before performing a backup. To clear the system cache, temporarily mount the secondary volume on the backup server. PROMPT> drmmount -copy_group EXG001,B001 -mount_pt W: KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start. Mount point = W: KAVX0401-I Mounting has finished. Mount point = W: KAVX0002-I The drmmount will now end. PROMPT> drmumount -copy_group EXG001,B001 KAVX0001-I The drmumount command will now start.
4. From the source server, confirm that the backup was successful. PROMPT> drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: EXG001,B001 - EXG001,B001 P PUBLICSTORE PUBLIC1(STR1) D:\STR1\pub1.edb D: EXG001,B001 - EXG001,B001 T TRANSACT E:\STR1\E00*.
8. Check the backup catalog information that was imported into the backup server. PROMPT> drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000001 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: EXG001,B001 - EXG001,B001 P PUBLICSTORE PUBLIC1(STR1) D:\STR1\pub1.edb D: EXG001,B001 - EXG001,B001 T TRANSACT E:\STR1\E00*.
10. From the backup server, back up the data on the secondary volume to a tape device. An unused backup ID (0000000002) is assigned. PROMPT> drmmediabackup 0000000001 KAVX0001-I The drmmediabackup command will now start. KAVX0402-I Backup processing will now start. To see more details on backup progress, use the monitoring method of the backup management product. Source = W: KAVX0402-I Backup processing will now start.
2. From the backup server, check the backup ID of the tape device. PROMPT> drmtapecat BACKUP-ID BACKUP-OBJECT 0000000002 MSEXCHANGE PROMPT> 3. SNAPSHOT TIME 2002/06/01 11:00:00 EXPIRATION TIME 2002/06/02 11:00:00 BACKUP-MEDIA MEDIA1 From the backup server, mount the secondary volume to restore data from the tape device. Specify the backup ID 0000000002, and then execute the drmmount command. PROMPT> drmmount 0000000002 -mount_pt W: KAVX0001-I The drmmount command will now start.
5. From the backup server, confirm that the restoration from the tape device to the secondary volume was successful. PROMPT> drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000003 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: EXG001,B001 - EXG001,B001 P PUBLICSTORE PUBLIC1(STR1) D:\STR1\pub1.
9. Import the transferred temporary file on the source server into the backup catalog. A new backup ID is registered into the backup catalog. An unused backup ID (0000000002) is assigned. PROMPT> drmdbimport -f C:\0000000005.drm KAVX0001-I The drmdbimport command will now start. KAVX0418-I Backup information from the specified file was imported into the backup catalog. Imported backup ID = 0000000002 KAVX0002-I The drmdbimport command will now end. PROMPT> 10.
Point-in-time restoration when not using the SCR seed function This section gives an example of how to perform a point-in-time restoration on a storage group, using backed up data that was acquired in an SCR configuration, and without using the SCR seed function. This example uses the backup data acquired in “Backing up in an SCR configuration” on page 469. 1. From the backup server, start the Protection Manager service. 2. From the backup server, check the backup ID of the tape device.
5. From the backup server, confirm that the restoration from the tape device to the secondary volume was successful. PROMPT> drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000003 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: EXG001,B001 - EXG001,B001 P PUBLICSTORE PUBLIC1(STR1) D:\STR1\pub1.
9. Import the transferred temporary file on the source server into the backup catalog. A new backup ID is registered into the backup catalog. An unused backup ID (0000000002) is assigned. PROMPT> drmdbimport -f C:\0000000005.drm KAVX0001-I The drmdbimport command will now start. KAVX0418-I Backup information from the specified file was imported into the backup catalog. Imported backup ID = 0000000002 KAVX0002-I The drmdbimport command will now end. PROMPT> 10.
Point-in-time restoration when using the SCR seed function This section gives an example of how to perform a point-in-time restoration on a storage group, using backed up data that was acquired in an SCR configuration, and using the SCR seed function. This example uses the backup data acquired in “Backing up in an SCR configuration” on page 469. 1. From the backup server or target server, start the Protection Manager service. 2. From the backup server, check the backup ID of the tape device.
5. From the backup server, confirm that the restoration from the tape device to the secondary volume was successful. PROMPT> drmexgcat STRAGEGROUP: STR1 BACKUP-ID:0000000003 BACKUP-MODE: VSS STRAGEGROUP: STR1 ORIGINAL-ID:0000000001 START-TIME:2007/11/01 10:00:00 END-TIME: 2007/11/01 10:05:00 HOSTNAME:EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG COPY-GROUP M MAILBOXSTORE MAILBOX1(STR1) D:\STR1\priv1.edb D: EXG001,B001 - EXG001,B001 P PUBLICSTORE PUBLIC1(STR1) D:\STR1\pub1.
9. Import the transferred temporary file on the source server into the backup catalog. A new backup ID is registered into the backup catalog. An unused backup ID (0000000002) is assigned. PROMPT> drmdbimport -f C:\0000000005.drm KAVX0001-I The drmdbimport command will now start. KAVX0418-I Backup information from the specified file was imported into the backup catalog. Imported backup ID = 0000000002 KAVX0002-I The drmdbimport command will now end. PROMPT> 10.
11. While the SCR seed function is still enabled, perform a point-in-time restoration on the backup data from the secondary volume to the primary volume. PROMPT> drmexgrestore 0000000002 -resync -recovery -ef exchange.conf KAVX0001-I The drmexgrestore command will now start. KAVX1526-I The Exchange environment configuration file has been read. Exchange environment configuration file = exchange.conf KAVX0256-I A connection to the Protection Manager service will now be established.
Figure 124 System Configuration for Backing Up and Restoring Data in a DAG Configuration For the backup and restoration examples below, assume the following: • If the backup operation is backing up a secondary volume to a tape device, another primary volume cannot be backed up until the current operation finishes. • In the initial status, disks P1 and P2 of database server 1 are the active mailbox database copies.
Disk number Object Disk P1 The database file for the active mailbox database copy Mail01 Disk P2 The transaction log file and checkpoint file for the active mailbox database copy Mail01 Disk P3 The database file for the passive mailbox database copy Mail01 Disk P4 The transaction log file and checkpoint file for the passive mailbox database copy Mail01 • Pair definitions have been defined for the primary and secondary volumes in a RAID Manager configuration definition file on the database server a
2. On database server 1, perform a VSS backup from the primary volume to the secondary volume. A new backup ID is registered in the backup catalog. The unused ID 0000000001 is set for the backup ID. The backup catalog is imported into backup server 1. PROMPT> drmexgbackup –mode vss -s backup server 1 -auto_import KAVX0001-I The drmexgbackup command will now start. KAVX0256-I A connection to the Protection Manager service will now be established.
4. Check the imported backup catalog information on backup server 1. PROMPT> drmexgcat STORAGEGROUP: /EXCHANGE BACKUP-ID: 0000000001 BACKUP-MODE: VSS STORAGEGROUP: /EXCHANGE ORIGINAL-ID: 0000000001 START-TIME: 2010/01/01 11:00:00 END-TIME: 2010/01/01 11:30:00 HOSTNAME: EXG_SRV1 T OBJECT INFORMATIONSTORE FILE FS DG DEVICE COPY-GROUP M MAILBOXSTORE EXG001,B001 - EXG001,B001 T TRANSACT EXG001,B002 - EXG001,B002 C CHECKPOINT EXG001,B002 - EXG001,B002 PROMPT> 5. Mail1 D:\Mail1\mail.
7. On backup server 1, verify that the backup to the tape device was completed successfully. PROMPT> drmtapecat -backup_id 0000000002 BACKUP-ID BACKUP-OBJECT SNAPSHOT TIME 0000000002 MSEXCHANGE 2010/01/01 12:00:00 PROMPT> 8. EXPIRATION TIME 2010/01/01 13:00:00 BACKUP-MEDIA MEDIA1 On backup server 1, unmount the secondary volume on which the backup data is stored. Unmount the secondary volume with backup ID 0000000001 (set when the temporary file was imported).
2. On database server 2, perform a VSS backup from the primary volume to the secondary volume. A new backup ID is registered in the backup catalog. The unused ID 0000000001 is set for the backup ID. The backup catalog is imported into backup server 2. PROMPT> drmexgbackup –mode vss -s backup server 2 -auto_import KAVX0001-I The drmexgbackup command will now start. KAVX0256-I A connection to the Protection Manager service will now be established.
4. Check the imported backup catalog information on backup server 2. PROMPT> drmexgcat STORAGEGROUP: /EXCHANGE BACKUP-ID: 0000000001 BACKUP-MODE: VSS STORAGEGROUP: /EXCHANGE ORIGINAL-ID: 0000000001 START-TIME: 2010/01/01 11:00:00 END-TIME: 2010/01/01 11:30:00 HOSTNAME: EXG_SRV2 T OBJECT INFORMATIONSTORE FILE FS DG DEVICE COPY-GROUP M MAILBOXSTORE EXG002,B001 - EXG002,B001 T TRANSACT EXG002,B002 - EXG002,B002 C CHECKPOINT EXG002,B002 - EXG002,B002 PROMPT> 5. Mail1 D:\Mail1\mail.
7. On backup server 2, verify that the backup to the tape device was completed successfully. PROMPT> drmtapecat -backup_id 0000000002 BACKUP-ID BACKUP-OBJECT SNAPSHOT TIME 0000000002 MSEXCHANGE 2010/01/01 12:00:00 PROMPT> 8. EXPIRATION TIME 2010/01/01 13:00:00 BACKUP-MEDIA MEDIA1 On backup server 2, unmount the secondary volume on which the backup data is stored. Unmount the secondary volume with backup ID 0000000001 (set when the temporary file was imported).
4. On backup server 1, restore the backup data from the tape device to the secondary volume. Execute the drmmediarestore command with backup ID 0000000002 specified. The backup ID 0000000001 is deleted, and the new backup ID 0000000003 is registered. PROMPT> drmmediarestore 0000000002 KAVX0001-I The drmmediarestore command will now start. KAVX0404-I Restoration will now start. To see more details on restoration progress, use the monitoring method of the backup management product.
7. On backup server 1, export the backup catalog information to the temporary file. PROMPT> drmdbexport 0000000003 -f C:\FTP_ROOT\0000000003.drm KAVX0001-I The drmdbexport command will now start. KAVX0002-I The drmdbexport command will now end. PROMPT> 8. On backup server 1, use FTP to transfer the exported temporary file to database server 1. PROMPT> ftp-database-server-1-name ftp> Username: Enter the login name ftp> password: Enter the password ftp> get 0000000003.drm ftp> quit PROMPT> 9.
11. On the backup server, perform a roll-forward restore operation for the data on the secondary volume to the primary volume. Do this with the seed function enabled. PROMPT> drmexgrestore 0000000002 -resync –recovery –ef exchange.conf KAVX0001-I The drmexgrestore command will now start. KAVX1526-I The Exchange environment configuration file has been read. Exchange environment configuration file = exchange.conf KAVX0256-I A connection to the Protection Manager service will now be established.
4. On backup server 2, mount the secondary volume to restore the backup data from the tape device. Execute the drmmount command with backup ID 0000000002 specified. PROMPT> drmmount 0000000002 –mount_pt W: KAVX0001-I The drmmount command will now start. KAVX0400-I Mounting will now start. Mount point = W: KAVX0401-I Mounting has finished. Mount point = W: KAVX0400-I Mounting will now start. Mount point = X: KAVX0401-I Mounting has finished. Mount point = X: KAVX0002-I The drmmount command will now end.
7. On backup server 2, unmount the secondary volume on which the restore operation from the tape device has been completed. Execute the drmumount command with backup ID 0000000002 specified. PROMPT> drmumount 0000000002 KAVX0001-I The drmumount command will now start. KAVX0406-I Unmounting will now start. Mount point = W: KAVX0407-I Unmounting has finished. Mount point = W: KAVX0406-I Unmounting will now start. Mount point = X: KAVX0407-I Unmounting has finished.
11. On database server 2, check the execution result of the import operation. PROMPT> drmexgcat STORAGEGROUP: /EXCHANGE BACKUP-ID: 0000000001 BACKUP-MODE: VSS STORAGEGROUP: /EXCHANGE ORIGINAL-ID: 0000000001 START-TIME: 2010/01/01 11:00:00 END-TIME: 2010/01/01 11:30:00 HOSTNAME: EXG_SRV2 T OBJECT INFORMATIONSTORE FILE FS DG DEVICE COPY-GROUP M MAILBOXSTORE Mail1 D:\Mail1\mail.edb D: Harddisk2 EXG002,B001 - EXG002,B001 T TRANSACT Mail1 E:\Mail1\E01*.
1. When usual operation is in the split state, execute EX_DRM_CACHE_PURGE to clear the secondary volume cache. 2. When usual operation is in the split state, execute EX_DRM_RESYNC to resynchronize the copy group. 3. Execute EX_DRM_EXG_BACKUP to back up the file system to the secondary volume. 4. Execute EX_DRM_DB_EXPORT to export the backup information to temporary files. 5. Execute EX_DRM_FTP_PUT to transfer the temporary files to the backup server. 6.
1. Check the temporary directory for extended commands that was created automatically by the check tool for operation definition files. For more information about where the temporary directory for extended commands is created automatically, see “CheckingChecking the temporary directory for extended commands” on page 201. 2. Running Explorer or any other tool, share the temporary directory for extended commands that is on the backup server. 3.
To restore storage groups on the backup server by using a file share: 1. Execute the drmtapecat command to check the backup ID of the backup data. 2. Execute EX_DRM_TAPE_RESTORE to restore the backup data from the tape to the secondary volume. 3. Execute EX_DRM_DB_EXPORT to export backup information to a temporary file. 4. Copy the temporary files from the backup server to the database server.
8 Troubleshooting This chapter explains how to deal with problems that may occur during the operation of Application Agent. The descriptions in this chapter apply to the Application Agent CLI. Troubleshooting procedure To deal with problems that may occur during the operation of Application Agent follow the steps below. If a problem occurs during operation using an extended command, see “Troubleshooting extended commands” on page 501. 1. Check the conditions in which the problem occurred.
2. Check the problem in the Application Agent log file. When an error occurs in a Application Agent command executed within an extended command, an error message is output to the Application Agent log file drm_output.log (or drm_output.log.old). See the content of the Application Agent log file regarding the time when the error message for the extended command was output, and check the message and the operation status from the time the problem with the Application Agent command occurred. 3.
Information type Summary Default file name Windows Server 2008 Problem report and problem resolution log file#2 MSCS information All files in the following folder: system-drive\Users\user-name#3\AppData\Local\ Microsoft\Windows\WER Definition file and log file CHKDSK execution logs -system-directory\cluster\ChkDsk_*.log Legend: -- indicates that there is no corresponding file name. #1 Use Windows Event Viewer to collect files saved in text or CSV format.
Information type Summary Default files Detailed trace logs Application Agent trace log files#2 Application-Agent-installation-directory\log\ drm_pp_trace[1-16].log Installation trace logs Application Agent installation trace log files Application-Agent-installation-directory\log\ drm_inst.log Application-Agent-installation-directory \log\ drm_nbu_backup.log Trace logs of NetBackup Application Agent log files#3 Application-Agent-installation-directory \log\ drm_nbu_backup.log.
size of the drm_nbu_restore.log file reaches 10 MB, the contents of the file are moved to drm_nbu_restore.log.old. If drm_nbu_restore.log.old already exists, it is overwritten. #4 If multiple directories of the same virtual server name are specified in the DRM_DB_PATH parameter, a number n will be appended to the name of the directories from which log data will be collected. This number is based on the order that the directories are specified in the DRM_DB_PATH parameter.
Database information (when the backup is of an SQL Server database or Exchange database) Collect the following information about the database. In cases where the problem occurred over a network connection, you will need to collect files from the connected machine.
The log file output directory can store up to two generations of log files. The paths of the log files are as follows. Current log file: Application-Agent-installation-directory\script\log\drm_script.log Previous log file: Application-Agent-installation-directory\script\log\drm_script.log.old For details on how to respond to a message, indicating an error was encountered during extended command execution, that was output to the extended command execution log file drm_script.
Item Explanation When the backup is of a file system: The name of the mount point directory or mount point directory list file that was backed up. Instance name When the backup is of an SQL Server database: The name of the SQL server instance that was backed up is output. When the backup is of an Exchange database: The character string defined in the specification item INSTANCE_NAME in the operation definition file is output.
Adjusting Trace Log Settings This section explains how to adjust trace log settings. Adjusting the output level for detailed trace log information The level of information output to trace log files of Application Agent can be changed whenever necessary. To adjust the amount of log information to be collected, or to select a certain type of log information to be collected, edit the Application Agent configuration definition file (init.
Investigating standard output logs When execution of a Application Agent results in some problem, investigate the information in the standard output logs. If a problem occurs, the time when the problem occurred and the messages that were displayed in the standard output are recorded in the standard output logs. Refer to the contents of the standard output log, and check what messages were output when the problem occurred.
The following shows the items output to the detailed trace log. Table 116 Items output to the detailed trace log Output item Description Number Log sequence number Date Date when the log was output, using the yyyy/mm/dd format Time Time when the log was output, using the hh:mm:ss.sss format Application name Application Agent command name (drmxxx) that triggered the output of the log. Process ID Process ID Thread ID Thread ID Message ID ID of the message Type of the message.
Source of messages (controlled objects) Message output is triggered by: Message ID Cluster Cluster operations using the Windows API KAVX9203-I, KAVX9204-W, KAVX9205-E Operations and instruction using commands KAVX9300-I, KAVX9301-W, KAVX9302-E Operations and instruction using OCI KAVX9303-I, KAVX9304-W, KAVX9305-E Operations and instruction using ODBC KAVX9306-I, KAVX9307-W, KAVX9308-E Use of COM (MSSQL) interface KAVX9400-I, KAVX9401-W, KAVX9402-E Use of COM (ADO) interface KAVX9403-I, KAVX9
Troubleshooting dictionary map file errors During execution of a Application Agent command, when the system shuts down unexpectedly or the command is forced to terminate, dictionary map files may be lost or become incorrect. When you execute a Application Agent command, the following message might appear: KAVX0006-E An error that stopped processing occurred. Cause = DRM-10106: An internal error occurred.
2. Take the following actions in accordance with the output results. When the message KAIU020-I is output: There are no errors in the dictionary map files. Execute the drmfsdisplay or drmfscat command. If the drmfsdisplay or drmfscat command can be executed successfully, the dictionary map files are not damaged. When the message KAIU004-E is output: Some key definition files (.KDF) are missing or incorrect. Perform the procedures outlined in “Restoring key definition files (.KDF)” on page 514.
2. Execute the drmiskeymnt command to restore missing key files (.K01 or .Knn). drmiskeymnt parameter-file-name 3. Execute the drmischk command to verify the restored dictionary map files. drmischk -l 3 "C:\Program Files\CVXPAE\DRM\db\DRM*" 4. Make sure that the message KAIU020-I is output, and then execute the drmfsdisplay or drmfscat command. If the drmfsdisplay or drmfscat command can be executed successfully, the dictionary map files are not damaged. Restoring missing data files (.DRF or .
3. Execute the drmischk command to verify the restored dictionary map files. drmischk -l 3 "C:\Program Files\CVXPAE\DRM\db\DRM*" 4. Make sure that the message KAIU020-I is output, and then execute the drmfsdisplay or drmfscat command. If the drmfsdisplay or drmfscat command can be executed successfully, the dictionary map files are not damaged. Recreating dictionary map files 1. Copy and save all files and directories in the directory storing the dictionary map files. 2.
9 Support and other resources Numerous support options are available. Contacting HP HP technical support For worldwide technical support information, see the HP support website: http://www.hp.
Conventions This guide follows the conventions shown in Table 118 to refer to HP StorageWorks P9000 Command View Advanced Edition Suite products.
A Example of an Application Agent environment configuration This appendix explains an example configuration of the Application Agent environment. The descriptions in this appendix apply to the Application Agent CLI. You can use this example as a reference when setting up an actual environment. Note This example is based on operation in a specific configuration. For other configurations, you must adjust the settings to match operational requirements.
Figure 125 System configuration (for the example Application Agent environment configuration) The following example shows details regarding the above configuration. Server configuration Using two database servers, configure a virtual server by using an active-passive cluster configuration. The backup server is linked to a tape device. The following table shows the server configuration.
Information (Database server) Information (Backup server) • RAID Manager (instance number: 1) • RAID Manager (instance number: 1) • Device Manager Agent • Device Manager Agent • Application Agent • Application Agent Application Agent installation directory C:\Program Files\CVXPAE\DRM (default-installation-directory) C:\Program Files\CVXPAE\DRM (default-installation-directory) Cluster software MSCS -- Virtual server name SQL001 -- DBMS SQL Server -- SQL Server instance name The specified
Mount drive from the database server I: J: Mount drive from the backup server X: Y: Copy group name Generation VG01,VOL12 1st generation VG02,VOL22 2nd generation VG03,VOL32 3rd generation VG01,VOL13 1st generation VG02,VOL23 2nd generation VG03,VOL33 3rd generation VG01,VOL14 1st generation VG02,VOL24 2nd generation VG03,VOL34 3rd generation Volume contents DB01 (MDF) DB02 (MDF) DB01 (LDF) DB02 (LDF) K: L: Z: -- -- -- DB03 (MDF,LDF) Dictionary map file, VDI metafile, tra
Since a RAID Manager instance (instance number: 1) is running on the database server, and a RAID Manager instance (instance number: 2) is running on the backup server, horcm1.conf and horcm2.conf files are placed on the database server and backup server, respectively. Also, since this example uses a cluster configuration, configuration definition files with the same contents need to be placed on both the active server and the standby server.
HORCM_MON #ip_address service poll(10ms) localhost horcm2 6000 HORCM_CMD #dev_name dev_name \\.
• RAID Manager configuration definition file, for the backup server (C:\Windows\horcm2.conf) HORCM_MON #ip_address service poll(10ms) localhost horcm2 6000 HORCM_CMD #dev_name dev_name \\.
LOGLEVEL=3 PP_LOGFILE_NUM=2 COM_RETRY_TIME=0 COM_RETRY_WAIT=10 CLU_RETRY_TIME=6 CLU_RETRY_WAIT=10 SVC_RETRY_TIME=6 SVC_RETRY_WAIT=10 DRM_DB_PATH=L:\PTM;SQL001 In this environment configuration example, the dictionary map file directory is L:\PTM. Since the name of the virtual server is SQL001, specify L:\PTM;SQL001 for DRM_DB_PATH. • Application Agent configuration definition file, for the backup server (C:\Program Files\CVXPAE\DRM\conf\init.
HORCMINST=1 HORCMINST_AUX=2 RETRY_TIME=120 RETRY_WAIT=5 VENDER=HITACHI PRODUCT=OPEN-3 INSTALLPATH=C:\HORCM • RAID Manager-linkage definition file, for the backup server (C:\Program Files\CVXPAE\DRM\conf\raid\DEFAULT.dat) HORCMINST=2 HORCMINST_AUX=1 RETRY_TIME=120 RETRY_WAIT=5 VENDER=HITACHI PRODUCT=OPEN-3 INSTALLPATH=C:\HORCM For details about the RAID Manager-linkage definition file (DEFAULT.dat), see “Application AgentSetting up Application Agent for linkage with RAID Manager” on page 118.
PROMPT> set DRM_HOSTNAME=SQL001 PROMPT> drmsqlinit DEFAULT PROMPT> KAVX1100-I Enter the name of the storage directory for VDI metafiles: L:\mssql\meta PROMPT> KAVX1101-I Enter the timeout interval for VDI generation (in seconds, between 0 and 3600): 1000 PROMPT> KAVX1102-I Enter the name of the storage directory for undo files: L:\mssql\undo PROMPT> KAVX1107-I Enter the name of the storage directory for backup-log files: L:\mssql\log Check that the SQL Server database configuration definition file was c
Example registering information for linkage to the tape backup management software • The following shows an example registering information for linkage to the tape backup management software. To register information for linkage to the tape backup management software, execute the drmtapeinit command on the backup server, as follows: PROMPT> drmtapeinit PROMPT> KAVX0411-I Enter the backup management product name. NBU PROMPT> KAVX0417-I Enter the number of days to store the backup catalog.
INST_PATH=C:\Program Files\VERITAS\NetBackup MOUNT_POINT=W: CLASS=Class1 SCHEDULE=Schedule1 MOUNT_POINT=X: CLASS=Class2 SCHEDULE=Schedule2 MOUNT_POINT=Y: CLASS=Class3 SCHEDULE=Schedule3 MOUNT_POINT=Z: CLASS=Class4 SCHEDULE=Schedule4 MOUNT_POINT=default CLASS=Class5 SCHEDULE=Schedule5 PARALLEL_COUNT=5 For details on the configuration definition file for tape backup, see “Creating a configuration definition file for tape backup” on page 156.
Operation definition files (_operation-ID.dat) with the same contents are placed on each backup server (both the active server and the standby server). In this example, the operation ID is OperationA.
VG03,VOL31 VG03,VOL32 VG03,VOL33 VG03,VOL34 For details about copy-group list files, see “Creating a copy-group list file” on page 161.
B List of files used in Application Agent This appendix explains the purposes and locations of the files used by Application Agent. The descriptions in this appendix apply to the Application Agent CLI. List of files used in Application Agent The following table lists the files used in Application Agent.
File name Description Backup catalog file Files that contain exported backup catalog information. These files are used to exchange backup catalog information between file servers (or database servers) and backup servers. Database configuration definition files (instancename.dat) Files that contain information (parameters) about target databases registered by using the drmsqlinit command. These files are used when backup is of an SQL Server database.
File name Description Storage location • When the backup is of an SQL Server database: Definition files containing a list of databases subject to backup Database batch definition files • When the backup is of an Exchange database: User creates the files in the desired location.
File name Backup ID files Description Storage location Temporary files created when extended commands are executed. These files are used to carry over backup IDs between extended commands. These files are used for extended commands. Temporary files Saved copies of files specific to the system subject to backup, created during disk backup. These files are used during database restoration. In a file server or database server: These files are used for extended commands.
File name Description Storage location Copy parameters definition file (any-filename) Create this file to change the retry time for confirming the pair statuses used when commands are executed in operation. Specify this file during command execution for backup, restoration, and resynchronization. Copy group mount file (CG_MP.conf) This file is necessary when copy group names are used for parameters, in a dynamic disk configuration.
List of files used in Application Agent
C List of Event Logs That Have No Effect on Application Agent Operation This appendix provides a list of event logs that have no effect on Application Agent operation. The descriptions in this appendix apply to the Application Agent CLI and GUI. List of Event Logs That Have No Effect on Application Agent Operation Sometimes, event logs that have no effect on Application Agent operation are output while Application Agent is being used. The following table lists these event logs.
Server on which event occurred When message is output to event log Type Source Event ID Message Backup server A VSS backup is executed. Warning disk 51 An error was detected on device during a paging operation. Warning ftdisk 57 The system failed to flush data to the transaction log. Corruption may occur. 107 Exchange Search Indexer has temporarily disabled indexing of the Mailbox Database xxxxxxxx due to an error xxxxxxxx.
Server on which event occurred When message is output to event log Type Source Event ID Message Backup server Simultaneous backups are executed in a cascade configuration. Warning PlugPlayManager 257 Timed out sending notification of target device change to window of "VDS Notification Thread Hidden Window {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}" Passive node in a CCR environment and the SCR environment target A VSS backup is executed. SCR environment target A VSS backup is executed.
Server on which event occurred When message is output to event log Type Source Event ID Message Backup server The OS is Windows Server 2008 and during a VSS import, COPY/COPY or PAIR/PAIR volumes other than the volumes to be processed exist. Error VSS 8193 Volume Shadow Copy Service error: Unexpected error calling routine xxxx Backup server The OS is Windows Server 2008 and during a VSS import, COPY/COPY or PAIR/PAIR volumes other than the volumes to be processed exist.
Server on which event occurred When message is output to event log Type Source Event ID Message Backup server A VSS backup is executed. Error DLM Manager 32790 KAPL08022-E A path error occurred. ErrorCode = xxxxxxxx PathID = xx PathName = xx DNum = xx HDevName = xx Backup server A VSS backup is executed. Error DLM Manager 32974 KAPL08026-E An error occurred on all the paths of the LU.
List of Event Logs That Have No Effect on Application Agent Operation
D Replacing and secondary volume disks while Application Agent is running primary This appendix explains how to replace a primary or secondary volume disk while Application Agent is running. The descriptions in this appendix apply to the Application Agent CLI. Replacing primary and secondary volume disks while Application Agent is running This section explains how to replace a primary volume disk and secondary volume disk while Application Agent is running.
Figure 126 Example of replacing a primary volume disk To replace the primary volume: 1. Execute the following RAID Manager command to delete the pair definition of the primary volume to be replaced. PROMPT> pairsplit -g SI01 -S 2. On the host that manages the primary volume, delete primary volume partitions. 3. In Windows Server 2003: From the Start menu, choose Control Panel, Management Tool, and Computer Management.
4. On the host that manages the primary volume, change the contents of the definition file for the RAID Manager instance to the Port, TargetID, and LU of the new primary volume and then restart the RAID Manager instance. PROMPT> horcmshutdown 10 PROMPT> horcmstart 10 5. Execute the following command to generate a pair of the new primary volume and the secondary volume on the host that manages the primary volume: PROMPT> paircreate -g SI01 -vl -c 15 6.
Procedure for replacing a secondary volume disk The following example shows how to replace a disk on which a secondary volume belongs: Figure 127 Example of replacing a secondary volume disk To replace the secondary volume: 1. Delete the pair definition of the primary volume. PROMPT> pairsplit -g SI01 -S 2. 3. On the host that manages the secondary volume, create partitions for a new secondary volume.
4. On the host that manages the primary volume, generate a primary volume and secondary volume pair. PROMPT> paircreate -g SI01 -vl -c 15 5. Wait for the completion of pair generation. PROMPT> pairevtwait -g SI01 -s PAIR -t 10 180 6. Split the pair. PROMPT> pairsplit -g SI01 7. To restore data from the tape, execute the drmmount command with the -force option to mount the secondary volume. PROMPT> drmmount 0000000065 -force 8.
Replacing and secondary volume disks while Application Agent is running primary
E Restoring from a tape directly to a primary volume in a Snapshot configuration This appendix describes an example of restoring data from tape directly to a primary volume in a Snapshot configuration. The descriptions in this appendix apply to the Application Agent CLI. Note that the procedure for restoring data from tape directly to a primary volume is not supported if the configuration uses Exchange Server.
1. Execute the following command to import the file of backup information corresponding to the data that is to be restored. This file is from among the backup information files that were output by the drmdbexport command (the files exported as described in “Procedure for backing up to tape on the backup server” on page 551) when backing up to tape, and which were sent from the backup server to the database server. PROMPT> drmdbimport -f file-name (Create the file in the DRM_DB_PATH directory.) 2.
F Note on a firewall on the local host This appendix provides notes that apply when you set up a firewall on the local host. The descriptions in this appendix apply to the Application Agent CLI. Note on a firewall on the local host Some of the firewall functions provided by the OS might terminate socket connections in the local host. You cannot install and operate HP StorageWorks P9000 Command View AE Suite products in an environment in which socket connections are terminated in the local host.
Note on a firewall on the local host
G Notes on using the Remote Desktop functionality This appendix provides notes that apply when you use the Remote Desktop functionality. The descriptions in this appendix apply to the Application Agent CLI. Notes on using the Remote Desktop functionality HP StorageWorks P9000 Command View AE Suite products for Windows support the Windows Remote Desktop functionality. Note that the Microsoft terms used for this functionality differ depending on the Windows OS.
Notes on using the Remote Desktop functionality
H Correspondence to Replication Manager GUI terms Some terms used in the Application Agent command line interface have different meanings from those used in the Replication Manager GUI. Correspondence to Replication Manager GUI terms The following table describes the correspondence between these terms.
Correspondence to Replication Manager GUI terms
Glossary This glossary defines the terms used in this manual. application map file One of the map files making up the dictionary map files. Application map files are used to keep track of the mapping information between the application data to be backed up, and the files on the file system. backup catalog A collection of information necessary to manage the history and generations of backups performed using Application Agent.
Dictionary map files consists of the follow three types of map files and a backup catalog: - Application map file - Core map file - Copy group map file - Backup catalog disk group With VxVM, one or more logical devices can be grouped as individual units. Disk groups can consist of one or more volumes, regardless of the content of the logical volumes that comprise the disk group.
RAID Manager Software used to control HP StorageWorks P9000 disk array storage systems. RAID Manager is installed on a host connected to the storage system. Remote copy functionality In this manual, the volume copy functionality that replicates a volume to a remote site, such as Continuous Access Software or Continuous Access Journal, is generically called volume copy between storage systems (or remote copy functionality).
and the database must be frozen. If VSS is used, however, the OS functionality can control transactions for database applications and I/O operations for a volume, and the database can be frozen without the previously mentioned suspensions. This provides higher reliability for backup operations. To use VSS to freeze a database application, however, VSS must support the database application.
Index A Active-Active, 46, 136 Active-Passive, 45, 134 adjusting number of log files for detailed trace log, 509 output level for detailed trace log, 509 allocating files configuring database, 85 metafiles, 86 multiple database configuration files to one volume, 86 Application Agent, 27 configuration definition file, 110 cooperative software, 38 cooperative software trace log, 510 features, 27 functions, 28 overview, 27 overview of functions, 28 system requirements, 35 usable OSs, 35 version of, 36 Applicat
BUSY_RETRY_TIME, 125 BUSY_RETRY_WAIT, 126 C cascade configuration, 96, 334, 351 cascade configuration definition file, 537 cascade configuration, backing up and restoring, 425 Cascade configuration for SQL Server database backup, 54 CCR configuration backing up in, 441 restoring in, 441 CCR configurations, 57 CG_MP.
Creating a configuration definition file for SQL Server database backup, 142 creating dictionary map files Creation in a non-cluster configuration or on a backup server, 133 Creating operation definition files for Exchange database backup, 196 for file system backup, 186 for SQL Server database backup, 191 creation of a transaction log list file, 164 D DAG configurations, 60 data file (for SQL server database), 83 data files (for Exchange database), data files (for Exchange database), 89 data management us
example of creating operation definition file in cluster configuration, 189 when backup is of Exchange database, 199 when backup is of SQL server database, 194 example of environment configuration example of registering SQL Server information, 527 example setting for copy-group list file, 531 example setting for host environment setting file, 530 example settings for Application Agent configuration definition File (init.
glossary application map file, 559 backup catalog, 559 backup ID, 559 backup information, 559 basic disk, 559 basic volume, 559 cluster software, 559 copy group, 559 copy group map file, 559 core map file, 559 DBMS, 559 dictionary map file, 559 disk group, 560 disk set, 560 dynamic disk, 560 dynamic volume, 560 Exchange database, 560 failover, 560 freezing database, 560 Hitachi Protection Manager, 560 Information Store, 560 metadata, 560 pair volume, 560 RAID Manager, 561 remote copy functionality, 561 stor
Mutual standby configuration, 46 N NBU_MASTER_SERVER, 157 notes on starting and stopping RAID Manager, 131 O on backing up and restoring data between storage systems Precautions, 51 online backup, 27 operation definition file, 535 operation details, 506 operation example backing up and restoring file system using tape backup management software that is unable to link with Application Agent, 271 backing up file system by using user script, 257 backing up file system to secondary volume, 248 backing up file
precautions, 80 Application Agent operations, 225 application of transaction logs (SQL Server), 283 backing up and restoring multiple databases (SQL Server), 277 backing up database (SQL Server), 275 backing up file system, 245 backing up transaction logs (SQL Server), 280 backup (Application Agent), 227 backup and restoration (Application Agent), 226 backup servers (Application Agent), 230 configuring volumes (Exchange), 398 database verification (Exchange), 398 executing commands (Application Agent), 233
retry time when error occurs, 240 RETRY_TIME, 121 RETRY_WAIT, 121 right to log in as service, 242 roll-forward, 414 S Sample user script files, 357 saving transaction log that have previously been backed up, to tape or other storage media, 316 SCHEDULE, 158 SCR configuration backing up in, 467 restoring in, 467 SCR configurations, 59 SCRIPT_FILE, 159 SET_DRM_HOSTNAME, 188, 193, 198 setting as operating server distribution target server, 349 setting up Application Agent for linkage with RAID Manager, 118 se
SQL Server database backing up, 366 backing up and restoring data between volumes, 289 backing up and restoring in Multi-target configuration, 334 backing up SQL Server database by using user script, 304 backing up SQL Server database to remote site, 327 backing up SQL Server database to secondary volume, 291 backing up SQL Server database to tape, 298 database status when restoring and recovering, 279 example of operation using transaction log backup, 310 loading status, 279 performing restoration and reco
transaction logs backing up and restoring, 316 troubleshooting dictionary map file error, 513 extended commands, 501 U unlocking copy group, 324 updating dictionary map files, 165 user script coding rules for, 203 creating, 203 creating, to perform backup in cascade configuration, 356 overview of, 203 user script example (for file system), 259 user script example (for SQL Server database), 306 user script example (for storage group), 413 user script file, 356, 536 Using VSS with RM Shadow Copy Provider ver