Creating a transaction log list file, File name of the transaction log list file, Transaction log list file storage location – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 163: Contents of the transaction log list file, 163 transaction log list file storage location, 163 contents of the transaction log list file

Advertising
background image

# Example of specifying files

D:\data1\batch_0001\Tokyo_output_dir

D:\data1\batch_0001\Osaka_output_dir

D:\data1\transact.log

Creating a transaction log list file

The transaction log list file is used to specify the sequence of applying the transaction log files when
performing recovery by using the options of the

drmsqlrecover

command. You create this file

when performing recovery by using the transaction logs.

When using the

drmsqlrecovertool

command to recover data, you do not need a transaction

log list file.

File name of the transaction log list file

Use alphanumeric characters to specify the file name.

Transaction log list file storage location

This file can be stored in any location.

In a cluster environment, however, this file should be stored in a shared directory that can be accessed
from both servers.

Contents of the transaction log list file

The contents of the file must follow these coding rules:

Enter the name of the database, followed by the name of the transaction log file.

Enclose the name of the database in square brackets "[" and "]".

Enter the transaction log files for each database in the order in which they are to be applied.

Each transaction log file name must be specified on one line.

Each transaction log file name must be specified using the absolute path name.

A transaction log file name must be left justified with no leading spaces.

Lines beginning with a hash mark (

#

) are assumed to be comment lines.

Example of entries in a target definition file:

# Application Agent 7.0

# Log Backup Files

[SQLDB001]

C:\MSSQL\BackupLog\SQLDBLog001.bak

C:\MSSQL\BackupLog\SQLDBLog002.bak

C:\MSSQL\BackupLog\SQLDBLog003.bak

[SQLDB002]

C:\MSSQL\BackupLog\SQLDB2Log001.bak

C:\MSSQL\BackupLog\SQLDB2Log002.bak

C:\MSSQL\BackupLog\SQLDB2Log003.bak

Application Agent CLI User Guide

163

Advertising