Hp XP Array Manager Software Manuale Utente

HP XP7 Replication ManagerApplication Agent CLI User GuidePart number: TK981-96015First edition: April 2014

Creating a user script to perform a backup in a cascade configuration ... 357Outline of user script files ...

To back up multiple primary volumes to a single generation, specify the same dev_group name forall pair volumes to be backed up in a batch.Figure 48 V

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

• 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

Precautions when restoring an Exchange database ... 402Precautions when restoring from a t

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

NOTE:If the SERVICE_TIMEOUT parameter is changed while a Application Agent command is executing,the timeout time is not changed for the executing comm

NOTE:To utilize, for example, the volume replication function within the storage system when the RAIDManager instance for managing the primary volumes

#2: Even when multiple HORCMINST parameters are specified, if a RAID Manager instancenumber is specified in the DRM_HORCMINST environment variable, on

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

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

Restoring backup data acquired on the standby server (when the automatic seed function isnot used) ...

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 29 Parameter in the RAID Manager-linkage

• drmfsbackup• drmsqlbackup• drmexgbackup• drmresyncTable 30 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

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

A Example of an Application Agent environment configuration ... 521System 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 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

2. Create the dictionary map files and backup catalog on each shared disk.At the two servers comprising the cluster configuration, place the virtual s

1. Change the locations of the dictionary map files and the backup catalog at both the local andremote sites.In the Application Agent configuration de

The following table lists and describes directories that need to be created on a shared disk and thelocation of explanations on how to create the dire

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 36 Parameters for the cluster softwareExplanationEntry nameEnter the virtual se

NOTE:• Execute the drmclusinit command before performing backup.• If you have changed the cluster configuration, execute the drmclusinit command to re

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

Creating a database configuration definition fileThis section describes how to create a database configuration definition file when backing up an SQLd

3. Confirm that the SQL Server database configuration definition file (instance-name.dat) has beencreated.The SQL Server database configuration defini

NOTE:• If your system is in a cluster configuration. or if you use Continuous Access Software or ContinuousAccess Journal functionality, you need to e

You can use the SQL_LOGIN_TIMEOUT parameter to specify the SQL Server login timeout optionin sqlinit_instance-name.conf.A login request timeout is lik

Parameter specifica-tionSQL Serverautomatic re-covery pro-cessingRestorationtypeSystem config-urationRestored objectUSNeeded#PerformedRestorationwhile

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

DefaultDescriptionParameterYou can use the SQL Server log file to check theamount of time from the beginning to the endof automatic recovery of the sy

• Edit the VSS definition file on the file server or database server. The VSS definition file(vsscom.conf) is stored in the following location. Do not

Using VSS with RMXP Shadow Copy Provider version 01-02-03/03 or laterThis subsection describes the system settings on each server when the version of

Using VSS with RMXP Shadow Copy Provider version 01-02-03/02 or earlierIf you use a version of RMXP Shadow Copy Provider that is earlier than 01-02-03

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

Set system environment variables for the backup server, as shown in the table below.Table 45 System environment variables required to use VSS (backup

The following table lists the parameters defined in the definition file for the cascade configuration.Table 46 Parameters defined in the definition fi

OmissionMaximumcharacterlengthDescription#2Parameter#1Y5(Themaximumvalue is86400.)Specify the timeout value forconfiguration check processing at there

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

Setting up linkage with a tape backup management softwareThis section describes how to set up linkage with a tape backup management software. You need

4. Execute the drmtapeinit command with the -v option specified, in order to confirm that theinformation has been registered correctly.An example is p

DescriptionParameterSpecify the NetBackup master server name used to query the backup target(maximum of 255 bytes). Specify a host name that can be re

DescriptionParameterSpecify the schedule name used to back up the data stored in the path specifiedby MOUNT_POINT (use a maximum of 255 bytes).SCHEDUL

The following shows an example of the Backup Exec backup job script file used by ApplicationAgent.[General]JOB_TYPE=BackupJOB_NAME=tapebackup[Backup_O

SCHEDULE=schedule2MOUNT_POINT=G:POLICY=backup1SCHEDULE=schedule1MOUNT_POINT=defaultPOLICY=backup1SCHEDULE=schedule3PARALLEL_COUNT=2• Using Backup Exec

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

Creating a list fileCertain options of extended or basic commands may require you to specify multiple files, databases,copy groups, or other entities.

Commands that support a target definition fileYou can use a target definition file with the following commands:• drmexgbackup• drmexgcat• drmexgdispla

# Example of specifying filesD:\data1\batch_0001\Tokyo_output_dirD:\data1\batch_0001\Osaka_output_dirD:\data1\transact.logCreating a transaction log l

Creation of a transaction log list fileYou can use a redirect file created by specifying the -v option for the drmsqllogbackup commandas a transaction

NOTE:• In a cluster configuration, dictionary map files updating must be performed on the active server.You do not need to perform updating on both se

NOTE:Of the physical disks connected to the device adapter port, do not use the LUN#0 disk for theprimary and secondary volumes if the secondary volum

3. Create backup catalogs for all generations.Create a backup catalog by executing the backup command on the file server or database server.Repeat the

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

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

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

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

System configuration for backing up and restoring storage groups to and from tape ... 407115Processing flow for backing up storage groups to tape .

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

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

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

PROMPT> set DRM_HOSTNAME=VHOST2. Execute drmfsdisplay with the -v option specified, and check the directory name displayedafter DB_PATH:.3. Delete

cscript name-of-the-extended-command-you-want-to-executeIn the Windows default settings, wscript.exe starts an extended command and a pop-up dialogbox

For an item that can be omitted, the default value is used for operation.After creating the host environment settings file, in the created server exec

Creating operation definition files for file system backupCreate an operation definition file according to the configuration of the system using exten

Format of operation definition filesAn operation definition file is created, for each operation ID that uniquely identifies the processingtarget, with

• The subdirectory name must not contain a delimiter character (\).• The subdirectory name must not be specified as only one period (.) or two periods

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

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

2. On the active server (file server A), execute EX_DRM_FS_DEF_CHECK, which is a check tool foroperation definition files.EX_DRM_FS_DEF_CHECK operatio

Deployment of operation definition filesCreate two identical operation definition files for the target SQL Server instance. Place one operationdefinit

The following table shows the entries of an operation definition file, the contents of them, and themaximum value length (in bytes). Specifying the en

Means 1,024 characters (either 1-byte or 2-byte characters), not 1,024 bytes.The character count does not include the characters in the header TARGET_

• When a temporary directory for extended commands is created automatically according to thenaming conventions, the length of the directory name does

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

• The subdirectory name must not be specified as only one period (.) or two periods (..).• The root directory must not be specified.#5Means 1,024 char

To create an operation definition file for a cluster configuration:1. Create an operation definition file on the active server (database server A) on

Legal and notice information© Copyright 2014 Hewlett-Packard Development Company, L.P.Confidential computer software. Valid license from HP required f

Values in the RETRY_WAIT parameter set for each storage system ... 11725Parameters in the RAID Manager-linkage definition

Checking the temporary directory for extended commandsThe temporary directory for extended commands is used when Application Agent executes an extende

For information on how to create a copy-group list file, see “Creating a copy-group list file” on page 160.Checking the FTP service (if you are going

The standard output and standard error output from the commands executed in the user script areoutput to the Application Agent standard output log (dr

Entries in user scriptsThe following table shows the entries specified in user scripts.Table 70 Entries in user scriptsOmissionMultiplespecifica-tion#

OmissionMultiplespecifica-tion#1Meaning and specifiable valuesEntry nameAllowed#3Allowed#4Indicates the beginning of a command definition section.• Th

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

How to determine a mount target when the command for mounting a secondary volumeis executed ...

NOTE:Do not specify a command that is not listed. Doing so might prevent the system from running normally.Table 72 Commands that can be specified in u

Examples of user script usageThe following table provides references to the sections in which examples of user script usage areexplained.Table 73 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

Definition files created after the installation of Application AgentBack up definition files that were created after installing Application Agent. Aft

NOTE:When EX_DRM_DB_EXPORT is executed, one generation of backup information is stored in thetemporary directory for extended commands. Only manage th

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

Correspondence between extended commands and basic commands (Exchangedatabase) ...

Preparation for using Application Agent220

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

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

Commands for displaying dictionary map file information ... 515112Commands for displaying backup information ..

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

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

24

#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

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 operations244

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

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

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

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

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

Preface26

Figure 71 Processing flowUser script exampleThe table below shows the user script that is created for the example.Table 95 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

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

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

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

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 systems276

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 1 Overview of Application AgentThe following describes how Application Agent controls other software components. The numbersbelow correspond to

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

User script files are used to perform a series of backup operations to copy data from a primary volumeto a secondary volume, and then from the seconda

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

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 299

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

If you execute Application Agent commands in a cluster configuration, you must specify the locationof the dictionary map files to be used for each vir

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

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

Application Agent supports mutual standby cluster configurations (Active-Active) as well as operationalstandby cluster configurations (Active-Passive)

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

• 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

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

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

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

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.

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

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

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

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 97 System configuration for restoring and recovering from a host not used for backup (whenbacking up)Operation for SQL Server databases342

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

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

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

Figure 104 Flow of script-specified operations performed when local backup is not involvedTable 101 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

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

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

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

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

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

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

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 9 Business Copy and Continuous Access Journal multi-target configurationContinuous Access Software and Continuous Access Journal multi-target c

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

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

• Restore only the system databasesSpecify the backup ID used when the databases, including the system databases, were backedup, and execute the drmsq

How to set the 'sync with backup' optionWhen creating the replication environment, execute the following stored procedure on the productiond

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

CCR configurations ... 58Configuration in wh

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

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

Precautions when restoring an Exchange databasePrecautions when restoring from a tapeWhen using the drmmediarestore command, or EX_DRM_TAPE_RESTORE ex

Procedure for when the Information Store cannot be mountedIf the data to be restored was obtained by using a VSS backup in Protection Manager version

System configurationTo back up and restore data between primary and secondary volume, install Application Agent onthe database server, and then execut

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 storage groups to and from tapeWith Application Agent, database servers can be clustered.

• 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 116 Processing flow for backing up storage groups to tapeApplication Agent CLI User Guide 409

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

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

Backup using VSSAn example of using VSS to back up a storage group is described below. Backup operations usingVSS are executed with an Information Sto

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 backup information to temporary files.To restore the data from the secondary volume to the primary volume, you must copy backupinformation a

To perform restoration in units of Information Stores, you need to execute a roll-forward with the-recovery option specified. For details on roll-forw

• The secondary volume is backed up to tape by using NTBACKUP, and then is unmounted (this isa step in the user post-processing section).The drmexgbac

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

Restoring by using transaction logs (Roll-forward)When backup data on Exchange Server is restored, the database returns to the state it was in at thet

volume, the database can be recovered to the state it was in immediately before the error occurred(state immediately before point C) by executing roll

Rolling forward the transaction logs at the time of restorationThis section describes the procedure for restoring only a specific Information Store in

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

Backing up and restoring between local sites and remote sitesThis section provides an example of backing up storage groups on Exchange Server from a p

• The system has a database server (DBServer) in the local site and a backup server (BKServer)in the remote site connected to a tape device.• The FTP

Operations at the local site1. Check the volume on which the database will be backed up and the generation identifier.Execute the drmexgdisplay comman

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,

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 ba

Operations at the remote siteTo restore a storage group to a local site:1. Split the Continuous Access Software pair (usual operation is in the pair s

5. Export the backup information to temporary files.To restore from the secondary volume to the primary volume, you must copy to the databaseserver th

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

Figure 123 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

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

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

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 >

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

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

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

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

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

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

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

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

• If you change the settings of the following files, use the Services pane in the Windows to restartthe Protection Manager service:• Application Agent

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

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

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

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

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

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

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-

Setting up Application Agent for linkage with RAID Manager ... 113Specifying instance numbers ...

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

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

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

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

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

3. When using the SQL Server database, delete all files and directories in the directory in whichthe VDI metafiles are stored.To identify the director

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 114 to refer to HP XP7 products.Table 114 Product reference conventionsFull name or meani

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

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

Full name or meaningProduct referenceThis abbreviation is used when it is not necessary to distinguishthe following products:• LUN Configuration and S

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

Figure 127 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

• 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

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

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

• For SQL Server 2005, the database configuration files of the resource and master databases arestored in the same location. Application Agent does no

List of files used in Application Agent540

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

Figure 128 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 running546

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

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

Correspondence to Replication Manager GUI terms550

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

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

Glossary554

IndexAActive-Active, 44, 131Active-Passive, 43, 129adjustingnumber of log files for detailed trace log, 511output level for detailed trace log, 511all

backing up storage group by using user scriptsystem configuration, 414backing up storage group to tape, 410backing up storage groups to a secondaryvol

CONFIRM_GENERATION_IDENTICAL, 126contents of list file, 161contents of transaction log list file, 162Continuous Access Journal, 551Continuous Access S

drm_output.log, 202, 504, 505drm_output.log.old, 504drm_script.log, 503drm_script.log.old, 503drmdbsetup utility, 130, 133dynamic disk, 552dynamic dis

extended command trace log file, 503extended commands, 221troubleshooting, 503Ffailover, 552Fast Snap, 552Fast Snap or Snapshot configuration example,

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

IINCLUDE_EXEC, 156Information Store, 553init.conf, 104, 536example settings, 527INST_PATH, 155, 157INSTALLPATH, 127INSTANCE_NAME, 187, 192, 197INSTANC

precautionexecuting commands in cluster environment(Application Agent), 230precautionsApplication Agent operations, 225application of transaction logs

restoring, 29backup data (in units of Information Stores),72databases (SQL Server AlwaysOn availabilitygroup configuration), 394SQL Server database, 3

Specifying modification of pair status if a backuperror occurs, 127specifying settings for using VSS (when filesystem or Exchange database), 146Specif

trace log settingsadjusting, 511transaction log, 553transaction log batch definition file, 537transaction log file, 538transaction log file (for SQL s

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

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 target ... 180Preparations required before ex

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

a group. If an error occurs in an active mailbox database copy, you can use the data in a passivemailbox database copy to continue operation.Applicati

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

ExtensionFiles subject to backupDatabase subject to backup*.chkCheckpoint filesIn Application Agent, data is backed up and restored in physical volume

Precautions on operations ... 226Precautions on backup a

• Defragmentation using the ESEUTIL utility (ESEUTIL /d).If you have performed any of these operations, you will have to execute the drmexgbackupor EX

• Since the number of log files might increase during backup operations by VSS, when you performbackup by using VSS, the backup results might contain

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

You can perform restoration of all Information Stores stored on the same disk provided thatyou specify all the Information Stores. In this case, if yo

Figure 35 Restoration in units of Information Stores (when the backup target is an Exchange database)In the above example, Information Stores from IS1

Using the Veritas Cluster Server for Windows• The status of the cluster resource groups must be online during backup. If it is not online, the backupc

• Before you back up, you must conceal the secondary volume of the local copy at both the localand remote sites.• When you back up, you must set the E

• If you use the automatic seed function, the Protection Manager service must be active on thestandby server.• If you use the automatic seed function,

• To back up the passive mailbox database copy, the conditions below must be satisfied in additionto the conditions in “Using VSS” on page 70. If any

• Automatic reseed cannot be used with Exchange Server 2013.• For Exchange Server 2013, before performing the restore, you must stop the Microsoft Exc

Operations at the local site ... 266Operations at the remote sit

• A copy group must consist of pair volumes for the same application. When a copy group consistsof more than one pair volume and there are pair volume

• When performing a backup or restoration on a database server, make sure that you unmount thesecondary volume in advance. If you do not, unexpected b

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

Define a consistency group for each storage group file type#.However, if rolling forward is not performed when restore and recovery operations are per

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

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

Backing up an SQL Server database ... 301Restoring an SQL Server database fro

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 file system was moved to another directory and mounted.• A disk group was deleted or disabled.• A logical volume allocated to a disk group was add

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

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 oper-ation of Applic-ationAgent, p

Sections anddocuments forreferenceFile nameBackupserverFile serv-erordatabaseserverEnvironment setup taskSetting up link-age with atape backupmanageme

Specify these settings when a command has ended with an error (with the error messageKAVX1008-E).#4This is not required for a backup server.When a pri

To check whether the RAID Manager configuration definition file you created is correct, test whethera RAID Manager instance can be activated. For deta