Hp XP Command View Advanced Edition Software Manuel d'utilisateur

HP P9000 Replication Manager SoftwareApplication Agent CLI User GuidePart number: TB584-96073Eighth edition: May 2013

Preparations for performing backup or restoration in a cascade configuration or multi-targetconfiguration ...

When a primary volume exists in the backup server, the dictionary map files must be updated.When the primary volume does not exist in the backup serve

• Back up multiple primary volumes to a single generation• Back up multiple primary volumes to multiple generations• Back up or restore between storag

Figure 48 Volume configuration and configuration definition to back up multiple primary volumes toa single generationBacking up multiple primary volum

Figure 49 Volume configuration and configuration definition to back up multiple primary volumes tomultiple generationsBackup or restore between storag

Figure 50 Example of a configuration definition for backup or restore between storage systemsThe following shows an example of the RAID Manager config

• RAID Manager configuration definition file (horcm1.conf)HORCM_DEV##dev_group dev_name port# TargetID LU# MU#TC01

than one volume. You need to take this into consideration when specifying the RAID Managerconfiguration definition file. The following shows an exampl

checking the status of the cluster resource, change the following parameters. In a non-clusterenvironment, these parameter must not be changed. Leave

Specifying the retry count and interval for process status retry checkWhen Application Agent performs a cold backup or restoration, it activates or de

Specifying the retry count and interval for command execution status retry checkIf you want to change the retry count and retry interval for retries o

Backing up and restoring a storage group ... 399Precautions when backing

• Make sure that the previous backup information has been deleted.Use the drmsqlcat command to confirm that the backup information has been deleted. T

Even after execution of the drmsqlrecover command, you can check integrity from SQL ServerEnterprise Manager.If YES is specified for this option, inte

Cluster resourcestatusRestore targetCLU_MSCS_RESTORECluster typeOFFLINEYes--Veritas Cluster ServerLegend:--: Not applicableYes: Can be restored• SQL S

If you specify -no_resync as the restoration option:Table 20 Parameter in CLU_MSCS_RESTORE and cluster resource Status (SQL Server database2)Cluster r

Setting up parallel execution of verification processes for Exchange databasebackupWhen an Exchange database is being backed up, you can specify the n

Setting up Application Agent for linkage with RAID ManagerDo not set HORCMINST or HORCC_MRCF in the system environment variable. Also, do not setHORCM

HORCMINST_AUX=1HORCMINST=2HORCMINST_AUX=3• In a cluster configuration, all servers making up the cluster must share the HORCMINST and HOR-CMINST_AUX i

Figure 52 Example of specifying a RAID Manager instance number in the RAID Manager-linkagedefinition file (DEFAULT.dat)The following conditions are as

The pair status checking retry interval should be 1.5 times the estimated pair operation time in abackup system configuration. By default, Application

specify any purpose-specific parameters, the values of RETRY_TIME and RETRY_WAIT are used.The following table shows the parameters you can add.Table 2

Performing a backup on the standby server ... 454Restoring data when using the automat

Specifiable val-ues(default)DescriptionParameter0 to 3600(Value ofRETRY_TIME)Specifies the maximum number of times a retrycan be performed for checkin

Specifiable val-ues(default)DescriptionParameter0 to 360000(Value ofRETRY_WAIT)Specifies the retry interval for checking whetherresynchronization on r

The smaller the retry interval value (RESYNC_RETRY_WAIT, SPLIT_RETRY_WAIT, RE-STORE_RETRY_WAIT, BUSY_RETRY_WAIT, or RESTORE_DELAY_RETRY_WAIT), the lar

• Write parameters in the form parameter-name=parameter-value.• Use an equals character (=) between a parameter name and a parameter value.• Specify a

Specifiable valuesDescriptionParameter0 to 3600Specify the maximum number ofretries that will be performed toconfirm whether the volume isready for re

For details about the values that can be specified as the track size, see the RAID Managerdocumentation.Table 30 Parameter in the RAID Manager-linkage

• drmfsbackup• drmsqlbackup• drmexgbackup• drmresyncTable 31 Parameter in the RAID Manager-linkage definition file (DEFAULT.dat) (to specify whetherto

Setting up operation mode when automatically selecting copy groupsUsually, Application Agent automatically selects the secondary volume used as a back

Specifying the installation path for RAID ManagerSpecifying the installation destination for the RAID Manager commands to be started by ApplicationAge

Creating dictionary map filesApplication Agent automatically creates dictionary map files during installation. If you want thedictionary map files to

Restoring key files (.K01 or .Knn) ... 520Restoring missing data

Creation in an Active-Passive cluster configurationIn an Active-Passive cluster configuration, you need to create dictionary map files in a shared dir

1. Change the locations of the dictionary map files and backup catalog.In the init.conf configuration definition files of Application Agent on the act

Creation in an Active-Active cluster configurationIn an Active-Active cluster configuration, you need to create dictionary map files on each virtual s

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

3. When Veritas Cluster Server is used, execute the drmclusinit command to register clusterresource information.For details, see “Creating a cluster i

• How to create a cluster information configuration definition file (when Veritas Cluster Server isused)A cluster information configuration definition

Figure 55 Cluster group definition (when a backup target and shared disks are in the same clustergroup)How to Define Cluster Groups (When a Backup Tar

Figure 56 Cluster Group Definition (When a Backup Target and Shared Disks are in Different ClusterGroups)Creating a cluster information configuration

2. Register the following items according to the output messages:Table 37 Parameters for the cluster softwareExplanationEntry nameEnter the virtual se

• Execute the drmclusinit command on both the active server and standby server.• The resource information to be registered by using the drmclusinit co

Glossary ... 559Index ...

The information to be registered includes the following:• Storage directory for the VDI metafiles• VDI generation timeout period• Storage directory fo

4. Check the registration.To check your registration, execute the drmsqlinit command with the -v option specified:PROMPT> drmsqlinit -v instance-na

Specify this option if the command that operates the SQL Server database terminates with an errordue to an SQL Server login request timeout (error mes

Parameter specifica-tionSQL Serverautomatic re-covery pro-cessingRestorationtypeSystem config-urationRestored objectUSNot neededNot performedRestorati

2. Specify the parameter in the sqlinit_instance-name.conf file.Write the parameter starting from the far left, without spaces. Delimit the parameter

Specifying settings for using VSSIf you want to use VSS to perform an online backup of a file system or an Exchange database, thefollowing settings ar

Application-Agent-installation-directory\DRM\confTable 42 vsscom.conf parametersValues that can be setDescriptionParameter1 to 256 one-byte charac-ter

Values that can be setDescriptionParameter0 to 99999Specifies, in seconds, the in-tervals at which backup is re-tried when an Exchangedatabase verific

Set the system environment variables for the file server or database server, as shown in the tablebelow.Table 43 System environment variables required

• A backup with a name identifying the generation specifiedThis section describes the system setup for each server.Set the system environment variable

FiguresOverview of Application Agent ... 281Logical volume consisting of

• In a configuration where multiple file servers or database servers are sharing one backup server,manage all the secondary volumes in a single RAID M

OmissionMaximumcharacterlengthDescription#2Parameter#1N10Specify the number of the RAIDManager instance that is managingRemote Copy in the cascadeconf

OmissionMaximumcharacterlengthDescription#2Parameter#1Y5(Themaximumvalue is86400.)Specify the timeout value for the pairresynchronization processing a

The following table provides details about the handling of the backup command's -cascadeoption and sections.Table 48 How the -cascade option and

2. When the following message appears, enter the name of the tape backup management software.KAVX0411-I Enter the backup management product name.Enter

Application-Agent-installation-directory\DRM\conf\tape\NBU_sample.dat• Backup ExecApplication-Agent-installation-directory\DRM\conf\tape\BEWS_sample.d

DescriptionParameterSpecify the absolute path of the mount point of the volume to be backed up (usea maximum of 255 bytes).If no entry for the mount p

DescriptionParameterSpecify the absolute path of the mount point of the volume to be backed up (use amaximum of 255 bytes).If no entry for the mount p

PATH1=SUBDIRS1=Parameters other than INST_PATH, NBU_MASTER_SERVER, INCLUDE_EXEC, and PARALLEL_COUNTcan be specified multiple times for a mount point.

User-defined configuration definition fileWhen you execute the drmmediabackup command or the drmmediarestore command with the-bup_env option (that is,

Example of a CCR configuration (active and standby servers use the same backupserver) ...

• File nameYou can use alphanumeric characters to specify any name.• File storage locationThis file can be stored in any location.In a cluster environ

• drmsqllogbackupFile name of the list fileUse alphanumeric characters to specify the file name.List file storage locationList files are stored in the

In a cluster environment, however, this file should be stored in a shared directory that can be accessedfrom both servers.Contents of the transaction

Updating a dictionary map fileAfter environment setup is complete, the next step is to update the dictionary map files. By updatingthe dictionary map

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 exi

1. Conceal all secondary volumes from the backup server.To conceal all secondary volumes from the backup server, execute the drmdevctl commandon the b

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

START-TIME: 2004/12/15 10:20:00 END-TIME: 2004/12/15 10:23:00HOSTNAME: DB_SVR1::When the backup is of an Exchange database:DBServer > drmexgcatSTOR

6. Transfer exported backup catalog information from the file server or database server to the backupserver.Transfer the temporary file exported from

9. Unmount the secondary volume.To unmount the secondary volume on the backup server, execute the drmumount command.The secondary volume becomes conce

Cluster group definition (when a backup target and shared disks are in the same clustergroup) ...

11. Check the contents of the created copy group mount definition file.The created copy group mount definition file is stored in theApplication-Agent-

#configuration file for copy-group mounting[CG_DEF]COPY-GROUP-NUM=6COPY-GROUP=Grp1,dev11BUID=0000000001DATETIME=20041201123456COPY-GROUP=Grp1,dev12BUI

COPY-GROUP-NUM=2COPY-GROUP=Grp3,dev31COPY-GROUP=Grp3,dev32P-DG=DG01S-DG=DG01FS-NUM=3LVM-DEVICE=\Device\HarddiskDmVolumes\Dg01\Volume1LABEL=Volume1FS=X

2. Confirm that a backup catalog has been created.To confirm that the backup catalog has been created, execute a command (drmfscat,drmsqlcat, or drmex

4. Transfer the backup catalog information exported from the file server or the database server toa backup server.Transfer the temporary file exported

7. Create a copy group mount definition file.To create a copy group mount definition file, on the backup server execute the drmmountcommand with the b

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 chec

Determination of a mount pointThe following table describes how Application Agent determines a mount point when executing thecommand for mounting a se

The system uses a mount point specified in FS=mountpoint that corresponds to a copy group tobe backed up, in the copy group mount definition file.Tabl

If you specify an absolute path that begins with the drive letter as a mount point directory namein the -mount_pt option, the mount point should be ab

Procedure for restoring an SQL Server database to the primary volume ... 29786Procedure for restoring an SQL Server database from

Location in thismanualBackupserverFile server ordatabase serverTasksSpecifying how tostart the extendedcommands, page 182NeededNeededSpecify how the e

Execution permissions for extended commandsTo execute the extended commands, you need system administrator permissions. Make sure that youhave these p

3. Delete the operation-ID directory created in the script_work directory in the same level ofthe directory that you checked in step 2.(Perform the fo

In the Windows default settings, wscript.exe starts an extended command and a pop-up dialogbox appears. The dialog box displays the execution results

On the file or database server:EX_DRM_HOST_DEF_CHECK -db -f host-environment-settings-fileOn the backup server:EX_DRM_HOST_DEF_CHECK -bk -f host-envir

After storing the operation definition file in the stipulated directory, execute the check tool for operationdefinition files to check the content of

The following table shows the entries of an operation definition file, their contents, and the maximumvalue length (in bytes). Specification of these

The following prerequisites apply to this example:• There are two file servers and a backup server to which a tape device is connected.• A virtual ser

1. Create an operation definition file on the active server (file server A), and then set the requireditems.Create the following two files.Application

4. On the backup server, execute EX_DRM_FS_DEF_CHECK, which is a check tool for operationdefinition files.EX_DRM_FS_DEF_CHECK operation-ID -bkThe oper

System configuration for backing up and restoring data between volumes by using VSS(when an Exchange database is backed up) ...

Figure 58 Example of locations of operation definition files (when the backup is of an SQL Serverdatabase)In this example, the virtual server (server

Maximumnumber ofcharactersInformation to be specifiedSpecification item128Specify the database server name. In a cluster configuration,specify the nam

Example of creating operation definition filesThe following gives an example of creating operation definition files for a system that has a clustercon

In this example, you create an operation definition file for each of the operation IDs listed in thefollowing table.Table 62 Operation IDs for which t

4. On the backup server, execute EX_DRM_SQL_DEF_CHECK, which is a check tool for operationdefinition files.EX_DRM_SQL_DEF_CHECK operation-ID -bkThe op

Figure 59 Example of locations of operation definition files (when the backup is of an Exchangedatabase)In this example, the virtual server (server na

Maximumnumber ofcharactersInformation to be specifiedSpecification item63Specify the database server name. In a cluster configuration,specify the name

#4If you specify this item, do not specify a recovery database.#5The specified subdirectory must satisfy the following:• The subdirectory name must no

This example creates operation definition files corresponding to the operation IDs listed in the followingtable.Table 65 Operation IDs for which an op

4. On the backup server, execute EX_DRM_EXG_DEF_CHECK, which is a check tool for operationdefinition files.EX_DRM_EXG_DEF_CHECK operation-ID -bkThe op

Legal and notice information© Copyright 2011, 2013 Hewlett-Packard Development Company, L.P.Confidential computer software. Valid license from HP requ

TablesTypes of data subject to backup in the SQL Server database ... 511Comparison of DAG configurations ...

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 du

Creating a user scriptBy specifying a user script when executing the backup command, you can simplify the backup operationbecause the commands specifi

RulesApplicable items• The value of an item must be specified after the one-byte equal sign (=) thatfollows the item name. Do not enter a linefeed cod

OmissionMultiplespecifica-tion#1Meaning and specifiable valuesEntry nameAllowed#3Not al-lowedUser processing section: Indicates the beginning of the &

OmissionMultiplespecifica-tion#1Meaning and specifiable valuesEntry nameNot allowedNot al-lowedSpecifies a command line to be executed.• If you want t

OmissionMultiplespecifica-tion#1Meaning and specifiable valuesEntry nameAllowedAllowed#4Specifies the environment variables to be applied for executio

OmissionMultiplespecifica-tion#1Meaning and specifiable valuesEntry nameAllowedNot al-lowedSpecifies the command timeout value. Specifiable values are

#1"Multiple specification is not allowed" means that multiple entries cannot be specified in thecommand definition section (CMD).#2The [PRE_

Script environment variablesThe table below shows the Application Agent script environment variables that can be referenced bycommands in the user pos

Do not specify a command that is not listed. Doing so might prevent the system from runningnormally.Table 73 Commands that can be specified in user pr

Parameters in the RAID Manager-linkage definition file (DEFAULT.dat) (to specify the retrycount and retry interval for checking the status of a pair)

Examples of user script usageThe following table provides references to the sections in which examples of user script usage areexplained.Table 74 Exam

Default (value after in-stallation)DescriptionParametermailserverSpecifies the host name or IP address of the SMTPserver to be used for sending the e-

Protection Manager message:Hostname=flora1 DRM_HOSTNAME=ExchangeServer12005/10/08 19:22:32(00003896) drmexgbackup -mode vss2005/10/08 19:22:32(000038

• Copy-group list fileFor details on the file name and location of the copy group list file, see “Creating a copy-grouplist file” on page 159.• Databa

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

Figure 61 Protecting backup information for tape backupsBack up the tape, and then carry out the following procedure:Execute EX_DRM_TAPE_BACKUP, and t

Recovering backup information (file server)This section explains how to recover backup information and restore the file system after restoring theoper

4. Carry out the procedure described in this manual for restoration.Creating the Exchange environment configuration fileThe Exchange environment confi

MaximumCharacterString (bytes)DefaultDescriptionParameter3OFFIn Exchange Server 2007:If you have specified ON in theEXG_SCR_SEED parameter, specifywhe

4 Application Agent operationsApplication Agent operations differ depending on the object to be backed up.This chapter provides an outline of and prec

How to determine a mount point when the command for mounting a secondary volumeis executed (when a copy group is specified for an option) ...

Basic commandsBasic commands provide data protection functions such as backup and restore.Extended commands execute basic commands internally for proc

FunctionCorresponding basic com-mandExtended commandCollects a backup informationfile from the backup server. Ifthe backup is of an SQL Serverdatabase

FunctionCorresponding basic com-mandExtended commandUnmounts a secondary volume.drmumountEX_DRM_UMOUNTDisplays a listing of backupinformation for a ta

FunctionCorresponding basic com-mandExtended command• Displays a listing of SQLServer database information.• Updates the SQL Serverdatabase informatio

Backing up and restoring a file system, page 243• When the backup is of an SQL Server database:Backing up and restoring an SQL Server database, page 2

Figure 62 Correspondence of backup catalog and copy groupWhen you back up database A only (as in step 2), the backup ID 0000000002 is created, andthe

• If there are multiple mount points specified for a single logical volume, as shown below, anybackup will fail and an error message (KAVX0006-E and D

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 vol

Precautions for executing commands in a cluster environmentIn a cluster environment, before executing a Application Agent command, you must set the en

Precautions regarding the drive when mounting data to a backup serverWhen Application Agent performs tape backup, it mounts the secondary volume to th

Correspondence between extended commands and basic commands (SQL serverdatabase) ...

For details on the procedure for updating the dictionary map files, see “Updating a dictionary mapfile” on page 163.Unavailable tools when executing c

Figure 63 Disk group configuration that does not allow backupIn such a case, change the configuration to one of the following volume configurations:•

message appears, indicating that the user has insufficient permissions to execute the command,and command execution fails.• Database access permission

Database access permis-sionsOS administrator permis-sions#1Extended command nameNot NeededNeededdrmcgctlNot NeededNeededdrmclusinitNot NeededNeededdrm

In a Windows Server 2008 or Windows Server 2012 operating environment, this also includesOS administrator privileges.Table 86 Required permissions for

Database access permissionsOS administrator permis-sions#Extended command nameNeededNeededEX_DRM_EXG_RESTORENot NeededNeededEX_DRM_EXG_VERIFYNeededNee

This command cannot be executed with other commands when the -refresh option is specified.This command can be executed with other commands when other

Legend:No: These commands cannot execute concurrently with other commands marked by No.Yes: These commands can execute concurrently with any other com

#2This command can be executed with the drmresync command only when all of the followingconditions are satisfied:• In Application Agent, the drmsqlbac

indefinitely until the former command terminates. To prevent the system from attempting to executesuch a command, you need to edit the Application Age

Items output to the detailed trace log ... 517111Sources of messages (controlled o

Specify a period longer than the following: (the period from the time EX_DRM_TAPE_BACKUP orEX_DRM_TAPE_RESTORE is executed to the time the tape backup

Restarting the Protection Manager serviceWhen the contents of the Application Agent init.conf and DEFAULT.dat definition files arechanged, you must us

Application Agent operations242

5 Operation for file systemsThis chapter describes the procedures for running Application Agent when backing up a file system.The descriptions in this

• 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

Figure 64 System configuration for backing up and restoring data between volumes (when the backupis of a file system)Processing flowThe processing flo

Figure 65 Procedure for backing up a file system to the secondary volumeFigure 66 Procedure for restoring a file system to the primary volumeBacking u

Restoring a file system to a primary volumeThis section gives an example of restoring a file system when the backup data is stored on a secondaryvolum

Figure 67 System configuration for backing up a file system to tape and restoring it from tapeWith Application Agent, file servers can be clustered. W

Flow of processingThis section describes the processing flow of backing up a file system to tape and restoring it to theprimary volume on a multi-serv

PrefaceThis guide describes how to manage HP P9000 Replication Manager Software.Application Agent CLI User Guide 25

Figure 68 Procedure for backing up a file system to tapeFigure 69 Procedure for restoring a file system from tapeOperation for file systems250

Backing up a file system to tapeThis section gives an example of backup of a file system to a tape. In this example, we back up thefile server FSServe

2. Check that the file system has been backed up correctly.To check that backup information bearing the date on which the file system had been backedu

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. For the tape backupmount

3. Export the backup information to temporary files.To perform backup from the secondary volume to tape, you need to copy information, about thebackup

To restore the file system:1. Check the backup ID of the backup data.Check the backup ID of the backup data used to restore it from tape to the second

6. Import the temporary files, which were transferred from the backup server, into the backup catalogon the file server.Import the temporary files, wh

Figure 70 System configuration for backup of a file system to tapeProcessing flowIn this example, the processing flow of the drmfsbackup command that

Figure 71 Processing flowUser script exampleThe table below shows the user script that is created for the example.Table 96 User script creation exampl

ExplanationScript text#Stop the application programs that are using the file systemCMDLINE=C:\tmp\stop_app.bat(3) Pass the environment variable VAL=Ap

Preface26

ExplanationScript text(8) Start of the user post-processingsection[POST_PROC] ...(8)#Tape backup of the secondary volume[CMD]CMDLINE=C:\tmp\tapebackup

ExplanationScript text#Re-start the application programs that use the file systemCMDLINE=C:\tmp\restart_app.batENV=VAL=ApplicationNameTIMEOUT=60END_CO

PROMPT> drmfsbackup F: -mode cold -script C:\tmp\script.txt -s BKHOST -auto_import -auto_mount G: -comment TEST1KAVX0001-I The drmfsbackup command

Backing up and restoring between local sites and remote sitesThis section shows examples for using volume replication functionality between storage sy

• The system is equipped with a file server in the local site (server name: FSServer), and has abackup server (server name: BKServer) with a tape devi

3. Check that backup was performed correctly.On the file server, execute the drmfscat command, and check the backup information.FSServer > drmfscat

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

Restoring a file system to the local siteThis subsection explains an example for restoring a file system to a local site, when the local site isrunnin

5. Export the backup information to temporary files.To perform restoration from the secondary volume to the primary volume, you need to copybackup inf

5. Resynchronize the copy group.To resynchronize the copy group, execute EX_DRM_RESYNC on the file server.FSServer > EX_DRM_RESYNC Operation_AResto

1 Overview of Application AgentApplication Agent is designed to reduce the workload on system administrators and to provide efficientand reliable data

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

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 tempora

2. When running Explorer or any other tool, put the temporary directory for extended commandsthat is on the backup server in a shared state.3. From th

2. Execute EX_DRM_TAPE_RESTORE to restore the backup data from the tape to the secondaryvolume.3. Execute EX_DRM_DB_EXPORT to export the backup inform

Operation for file systems274

6 Operation for SQL Server databasesThis chapter describes how to operate Application Agent when backing up an SQL Server database,focusing on actual

Precautions when restoring a database• When you attempt to restore an SQL Server system database (master, model, msdb, or distribution),the SQL Server

For example, when ODBC sections cannot be established, if an application that performs retriesis running, since an ODBC section establishment request

Figure 73 Backing up and restoring multiple databases (same volume configuration)When multiple databases are stored in multiple volumesYou can specify

Figure 75 Tape restoring multiple databases (multiple volume configuration)In the operations shown in the above figure, the data restored from tape is

Figure 1 Overview of Application AgentThe following describes how Application Agent controls other software components. The numbersbelow correspond to

Figure 76 Database statuses during restoration and recoveryNote that when a database in the standby status is viewed by Enterprise Manager, before exe

The following figure shows the example when LOCAL_BACKUP is set to YES and the secondaryvolume on the local site is backed up. In this example, the po

Figure 77 Transaction log backups after roll-forward (1)• After performing roll-forward, use Application Agent to perform backup from the primary volu

Figure 79 Transaction log backup error after roll-forwardPrecautions regarding application of transaction logsApplication of transaction logs enables

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

Service statusCommandsStoppingRunning(Not applicable)Executabledrmsqldisplay (when the -refresh option isspecified)ExecutableExecutabledrmsqldisplay (

SQL Server database statusCommandsUncon-firmedRead-onlyReadingOfflineOnlineNoNoNoNoYes (DB)drmsqllogbackup(when the -no_truncateoption is not specifie

If you restore the user database only, delete the database in a state where a restoration commandcannot be executed, and then re-execute the restorati

SQL Server database statusCommandsRead-only,offline, anduncon-firmedRead-onlyand uncon-firmedRead-onlyand offlineReadingand uncon-firmedOffline andunc

SQL Server database typeCommandsUser databaseSystem databasetempdbmodelmsdbmasterYes (DB)No(terminateswith an error)No(Nooperation isperformed)No(Noop

Restoring dataApplication Agent provides various commands that use volume replication functions to restore adatabase or file system from a backup. You

Figure 82 System configuration for backing up and restoring data between volumes (when the backupis of an SQL server database)Processing flowThe proce

Figure 83 Procedure for backing up an SQL Server database to the secondary volumeFigure 84 Procedure for restoring an SQL Server database to the prima

Restoring an SQL Server database to a primary volumeThis section provides an example of recovering an SQL Server database when the backup data isstore

Using the drmsqlrecover command to recover an SQL Server databaseThe drmsqlrecover command is useful for recovering particular databases and recoverin

To use the drmsqlrecovertool dialog box to recover an SQL Server database:1. Specify an instance name to execute the drmsqlrecovertool command.DBServe

System configurationThis section uses examples to describe how to use extended commands. The example here assumesthat the system is configured to use

• The FTP service on the backup server is started, and the system is set up so a user who has loggedonto the OS of the database server can log onto th

Figure 86 Procedure for restoring an SQL Server database to the primary volumeApplication Agent CLI User Guide 297

Figure 87 Procedure for restoring an SQL Server database from its backup tapeBacking up an SQL Server database to tapeThis section provides an example

Resynchronize the copy group.1. For multi-generation operations, check the copy group to be used next.To check the copy group to be used next, execute

ContentsPreface ... 251 Overview of Application Agent ...

Pair management using copy groupsIn Application Agent, a primary and secondary volume pair whose synchronization is started andstopped by using volume

3. Export the backup information to temporary filesTo back up data from the secondary volume to tape, copy the backup information to the backupserver.

8. 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 backupserver. In th

3. Export the backup information to temporary files.To restore data from the secondary volume to the primary volume, the backup information aboutthe r

9. Recover the SQL Server database.To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertoolcommand.The following shows an ex

To use the drmsqlrecovertool dialog box to recover an SQL Server database:1. Specify an instance name to execute the drmsqlrecovertool command.DBServe

System configurationThe example is based on the system configuration shown in the figure below.Figure 88 System configuration for backup of an SQL Ser

By not specifying the VDI metafile storage location in drmsqlinit, the VDI metafile is writtento the primary volume and can be backed up at the same t

ExplanationScript text(3) Mounting of the first volume[CMD] ...(3)CMDLINE="C:\program files\CVXPAE\drm\bin\drmmount.exe" -copy_group vg01,vo

ExplanationScript text#Tape backup of the secondary volume[CMD]CMDLINE=C:\tmp\tapebackup.bat(9) Execute the next command withoutwaiting for the comman

Operation using SQL Server transaction logsBacking up an SQL Server database entails either backing up all databases, or backing up transactionlog fil

In a cluster environment using Microsoft Cluster Service or Windows Server Failover Clustering, youcan select whether to perform data restoration whil

• The primary volume and the secondary volume are pair defined in the database server and thebackup server.• The tape backup management software is in

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 poi

3. Resynchronize the copy group.Execute EX_DRM_RESYNC on the database server to resynchronize the copy groups. If there isa big difference between the

To back up the transaction logs:• Back up the transaction logs at point B (point C).To back up the transaction logs, execute EX_DRM_SQL_TLOG_BACKUP.DB

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 ap

Example of operation using transaction log backupIf a failure occurs, you can restore the database up to the point of the last backup by using the dat

• Obtain transaction logs, without truncating those subsequent to point C.To obtain transaction logs without truncating, execute the EX_DRM_SQL_TLOG_B

System configurationThe examples in this section assume the system configuration shown in the following figure.Figure 93 Backing up SQL Server transac

FTP_HOME_DIR=C:\FTP_ROOTFTP_SUB_DIR=scriptSET_DRM_HOSTNAME=1• The operation definition file used to back up the file system is named FS1. The backup t

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_F

Figure 3 Data management at a remote siteManaging data at a remote site allows you have a secondary volume in a storage system that isphysically diffe

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 backupserver. Spec

4. Export the backup information to temporary files.To restore data from the secondary volume to the primary volume, the backup information aboutthe r

• Backups obtained for a volume are kept, while the usual backups are obtained for the other twovolumes.Example of operation using lock functionality

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 gro

4. Lock secondary volume 1.To keep the backup data (generation 1), lock the copy group (generation 1) by executing thedrmcgctl command with the -mode

2. Check the copy group status.Display the copy group list and check that the copy group has been unlocked.DBServer > drmcgctlCOPY GROUP LOCK STATU

Figure 95 System configuration for backing up and restoring an SQL Server database between a localsite and a remote siteThe system prerequisites for t

• The SQL Server data files and transaction log files are stored in the same directory structures onthe local and remote sites.• Use Operation_A as th

4. Export the backup information to temporary files.To perform backup from the secondary volume to tape, you need to copy information about thebackup

4. Confirm that data has been correctly backed up to tape.To confirm that backup information with the date of the backup from the primary volume to th

When selecting a secondary volume for a backup, you can either manually select the volume youwant to use or have Application Agent choose it for you.

3. Restore data from its backup tape to the secondary volume.To restore data, execute EX_DRM_TAPE_RESTORE on the backup server.BKServer > EX_DRM_TA

3. Check that the import operation has been performed correctly.To confirm that backup information with the date of the backup from the primary volume

3. Restore data from its backup tape to the secondary volume.To restore data, execute EX_DRM_TAPE_RESTORE on the backup server.BKServer > EX_DRM_TA

Operation at the local site1. If SQL Server is running on the database server, stop SQL Server.2. Use a disk management function to unmount the volume

Figure 96 System configuration for backing up an SQL Server database to tape and restoring it fromtape in a multi-target configurationThis example ass

• The FTP service on the backup server is started, and the system is set up so a user who has loggedonto the OS of the database server can log onto th

END_CODE=TERMINATE_NZTIMEOUT=0[SPLIT_PROC]# Target pair volume: SI01,dev01[CMD]CMDLINE=C:\HORCM\etc\pairsplit.exe -g TC01 -d sql01 -FBC 0ENV=HORCMINST

4. Export the backup information at the local site to temporary files.To back up data from the secondary volume to tape, copy the backup information t

2. Restore data from its backup tape to the secondary volume.To restore data, execute EX_DRM_TAPE_RESTORE on the backup server at the local site.hostA

7. Recover the SQL Server database.To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertoolcommand on the database server at

Figure 5 Backing up multiple generations when a copy group is lockedThe order in which secondary volumes are used for backups does not change regardle

Figure 97 System configuration for restoring and recovering from a host not used for backup (whenbacking up)Operation for SQL Server databases340

Figure 98 System configuration for restoring and recovering from a host not used for backup (whenrestoring)The following conditions are assumed:• The

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.P

4. Transfer the exported temporary file from database server 1 to database server 2.Use the ftp (file transfer protocol) command to transfer the expor

7. Restore the data from the secondary volume to the primary volume.Restore the data by resynchronizing the primary and secondary volumes. To restore

Figure 99 System configuration for log-shipping operationsThe following conditions are assumed::• The primary volumes on the source server and the vol

1. Back up the SQL Server database to the secondary volumes.To perform an online backup of the SQL Server database, execute the drmsqlbackup commandon

4. Transfer the metafile and the temporary file from the source server to the distribution target server.Use the ftp (file transfer protocol) command

8. Restore the backup data to the distribution target server volumes.Check that the backup data has been copied to the distribution target server volu

Figure 100 System configuration for setting a distribution target server to be an operating serverThe following conditions are assumed:• The distribut

2 Application Agent system configurationsThis chapter describes the system configurations and volume configurations required for usingApplication Agen

2. Place the standby database online.To use a Application Agent command after restoring the database, execute the drmsqldisplaycommand with the -refre

• The primary volume at the local site and the primary volume at the remote site must be defined asa pair in Continuous Access Software. The primary a

4. After the pair status of the Continuous Access Software pair volume is changed to PAIR, performtakeover.To perform takeover, execute the RAID Manag

12. Create a user script file.To obtain the information required to create a user script file, execute the drmsqldisplaycommand on the database server

18. Create a template catalog at the remote site.To create a template catalog, execute the drmsqlbackup command on the database server atthe remote si

Creating a user script to perform a backup in a cascade configurationTo perform backup in a cascade configuration, you need to create a user script fi

• If you set TIMEOUT to 0, the drmsqlbackup command does not finish unless the command ex-ecuted by the user script file finishes. Keep this in mind w

- - - - TC01,sql01 TC01,sql01#0 - - - - 114 C 55555D UserDB DATAFILE P:\UserDB_Data.NDF -

Figure 104 Flow of script-specified operations performed when local backup is not involvedTable 102 Sample script for when a local backup is not perfo

DescriptionScript code(3) Batch resynchronization witha pair group specifiedCMDLINE=C:\HORCM\etc\pairresync.exe -g TC01 -FBC 0 ...(3)(4) Specifies a r

Figure 6 Example of a system configured to back up and restore data within a storage systemConfigurations in which data can be backed up and restored

DescriptionScript code(15) Waits for command termin-ation.TIMEOUT=0 ...(15)(16) User processing for pairsplitting.[SPLIT_PROC] ...(16)# Target pair vo

DescriptionScript code(26) Checks the sql02 pairstatus.Waits until the sql02 statusbecomes PSUS.CMDLINE=C:\HORCM\etc\pairevtwait.exe -g TC01 -d sql02

Figure 105 Flow of script-specified operations performed when local backup is involvedTable 103 Sample script for when a local backup is performedDesc

DescriptionScript code(3) Batch resynchronization witha pair group specifiedCMDLINE=C:\HORCM\etc\pairresync.exe -g TC01 -FBC 0 ...(3)(4) Specifies a r

DescriptionScript code(15) Waits for command termin-ation.TIMEOUT=0 ...(15)(16) User processing for pairsplitting.[SPLIT_PROC] ...(16)# Target pair vo

DescriptionScript code(26) Checks the sql02 pairstatus.Waits until the sql02 statusbecomes PSUS.CMDLINE=C:\HORCM\etc\pairevtwait.exe -g TC01 -d sql02

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\pairre

4. Export the backup catalog to a temporary file.Export the backup catalog to a temporary file. To export the backup catalog to the temporaryfile C:\t

7. Check the import results.Confirm that the import finished successfully. To confirm this, execute the drmsqlcat commandon the backup server at the r

10. Unmount the secondary volume.To unmount the secondary volume, specify the backup ID used when mounting 0000000002.This step must be performed on t

Figure 7 Continuous Access Software or Continuous Access Journal system configurationBusiness Copy and Continuous Access Software multi-target configu

3. Perform takeover.If the local site primary volume can communicate with the remote site secondary volume (forexample when the current and standby sy

7. Unmount the secondary volume.To unmount the secondary volume, specify the backup ID that was used when mounting0000000002. This step must be perfor

10. From the database server, obtain the temporary file that was exported on the backup server.Obtain the temporary file C:\FTP_ROOT\EX-FILE1.drm, whi

15. Restore the data from the secondary volume to the primary volume.Restore the data by resynchronizing the primary and secondary volumes. To restore

21. Perform takeover at the local site to change the local site to the primary volume.Execute the horctakeover command at the local site.PROMPT> ho

10. Check the storage location of the data files and log files.To check the location, execute the drmmount command using the backup ID checked in step

Figure 106 System configuration using file sharing to back up and restore an SQL Server databasePreparing to back up or restore by using a file shareT

3. Use Explorer on the database server to allocate the temporary directory for extended commandsas a network drive.In this case, C:\FTP_ROOT\script\Op

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 da

Figure 107 System configuration for restoring data to an SQL Server instance different from the backupsourceFor example, if only the user database bac

Figure 8 Business Copy and Continuous Access Software multi-target configurationBusiness Copy and Continuous Access Journal multi-target configuration

Additionally, execute the drmsqlinit command on database server 2 to create a databaseconfiguration definition file. In this case, do not specify the

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

• Execute the drmresync command, specifying the backup ID of the data to be deleted.PROMPT> drmresync -backup_id backup-IDKAVX0001-I The drmresync

Figure 108 System configuration for restoring to an SQL Server instance that is different from thebackup source (using a user script)The following sys

• The copy groups are composed of the following two generations:Generation 1 (VG01, VOL11 and VG01, VOL12): Used for data miningGeneration 2 (VG02, VO

[POST_PROC]: Executes the remote_sqlrestore.bat batch file. The contents ofremote_sqlrestore.bat mount the secondary volume and execute the restore co

@echo off@bpbackup -k "%DRMENV_COMMENT%" -p ptm_plc -s ptm_schd -i -S BackupServer -w -t 0 -L C:\temp\nbu.logif NOT "%ERRORLEVEL%"

Figure 109 Configuration for using the SQL Server replication functionRequirements for the publication database and the distribution databaseThe publi

Figure 110 Configuration of backup server for the publisher/distributor serverRequirements for the subscription databaseBecause the subscription datab

PROMPT> drmsqlbackup instA -target PubUserDB1,distributionPROMPT>• Back up the subscription databaseExecute the drmsqlbackup command on the subs

Figure 9 Business Copy and Continuous Access Journal multi-target configurationContinuous Access Software and Continuous Access Journal multi-target c

Restore the databases• Restore the publication databaseSpecify the backup ID used when the publication database and the distribution database wereback

Specify the backup ID used when the databases, including the system databases, were backedup, and execute the drmsqlrestore command on the publisher/d

sp_replicationdboption 'database-name', 'sync with backup', 'true'For the database-name argument, specify the name of th

Figure 111 Operation when using Application Agent on an SQL Server in an AlwaysOn availabilitygroup configurationThe following conditions must be sati

1. Back up the user database.On the database server (active server), execute the drmsqlbackup command with the -targetor -f option specified.To execut

1. Back up the user database to the secondary volume.On the database server (active server), execute the drmsqlbackup command with the -targetor -f op

7. Confirm that the backup information file has been imported correctly.On the database server (standby server), execute the drmsqlcat command.PROMPT&

4. Back up the user database to the secondary volume.On the database server (active server), execute the drmsqlbackup command with the -targetor -f op

10. Confirm that the backup information file has been imported correctly.On the secondary-use server (active server), execute the drmsqlcat command.PR

7 Operation for Exchange databasesThis chapter explains the procedures for running Application Agent when backing up Exchangedatabases. The descriptio

CCR configurations ... 58Configuration in wh

Figure 10 Continuous Access Software and Continuous Access Journal multi-target configurationBusiness Copy (multi-generation), Continuous Access Softw

Event source: ftdiskEvent ID: 57orEvent type: warningEvent source: diskEvent ID: 51This Windows event information is logged during a VSS backup when t

transactions log files, a roll-forward will be completed when the drmexgrestore command isexecuted, but the Information Store will not be mounted. In

Precautions on recovery storage groups and recovery databasesIf you are using Exchange Server 2003 or Exchange Server 2007 as the database managements

Figure 112 System configuration for backing up and restoring data between volumes without usingVSS (when an Exchange database is backed up)Processing

Figure 113 Processing flow for backing up storage groups to a secondary volumeFigure 114 Processing flow for restoring storage groups on the primary v

Restoring storage groups to a primary volumeThis section explains how to restore a storage group when backup data has been saved on a secondaryvolume.

Figure 115 System configuration for backing up and restoring data between volumes by using VSS(when an Exchange database is backed up)Processing flowT

Figure 116 Processing flow for backing up storage groups to a secondary volumeFigure 117 Processing flow for restoring storage groups on the primary v

Restoring storage groups to a primary volumeThis section explains how to restore a storage group when backup data has been saved on a secondaryvolume.

Figure 118 System configuration for backing up and restoring storage groups to and from tapeWith Application Agent, database servers can be clustered.

Figure 11 Business Copy (multi-generation), Continuous Access Software, or Continuous Access JournalconfigurationPrecautions on backing up and restori

• The primary volume configured as a pair with the secondary volume to be backed up will not bebacked up until the secondary volume is backed up onto

Figure 119 Processing flow for backing up storage groups to tapeApplication Agent CLI User Guide 411

Figure 120 Processing flow for restoring storage groups from tapeBacking up storage groups to tapeResynchronizing copy groupsWhen usual operation is i

Cold backupAn example of backing up storage groups to tape in a cold backup is described below. In a coldbackup, the Information Store to be backed up

5. Import the temporary files, which were transmitted from the database server, into the backupcatalog on the backup server.To import the temporary fi

3. Export the backup information to temporary files.To back up from the secondary volume onto tape, you must copy onto the backup server allinformatio

1. Back up the storage group to the secondary volume.Using VSS, back up the storage group in an online backup operation. To perform backup, executeEX_

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

4. Receive the temporary files on the database server.To batch-receive the temporary files held on the backup server onto the database server, execute

Backing up a storage group by using a user scriptBy using a backup command that specifies a user script, you can use a single operation to back upa st

Figure 12 Example of configuration for concurrent backup from multiple primary volumes to multiplesecondary volumes (remote copy)• Regarding start of

Figure 122 Processing flowUser script exampleThe table below shows the user script that is created for the example.Table 104 User script creation exam

ExplanationScript text[CMD]CMDLINE=C:\tmp\tapebackup.bat(3) Execute the next command withoutwaiting for the command to terminate.TIMEOUT=NOWAIT ...(3)

rolled forward by specifying the -recovery option. In this case, by applying the transaction logsafter backup, the database can be recovered to the st

This example describes the procedure for restoring only the data in the mailbox store (InformationStore) out of the backup data obtained by VSS from t

To perform restoration of data from a VSS backup, the Protection Manager service must be runningon the backup server.To roll forward transaction logs

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 lo

• A storage group STR1 exists on the database server (DBServer) in the local site, and servicesare running.• The volume (usual operation is in the pai

2. Back up the database to the secondary volume in the remote site.To back up the database to the secondary volume in the remote site, specify the gen

Operations at the remote site1. Import the temporary files, which were transmitted from the database server in the local site, intothe backup catalog

Operations at the local site• Resynchronize the copy groups.To resynchronize the copy groups, execute EX_DRM_RESYNC on the database server.DBServer &g

Figure 13 Example of a system configured with a tape deviceConfigurations for operation in cluster environmentsThis section describes configurations f

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 whic

3. Check that the temporary file has been imported correctly.To check that backup information bearing the date on which the storage groups had been ba

Figure 126 Example of a system for backing up and restoring data in a cascade configurationThe examples in this section assume the following condition

• Continuous Access Synchronous is configured between disks P1 and P3, and between disks P2and P4.• Using the RAID Manager configuration definition fi

KAVX0256-I A connection to the Protection Manager service will now be established. Host name = name-of-backup-server-BKAVX0040-I The backup

Operation at both the local and remote sites1. Confirm that the backups were performed correctly.Execute the drmexgcat command on database server A to

2. Confirm that the files were imported correctly.Execute the drmexgcat command on backup server A to check whether the backup cataloginformation for

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 onthe sec

4. Confirm that the data was correctly backed up to tape.Execute the drmtapecat command on backup server A to check whether there exists backupcatalog

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:B

Figure 14 Example of a cluster configuration of the operation standby type (Active-Passive)To execute Application Agent commands in a cluster configur

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:

4. Confirm that the data was restored correctly from the tape to the secondary volume.Execute the drmexgcat command on backup server A to check whethe

7. Transfer the temporary file to the database server.Using ftp on database server A, transfer the temporary file from backup server A to databaseserv

10. Separate the Continuous Access Software pair.Use RAID Manager on database server A to separate the Continuous Access Software pair:DBServer A >

2. Check the backup ID of the backup data.To check the backup ID, execute the drmtapecat command on backup server B:BKServer B > drmtapecatBACKUP-I

5. Confirm that the data was restored correctly from the tape to the secondary volume.Execute the drmexgcat command on backup server B to check whethe

8. Transfer the temporary file to the database server.Using ftp on database server B, transfer the temporary file from backup server B to databaseserv

11. Separate the Continuous Access Software pair.Use RAID Manager on database server B to separate the Continuous Access Software pair:DBServer B >

• 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 volum

• Backup of another primary volume cannot be performed until the secondary volume is backed upto the tape device.• Initially, database server A is the

Figure 15 Example of a cluster configuration of the mutual standby type (Active-Active)To execute Application Agent commands in a cluster configuratio

Performing a backup on the active server1. Clear the system cache on the backup server.To clear the system cache, execute the drmmount command on back

3. Confirm that the data was backed up correctly.Execute the drmexgcat command on database server A, and check the backup information.DBServer A >

7. Confirm that the file was imported correctly.Execute the drmexgcat command on backup server A to check whether the backup informationfor the date o

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 onthe secon

Performing a backup on the standby server1. Clear the system cache on the backup server.To clear the system cache, execute the drmmount command on bac

3. Confirm that the data was backed up correctly.Execute the drmexgcat command on database server B, and check the backup information.DBServer B >

7. Confirm that the file was imported correctly.Execute the drmexgcat command on backup server B to check whether the backup informationfor the date o

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 onthe seco

Restoring data when using the automatic seed functionThe following subsections provide examples of restoring data using different backup servers for t

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 ont

Figure 16 Example of a system configured to use VSS to back up dataRequirements and precautions for backing up file systemsThis subsection explains re

5. Unmount the secondary volume after restoration of the backup data is finished.Execute the drmumount command on backup server A to unmount the secon

9. Confirm that the file was imported correctly.Execute the drmexgcat command on database server A to check whether the backup informationfor the date

Restoring backup data acquired on the standby server (when the automatic seed function isused)This subsection gives an example of performing a roll-fo

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 ont

6. Unmount the secondary volume after restoration of the backup data is finished.Execute the drmumount command on backup server B to unmount the secon

10. Confirm that the file was imported correctly.Execute the drmexgcat command on database server B to check whether the backup informationfor the dat

Restoring data when not using the automatic seed functionThe following subsections provide examples of restoring data using different backup servers f

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 ont

5. Unmount the secondary volume after restoration of the backup data is finished.Execute the drmumount command on backup server A to unmount the secon

9. Confirm that the file was imported correctly.Execute the drmexgcat command on database server A to check whether the backup informationfor the date

• Do not mount another volume in a directory on the volume to be backed up. If another volume ismounted, mounting and restoration for the secondary vo

Restoring backup data acquired on the standby server (when the automatic seed function isnot used)This subsection gives an example of performing a rol

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 ont

6. Unmount the secondary volume after restoration of the backup data is finished.Execute the drmumount command on backup server B to unmount the secon

10. Confirm that the file was imported correctly.Execute the drmexgcat command on database server B to check whether the backup informationfor the dat

Backing up and restoring in SCR configurationsThis section provides examples of how to back up and restore data in SCR configurations. Theexplanations

Drive letterDisk numberD:Disk P1,Disk P3E:Disk P2,Disk P4• Each disks contains the following.ObjectDisk numberThe information storage configuration fi

2. Clear the system cache right before performing a backup.To clear the system cache, temporarily mount the secondary volume on the backup server.PROM

4. From the source server, confirm that the backup was successful.PROMPT> drmexgcatSTRAGEGROUP: STR1BACKUP-ID:0000000001 BACKUP-MODE: VSS STRAGEGRO

8. Check the backup catalog information that was imported into the backup server.PROMPT> drmexgcatSTRAGEGROUP: STR1BACKUP-ID:0000000001 BACKUP-MODE

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> drmmedia

Figure 17 Example of a system configured to restore data on a host that differs from the host usedfor backupConfigurations for using the log-shipping

2. From the backup server, check the backup ID of the tape device.PROMPT> drmtapecatBACKUP-ID BACKUP-OBJECT SNAPSHOT TIME EXPIRATION TI

5. From the backup server, confirm that the restoration from the tape device to the secondary volumewas successful.PROMPT> drmexgcatSTRAGEGROUP: ST

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

Point-in-time restoration when not using the SCR seed functionThis section gives an example of how to perform a point-in-time restoration on a storage

5. From the backup server, confirm that the restoration from the tape device to the secondary volumewas successful.PROMPT> drmexgcatSTRAGEGROUP: ST

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

Point-in-time restoration when using the SCR seed functionThis section gives an example of how to perform a point-in-time restoration on a storage gro

5. From the backup server, confirm that the restoration from the tape device to the secondary volumewas successful.PROMPT> drmexgcatSTRAGEGROUP: ST

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

11. While the SCR seed function is still enabled, perform a point-in-time restoration on the backupdata from the secondary volume to the primary volum

Figure 18 Example of a system configuration for the log-shipping functionalityCascade configurationsWhen the backup is of an SQL Server database, Appl

Figure 129 System configuration for backing up and restoring data in a DAG configurationFor the backup and restoration examples below, assume the foll

ObjectDisk numberThe database file for the active mailbox database copy Mail01Disk P1The transaction log file and checkpoint file for the active mailb

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

4. Check the imported backup catalog information on backup server 1.PROMPT> drmexgcatSTORAGEGROUP: /EXCHANGEBACKUP-ID: 0000000001 BACKUP-MODE: VSS

7. On backup server 1, verify that the backup to the tape device was completed successfully.PROMPT> drmtapecat -backup_id 0000000002BACKUP-ID BAC

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

4. Check the imported backup catalog information on backup server 2.PROMPT> drmexgcatSTORAGEGROUP: /EXCHANGEBACKUP-ID: 0000000001 BACKUP-MODE: VSS

7. On backup server 2, verify that the backup to the tape device was completed successfully.PROMPT> drmtapecat -backup_id 0000000002BACKUP-ID BAC

4. On backup server 1, restore the backup data from the tape device to the secondary volume.Execute the drmmediarestore command with backup ID 0000000

7. On backup server 1, export the backup catalog information to the temporary file.PROMPT> drmdbexport 0000000003 -f C:\FTP_ROOT\0000000003.drmKAVX

Setting communication timeout periods for the Protection Manager service ... 114Setting up Application Agent for linkage w

Figure 19 Example of a cascade configuration (when the backup is of an SQL Server database)Multi-target configurationsWhen the backup is of an SQL Ser

11. On the backup server, perform a roll-forward restore operation for the data on the secondaryvolume to the primary volume. Do this with the seed fu

4. On backup server 2, mount the secondary volume to restore the backup data from the tapedevice.Execute the drmmount command with backup ID 000000000

7. On backup server 2, unmount the secondary volume on which the restore operation from thetape device has been completed.Execute the drmumount comman

11. On database server 2, check the execution result of the import operation.PROMPT> drmexgcatSTORAGEGROUP: /EXCHANGEBACKUP-ID: 0000000001 BACKUP-

To back up storage groups to tape (where a tape backup management software that is unable to linkwith Application Agent is used):1. When usual operati

Preparing to use a file share for storage group backup and restoreTo prepare to back up and restore storage groups by using a file share:1. Check the

Example of using a file share for storage group restorationThis section explains how to restore storage groups on the backup server by using a file sh

8 TroubleshootingThis chapter explains how to deal with problems that may occur during the operation of ApplicationAgent. The descriptions in this cha

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 erro

Default file nameSummaryInformation typeWindows Server 2008 or Windows Server 2012All files in the following folder:system-drive\Users\user-name#3\App

Figure 20 Example of a multi-target configuration (when the backup is of an SQL Server database)Requirements and precautions for backing up SQL Server

Default filesSummaryInformation typeApplication-Agent-installation-directory\DRM\log\drm_pp_trace[1-16].logApplication Agent tracelog files#2Detailed

size of the drm_nbu_restore.log file reaches 10 MB, the contents of the file are moved todrm_nbu_restore.log.old. If drm_nbu_restore.log.old already e

Database information (when the backup is of an SQL Server database or Exchange database)Collect the following information about the database. In cases

• A command (including Application Agent commands (drmxxx)) inside the extended command isexecuted and then failedThe log file output directory can st

ExplanationItemWhen the backup is of a file system:The name of the mount point directory or mount point directory list filethat was backed up.When the

Adjusting trace log settingsThis section explains how to adjust trace log settings.Adjusting the output level for detailed trace log informationThe le

Investigating standard output logsWhen execution of a Application Agent results in some problem, investigate the information in thestandard output log

The following shows the items output to the detailed trace log.Table 111 Items output to the detailed trace logDescriptionOutput itemLog sequence numb

Message IDMessage output is triggeredby:Source of mes-sages (controlledobjects)KAVX9203-I, KAVX9204-W, KAVX9205-ECluster operations using theWindows A

KAVX0006-E An error that stopped processing occurred.Cause = DRM-10106: An internal error occurred.In such a case, if the following message is output

Storage destination forbackup filesBackup file nameType of file subject tobackupDatabase subjectto backup#1Secondary volumeSame as the backup sourcefi

2. Take the following actions in accordance with the output results.When the message KAIU020-I is output:Make sure that there are no problems in the d

1. Create the parameter file for error recovery in the desired directory.fi-Application-Agent-installation-directory\DRM\db\table-to-be-recovered2. Ex

1. Execute the drmisext command to extract as many records as possible to a temporary file.drmischk Application-Agent-installation-directory\DRM\db\ta

Recreating dictionary map files1. Copy and save all files and directories in the directory storing the dictionary map files.2. Delete all files and di

Troubleshooting524

9 Support and other resourcesNumerous support options are available.Contacting HPHP technical supportFor worldwide technical support information, see

ConventionsThis guide follows the conventions shown in Table 115 to refer to HP P9000 products.Table 115 Product reference conventionsFull name or mea

Full name or meaningProduct referenceThis abbreviation is used when it is not necessary to distinguishthe following products:• XP Continuous Access As

Full name or meaningProduct referenceThis abbreviation is used when it is not necessary to distinguishthe following products:• Snapshot• XP Snapshot•

A Example of an Application Agentenvironment configurationThis appendix explains an example configuration of the Application Agent environment. Thedes

• Do not use the name META_database-ID (ten digits).dmp for a data file of a database or transactionlog file.• Backed-up data cannot be restored or re

Figure 130 System configuration (for the example Application Agent environment configuration)The following example shows details regarding the above c

Information(Backup server)Information(Database server)Item• RAID Manager (instance number:1)• Device Manager Agent• Application Agent• RAID Manager (i

Volume contentsGenerationCopy group nameMount drivefrom thebackup serverMount drivefrom the data-base serverDB02 (LDF)2nd generationVG02,VOL233rd gene

(C:\Windows\horcm1.conf)HORCM_MON#ip_address service poll(10ms) timeout(10ms)localhost horcm1 6000 3000HORC

HORCM_MON#ip_address service poll(10ms) timeout(10ms)localhost horcm2 6000 3000HORCM_CMD#dev_name

• RAID Manager configuration definition file, for the backup server(C:\Windows\horcm2.conf)HORCM_MON#ip_address service poll(10ms) tim

LOGLEVEL=3PP_LOGFILE_NUM=2COM_RETRY_TIME=0COM_RETRY_WAIT=10CLU_RETRY_TIME=6CLU_RETRY_WAIT=10SVC_RETRY_TIME=6SVC_RETRY_WAIT=10DRM_DB_PATH=L:\PTM;SQL001

HORCMINST=1HORCMINST_AUX=2RETRY_TIME=120RETRY_WAIT=5VENDER=HPPRODUCT=OPEN-3INSTALLPATH=C:\HORCM• RAID Manager-linkage definition file, for the backup

PROMPT> set DRM_HOSTNAME=SQL001PROMPT> drmsqlinit DEFAULTPROMPT> KAVX1100-I Enter the name of the storage directory for VDI metafiles:

CLASS can be replaced with POLICY for this example. However, both POLICY and CLASS cannotbe specified for the same MOUNT_POINT.Example registering inf

database is backed up and restored along with the database configuration file of the masterdatabase when the system database is backed up and restored

INST_PATH=C:\Program Files\VERITAS\NetBackupMOUNT_POINT=W:CLASS=Class1SCHEDULE=Schedule1MOUNT_POINT=X:CLASS=Class2SCHEDULE=Schedule2MOUNT_POINT=Y:CLAS

Operation definition files (_operation-ID.dat) with the same contents are placed on each backupserver (both the active server and the standby server).

VG03,VOL31VG03,VOL32VG03,VOL33VG03,VOL34For details about copy-group list files, see “Creating a copy-group list file” on page 159.Example of an Appli

B List of files used in Application AgentThis appendix explains the purposes and locations of the files used by Application Agent. Thedescriptions in

Storage locationDescriptionFile name--Files that contain exportedbackup catalog information.These files are used to ex-change backup catalog in-format

Storage locationDescriptionFile nameUser creates the files in the desired location.• When the backup is ofan SQL Server data-base:Definition files con

Storage locationDescriptionFile nameIn a file server or database server:directory-at-the-same-level-as-the-dictionary-map-file-directory\script_work\o

Storage locationDescriptionFile nameApplication-Agent-installation-directory\DRM\conf\raidA user-specified file name.Create this file to changethe ret

List of files used in Application Agent548

C Replacing primary and secondary volumedisks while Application Agent is runningThis appendix explains how to replace a primary or secondary volume di

Figure 21 Allocation of database configuration filesAllocating multiple database configuration files to one volumeWhen multiple database configuration

Figure 131 Example of replacing a primary volume diskTo replace the primary volume:1. Execute the following RAID Manager command to delete the pair de

3. On the host that manages the primary volume, create a volume for the new primary volume.In Windows Server 2003:From the Start menu, choose Control

12. On the host that manages the primary volume, import the catalog.PROMPT> drmdbimport -f \tmp\expfile13. Execute the drmfsrestore command with th

2. On the host that manages the secondary volume, create the volume for a new secondary volume.In Windows Server 2003:From the Start menu, choose Cont

Replacing primary and secondary volume disks while Application Agent is running554

D Restoring from a tape directly to aprimary volume in a Fast Snap or SnapshotconfigurationThis appendix describes an example of restoring data from t

Procedure for restoring from tape directly to the primary volumePerform the following procedure on the database server.To restore data that was backed

E Correspondence to Replication ManagerGUI termsSome terms used in the Application Agent command line interface have different meanings from thoseused

Correspondence to Replication Manager GUI terms558

GlossaryThis glossary defines the special terms used in this document. Click the desired letter below to displaythe glossary entries that start with t

Figure 23 Metafile allocationAssume that you have a cluster system in which database servers are clustered using Microsoft ClusterService or Windows S

copy group A copy group consists of a primary volume and secondary volume that aresynchronized and split using volume replication functionality and RA

If a database is frozen when a paired volume is synchronized, the primary andsecondary volumes will be identical. Backing up the database in this stat

Glossary562

IndexAActive-Active, 44, 132Active-Passive, 43, 130adjustingnumber of log files for detailed trace log, 515output level for detailed trace log, 515all

backing up storage group by using user scriptsystem configuration, 419backing up storage group to secondary volume,404backing up storage group to tape

CONFIRM_GENERATION_IDENTICAL, 127contents of list file, 161contents of transaction log list file, 162Continuous Access Journal, 559Continuous Access S

distribution target serversetting, 348DRM_DB_SYNC, 110drm_output.log, 201, 508, 509drm_output.log.old, 508drm_script.log, 507drm_script.log.old, 507dr

extended command trace log file, 507extended commands, 219troubleshooting, 507Ffailover, 560Fast Snap, 560Fast Snap or Snapshot configuration example,

HP StorageWorks P9000 Protection Managersoftware, 561IINCLUDE_EXEC, 155incorrect data filerestoring, 521Information Store, 561init.conf, 106, 544examp

period required to verify Exchange Server 2007database for backup by using VSS, 72period required to verify Exchange Server 2010database for backup by

Figure 24 Metafile allocation (in the cluster configuration)Using a dynamic disk configuration• Do not allocate a data file made up of multiple instan

RRAID Managerenvironment setup, 100RAID Manager configuration definition file,100, 544RAID Manager information, 511RAID Manager-linkage definition fil

SCR configurationsfor backing up Exchange databases, 61SCRIPT_FILE, 157secondary volume diskreplacing, 552replacing, 552SET_DRM_HOSTNAME, 186, 191, 19

SQL Server database requirement for executingcommand, 284SQL Server database status for executingcommand, 285SQL Server database type for executingcom

volume copy function between storage systems,32volume dynamic recognition, 561volume replication functions, 561VSSusing, 70VSS definition file, 145, 5

574

Using a cluster configuration• Do not register the service resources of multiple SQL Server instances into a cluster group.• In a cluster environment,

• When VSS backup is used with SCC, backups can be performed only at the active server. However,when VSS backup is used with CCR, backups can also be

Determination of a mount point ... 177Determination of a mount target

Figure 27 Example of a CCR configuration (only the standby server is used)Configuration in which different backup servers are used for the active and

Figure 29 Example of a CCR configuration (active and standby servers use the same backup server)SCR configurationsApplication Agent provides VSS backu

Figure 30 Example of an SCR configurationApplication Agent's restore processing provides the SCR seed function that executes seed processing(data

an active mailbox database copy, you can use the data in a passive mailbox database copy tocontinue operation.Application Agent provides backup and re

Figure 31 Configuration in which an active mailbox database copy Is backed up and restoredPrimary volume 1 is the active mailbox database copy, primar

Figure 32 Configuration in which a passive mailbox database copy Is backed up and restoredPrimary volume 1 is the active mailbox database copy, primar

Figure 33 Configuration in which an active mailbox database copy and a passive mailbox databasecopy are backed up and restored by different backup ser

Backing up and restoring the active mailbox database copy and the passive mailbox databasecopy by using the same backup serverThe following figure sho

If logical errors, such as those caused by viruses, occur on both the active side and the passive side,the data is restored from the tape device to se

Requirements and precautions for backing up ExchangedatabasesThe following table describes the types of data subject to backup in the Exchange databas

Precautions on operations ... 223Precautions on o

• Maximum length: 64 characters• Characters that cannot be used = ; \ / ,• The operations shown below change information pertaining to the Exchange Se

• P9000 RMXP Shadow Copy Provider must be installed in advance, on both the database serverand the backup server. If P9000 RMXP Shadow Copy Provider h

the verification, we recommend that you use the drmexgverify or EX_DRM_EXG_VERIFYcommand to verify the database before performing restoration or backi

• The following table lists the approximate amount of time required to verify a database for Ex-change Server 2010.Table 6 Approximate amount required

The table below lists the conditions for allocating files when restoring backup data in units of InformationStores.Table 7 Conditions for allocating f

• Restore only IS12 individually• Restore IS13 and IS14 at the same time (you cannot restore just one)Notes:• When restoring backup data in units of I

• When using VSS, the following conditions must be satisfied regarding the relationship betweenthe cluster resource and the Exchange Information Store

CCR configuration• With a CCR configuration, you must manage dictionary map files and backup catalogs separatelyfor the active and standby servers. Th

• The server used for seed processing has sufficient performance (such as CPU and disk perform-ance) to adequately run the installed applications (suc

• To restore the backup data, the mailbox database copy to be restored must be in the active status.If it is not in the active status, a message indic

Backing up a file system to a remote site ... 264Operations at the local sit

Figure 36 Configuration for managing the primary volume and secondary volume from the sameserver (without using Application Agent)• A copy group must

drmXXdisplay indicates the drmfsdisplay, drmsqldisplay, or drmexgdisplaycommand.• When using Continuous Access Journal, define h0 (h and a generation

Figure 37 System configuration (when the primary volume for Business Copy and the primaryvolume for Continuous Access Software are the same LDEV)When

Figure 38 System configuration (when the secondary volume for Business Copy and the primaryvolume for Continuous Access Software are the Same LDEV)Whe

Figure 39 System configuration (In a Business Copy cascade configuration, when the volume subjectto backup operates both as the primary volume and the

If not using VSS:It is possible to define consistency groups to make files of the same file types of multiple storagegroups that are always restored t

Figure 40 In XP Continuous Access Asynchronous/Continuous Access Journal configuration: restoringUserDB1 and UserDB2 together or separatelyFigure 41 I

CMD-IP-address-PORT-number), take measures based on the confirmed information, andthen start Application Agent CLI operation once again.Volume configu

Figure 42 Examples of a disk set configuration and of a relationship between a disk group and a disksetIn this manual, unless it is necessary to disti

Examples of disk group configurations usable by Application AgentIf you configure a disk group with logical volume manager, Application Agent can be u

Resynchronizing copy groups ... 298Backing up an SQL Server databas

Figure 44 Data backup and restoration in a system configuration where multiple disk groups exist ina file systemIn this figure, disk groups DG01 and D

Example:Restore only the file system created in disk group DG02 after backing up disk groups DG01 andDG02.PROMPT> drmfsrestore 0000000001 -resync -

• If one disk group contains multiple physical volumes, Application Agent performs volume duplicationoperation for backup only by the number of physic

• A disk group was deleted or disabled.• A logical volume allocated to a disk group was added or deleted.• A physical volume belonging to a disk group

Backing up and restoring dynamic disks by dynamically or statically recognizing secondaryvolumesDynamically recognizing secondary volumes:• When Appli

formed. To view the backup signatures that were created when the backup was performed, executethe drmdevctl command by specifying the backup ID and th

Application Agent system configurations96

3 Preparation for using Application AgentThis chapter explains the flow of environment setup required for using Application Agent, and givesdetails on

Sections anddocuments forreferenceFile nameBackupserverFile serv-erordatabaseserverEnvironment setup taskSetting up Ap-plication Agentfor linkage with

Sections anddocuments forreferenceFile nameBackupserverFile serv-erordatabaseserverEnvironment setup taskCreating a listfile, page 159Any fileNeededNe