ibm tivoli storage manager for databases version...

IBM Tivoli Storage Manager for Databases Version 5.2

Data Protection for Oracle for WindowsInstallation and User’s Guide

SC32-9065-00

��

NoteBefore using this information and the product it supports, read the general information under “Notices” on page 49.

First Edition (April 2003)

This edition applies to version 5, release 2, modification 0, of IBM Tivoli Storage Manager for Databases Version 5.2Data Protection for Oracle for Windows XP, Windows 2000, or Windows Server 2003, 5698–APD, and to allsubsequent releases and modifications until otherwise indicated in new editions.

Order publications through your IBM representative or the IBM branch office that serves your locality.

Your feedback is important in helping to provide the most accurate and highest quality information. If you haveany comments about this book or any other IBM Tivoli Storage Manager documentation, please see “Contactingcustomer support” on page viii.

© Copyright International Business Machines Corporation 1998, 2003. All rights reserved.US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corp.

Contents

Summary of Changes . . . . . . . . . vApril 2003, Version 5 Release 2.0. . . . . . . . v

Preface . . . . . . . . . . . . . . viiWho should read this publication . . . . . . . viiIBM Tivoli Storage Manager Web site . . . . . viiIBM Tivoli Storage Manager publications . . . . viiContacting customer support . . . . . . . . viiiConventions used in this book . . . . . . . . ixReading syntax diagrams . . . . . . . . . . x

Chapter 1. Introducing Data Protectionfor Oracle . . . . . . . . . . . . . . 1Understanding Tivoli Storage Manager . . . . . 1Overview of Data Protection for Oracle . . . . . 2

RMAN and Data Protection for Oracle. . . . . 2LAN-free data transfer . . . . . . . . . . 3Migration and coexistence . . . . . . . . . 3

Chapter 2. Installing Data Protection forOracle . . . . . . . . . . . . . . . 5Environment requirements. . . . . . . . . . 5

Operating system requirements . . . . . . . 5Hardware requirements. . . . . . . . . . 5Software requirements . . . . . . . . . . 6Communication methods . . . . . . . . . 6

Installing Data Protection for Oracle . . . . . . 6

Chapter 3. Configuring Data Protectionfor Oracle . . . . . . . . . . . . . . 91. Define Data Protection for Oracle options in thetdpo.opt file . . . . . . . . . . . . . . 9

Available options . . . . . . . . . . . . 92. Register the Data Protection for Oracle node to aTivoli Storage Manager Server . . . . . . . . 123. Define Tivoli Storage Manager options in thedsm.opt file . . . . . . . . . . . . . . 13

Required options . . . . . . . . . . . 13Other options to consider. . . . . . . . . 14

4. Define Tivoli Storage Manager policyrequirements . . . . . . . . . . . . . . 14

5. Initialize the password with a Tivoli StorageManager Server . . . . . . . . . . . . . 16

Chapter 4. Using RMAN and DataProtection for Oracle. . . . . . . . . 17Invoking RMAN. . . . . . . . . . . . . 17Scripts . . . . . . . . . . . . . . . . 17

Example . . . . . . . . . . . . . . 17Using the Duplex Copy function . . . . . . . 18Removing old backups . . . . . . . . . . 19

Example . . . . . . . . . . . . . . 19Management class options affecting objectremoval . . . . . . . . . . . . . . 19

Reporting problems . . . . . . . . . . . 20Requesting Tivoli Storage Manager service . . . . 21

Chapter 5. Using the utilities . . . . . 23Command line syntax and characteristics . . . . 23TDPOCONF . . . . . . . . . . . . . . 23

Password command . . . . . . . . . . 23Showenvironment command . . . . . . . 24

TDPOSYNC . . . . . . . . . . . . . . 25Considerations . . . . . . . . . . . . 26Syncdb Command . . . . . . . . . . . 27

Appendix A. Quick start guide . . . . 31

Appendix B. Using the Tivoli StorageManager scheduler . . . . . . . . . 33Setting up a schedule . . . . . . . . . . . 33

Part I: On the Tivoli Storage Manager Server . . 33Part II: On the workstation with the OracleServer: . . . . . . . . . . . . . . . 34

Appendix C. Messages . . . . . . . . 39

Notices . . . . . . . . . . . . . . 49Trademarks . . . . . . . . . . . . . . 51

Index . . . . . . . . . . . . . . . 53

© Copyright IBM Corp. 1998, 2003 iii

iv IBM Tivoli Storage Manager for Databases Version 5.2: Data Protection for Oracle for Windows Installation and User’s Guide

Summary of Changes

Changes for this publication are summarized below.

April 2003, Version 5 Release 2.0This release contains the following changes:v Support for Oracle 9i databases.v Support for the Windows Server 2003 operating system.v A quick start procedure is available to assist in setting up your Data Protection

for Oracle environment. See Appendix A, “Quick start guide”, on page 31 formore information.

© Copyright IBM Corp. 1998, 2003 v

vi IBM Tivoli Storage Manager for Databases Version 5.2: Data Protection for Oracle for Windows Installation and User’s Guide

Preface

IBM Tivoli Storage Manager for Databases Version 5.2 Data Protection for Oracle isreferred to as Data Protection for Oracle throughout this book.

Data Protection for Oracle performs online or offline backups of Oracle8i orOracle9i databases to Tivoli Storage Manager storage. This integration with theRMAN Media Management API maximizes the protection of data, thus providinga comprehensive storage management solution.

Tivoli Storage Manager is a separate client-server licensed product that providesstorage management services in a multi-platform computer environment.

Who should read this publicationThe target audience for this publication are system installers, system users, Oracledatabase administrators, and system administrators .

In this book, it is assumed that you have an understanding of the followingapplications:v Oracle Serverv Tivoli Storage Manager Serverv Tivoli Storage Manager backup-archive clientv Tivoli Storage Manager Application Program Interface

It is also assumed that you have an understanding of one of the followingoperating systems:v Windows 2000v Windows XPv Windows Server 2003

Throughout this document, the term Windows refers to Windows Server 2003,Windows 2000 Server, or Windows XP Server.

IBM Tivoli Storage Manager Web siteTechnical support information and publications are available at the followingaddress:www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

By accessing the Tivoli Storage Manager home page, you can access subjects thatinterest you. You can also keep up-to-date with the newest Tivoli Storage Managerproduct information.

IBM Tivoli Storage Manager publicationsTable 1. Related Tivoli Storage Manager publications

Title Order Number

IBM Tivoli Storage Manager for Windows Backup-Archive ClientInstallation and User’s Guide

GC32-0788

© Copyright IBM Corp. 1998, 2003 vii

Table 1. Related Tivoli Storage Manager publications (continued)

Title Order Number

IBM Tivoli Storage Manager for UNIX Backup-Archive ClientsInstallation and User’s Guide

GC32-0789

IBM Tivoli Storage Manager for Windows Administrator’s Guide GC32-0782

IBM Tivoli Storage Manager for Windows Administrator’sReference

GC32-0783

IBM Tivoli Storage Manager for AIX Administrator’s Guide GC32-0768

IBM Tivoli Storage Manager for AIX Administrator’s Reference GC32-0769

IBM Tivoli Storage Manager for Sun Solaris Administrator’sGuide

GC32-0778

IBM Tivoli Storage Manager for Sun Solaris Administrator’sReference

GC32-0779

IBM Tivoli Storage Manager Messages GC32-0767

IBM Tivoli Storage Manager Using the Application ProgramInterface

GC32-0793

Tivoli Storage Manager Managed System for SAN Storage AgentUser’s Guide

GC35-0434

Contacting customer supportFor support for this or any Tivoli product, you can contact IBM Customer Supportin one of the following ways:v Visit the Tivoli Storage Manager technical support Web site at:

www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

v Submit a problem management record (PMR) electronically atIBMSERV/IBMLINK. You can access the IBMLINK from the IBM Web site at:www.ibm.com/ibmlink

v Submit a problem management record (PMR) electronically atwww.ibm.com/software/support/probsub.html

v Hearing-impaired customers should visit the TDD/TTY Voice Relay services andAccessibility Center Web site atwww.ibm.com/able/voicerelay.html

Customers in the United States can also call 1-800-IBM-SERV (1-800-426-7378).

International customers should consult the Web site for customer supporttelephone numbers.

You can also review the IBM Software Support Guide, which is available on ourWeb site attechsupport.services.ibm.com/guides/handbook.html

When you contact IBM Software Support, be prepared to provide identificationinformation for your company so that support personnel can readily assist you.Company identification information is needed to register for online supportavailable on the Web site.

The support Web site offers extensive information, including a guide to supportservices (IBM Software Support Guide); frequently asked questions (FAQs); and

viii IBM Tivoli Storage Manager for Databases Version 5.2: Data Protection for Oracle for Windows Installation and User’s

Guide

documentation for all IBM Software products, including Release Notes, Redbooks,and white papers, defects (APARs), and solutions. The documentation for someproduct releases is available in both PDF and HTML formats. Translateddocuments are also available for some product releases.

All Tivoli publications are available for electronic download or order from the IBMPublications Center:www.ibm.com/shop/publications/order/

We are very interested in hearing about your experience with Tivoli products anddocumentation. We also welcome your suggestions for improvements. If you havecomments or suggestions about our documentation, please complete our customerfeedback survey atwww.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

by selecting the Feedback link in the left navigation bar.

Please have the following information ready when you report a problem:v The Tivoli Storage Manager Server version, release, modification, and service

level number. You can get this information by entering the query statuscommand at the Tivoli Storage Manager command line.

v The Tivoli Storage Manager client version, release, modification, and servicelevel number. You can get this information by entering dsmc at the commandline.

v The communication protocol (for example, TCP/IP), version, and release numberyou are using.

v The activity you were doing when the problem occurred, listing the steps youfollowed before the problem occurred.

v The exact text of any error messages.

Conventions used in this bookThis document uses several typeface conventions for special terms and actions.These conventions have the following meaning:

Table 2. Typeface conventions

Example Description

bold Commands, keywords, authorization roles, orother information that you must use appearin bold. Example: Log on to the server asroot user.

italics Values or variables that you must provideappear in italics. Emphasized words andphrases also appear in italics. Example: Thenode name of the production node and backupnode must not be the same.

bold italics Options and parameters appear in bolditalics. Example: Specify the value for thecompression option.

monospace Directories, parameters, URLs, and outputexamples appear in monospace. Example: Theproduct is installed in the C:\programfiles\tivoli\tsm\client\ba directory.

Preface ix

Table 2. Typeface conventions (continued)

Example Description

UPPER CASE Environment variables associated with TivoliStorage Manager, operating systems, orOracle Server appear in UPPER CASE.Example: Make sure the DSM_DIRenvironment variable is set correctly.

Reading syntax diagramsThis section describes how to read the syntax diagrams used in this book. To reada syntax diagram, follow the path of the line. Read from left to right, and top tobottom.v The !!─── symbol indicates the beginning of a syntax diagram.v The ───! symbol at the end of a line indicates the syntax diagram continues on

the next line.v The !─── symbol at the beginning of a line indicates a syntax diagram continues

from the previous line.v The ───!# symbol indicates the end of a syntax diagram.

Syntax items, such as a keyword or variable, can be:v On the line (required element)v Above the line (default element)v Below the line (optional element).

Syntax Diagram Description Example

Abbreviations:

Uppercase letters denote the shortestacceptable truncation. If an item appearsentirely in uppercase letters, it cannot betruncated.

You can type the item in any combination ofuppercase or lowercase letters.

In this example, you can enter KEYWO,KEYWORD, or KEYWOrd.

!! KEYWOrd !#

Symbols:

Enter these symbols exactly as they appear inthe syntax diagram.

* Asterisk{ } Braces: Colon, Comma= Equal Sign- Hyphen() Parentheses. Period

Space

Variables:

Italicized lowercase items (var_name) denotevariables.

In this example, you can specify a var_namewhen you enter the KEYWORD command.

!! KEYWOrd var_name !#

x IBM Tivoli Storage Manager for Databases Version 5.2: Data Protection for Oracle for Windows Installation and User’s Guide


Repetition:

An arrow returning to the left means you canrepeat the item.

A character or space within the arrow meansyou must separate repeated items with thatcharacter or space.

A footnote by the arrow references thenumber of times you can repeat the item.

!! ) repeat !#

!! )

,

repeat !#

!! )(1)

repeat !#

Notes:

1 Specify repeat as many as 5 times.

Required Choices:

When two or more items are in a stack andone of them is on the line, you must specifyone item.

In this example, you must choose A, B, or C.

!! ABC

!#

Optional Choice:

When an item is below the line, that item isoptional. In the first example, you can chooseA or nothing at all.

When two or more items are in a stack belowthe line, all of them are optional. In thesecond example, you can choose A, B, C, ornothing at all.

!!A

!#

!!ABC

!#

Defaults:

Defaults are above the line. The default isselected unless you override it. You canoverride the default by including an optionfrom the stack below the line.

In this example, A is the default. You canoverride A by choosing B or C. You can alsospecify the default explicitly.

!!A

BC

!#

Preface xi


Repeatable Choices:

A stack of items followed by an arrowreturning to the left means you can selectmore than one item or, in some cases, repeata single item.

In this example, you can choose anycombination of A, B, or C.

!! ) ABC

!#

Syntax Fragments:

Some diagrams, because of their length, mustfragment the syntax. The fragment nameappears between vertical bars in the diagram.The expanded fragment appears betweenvertical bars in the diagram after a headingwith the same fragment name.

!! The fragment name !#

The fragment name:

A

BC

xii IBM Tivoli Storage Manager for Databases Version 5.2: Data Protection for Oracle for Windows Installation and User’s Guide

Chapter 1. Introducing Data Protection for Oracle

This section provides a brief overview of Tivoli Storage Manager and DataProtection for Oracle.

Understanding Tivoli Storage ManagerTivoli Storage Manager is a client/server program that provides storagemanagement services in a multi-vendor, multi-platform computer environment.

Tivoli Storage Manager provides these functions:v Reduces network complexity

Tivoli Storage Manager reduces network complexity with interfaces andfunctions that span network environments. This provides consistency acrossdifferent operating systems and hardware.

v Increases administrator productivity

Tivoli Storage Manager can reduce the cost of network administration byallowing administrators to perform these actions:– Automate repetitive processes– Schedule unattended processes– Administer Tivoli Storage Manager from anywhere in the network

v Reduces the risk of data loss

Many users do not back up their data. Other users apply stand-alone backuptechniques with diskettes and tapes as the only protection for business data.These backup systems often produce disappointing results during recoveryoperations. Tivoli Storage Manager schedules routine backups that enable usersto recover from accidental data deletion without administrator involvement.

v Optimizes existing storage resources

Tivoli Storage Manager allows users to move files from client file systems toTivoli Storage Manager storage. This saves space on client file systems and caneliminate the expense of upgrading client storage hardware.Tivoli Storage Manager monitors client storage space and moves files from clientfile systems to Tivoli Storage Manager storage if an out-of-space conditionthreatens. This function can also eliminate the expense of client hardwareupgrades.

Tivoli Storage Manager provides these services:v Backup and restore services

These services generate backup copies of data at specified intervals and restoresthe data from these copies when required. These services protect againstworkstation or file server media failure, accidental file deletion, data corruption,data vandalism, or site disasters.

v Archive and retrieve services

These services provide backup-archive clients with point-in-time copies of datafor long-term storage.

© Copyright IBM Corp. 1998, 2003 1

v Server hierarchical storage management services

These services migrate client files from expensive storage media to lessexpensive storage media (from disk to tape, for example). Administrator-definedthresholds determine file migration for each storage pool. Migration applies toall backup and archive client files.

v Automation services

Tivoli Storage Manager administrators can increase productivity by automatingcommon storage administration tasks.

v Administration services

Tivoli Storage Manager administration services provide support for routinemonitoring, administration, and accounting. Administrators can manage theserver from another system or the same system. The Tivoli Storage Managerutilities allow the administrator to perform these functions:– Set client and server options– Define devices– Format storage volumes– Add additional clients– Label tape volumes

Tivoli Storage Manager monitors scheduled operations and maintains statusinformation in the database. An administrator can export data to removablemedia. This data can be imported by another server, making the export andimport features a convenient utility for moving server data. The administratorcan specify the accounting option generated at the end of each client session.

v Security services

Security services control user access to Tivoli Storage Manager data, storage,policy definitions, and administrative commands.

v Disaster recovery management

Disaster recovery management helps the administrator implement acomprehensive backup and recovery procedure for important businessapplications, data, and records.

Overview of Data Protection for OracleData Protection for Oracle currently supports Oracle8i (8.1.7) and Oracle 9i (9.0.1 or9.2) databases with the Oracle Recovery Manager (RMAN).

RMAN and Data Protection for OracleRMAN provides consistent and secure backup, restore, and recovery performancefor Oracle databases. While the Oracle RMAN initiates a backup or restore, DataProtection for Oracle acts as the interface to the Tivoli Storage Manager ServerVersion 5.1.0 (or later). The Tivoli Storage Manager Server then appliesadministrator-defined storage management policies to the data. Data Protection forOracle implements the Oracle defined Media Management application programinterface (API) 2.0. This API which interfaces with RMAN and translates Oraclecommands into Tivoli Storage Manager API calls to the Tivoli Storage ManagerServer.

With the use of RMAN, Data Protection for Oracle allows you to perform thefollowing functions:v Full backup function for the following while online or offline:

– Databases

2 IBM Tivoli Storage Manager for Databases Version 5.2: Data Protection for Oracle for Windows Installation and User’s Guide

– Tablespaces– Datafiles– Archive log files– Control files

v Full database restores while offlinev Tablespace and datafile restore while online or offline

LAN-free data transferData Protection for Oracle supports backup and restore operations in a LAN-freeenvironment. This environment shifts the movement of data from thecommunications network to a storage area network (SAN). Data moves over theSAN to a SAN-attached storage device via the Tivoli Storage Manager StorageAgent. Running Data Protection for Oracle in a LAN-free environment avoidsconstraints of the network and decreases the load on the Tivoli Storage ManagerServer, allowing the server to support a greater number of simultaneousconnections.

Migration and coexistencev Data Protection for Oracle Version 5.2 does not support Oracle8 (8.0.x) databases.v Existing backups created using Data Protection for Oracle Version 2.2.0 and 2.2.1

are restorable using Data Protection for Oracle 5.2.v Data Protection for Oracle relies heavily on the tdpo.opt file for accuracy in

setup and maintenance. The contents of the tdpo.opt file are different than theenvironment variables used with Data Protection for Oracle Version 2.1.Therefore, Version 2.1 RMAN scripts for environment variables are ignored. Formore information, see Chapter 3, “Configuring Data Protection for Oracle”, onpage 9 or “Scripts” on page 17.

v Tivoli Storage Manager Server Version 5.1.0 (or later) and the Tivoli StorageManager API Version 5.1.5 (or later) are supported.

Chapter 1. Introducing Data Protection for Oracle 3

Chapter 2. Installing Data Protection for Oracle

This chapter provides information on the required client environment for DataProtection for Oracle and instructions on installing Data Protection for Oracle.

Make sure these conditions exist before installing Data Protection for Oracle:v Tivoli Storage Manager Server Version 5.1.0 (or later) is configured.v Tivoli Storage Manager API Version 5.1.5 (or later) is installed. This version of

the Tivoli Storage Manager API is included in the Data Protection for Oracleproduct media.

Attention: A user with administrative authority must install Data Protection forOracle on a Windows server where the target database resides.

After Data Protection for Oracle is installed, you must perform the followingconfiguration tasks:1. Define Data Protection for Oracle options in the tdpo.opt file.2. Register the Data Protection for Oracle node to a Tivoli Storage Manager Server.3. Define Tivoli Storage Manager options in the dsm.opt file.4. Define Tivoli Storage Manager policy requirements.5. Initialize the password with a Tivoli Storage Manager Server.

See Chapter 3, “Configuring Data Protection for Oracle”, on page 9 for detailedtask instructions.

Note: If you would like to configure Data Protection for Oracle using defaultsettings, see Appendix A, “Quick start guide”, on page 31 for instructions.

ImportantSee the readme.tdpo file that is shipped on the product installation media forthe most current information.

Environment requirementsThis section contains the hardware and software requirements for installing DataProtection for Oracle on a Windows operating system.

Operating system requirementsOne of the following Windows operating systems:v Windows 2000v Windows XPv Windows Server 2003

Hardware requirementsv A Pentium 166 processor (or faster) or equivalentv 64 MB of RAM minimum (96 MB recommended)v 6 MB of disk space


Software requirementsv Tivoli Storage Manager Server Version 5.1.0 (or later)v Tivoli Storage Manager API Version 5.1.5 (or later)1

v One of the following levels of Oracle Server:– Oracle8i Version 8.1.7– Oracle9i Version 9.0.1– Oracle9i Version 9.2

Communication methodsData Protection for Oracle supports the communication methods supported by theTivoli Storage Manager API and the Tivoli Storage Manager Server.

Installing Data Protection for OracleThe following instructions assume that a Windows 2000, Windows XP, or WindowsServer 2003 program is running on the client workstation.

Note: Data Protection for Oracle must be installed from an account havingadministrator privileges to the local system.

Installing all Tivoli Storage Manager products and components into the samebase directory is highly recommended. The installation process does not overwritethe existing dsm.opt (options file), tdpo.opt (configuration file), or log files.v If Data Protection for Oracle was not previously installed on your system, you

can install Data Protection for Oracle into the Tivoli Storage Manager basedirectory of your choice. Data Protection for Oracle 5.2 installs to the \AgentOBAdirectory under this base default directory:c:\Program Files\Tivoli\TSM\

v If Version 2.2 of Data Protection for Oracle exists on your system, DataProtection for Oracle 5.2 will replace it in the same directory.

v If Data Protection for Oracle 5.2 was previously installed, the ProgramMaintenance dialog prompts you to Repair the program if files are missing orcorrupt, or to Remove the existing version from your computer.

These instructions guide you through the installation of Data Protection for Oracle:1. Insert the Data Protection for Oracle CD-ROM into the CD-ROM drive.

Note: Windows automatically starts the InstallShield wizard for you. If thewizard is not enabled, perform the following steps:a. Select Run from the Start menu.b. Enter x:\setup where x is your CD-ROM drive letter.c. Click OK to start the installation program.

Alternatively, you can double-click setup.exe using the Windows file manager.2. Follow the instructions displayed on your screen.

You are prompted to choose a setup language. You can choose:v Chinese (Simplified)v Chinese (Traditional)

1. The Tivoli Storage Manager API is included on the product media. If you have already installed a later level API, the latestversion is retained during installation.


v English (United States) This is the default.v French (Standard)v German (Standard)v Italian (Standard)v Japanesev Koreanv Portuguese (Brazilian)v Spanish (Traditional Sort)

Please note that you must download the Language Pack of your desiredlanguage after installing Data Protection for Oracle. The Language Pack enablesthe command output, error log text, and messages to display in your desiredlanguage. You can download the Language Pack from the product CD-ROM oronline. See the readme.tdpo file that is shipped on the product installationmedia for the exact location of these Language Packs.

3. Data Protection for Oracle prompts you to accept the License Agreement. If youdo not accept the License Agreement, Data Protection for Oracle will not install.

4. Click Finish to complete the installation.

Chapter 2. Installing Data Protection for Oracle 7

Chapter 3. Configuring Data Protection for Oracle

After Data Protection for Oracle is successfully installed, you must complete thefollowing configuration tasks:1. Define Data Protection for Oracle options in the tdpo.opt file.2. Register the Data Protection for Oracle node to a Tivoli Storage Manager Server.3. Define Tivoli Storage Manager options in the dsm.opt file.4. Define Tivoli Storage Manager policy requirements.5. Initialize the password with a Tivoli Storage Manager Server.

Note: If you would like to configure Data Protection for Oracle using defaultsettings, see Appendix A, “Quick start guide”, on page 31 for instructions.

1. Define Data Protection for Oracle options in the tdpo.opt fileThe Data Protection for Oracle options file, tdpo.opt, contains options thatdetermine the behavior and performance of Data Protection for Oracle. The onlyenvironment variable Data Protection for Oracle Version 5.2 recognizes within anRMAN script is the fully qualified path name to the tdpo.opt file. Therefore, someRMAN scripts may need to be edited to use tdpo_optfile=fully qualified path and filename of options file variable in place of other environment variables. For example:allocate channel t1 type ’sbt_tape’ parms’ENV=(tdpo_optfile=C:\RMAN\scripts\tdpo.opt)’

See “Scripts” on page 17 for further information.

If a fully qualified path name is not provided, Data Protection for Oracle uses thetdpo.opt file located in the Data Protection for Oracle default installation directory.If this file does not exist, Data Protection for Oracle proceeds with default values.

Note: Though it is possible to change values in the options file, you cannot effectchanges to the dsmi options until you restart Data Protection for Oracle.Data Protection for Oracle loads these values from the default tdpo.opt fileinto the default installation directory when the Oracle service is started.

Considerations

v It is strongly recommended that you use the tdpo.opt file exclusively instead ofdefault parameters.

v RMAN and the tdpoconf and tdposync utilities use the options defined in thetdpo.opt file.

v By default, the tdpo.opt file is located in the directory where Data Protection forOracle is installed.

v Data Protection for Oracle supports options specified in upper case or lower casetype.

Available optionsThe following options can be set in the tdpo.opt file:

dsmi_logSpecify the directory that contains the Data Protection for Oracle error logfile (tdpoerror.log).


dsmi_orc_configSpecify the complete path to the Tivoli Storage Manager backup-archiveclient user options file (dsm.opt) used during the Data Protection forOracle session. If you do not specify this option, Data Protection for Oraclelooks for this options file in the Data Protection for Oracle installationdirectory. You must specify this option if your Tivoli Storage Managerclient user options file is located in a directory other than the DataProtection for Oracle installation directory.

tdpo_fsSpecify a file space name on the Tivoli Storage Manager Server for DataProtection for Oracle backup, delete, and restore operations. The file spacename can contain a string of 1 to 1024 characters.v The default file space name is adsmorc.v When you have more than one Oracle database, use this option to back

up each Oracle target database to its own file space.v Do not use a directory delimiter in front of the filespace name when

setting up this option.v If you have more than one Oracle database, back up each Oracle target

database to its own file space on the Tivoli Storage Manager Server.v The file space name in the include/exclude statement must match the

file space name specified in the tdpo_fs option for include/excludeprocessing to function correctly.

tdpo_date_fmtThis option specifies the format you want to use to display dates. You canspecify a number between 1 and 5 inclusively. The default value is 1.

1 MM/DD/YYYY (Default)2 DD-MM-YYYY3 YYYY-MM-DD4 DD.MM.YYYY5 YYYY.MM.DD

tdpo_num_fmtThis option specifies the format you want to use to display numbers. Youcan specify a number between 1 and 6 inclusively. The default value is 1.

1 1,000.00 (Default)2 1,000,003 1 000,004 1 000.005 1.000,006 1’000,00

tdpo_time_fmtThis option specifies the format you want to use to display time. You canspecify a number between 1 and 4 inclusively. The default value is 1.

1 23:00:00 (Default)2 23,00,003 23.00.004 12:00:00 A/P


tdpo_languageThis option specifies the national language in which to display DataProtection for Oracle messages in the error log file. You can specify thefollowing:

enu American English (Default)deu Standard Germanfra Standard Frenchita Standard Italianjpn Standard Japanesekor Standard Koreanptb Brazilian Portuguesesch Chinese, Simplifiedtch Chinese, Traditional

tdpo_mgmt_class_2This option specifies the second management class used for copy 2 in theRMAN duplex copy command.

tdpo_mgmt_class_3This option specifies the third management class used for copy 3 in theRMAN duplex copy command.

tdpo_mgmt_class_4This option specifies the fourth management class used for copy 4 in theRMAN duplex copy command. Four copies is the maximum allowed byRMAN.

Note: It is recommended that you review “Using the Duplex Copy function” onpage 18 for specific details on using management class options.

Chapter 3. Configuring Data Protection for Oracle 11

2. Register the Data Protection for Oracle node to a Tivoli StorageManager Server

The Data Protection for Oracle node name and password (if required) must beregistered to the Tivoli Storage Manager Server before you can begin requestingbackup and restore services. The process of setting up a node name and passwordwith the Tivoli Storage Manager Server is called registration.

The following information is needed to register Data Protection for Oracle with theTivoli Storage Manager Server:v The Data Protection for Oracle node name

This is the node name that identifies the workstation on which Data Protectionfor Oracle is installed. It is recommended that you use a separate and uniquenode name for Data Protection for Oracle. This prevents any confusion with anexisting Tivoli Storage Manager backup-archive client on the same workstation.

v The initial passwordThis is the password you want to use, if a password is required.

The following information is defined by the Tivoli Storage Manager administrator:v The policy domain to which your client node belongs.

A policy domain contains policy sets and management classes that control howTivoli Storage Manager manages the objects you back up. Rather than bindingData Protection for Oracle backups to a different management class, it isrecommended that a unique policy domain be defined for Data Protection forOracle node names. These backups can be bound to the default managementclass within this unique policy domain. Rather than binding a differentmanagement class for Oracle backups, it is also recommended that you specify adifferent domain for Oracle backups with a separate management class.

v The authority to enable compression.The Data Protection for Oracle node can only compress objects before sendingthem to the Tivoli Storage Manager Server if the Tivoli Storage Manageradministrator leaves the compression decision to the node.

v The authority to delete backup data from Tivoli Storage Manager storage.The Data Protection for Oracle node can only delete backed up data from TivoliStorage Manager storage if the Tivoli Storage Manager administrator registersthe node with backdelete authority. Specify the following option to allowbackdelete authority:

backdelete=yes

The copy group of the management class to which Oracle backups are boundmust also have the following option settings for backdelete authority to function:

verdeleted=0

retonly=0


3. Define Tivoli Storage Manager options in the dsm.opt fileYou must define some Tivoli Storage Manager options after the Data Protection forOracle node is registered to the Tivoli Storage Manager Server:v These options are defined in the Tivoli Storage Manager client user options file

(dsm.opt by default).v Please note that the Tivoli Storage Manager client user options file (dsm.opt by

default) you must edit for Data Protection for Oracle is located in the directoryspecified by the dsmi_orc_config option. If this option is not specified, DataProtection for Oracle looks for this options file in the Data Protection for Oracleinstallation directory.

v Data Protection for Oracle provides sample Tivoli Storage Manager options filesthat you can modify for this purpose. These sample files are located in the DataProtection for Oracle installation directory.

v The Tivoli Storage Manager administrator can provide you with the node name,password, and communication method for connecting Data Protection for Oracleto the Tivoli Storage Manager Server.

Required optionsSpecify these options in the Tivoli Storage Manager client user options file(dsm.opt by default) located in the directory specified by the dsmi_orc_configoption:

nodenameSpecify the Data Protection for Oracle node name used during operationswith the Tivoli Storage Manager Server. The node name can contain astring of 1 to 64 characters.

To restore data from one Oracle server to another Oracle server using DataProtection for Oracle, make sure the value of the nodename option in thedsm.opt file on the target Oracle server equals the value of the nodenameoption in the dsm.opt file on the source Oracle server. Data Protection forOracle, the Tivoli Storage Manager backup-archive client, and the TivoliStorage Manager API must be at the same levels on both the source Oracleserver and the target Oracle server. If there is a password associated withthe nodename option in the dsm.opt file on the target Oracle server, use thetdpoconf utility to generate the local password file once the value of thenodename option changes.

passwordaccessSpecify whether you want to generate your password automatically or setas a user prompt. You must specify passwordaccess generate for DataProtection for Oracle to function. The default value is prompt. (DataProtection for Oracle installed in a UNIX environment requirespasswordaccess prompt)The Tivoli Storage Manager API saves the currentpassword (encrypted) in the Windows registry and automatically generatesa new password when the current password expires. This method ofpassword management is useful when running unattended scheduledbackups because it ensures that the backup never fails due to an expiredpassword.

commmethodSpecify the communication method for Data Protection for Oracle tocommunicate with the Tivoli Storage Manager Server. Please note that thisoption requires other Tivoli Storage Manager options, depending on thecommunication method you specify.


Other options to considerIt is recommended that you specify these options in the Tivoli Storage Managerclient user options file, dsm.opt:

compressionSpecify whether the Tivoli Storage Manager API compresses data beforesending it to the Tivoli Storage Manager Server. You can specify on or off.The default value is on. The value of the compression option for DataProtection for Oracle is honored only if the Tivoli Storage Manageradministrator leaves the compression decision to the node. Enablingcompression affects performance in three ways:v CPU utilization is higher on the machine on which Data Protection for

Oracle is running.v Network bandwidth utilization is lower because fewer bytes are

transmitted.v Storage usage on the Tivoli Storage Manager Server is reduced.

Considerations: It is recommended that you specify on when any of thefollowing conditions exist:v The network adapter has a data overload.v Communications between Data Protection for Oracle and the Tivoli

Storage Manager Server are over a low bandwidth connection.v There is heavy network traffic.

It is recommended that you specify off when any of the followingconditions exist:v The machine running Data Protection for Oracle has a CPU overload.

The added CPU usage (as a result of enabling compression) can impactother applications, including the Oracle server. You can monitor CPUand network resource utilization using the Performance Monitorprogram shipped with Windows.

v You are not constrained by network bandwidth. In this case, you canachieve the best performance by specifying compression off and enablinghardware compaction on the tape drive, which also reduces storagerequirements.

Note: The compression option also accepts these values: true, false, yes, no.

enablelanfreeSpecify whether you run backup operations in a LAN-free environment ifyou are equipped to do so. You can specify yes or no. The default value isno. You can avoid network constraints by shifting the movement of data toa storage area network (SAN). For more information, see the appropriateManaged System for SAN Storage Agent User’s Guide for your operatingenvironment.

4. Define Tivoli Storage Manager policy requirementsRMAN uses the format parameter (in the RMAN script) to generates uniquebackup file names. Because all backup objects inserted into the Tivoli StorageManager backup storage pool have unique file names, they never expire on theTivoli Storage Manager Server. As a result, Data Protection for Oracle requiresthese special Tivoli Storage Manager policy domain settings:


Backup copy group valuesData Protection for Oracle provides the tdposync utility to removeunwanted backup objects from the Tivoli Storage Manager Server. Thefollowing Tivoli Storage Manager backup copy group options must be set:v verdeleted=0v retonly=0

Then, when Data Protection for Oracle marks a backup object inactive, thatobject is deleted from the Tivoli Storage Manager Server the next timeexpiration processing occurs. A backup object is marked inactive when youdelete it through RMAN using the Data Protection for Oracle interface orwith the tdposync utility.

Notes:

1. The Tivoli Storage Manager administrator must also register your nodeby specifying backdelete=yes in order for backup objects to be deleted.

2. The following backup copy group options are not applicable to DataProtection for Oracle:v frequencyv verexistsv retextrav modev serialization

Data Protection for Oracle accepts default values for these options.3. An archive copy group is not required (although it can exist) because

Data Protection for Oracle stores all objects as backup objects on TivoliStorage Manager.

4. Be aware that the RMAN crosscheck command will expire backups onthe Tivoli Storage Manager Server that belong to a different TivoliStorage Manager node or file space.

Management classTivoli Storage Manager uses management classes to manage backups onthe Tivoli Storage Manager Server. When you back up a database, thedefault management class for your node is used. Because the policyrequirements for Data Protection for Oracle may be different from thedesired settings for the regular Tivoli Storage Manager backup-archiveclients, you must have a different management class defined for DataProtection for Oracle. It is recommended that you define a separate policydomain where the default management class has the required settings andthen register all Data Protection for Oracle nodes to that domain.

If you choose to define a new management class within an existing policydomain (not the default management class for that domain), then you mustadd an include statement to the Data Protection for Oracle options file tobind all objects to that management class.

The following steps assign a management class name orcbackup to allOracle backups with a default file space name adsmorc:1. Add this inclexcl entry under the server stanza you use in the dsm.opt

file:inclexcl C:\myfile\include.def

2. Add this include entry to the C:\myfile\include.def file:include \adsmorc\...\* orcbackup


Note: The file space name in the include/exclude statement mustmatch the file space name defined with the tdpo_fs option. If afile space name other than the default value (adsmorc) is used:a. You must specify the file space name with the tdpo_fs option.b. You must specify the file space name defined in the tdpo_fs

option in the include/exclude statement.

All the files backed up with a default file space name of adsmorc areassigned to management class orcbackup.

Note: Data Protection for Oracle stores all objects as backup objects on TivoliStorage Manager storage, so an archive copy group is not required, althoughit can exist.

See your Tivoli Storage Manager administrator or see Tivoli Storage ManagerAdministrator’s Guide for more information on defining or updating Tivoli StorageManager policy domains and copy groups.

5. Initialize the password with a Tivoli Storage Manager ServerThe administrator must run the tdpoconf utility program to set the passwordbefore using Data Protection for Oracle. See “TDPOCONF” on page 23 for moreinformation.


Chapter 4. Using RMAN and Data Protection for Oracle

You can perform full or partial, offline or online backups with Oracle. Once youidentify which database to back up, Oracle locates all necessary files and sendsthem to the Tivoli Storage Manager Server through Data Protection for Oracle. As aresult, Data Protection for Oracle provides an interface between Oracle MediaManagement API calls and Tivoli Storage Manager API routines.

Invoking RMANInvoke RMAN to back up and restore an Oracle database. In this example, thecatalog database contains a registered target database. Invoke RMAN with thiscommand:$> rman target xxx/yyy@target rcvcat aaa/bbb@catalog

cmdfile bkdb.scr msglog bkdb.log

This starts RMAN in the sequence shown.target xxx/yyy@target: connect to target databaseusing user xxx and password yyy with connect string targetrcvcat aaa/bbb@catalog: connect to catalog databaseusing user aaa and password bbb with connect string catalogcmdfile bkdb.scr: run bkdb.scr scriptmsglog bkdb.log: log the output messages in bkdb.log

Note: In the above example, RMAN creates a log file (bkdb.log) in the currentworking directory. If an error occurs, you will see the error stack in the logfile.

ScriptsData Protection for Oracle does not recognize environment variables specified inan RMAN script. The only environment variable Data Protection for Oracle Version5.2 recognizes within an RMAN script is the fully qualified path name to thetdpo.opt file. Therefore, existing RMAN scripts may need to be edited to usetdpo_optfile=fully qualified path and file name of options file variable in place of otherenvironment variables.

ExampleThis backup script allocates two parallel connections to the Tivoli Storage ManagerServer. The Tivoli Storage Manager Server views these connections as two separatesessions:run{

allocate channel t1 type ’sbt_tape’ parms’ENV=(tdpo_optfile=C:\oracle\ora81\scripts\tdpo.opt)’;

allocate channel t2 type ’sbt_tape’ parms’ENV=(tdpo_optfile=C:\oracle\ora81\scripts\tdpo.opt)’;

backupfilesperset 5format ’df_%t_%s_%p’(database);

}


Note: To back up to Tivoli Storage Manager using Data Protection for Oracle, youmust specify type ’sbt_tape’ in the RMAN script.

This restore script allocates one parallel connection to the Tivoli Storage ManagerServer:run{allocate channel t1 type ’sbt_tape’ parms ’ENV=(tdpo_optfile=C:\home\oracle\tdpo.opt)’;restore database;recover database;alter database open;}

Note: The Oracle database must be in mount mode for the restore to succeed.

Using the Duplex Copy functionFor example, to create four backup copies:1. Specify the following option in the RMAN backup script:

set duplex 4

2. Define the following options in the tdpo.opt file:v tdpo_mgmt_class_2v tdpo_mgmt_class_3v tdpo_mgmt_class_4

3. Run the RMAN backup script.

The following backup behavior occurs:v The first backup copy is bound to the default management class to which the

node is registered.v The second backup copy is bound to the management class defined by the

tdpo_mgmt_class_2 option.v The third backup copy is bound to the management class defined by the

tdpo_mgmt_class_3 option.v The fourth backup copy is bound to the management class defined by the

tdpo_mgmt_class_4 option.

Considerations

When using the duplex copy feature, make sure that no include options aredefined for Oracle backups.You will receive an error message if you specify set duplex 4 in the RMANbackup script and do not define a sufficient number of tdpo_mgmt_classoptions in the tdpo.opt file.In order to place duplicate copies on different media:– Make sure the storage pool information for each backup copy group within

the management classes is not the same.– Make sure backups from these different storage pools are not migrated to the

same storage pool at a later time.Be aware that duplicate data will be sent across the network.Be aware that if you specify set duplex 4 and allocate one channel in the RMANbackup script, RMAN will start four sessions to the Tivoli Storage ManagerServer. Likewise, if you specify set duplex 4 and allocate two channels in theRMAN backup script, RMAN will start eight sessions to the Tivoli StorageManager Server.Make sure RMAN does not start more sessions than the maximum mountpoints allowed by the Tivoli Storage Manager Server. The Tivoli Storage


Manager Server option, maxnummp, determines the maximum number ofmount points a client node is allowed to use on the Tivoli Storage ManagerServer during a backup operation. You can view the maximum mount pointsallowed by the Tivoli Storage Manager Server for a particular node by enteringthe query node command from a Tivoli Storage Manager Administrative Clientprompt:q node f=d

See the appropriate Tivoli Storage Manager Administrator’s Reference for moreinformation regarding this option.

It is highly recommended that you review your current Oracle documentationregarding the Duplex backup function.

Removing old backupsData Protection for Oracle uses the Tivoli Storage Manager backup repository. Eachdatabase backup creates a new object with a unique name. Since these objects haveunique names, they always remain active and never expire. This allows theDatabase Administrator (DBA) to control and coordinate copies removed from theTivoli Storage Manager Server with RMAN.

Be aware that the RMAN crosscheck command will expire backups on the TivoliStorage Manager Server that belong to a different Tivoli Storage Manager node orfile space.

Note: Make sure to use the same tdpo.opt file that was used for the originalbackup. This enables the backup objects to be found on the Tivoli StorageManager Server.

ExampleTo remove an old backup, issue this command from the RMAN prompt:run{

allocate channel for delete type ’sbt_tape’ parms’ENV=(tdpo_optfile=C:\oracle\ora81\scripts\tdpo.opt)’;

change backupset backupset number delete;

}

See the Oracle RMAN manual for more information on the change command andits options.

Management class options affecting object removalUse parameters in the Management Class definition to control when the inactiveobject expires on the Tivoli Storage Manager Server.

For the backup copy group, use:v verdeleted=0

v retonly=0

This erases the inactive objects from the server after the next inventory expiration.

Chapter 4. Using RMAN and Data Protection for Oracle 19

In order to delete backup objects, the Tivoli Storage Manager administrator mustregister your node by specifying backdelete=yes.

Reporting problemsIf you encounter a problem while using Data Protection for Oracle or if you cannotstart Data Protection for Oracle, do the following:1. Run the tdpoconf utility showenvironment command to collect information on

your options file (–tdpo_optfile=) and specified output files (–outfile=).2. If the above command ran successfully, check its output to see if the setup

worked as expected.3. If the above command failed, check the tdpoerror.log and dsierror.log files. The

tdpoerror.log is a log file created in the installation directory by default. Thedsierror.log is generated by the Tivoli Storage Manager API when a problemoccurs with the Tivoli Storage Manager API setup.

4. Fix the problem and run the tdpoconf utility again.5. If the problem persists, gather the following information:

v A problem description file that includes the command you used and thesession output you received when the problem occurred.

v The tdpo.opt filev The dsm.opt filev The tdpoerror.log filev The dsierror.log filev The RMAN log filev The Tivoli Storage Manager API trace file

To generate the Tivoli Storage Manager API trace file, add the following linesin your dsm.opt file:tracefile C:\oracle\admin\rman\tsmapi.outtraceflag service

v The node information on the Tivoli Storage Manager Server. To obtain thisinformation, enter:query node <nodename> format=detail

v The Tivoli Storage Manager Server activity log. To obtain this information,enter this Tivoli Storage Manager administrator command:

query actlog

v The Data Protection for Oracle trace fileTo generate the Data Protection for Oracle trace file, add the following linesin your tdpo.opt file:tdpo_trace_flags orclevel0 orclevel1 orclevel2tdpo_trace_file C:\oracle\admin\rman\tdpo.out

where:

orclevel0Traces out function exit points when errors occur.

orclevel1Traces out normal function entry and exit points.

orclevel2Traces out more detailed information.


Note: Any path and file name can be specified for the tdpo_trace_file andtracefile options. However, the directory must exist and have writablerights.

Requesting Tivoli Storage Manager serviceIf you need Tivoli Storage Manager customer assistance, call 1-800-IBM-SERV(1-800-426-7378). Inform the customer service representative that you are usingData Protection for Oracle. To help determine the problem, provide the customerservice representative with the following information:v The operating system platform, version, and release level of the machine on

which your Tivoli Storage Manager Server product is installed.v The version and release level of your Tivoli Storage Manager Server product.

Enter the query status command to determine this information. For example:query status

v The operating system platform, version, and release level of the machine onwhich your Data Protection for Oracle product is installed.

v The version and release level of your Data Protection for Oracle product. Youcan locate this in the readme file.

Chapter 4. Using RMAN and Data Protection for Oracle 21

Chapter 5. Using the utilities

This chapter describes how to use the Data Protection for Oracle utilities (tdpoconfand tdposync) from the command line interface. These utilities are located in thedirectory where Data Protection for Oracle is installed.v The tdpoconf utility is used for password maintenance and general Data

Protection for Oracle setup and maintenance.v The tdposync utility is used to delete the Oracle backups on the Tivoli Storage

Manager Server which are not in the RMAN catalog. This occurs when backupshave inadvertently not been deleted from the Tivoli Storage Manager Server.

Command line syntax and characteristicsThe Data Protection for Oracle utilities use the following command line syntax:tdpoconf <command> <0 or more optional parameters>

tdposync <command> <0 or more optional parameters>

The command line parameters have the following characteristics:v Minimum abbreviations for keywords are indicated in upper case.v Optional parameters begin with a dash (-).v Optional parameters can appear in any order.v Some keyword parameters require a value separated by the equal sign (=).v If a parameter requires more than one value, the values are separated with

commas.v A space separates the invocation from the command and the command from any

optional parameters.v Each parameter is separated from others by a space.v If a parameter value includes spaces, the entire parameter must be enclosed in

double quotes.

TDPOCONFThis utility provides setup tasks to ease the configuration of Data Protection forOracle. The utility uses the tdpo.opt file in the installation directory to centralizeinformation for setup purposes.

Two commands are available using the tdpoconf utility:v PASSWordv SHOWENVironment

A description of these two commands and their parameters follows.

Password commandUse the password command to create a new password or change an existingpassword on the Tivoli Storage Manager Server. You are prompted to enter boththe old and new passwords when you invoke this utility.


Syntax

!! TDPOCONF PASSWordinstalled tdpo.opt

-TDPO_OPTFILE=pathname

!#

Optional parameters-TDPO_OPTFILE=pathname

This parameter specifies the fully qualified path name to the tdpo.opt file.If you choose not to specify this option, the default path is used.

ExampleThis is an output example of the tdpoconf password command:

C:\Tivoli\Tsm\AgentOba>tdpoconf password

**************************************************************** Tivoli Data Protection for Oracle Utility ** Password file initialization/update program ****************************************************************

Please enter current password:

****Please enter new password:

****Please reenter new password for verification:****ANS0260I Password successfully changed.

Showenvironment commandUse the showenvironment command to query the Tivoli Storage Manager Serverusing the options set in –tdpo_optfile, the tdpo.opt file in the default installationdirectory, or the default values set by Data Protection for Oracle. The screen outputdisplays information about the Tivoli Storage Manager API and Tivoli StorageManager Server. This command is useful when troubleshooting Data Protection forOracle setup. If, for example, the password file is not initialized properly, tdpoconfshowenvironment reports this error immediately and prevents complications thatcan arise if this error were to go undetected.

Note: For initial setup, it is recommended that you direct the output to a file withthe –outfile option to ensure that the desired environment is set correctlybefore using RMAN.

Syntax

!! TDPOCONF SHOWENVironmentinstalled tdpo.opt


!

!-OUTfile= pathname

!#



This parameter specifies the fully qualified path name to the tdpo.opt file.This is the options file that is used by the utilities and the Data Protectionfor Oracle library.

-OUTfile=pathnameThis parameter specifies the fully qualified path name to the output file.The formatted text of this file is the same content that appears as output tothe screen.

ExampleBelow is an output example of the tdpoconf showenvironment command:

C:\Tivoli\Tsm\AgentOba>tdpoconf showenv

IBM Tivoli Storage Manager for Databases:Data Protection for OracleVersion 5, Release 2, Level 0.0(C) Copyright IBM Corporation 1997, 2003. All rights reserved.

DATA PROTECTION FOR ORACLE INFORMATIONVersion: 5Release: 2Level: 0Sublevel: 0Platform: 32bit TDP Oracle

TSM SERVER INFORMATIONServer Name: 3N1SERVServer Address: 8.12.654.90Server Type: AIX-RS/6000Server Port: 1500Communication Method: TCP/IP

SESSION INFORMATIONOwner Name:Node Name:Node Type: TDP Oracle NTDSMI_DIR: C:\Program Files\Tivoli\TSM\apiDSMI_ORC_CONFIG: c:\Program Files\Tivoli\TSM\baclient\dsm.optTDPO_OPTFILE: C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.optPassword Directory:Compression: FALSE

Note: The Server Name: value above identifies the Tivoli Storage Manager Serverstanza in the dsm.sys file, not the actual name of the Tivoli Storage ManagerServer.

TDPOSYNC

Attention: Deleted files cannot be restored! When using this utility to deletefiles, ensure that you do not log on under the wrong node name, query a differentdatabase than intended, and delete files in error. Double-check the node namelisted at the top of the PICK window. See “Optional parameters” on page 27 and“PICK Window” on page 28 for further details.

The tdposync utility checks for items on the Tivoli Storage Manager Server that arenot in the RMAN catalog. This utility allows you to repair such discrepancies

Chapter 5. Using the utilities 25

between the Tivoli Storage Manager Server and the RMAN catalog. By thusremoving unwanted objects in Tivoli Storage Manager storage, you can reclaimspace on the server.

When an RMAN deletion script is run, RMAN deletes entries in the recoverycatalog before confirmation from the Tivoli Storage Manager Server. In cases whereobjects are not found on the Tivoli Storage Manager Server, RMAN tries to deletebackup sets from the Tivoli Storage Manager Server and fails. When this happens,RMAN can no longer identify these backups through the catalog even though thefile still exists on the Tivoli Storage Manager Server. This utility thereforesynchronizes the contents of the servers.

When you invoke tdposync, the utility does the following:1. Prompts you for information2. Gathers information for the Oracle server(s)3. Queries the Oracle backup catalog and the Tivoli Storage Manager Server4. Displays formatted output to the screen (files that exist on Tivoli Storage

Manager but not in the RMAN catalog)5. Prompts you to do one of the following:

v Delete any files found causing the discrepancy.v Delete all files.v Exit the program without deleting files from the Tivoli Storage Manager

Server.

ConsiderationsThe following information must be considered before using the tdposynccommand:v Re-synchronize Oracle catalogs with the target databases before running the

tdposync syncdb command. First, connect to the target database and the catalogdatabase. The following is an example:$ rman target xxx/yyy@targetdb rcvcat xxx/yyy@catalogdb

When you are connected to both databases, type resync catalog at the RMANprompt.

v If the information for sqlplus that you provide to tdposync is incorrect (such aslogon, password, or connect string information), sqlplus stops at its logonscreen. You will need to log on again at the prompt using the following:login/password@connectstring

When you enter the correct input, tdposync proceeds correctly.v By default, Data Protection for Oracle prompts you to synchronize with one

Oracle catalog at a time. However, if you use multiple Oracle catalogs to backup multiple target databases to the same file space, the same node name, andthe same owner name on the same Tivoli Storage Manager Server, you must use–numcatalogs=number. This is necessary so that tdposync has all the informationto correctly query both Oracle and Tivoli Storage Manager. For more information, see “Optional parameters” on page 27.Attention: Failure to provide all pertinent and correct information can result inerroneous output. To prevent this, see the next consideration.

v If you have more than one Oracle database, back up each Oracle target databaseto its own file space on the Tivoli Storage Manager Server. To do this, use thetdpo_fs option in the tdpo.opt file. In addition, it is highly recommended thatyou use a separate Data Protection for Oracle options file for each database thatyou back up to Tivoli Storage Manager. In this way, it is only necessary to


synchronize one catalog at a time (once for each target database), thusminimizing the display of wrong information in the PICK window.

v Make sure to use the same tdpo.opt file that was used for the original backup.v Be aware that the RMAN crosscheck command will expire backups on the Tivoli

Storage Manager Server that belong to a different Tivoli Storage Manager nodeor file space.

Syncdb CommandThis is the only command available to tdposync utility.

Syntax

!! TDPOSYNC syncdbinstalled tdpo.opt


!

!1

-NUMCATalogs=number

!#


This parameter specifies the fully qualified path name to the tdpo.opt file.This is the options file that is used by the utilities and the Data Protectionfor Oracle library. This file contains the information for the Tivoli StorageManager Server name and address that tdposync needs for synchronizing.

Note: For syncdb tdpo_optfile, you must specify the same options filevalues that were used to perform the original backup operations.

-NUMCATalogs=numberThis parameter specifies the number of Oracle catalog databases that youwant to synchronize and prompts you for information for each catalog. .Specify this option only when you use multiple Oracle catalogs to back upmultiple target databases to the same Tivoli Storage Manager Server underthe same file space, node name, and owner name.

If, for example, you back up only one target database using two catalogs,you do not need to specify this option. However, if you back up two targetdatabases using two catalogs (one catalog for each) to the same TivoliStorage Manager Server under the same file space, node name, and ownername, you must specify numcatalogs. If you fail to provide information forthe second target database (by not specifying two catalogs), that databasewill be displayed as eligible for deletion.

According to the number you specify for -numcatalogs, you are promptedfor the user name, password, and connect string for each. If you do notspecify -numcatalogs, the default is 1, and you are prompted only once.


For each catalog, you are prompted for the following information:v Catalog # User Name:v Catalog # Password:v Catalog # Connect String:

You are also prompted for the following date information to narrow your search:v From Date: (MM/DD/YYYY)v To Date: (MM/DD/YYYY)

ExampleWhen you specify the syncdb -numcatalogs parameter, you are prompted forinput for each catalog on the node. This example assumes two separate RMANcatalogs (rman, rman2):

C:\Tivoli\Tsm\AgentOba>tdposync syncdb -numcatalogs=2 -tdpo_optfile=c:\RMAN\scripts\tdpo.opt

Catalog 1 User Name: rman

Catalog 1 Password: rman

Catalog 1 Connect String: rman

From Date (MM/DD/YYYY): 01/01/2000

To Date (MM/DD/YYYY): 01/01/2001

Catalog 2 User Name: rman2

Catalog 2 Password: rman2

Catalog 2 Connect String: rman2

From Date (MM/DD/YYYY): 01/01/2000

To Date (MM/DD/YYYY): 01/01/2001

Note: From Date implicitly searches from time=00:00:01 and To Date implicitlysearches to time=23:59:59 of the same day.

PICK WindowThe PICK window provides the following useful information to help you decide ifthe files displayed are indeed out of synchronization with the Oracle catalog:v The node with which you are querying the Tivoli Storage Manager Serverv The date of the file backupv The size of the backupv The backup name (\hl\orcnt\ll)

Attention: Use caution when selecting files for deletion. If you are unsure thatthe files in question are really out of synchronization, do further research beforedeleting them. Once you delete files, they cannot be restored.


Example: This is an example output of the PICK window:

Tivoli Data Protection for OracleSynchronize utility PICK Window

Node Name: AGENT_NODE

Backup Date Size Backup Name------------------------------------------------------------------------1. | 02/19/2001 09:19:59 50.35MB \adsmorc\orcnt\1kc2cnfv_1_12. | 02/19/2001 11:36:20 427.08MB \adsmorc\orcnt\4kc3cnfv_1_13. | 02/19/2001 07:14:30 508.00MB \adsmorc\orcnt\4qcgdhfr_1_14. | 02/19/2001 07:21:38 763.94MB \adsmorc\orcnt\4ocf8999_1_15. | 02/26/2001 11:00:11 69.12MB \adsmorc\orcnt\4ocf8999_1_26. | 02/26/2001 11:00:12 950.09MB \adsmorc\orcnt\4ocf8999_1_37. | 02/26/2001 11:00:13 656.69MB \adsmorc\orcnt\4rch25jk_1_18. | 02/26/2001 11:00:14 135.36MB \adsmorc\orcnt\4rch25jk_1_29. | 02/26/2001 11:00:15 298.01MB \adsmorc\orcnt\4rch25jk_1_30

|||

0---------10--------20--------30--------40--------50--------60--------70<U>=Up <D>=Down <T>=Top <B>=Bottom <R#>=Right <L#>=Left<G#>=Goto Line # <#>=Toggle Entry <+>=Select Al<->=Deselect All<#:#+>=Select A Range <#:#->=Deselect A Range <O>=Ok <C>=Cancelpick>

Files selected for deletion are marked by a plus (+). To delete selected files:1. Enter OK at the PICK prompt.

A warning message appears to confirm deletion of the selected files.2. Enter Yes to delete the selected files from the Tivoli Storage Manager Server.

IMPORTANT! The deletion process is irreversible. Use caution when selecting filesfor deletion.


Appendix A. Quick start guide

This section provides instructions on how to perform a quick configuration of DataProtection for Oracle on a Windows 2000 machine. This procedure uses defaultsettings and requires minimal configuration tasks. It minimizes set up time andallows you to proceed quickly to a state where you can begin backing up yourOracle databases. See page 9 for detailed instructions on how to customize DataProtection for Oracle for your environment and processing needs.1. Install Data Protection for Oracle.

v Detailed installation instructions are available on page 5.2. Change to the C:\Program Files\Tivoli\TSM\AgentOBA directory and copy the

tdpo.opt.smp file to tdpo.opt. Edit the tdpo.opt file to include these options:

dsmi_orc_config C:\Program Files\Tivoli\TSM\AgentOBA\dsm.optdsmi_log C:\Program Files\Tivoli\TSM\AgentOBA

v More information about these options is available on page 9.3. In this same directory, copy the dsm.smp file to dsm.opt. Edit the dsm.opt file to

include these options:

COMMMethod TCPipTCPServeraddress x.x.x.xPASSWORDAccess generateNODename hostname_oracle

Replace x.x.x.x with the IP address of the Tivoli Storage Manager Server towhich Data Protection for Oracle will back up data.v More information about these options and the dsm.opt file is available on

page 13.4. Register the node (specified in Step 3) to the Tivoli Storage Manager Server

with the following command:REG NODE hostname_oracle password maxnummp=2 passexp=0

Where hostname is the name of the machine where Data Protection for Oracle isinstalled and password is the password for this node.

5. Make sure the Oracle user has the following permissions:v Read and Write permission to the C:\Program Files\Tivoli\TSM\AgentOBA

directory.6. Change to the C:\Program Files\Tivoli\TSM\AgentOBA directory and run the

tdpoconf password command to generate the password file. You will beprompted to enter the password (from Step 4) three times.v More information about this command is available on page 23.

7. Run the tdpoconf showenvironment command to confirm properconfiguration.v More information about this command is available on page 24.

8. As Oracle user, run your RMAN backup script with theENV=(tdpo_optfile="C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt")parameter specified.


For example:run{

allocate channel t1 type ’sbt_tape’ parms’ENV=(tdpo_optfile="C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt")’;

backupfilesperset 5format ’df_%t_%s_%p’(database);

}

v More information about RMAN backup scripts is available on page 17.


Appendix B. Using the Tivoli Storage Manager scheduler

This section describes how to use the Tivoli Storage Manager scheduler with DataProtection for Oracle to automate online backups of Oracle server databases. Theexample illustrates the use of the Tivoli Storage Manager Version 5.1backup-archive client scheduler.

Considerations

The Tivoli Storage Manager backup–archive client must reside on the samemachine as Data Protection for Oracle for the Tivoli Storage Manager schedulerto function.

After Data Protection for Oracle has been registered to a Tivoli Storage ManagerServer and installed on the Oracle server, perform these steps:1. On the Tivoli Storage Manager Server:

a. Define a schedule to perform a Windows command file in the policydomain to which Data Protection for Oracle is registered.

b. Associate the Data Protection for Oracle node to the defined schedule.2. On the Oracle Server where Data Protection for Oracle is installed:

a. Install the Tivoli Storage Manager backup-archive client scheduler as aWindows service for Data Protection for Oracle. If a scheduler servicealready exists for the regular Tivoli Storage Manager backup-archive client,install another one for Data Protection for Oracle.

b. Configure the scheduler service to run under the Oracle Site Servicesaccount or an account that has Oracle authorization.

c. Define a command file that contains Data Protection for Oracle commandsto do the desired backup.

Note: Refer to Windows documentation for details on creating a Windowscommand file.

d. Start the scheduler service installed in step 2a (this is step 2.1 in someHTML browsers).

Setting up a scheduleFor consistency, this procedure uses specific information. However, you can definea command file with any set of commands you choose. This allows you to use thesame command file to define schedules on other Tivoli Storage Manager Servers.All command information is presented as command-line interface entries.

This schedule in this procedure contains the following settings:v The Data Protection for Oracle node name is NodeA1.v The password for node name NodeA1 is PasswordA1.v The policy domain to which node name NodeA1 is registered is PolicyA1.v The schedule is a daily backup of an online Oracle database.v The scheduled backup begins between 9:00 and 9:15 PM.

Part I: On the Tivoli Storage Manager Server1. Define the following schedule on the Tivoli Storage Manager Server. You can

enter the command on the Tivoli Storage Manager Server console or on an


Administrative Client. The Administrative Client does not have to be runningon the same system as the Tivoli Storage Manager Server.define schedule PolicyA1 daily_orcbkup description="07Daily Online DB Backup"action=command objects="C:\Program Files\Tivoli\TSM\AgentOBA\sched\orcsched.cmd"starttime=21:00 duration=15 durunits=minutes period=1 perunits=daydayofweek=any

The following message must display before proceeding to Step 2:

ANR2500I Schedule daily_orcbkup defined in policy domain PolicyA1.

2. Issue the following command to associate the Data Protection for Oracle nodeto the backup schedule defined in Step 1:

define association PolicyA1 daily_orcbkup NodeA1

The following message must display before proceeding to Part II:

ANR2510I Node NodeA1 associated with schedule orc_dailybkupin policy domain PolicyA1.

Summary:

v A backup schedule is now defined on the Tivoli Storage Manager Server.v The backup schedule runs a command file (orcsched.cmd) located in the

C:\Program Files\Tivoli\TSM\AgentOBA\sched\ directory.v The backup is performed once a day around 9:00 PM.v The backup schedule can start on any day of the week.v You can run the Tivoli Storage Manager query schedule and query

association commands to confirm that the schedule and node association areset correctly.

Part II: On the workstation with the Oracle Server:This example assumes:v The Tivoli Storage Manager backup-archive client is installed on the Oracle

Server in the directory:C:\Program Files\Tivoli\TSM\baclient

v The Data Protection for Oracle for the Oracle server is installed in the directory:C:\Program Files\Tivoli\TSM\AgentOBA

v The options files in each of these directories has been updated so that thecommunication parameters point to the Tivoli Storage Manager Server.

1. Login using a Windows account that has administrative privileges.2. Open a Windows command prompt window.3. Change to the backup-archive client installation directory with this command:

C:\>cd \Program Files\Tivoli\TSM\baclient

4. Use the Tivoli Storage Manager Client Service Configuration Utility (dsmcutil)to install the Tivoli Storage Manager Scheduler Service. Issue the commandfrom your current location in the backup-archive client installation directory.For example:

dsmcutil inst /name:"TSM Oracle Bkup Scheduler"/node:nodea1 /password:passworda1 /autostart:yes/clientdir:"C:\Program Files\Tivoli\TSM\baclient"/optfile:"C:\Program Files\Tivoli\TSM\AgentOBA\dsm.opt"/validate:yes


You can modify the command to contain options specific to your schedule.

This is an example of the output:TSM Windows Client Service Configuration UtilityCommand Line Interface - Version 5, Release 1, Level 0.0(C) Copyright IBM Corporation, 1990, 2003, All Rights Reserved.Last Updated Dec 31 2002TSM Api Verison 5.2.0

Command: Install TSM Client ServiceMachine: ABC-ARTXNC(Local Machine)

Installing TSM Client Service:

Machine : ABC-ARTXNCService Name : TSM Oracle Bkup SchedulerClient Directory : C:\Program Files\Tivoli\TSM\baclientAutomatic Start : yesLogon Account : LocalSystem

The service was successfully installed.

Creating Registry Keys ...

Updated registry value ’ImagePath’ .Updated registry value ’EventMessageFile’ .Updated registry value ’TypesSupported’ .Updated registry value ’TSM Oracle Bkup Scheduler’ .Updated registry value ’ADSMClientKey’ .Updated registry value ’OptionsFile’ .Updated registry value ’EventLogging’ .Updated registry value ’ClientNodeName’ .

Generating registry password ...Authenticating TSM password for node NODEA1 ...

Connecting to TSM Server via client options file’C:\Program Files\Tivoli\TSM\AgentOBA\dsm.opt’ ...

Password authentication successful.

The registry password for TSM node NODEA1 has been updated.

Starting the ’TSM Oracle Bkup Scheduler’ service .......

The service was successfully started.

Note that the options file that is defined for Data Protection for Oracle is usedby the scheduler when validating the node and password. The options files arealso used when contacting the Tivoli Storage Manager Server for scheduleinformation. This example assumes that the dsm.opt file is updated so that thecommunication parameters point to the Tivoli Storage Manager Server to whichthe Oracle databases are to be backed up.

If this message appears:A communications error occurred connecting to the TSM server

Appendix B. Using the Tivoli Storage Manager scheduler 35

Ensure that the dsm.opt file contains entries that point to the correct TivoliStorage Manager Server. Also ensure that the Tivoli Storage Manager Server isrunning. If you have to correct one of these, enter the following command:

dsmcutil remove /name:"TSM Oracle Bkup Scheduler"

Then enter the command given in Step 4.5. Data Protection for Oracle must be running under the Oracle Site Services

account in order to be able to access the Oracle backup API. The DataProtection for Oracle scheduler service must logon using that account. Thescheduler service account information can be specified using the services appletin the control panel.

6. Create a batch file called:C:\Program Files\Tivoli\TSM\AgentOBA\sched\orcsched.cmd

The following is an example of the orcsched.cmd file:rem =======================rem orcsched.cmdrem =======================

rem =======================rem setting oracle sidrem =======================

set oracle_sid=t1

rem =======================rem set orc executable binaryrem =======================set ora_exe=c:\oracle\ora81\bin

rem =======================rem set ora scripts to be executedrem =======================

set ora_script=C:\oracle\obackup\scripts\bkdb.rmn

%orc_exe% %orc_script%

Note: The key to using the Tivoli Storage Manager scheduler to perform thecommands in a command file is that complete paths must be given for allfile names and non-system commands, because the scheduler serviceruns from the Windows system directory. The scheduler service checksthe Windows system directory for input and produces its output bydefault.

7. The scheduler service is now installed, but has not been started. To start theservice, issue this command in the Windows command prompt:

net start "TSM Oracle Bkup Scheduler"

The following message is displayed:The TSM Oracle Bkup Scheduler service is starting.The TSM Oracle Bkup Scheduler service was started successfully.

Note that because autostart=yes is specified, the Tivoli Storage Managerscheduling service is automatically started each time the Windows system isrebooted.

Your system is now ready to run automatic daily online database backups.


Notes:

1. If you want to use the Tivoli Storage Manager Server-prompted schedulingmode, you must ensure that the Data Protection for Oracle options file has thetcpclientaddress and tcpclientport options specified. If you want to run morethan one scheduler service, use the same tcpclientaddress. However, you mustuse different values for tcpclientport in addition to the different node names.Scheduling Data Protection for Oracle as well as the regular Windowsbackup-archive client is an example of running more than one schedulerservice.Server-prompted scheduling is supported only when TCP/IP communication isbeing used. By default, Data Protection for Oracle uses the polling schedulemode.

2. If any changes that affect the scheduler service are made to the Data Protectionfor Oracle options file, the scheduler service has to be restarted in order to pickup the changes. An example of this is the Tivoli Storage Manager Serveraddress, the schedule mode, or the machine TCP/IP address or port. This canbe done by entering these commands:

net stop "TSM Oracle Bkup Scheduler"net start "TSM Oracle Bkup Scheduler"

3. The file named dsmsched.log contains status information for the Tivoli StorageManager scheduler service. Though the default directory is\Tivoli\TSM\baclient\sched\dsmsched.log, you can specify a differentdirectory, such as \Tivoli\TSM\AgentOBA\sched\dsmsched.log using theschedlogname option in the Data Protection for Oracle options file.

4. If a Tivoli Storage Manager scheduler service is already installed on yourworkstation (for the regular backups of the Windows system), you need toinstall another one (with a unique name) to run the schedules defined for DataProtection for Oracle. The Tivoli Storage Manager scheduler service needs adifferent node name than the regular Tivoli Storage Manager backup-archiveclient. If the path you want to use has a space in it, for example C:\ProgramFiles\Tivoli\TSM\baclient, you can place quotation marks around the sectionof the path name that contains a space (C:\"Program Files"\) You can also usethe short form of the path name. The short form of a path name is made up ofthe first six characters in the path and is followed by a tilde (~) and uniqueidentifier. The following is an example of the short form of the path name:C:\Progr~1\Tivoli\TSM\baclient

Appendix B. Using the Tivoli Storage Manager scheduler 37

Appendix C. Messages

ANU0003S An internal processing error hasoccurred.

Explanation: An internal processing error hasoccurred.System Action: Processing ends.User Response: Retry the operation. If this errorpersists, contact your service representative.

ANU0004E An unknown error has been detected.Explanation: An internal processing error hasoccurred that prevents the generation of a message fora return code.System Action: Processing continues.User Response: Retry the operation. If this errorpersists, contact your service representative.

ANU0005E Out of memory. Stop other processesand try the operation again.

Explanation: The machine has run out of memory.System Action: Processing continues.User Response: Close unnecessary processes and trythe operation again.

ANU0053E License file (licensefile) could not beopened.

Explanation: An attempt to read from the license filefailed.System Action: Processing ends.User Response: Install the product again. This ensuresthat the correct license file is installed.

ANU0054E Read failure on license file (licensefile).Explanation: An attempt was made to read from thelicense file. This attempt failed.System Action: Processing ends.User Response: Reinstall the product. This will ensurethat the correct license file is installed.

ANU0055E Write failure on license file (licensefile).Explanation: An attempt to write to the license filefailed.System Action: Processing ends.User Response: Make sure enough space exists on theworkstation to write to the license file. If enough spaceexists, run the command again.

ANU0056E Data in the license file (licensefile) is notin a valid format.

Explanation: An attempt to read information from thelicense file failed.System Action: Processing ends.User Response: Install the product again.

ANU0057E The checksum in the license file(licensefile) does not match the licensestring text.

Explanation: An attempt was made to readinformation from the license file. The checksum wasnot valid so it appears that the license file is not at thecorrect level.System Action: Processing ends.User Response: Reinstall the product.

ANU0058E The ’Try and Buy’ license has expired.Explanation: This ’Try and Buy’ license that wasdetected has expired.System Action: Processing ends.User Response: This product is no longer valid foruse. A valid license must be obtained before runningthe product.

ANU0100E Incomplete command:Explanation: This message displays the incompletecommand that was entered.System Action: Processing ends.User Response: Re-enter the complete command.

ANU0101E Invalid argument:Explanation: This message displays the command thatwas entered, up to and including the invalid commandor option argument that was detected.System Action: Processing ends.User Response: Re-enter the command specifying avalid argument for the command or option.

ANU0102E Invalid command:Explanation: This message displays the invalidcommand that was entered.System Action: Processing ends.User Response: Re-enter a valid command.

ANU0103E Invalid option for the specifiedcommand:

Explanation: This message displays the command thatwas entered, up to and including the option that wasdetected as invalid for the command.System Action: Processing ends.User Response: Re-enter the command specifyingvalid command options.

ANU0104E Invalid option:Explanation: This message displays the command thatwas entered, up to and including the invalid optionthat was detected.System Action: Processing ends.


User Response: Re-enter the command specifyingvalid command options.

ANU0105E Missing argument:Explanation: This message displays the command thatwas entered, up to and including the command oroption whose required argument is missing.System Action: Processing ends.User Response: Re-enter the command specifying avalid argument for the command or option.

ANU0132W Tracing could not be started. Processingwill continue.

Explanation: A problem prevented tracing frombeginning.System Action: Processing will continue with thecommand entered.User Response: Refer to the other messages thatdisplay with this message to determine the problem.

ANU0133W Could not locate installation directory.Attempting to continue...

Explanation: An attempt was made to read theregistry to determine where the Tivoli Data Protectionapplication client was installed. This attempt failed.System Action: Processing will continue with thecommand entered.User Response: There should be other messages alongwith this one. Refer to the other messages to determinethe problem. If the problem can not be determined, itmay be necessary to reinstall the application clientcode. This will ensure that the registry entries are setup correctly.

ANU0134W Could not locate log directory.Processing will continue...

Explanation: An attempt was made to read theregistry to determine where the Tivoli Data Protectionapplication client log is located. This attempt failed.System Action: Processing will continue with thecommand entered.User Response: There should be other messages alongwith this one. Refer to the other messages to determinethe problem. If the problem can not be determined, itmay be necessary to reinstall the application clientcode. This will ensure that the registry entries are setup correctly.

ANU0150I Operation canceled by user.Explanation: The user has requested that the DataProtection for Oracle application client end by enteringctrl-C.System Action: Processing ends.User Response: None

ANU0151E Errors occurred while processing therequest.

Explanation: Attempting to process the requestentered, an error occurred.System Action: Processing ends.User Response: Attempt to determine the source ofthe errors from viewing the log file. Correct theproblems and try running the command again.

ANU0152I Performance stats: seconds seconds spentin apicall API calls

Explanation: The indicated number of seconds werespent making API calls for the indicated system.System Action: Processing continues.User Response: None

ANU0153I Performance stats: seconds seconds spentin function

Explanation: The indicated number of seconds werespent the named function.System Action: Processing continues.User Response: None

ANU0154E The Data Protection for Oracleapplication client cannot work with theversion of the Tivoli Storage ManagerAPI you have installed. Please installversion version.release.level or greater.

Explanation: The version of the Tivoli StorageManager API currently installed on the system is olderthan the version used to build the Data Protection forOracle application client.System Action: Processing ends.User Response: Install a version of the Tivoli StorageManager API at or later than the indicated level. Acopy is distributed with the Data Protection for Oracleapplication client.

ANU0155E The Data Protection for Oracleapplication client cannot work with therelease of Tivoli Storage Manager APIyou have installed. Please install releaseversion.release.l evel or greater.

Explanation: The release of the Tivoli StorageManager API currently installed on the system is olderthan the release used to build the Data Protection forOracle application client.System Action: Processing ends.User Response: Install a release of the Tivoli StorageManager API at or later than the indicated level. Acopy is distributed with the Data Protection for Oracleapplication client.


ANU0156E Could not load the Tivoli StorageManager API.

Explanation: The Tivoli Storage Manager API couldnot be loaded.System Action: Processing ends.User Response: Ensure the Tivoli Storage ManagerAPI is correctly installed. Run the Data Protection forOracle application client with the /TRACEFLAGS=API/TRACEFILE=filename options and view the tracefileto determine why it could not be loaded. Anotherpossible cause is that the TSMAPI.DLL does not exist inthe system directory. Re-install the Tivoli StorageManager API, if this is the case.

ANU0160E An authentication error occurred withyour stored Tivoli Storage Managerpassword.

Explanation: You were unable to log on to the TivoliStorage Manager server due an authentication error.System Action: Processing stops.User Response: The stored Tivoli Storage Managerpassword may have become corrupted. Contact yourTivoli Storage Manager server administrator.

ANU0161E Authentication error. The passwordentered is not valid. You are not loggedon to the Tivoli Storage Manager server.

Explanation: An incorrect password was entered.System Action: Processing stops.User Response: Enter the correct Tivoli StorageManager password and try again.

ANU0162E The passwords entered do not match.Please enter them again.

Explanation: An incorrect password was entered.System Action: Processing stops.User Response: Enter the passwords again.

ANU0163E The directory path needs to befully-qualified.

Explanation: The /intopath option was specifiedwithout a fully-qualified path.System Action: Processing stops.User Response: Enter the command again and specifya fully-qualified path in the /intopath option.

ANU0167E The fully-qualified file name is toolong.

Explanation: An attempt was made to use afully-qualified file name that was too long. Thisattempt failed.System Action: Processing ends.User Response: None

ANU0200E File (filename) could not be opened forreading.

Explanation: An attempt was made to open a file forreading. This attempt failed.System Action: Processing ends.User Response: None

ANU0201E File (filename) could not be opened forwriting.

Explanation: An attempt was made to open a file forwriting. This attempt failed.System Action: Processing ends.User Response: None

ANU0202E Read failure on file (filename).Explanation: An attempt was made to read from afile. This attempt failed.System Action: Processing ends.User Response: None

ANU0203E Write failure on file (filename).Explanation: An attempt was made to write to a file.This attempt failed.System Action: Processing ends.User Response: None

ANU0204E File (filename) could not be closed.Explanation: An attempt was made to close a file.This attempt failed.System Action: Processing ends.User Response: None

ANU0205E File (filename) statistics could not beobtained.

Explanation: An attempt was made to obtain filestatistics. This attempt failed.System Action: Processing ends.User Response: None

ANU0206E Directory (directory) could not be created.Explanation: An attempt was made to create adirectory. This attempt failed.System Action: Processing ends.User Response: None

ANU0207E Directory path (directorypath) is too long.Explanation: An attempt was made to use a directorypath that was too long. This attempt failed.System Action: Processing ends.User Response: None

ANU0208E There is not enough disk space for theoperation attempted.

Explanation: An attempted operation required moredisk space than was available. The attempt failed.System Action: Processing ends.

Appendix C. Messages 41

User Response: None

ANU0209E The rename of file (filename1) to(filename2) failed.

Explanation: An attempt was made to rename a file.This attempt failed.System Action: Processing ends.User Response: None

ANU0210E The Tivoli Storage Manager high levelqualifier is too long.

Explanation: An attempt was made to use a TivoliStorage Manager high level qualifier that was too long.This attempt failed.System Action: Processing ends.User Response: None

ANU0211E The Tivoli Storage Manager low levelqualifier is too long.

Explanation: An attempt was made to use a TivoliStorage Manager low level qualifier that was too long.This attempt failed.System Action: Processing ends.User Response: None

ANU0212E The Tivoli Storage Manager filespacename is too long.

Explanation: An attempt was made to use a TivoliStorage Manager filespace name that was too long. Thisattempt failed.System Action: Processing ends.User Response: None

ANU0213E The maximum number of objectsallowed per Tivoli Storage Managertransaction is t oo small.

Explanation: In order to maintain backup dataintegrity, multiple backup objects are sent to the TivoliStorage Manager server in a single transaction. TheTivoli Storage Manager server has indicated that themaximum number of objects allowed per transaction isless than the minimum required by the Data Protectionfor Oracle application client.System Action: Processing ends.User Response: Increase the maximum number ofobjects allowed per transaction on the Tivoli StorageManager server and retry the operation.

ANU0214E The backup object’s management classbackup copy group does not exist.

Explanation: The Tivoli Storage Manager server hasindicated that the backup object’s management classbackup copy group does not exist.System Action: Processing ends.User Response: Contact your Tivoli Storage Managerserver administrator.

ANU0215E All backup objects do not have the samemanagement class backup copydestination.

Explanation: In order to maintain backup dataintegrity, multiple backup objects are sent to the TivoliStorage Manager server within a single transaction. Allbackup objects within a single transaction are requiredto have the same management class backup copydestinations.System Action: Processing ends.User Response: Contact your Tivoli Storage Managerserver administrator.

ANU0216E Unable to obtain space information forvolume (volumename).

Explanation: An attempt was made to obtain spaceinformation for a volume. This attempt failed.System Action: Processing ends.User Response: None

ANU0217E The Tivoli Storage Manager filespacename is invalid.

Explanation: The filespace name or directorydelimeter is invalid.System Action: Processing ends.User Response: Check that the filespace name length,characters, and directory delimeters are valid.

ANU0218E The Tivoli Storage Manager high levelqualifier is invalid.

Explanation: The high level qualifier name ordirectory delimeter is invalid.System Action: Processing ends.User Response: Check that the high level qualifiername length, characters, and directory delimeters arevalid.

ANU0219E The Tivoli Storage Manager low levelqualifier is invalid.

Explanation: The low level qualifier name or directorydelimeter is invalid.System Action: Processing ends.User Response: Check that the low level qualifiername length, characters, and directory delimeters arevalid.

ANU0256E The password in your Tivoli StorageManager options file has expired. Pleasechange your password on the TivoliStorage Manager server using the’change password’ command and theneither change or remove the passwordvalue in your options file.

Explanation: Your Tivoli Storage Manager passwordhas expired. You need to change your password.System Action: Processing ends.User Response: Obtain a new password for yourTivoli Storage Manager server; node using the change


password command or by asking your Tivoli StorageManager Administrator to change your password.

ANU0257E Your password has expired.Explanation: Your Tivoli Storage Manager passwordhas expired. A new password needs to be obtained.System Action: Processing ends.User Response: Obtain a new password for yourTivoli Storage Manager node using the changepassword command or by asking your Tivoli StorageManager Administrator to change your password.

ANU0258E You did not enter a valid password.Processing ends.

Explanation: The password that was entered was nota valid password.System Action: Processing ends.User Response: Re-enter the command specifying avalid password.

ANU0259E The password you entered forverification does not match thepassword you entered for your newpassword. Your password will not bechanged.

Explanation: The password you entered forverification of your new password does not match thenew password that was entered.System Action: Processing ends.User Response: Try again to change your passwordbeing sure to enter the same password for the newpassword and for the verification password.

ANU0260I Password successfully changed.Explanation: The change password commandcompleted successfullySystem Action: Processing ends.User Response: None

ANU0261I There are no backups for the servernamed servername.

Explanation: There are no backups on the TivoliStorage Manager server for the specified server name.System Action: Processing ends.User Response: None

ANU0263E Failed to start Web browser with areturn code of returncode.

Explanation: An attempt was made to start the webbrowser to view the TSM HTML b ook. This attemptfailed.System Action: Processing ends.User Response: Start your web browser manually andpoint it to bookfrm.htm in the agent htm directory.

ANU0264I Could not find the default browserdefined. An attempt will be made to useMicrosoft Internet Explorer.

Explanation: An attempt was made to read theregistry to determine the default browser. However, adefault browser is not defined. A determination will bemade where Microsoft Internet Explorer is installed.System Action: Processing continues.User Response: It is possible that a default browser isnot defined for the system. This is okay. An attemptwill be made to use Microsoft Internet Explorer.

ANU0265E Could not find Internet Explorer.Explanation: An attempt was made to read theregistry to determine where Microsoft’s InternetExplorer was installed. This attempt failed.System Action: Processing ends.User Response: Make sure that the registry is set upcorrectly for Internet Explorer.

ANU0266E Could not find the Tivoli StorageManager HTML books.

Explanation: An attempt was made to read theregistry to determine where the Tivoli Storage Managerbooks were installed. This attempt failed.System Action: Processing ends.User Response: It may be necessary to reinstall theapplication client code. This will ensure that theregistry entries are set up correctly.

ANU0267E The verify password entered does notmatch the new password entered.

Explanation: The verify password does not match thenew password.System Action: Processing ends.User Response: Retry the command with a matchingverify password.

ANU0300E Invalid restore type.Explanation: The type of restore requested is invalid.System Action: Processing ends.User Response: Re-enter the command specifying avalid restore type.

ANU0301E Invalid backup type.Explanation: The type of backup requested is invalid.System Action: Processing ends.User Response: Re-enter the command specifying avalid backup type.

ANU351E Invalid trace keyword - ’keyword’Explanation: A TRACEFLAG option in the userconfiguration file or on the command line is incorrect.System Action: Client program did not initialize ortracing was not enabled in the applet.User Response: Correct the value.


ANU357E Unable to open trace output filefile-name.

Explanation: A TRACEFILE option in the userconfiguration file or on the command line used adirectory path and file-name combination to which youdo not have write access.System Action: Client program did not initialize.User Response: Change the TRACEFILE value so thatit is a location to which you have write access.

ANU366E Unable to close trace output filefile-name.

Explanation: An error occurred during the closing of atrace output file-name (for example, not enough diskspace).System Action: Processing continues.User Response: Check the options.doc file for adescription of possible causes of the error, or see yoursystem administrator.

ANU367E Unable to write to trace file tracefile.Tracing disabled.

Explanation: An error occurred when writing to thespecified tracefile.System Action: Tracing is disabled. Processingcontinues.User Response: Ensure the device that the tracefileaccess is available and has sufficient space for thetracefile. Retry the command.

ANU368E Invalid trace file name (name too long).Explanation: A TRACEFILE option in the preferencesfiles used a file name that is too long.System Action: Client program did not initialize.User Response: Change the file name used as theTRACEFILE so that it is equal to or less than 255characters in length.

ANU383E Specifying the trace file ’link’ as asymbolic link is not allowed.

Explanation: Trace file ’linkname’ cannot be a symboliclink.System Action: The symbolic link ’linkname’ isdeleted, the trace file is recreated, and processing stops.User Response: Specify the trace file location with the’tracefile’ option.

ANU384E Symbolic link ’linkname’ to ’target’ wassuccessfully deleted.

Explanation: Log ’linkname’ cannot be a symbolic link.System Action: The symbolic link ’linkname’ isdeleted, the log is recreated, and processing stops.User Response: Check the location of the new file. Tospecify the location of log files, refer to the user’smanual for the ’errorlogname’ option, the’schedlogname’ option, and the ’DSM_LOG’environmental variable.

ANU385E Unable to delete symbolic link ’link’.Explanation: Log ’linkname’ cannot be a symbolic link.System Action: Processing stops.User Response: Delete the symbolic link ’linkname’.

ANU476E program-name: cannot open file file-spec:error.

Explanation: TDP cannot open the file.System Action: TDP cannot complete the requestedoperation.User Response: Retry the operation. If the problemcontinues, check with your system administrator.

ANU2500E Oracle passed an invalid modeExplanation: Invalid mode passed by Oracle.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2501E Oracle passed a null file nameExplanation: Null file name passed by Oracle.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2502E Wrong data block sizeExplanation: Wrong data block size.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2503E Backup object ’filespacehlll’ already existson TSM Server.

Explanation: The object has previously been backedup to the TSM Server.System Action: Data Protection for Oracle returns tothe calling procedure.User Response: If backing up an object, make sureOracle is generating a unique backup object name.

ANU2504E Dissimilar Oracle handleExplanation: The handle passed from Oracle is not thesame handle that TSM passed back.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2505I End of file reachedExplanation: End of file reached.System Action: The system returns to the callingprocedure.User Response: None.


ANU2506E Wrong Read StateExplanation: The operation must be in READ state.System Action: The system returns to the callingprocedure.User Response: Contact TSM support.

ANU2507E Runtime API version is outdatedExplanation: Runtime API is lower than compile timeAPI.System Action: The system returns to the callingprocedure.User Response: Check compile time API level, obtainsame or higher level of API library.

ANU2508E Wrong write stateExplanation: The operation must be in WRITE state.System Action: The system returns to the callingprocedure.User Response: Contact TSM support.

ANU2509E Invalid flag passedExplanation: Oracle passed an invalid flag.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2510E The Caller must be a root userExplanation: Only a UNIX root user can executepasswordSystem Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2511E Reduce the number of copies to thatspecified in RMAN

Explanation: The duplex copy feature has reachedmaximum allowed copies.System Action: The system returns to the callingprocedure.User Response: Reduce the number of backup copiesto that allowed by RMAN.

ANU2512E Could not open license file: license fileExplanation: The license file could not be opened.System Action: The system returns to the callingprocedure.User Response: Check that the license file exists withthe correct permissions.

ANU2513E Could not read license file: license fileExplanation: The license file could not be read.System Action: The system returns to the callingprocedure.User Response: Check that the license file permissionsare correct.

ANU2514E Could not write license file: license fileExplanation: The license file could not be written.System Action: The system returns to the callingprocedure.User Response: Check that the license file permissionsare correct.

ANU2515E Invalid data format in license file: licensefile

Explanation: The license file data format is invalid.System Action: The system returns to the callingprocedure.User Response: Reinstall the license that came withData Protection for Oracle.

ANU2516E Bad checksum of license file: license fileExplanation: The license file has a bad checksum.System Action: The system returns to the callingprocedure.User Response: Reinstall the license that came withData Protection for Oracle.

ANU2517E Try and Buy Evaluation period is overfor license file: license file

Explanation: The Try and Buy Evaluation period isover.System Action: The system returns to the callingprocedure.User Response: Purchase the product or discontinueuse.

ANU2518E License file: license file not valid for thisapplication

Explanation: The license file is not intended for thisapplication.System Action: The system returns to the callingprocedure.User Response: Reinstall the license that came withData Protection for Oracle.

ANU2519E Could not read passwordExplanation: There is an invalid password or thepassword file cannot be not found.System Action: The system returns to the callingprocedure.User Response: Check that password file exists and isvalid.

ANU2521E Error opening file name. Checkpermissions.

Explanation: A directory could not be created.System Action: The system returns to the callingprocedure.User Response: Check that permissions allow thecreation of directories.


ANU2522E No memory availableExplanation: There is not enough system memory tocomplete the action.System Action: The system returns to the callingprocedure.User Response: Make more system resources availableby closing other applications, then try the action again.

ANU2523E The Management Class does not matchExplanation: The management class for the queryobject could not be found.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2525E Input date does not match expected dateformat or range.

Explanation: The input date does not match theexpected date format or range.System Action: The system returns to the callingprocedure.User Response: Check that the format and length ofthe date entry matches TDP_DATE_FORMAT type andthe range of the date values are valid.Valid days are:1-31Valid months are: 1-12Valid years are:1990-2089

ANU2529E To Date cannot occur before From DateExplanation: The specified To Date occurs before FromDate.System Action: The system returns this error.User Response: Enter a valid To Date that occurs afterthe From Date.

ANU2530E Screen size is too small to accuratelydisplay the PICK window.

Explanation: You cannot use the PICK option on aworkstation that has a screen smaller than 20 charactersacross and 10 lines down.System Action: The operation was not completed.User Response: Retry the operation using aworkstation that has a screen with the minimum size.

ANU2531E Could not create file for Data Protectionfor Oracle utility

Explanation: The temporary file could not be created.System Action: The system returns to the callingprocedure.User Response: Check the status of the filespace.

ANU2532E Unknown Error - View the DataProtection for Oracle error log

Explanation: There was an unknown error. View thetdpoerror.log.System Action: NoneUser Response: None

ANU2533E SQLPLUS errorExplanation: The utility could not find SQLPLUS orthere was a scripting error.System Action: The system returns to the callingprocedure.User Response: Check that SQLPLUS is installed andlocated in your search path. Verify the password.

ANU2534E Option file error.Explanation: The option or option file name is invalid.System Action: The system returns to the callingprocedure.User Response: Check the tdpoerror.log file for anexplanation of the error.

ANU2535I File /fs/hl/ll = number bytes sentExplanation: This is the total bytes sent to the serverfor that file nameSystem Action: The system returns to the callingprocedure.User Response: Check the TSM Server activity log.

ANU2536I File /fs/hl/ll = number bytes recievedExplanation: This is the total bytes received from theserver for that backup file name.System Action: The system returns to the callingprocedure.User Response: Check the TSM Server activity log.

ANU2537E Error found while parsing options inData Protection for Oracle options file.

Explanation: There was an error found while parsingthe Data Protection for Oracle options file.System Action: The system returns to the callingprocedure.User Response: Check that the options and theoptions file are valid.

ANU2538E Error found while initializing tracing forData Protection for Oracle.

Explanation: Error found while initializing the DataProtection for Oracle trace facility.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.

ANU2539E Function Name: Error - string pointer isNULL.

Explanation: A NULL pointer was passed to DataProtection for Oracle.System Action: The system returns to the callingprocedure.User Response: Contact your system administrator.


ANU2571E Could not load the library: library DataProtection for Oracle

Explanation: Library cannot be loaded.System Action: The system returns to the callingprocedure.User Response: Check that the library exists.

ANU2600E There is no Registry entry for the TSMAPI.

Explanation: The Windows Registry entry was notfound.System Action: The system returns to the callingprocedure.User Response: Check that the TSM API is installedcorrectly.

ANU2601E There is no Registry entry for the DataProtection for Oracle install path.

Explanation: The Registry Entry for the DataProtection for Oracle install path was not found.System Action: The system returns to the callingprocedure.User Response: Check that Data Protection for Oraclewas installed correctly.

ANU2602E The object Filespace NameHigh LevelNameLow Level Name was not found onthe TSM Server

Explanation: The object name was not found on theTSM Server.System Action: The system returns to the callingprocedure.User Response: Check that the object name is correctand that it exists on the TSM Server.

ANU2603E The option Option Name in file Filenameis invalid.

Explanation: An incorrect option was passed into theData Protection for Oracle options file.System Action: The system returns to the callingprocedure.User Response: Verify that your options are correct inthe Data Protection for Oracle options file.

ANU2614E Invalid sequence of function calls toData Protection for Oracle

Explanation: Data Protection for Oracle received afunction call from Oracle that is out of sequence.System Action: Data Protection for Oracle returns tothe calling procedure.User Response: Contact Oracle or Data Protection forOracle support.

ANU2615E Options file ’filename’ not found.Explanation: The option file name specified could notbe located.System Action: The system returns to the callingprocedure.User Response: Ensure that an option file exists in thedefault path or that the user specified option file isvalid.

ANU2616E Empty parameter specified for option’option’ in options file ’filename’.

Explanation: The option specified must have aparameter supplied.System Action: The system returns to the callingprocedure.User Response: Ensure that a valid parameter for thegiven option is entered and valid.


Notices

This information was developed for products and services offered in the U.S.A.

IBM may not offer the products, services, or features discussed in this document inother countries. Consult your local IBM representative for information on theproducts and services currently available in your area. Any reference to an IBMproduct, program, or service is not intended to state or imply that only that IBMproduct, program, or service may be used. Any functionally equivalent product,program, or service that does not infringe any IBM intellectual property right maybe used instead. However, it is the user’s responsibility to evaluate and verify theoperation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matterdescribed in this document. The furnishing of this document does not give youany license to these patents. You can send license inquiries, in writing, to:

IBM Director of LicensingIBM CorporationNorth Castle DriveArmonk, NY 10504-1785U.S.A.

The following paragraph does not apply to the United Kingdom or any othercountry where such provisions are inconsistent with local law:INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THISPUBLICATION ″AS IS″ WITHOUT WARRANTY OF ANY KIND, EITHEREXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIEDWARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESSFOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express orimplied warranties in certain transactions, therefore, this statement may not applyto you.

This information could include technical inaccuracies or typographical errors.Changes are periodically made to the information herein; these changes will beincorporated in new editions of the publication. IBM may make improvementsand/or changes in the product(s) and/or the program(s) described in thispublication at any time without notice.

Any references in this information to non-IBM Web sites are provided forconvenience only and do not in any manner serve as an endorsement of those Websites. The materials at those Web sites are not part of the materials for this IBMproduct and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way itbelieves appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purposeof enabling: (i) the exchange of information between independently createdprograms and other programs (including this one) and (ii) the mutual use of theinformation which has been exchanged, should contact:

IBM CorporationInformation Enabling Requests


Dept. M135600 Cottle RoadSan Jose CA 95193-0001U.S.A.

Such information may be available, subject to appropriate terms and conditions,including in some cases, payment of a fee.

The licensed program described in this document and all licensed materialavailable for it are provided by IBM under terms of the IBM Customer Agreement,IBM International Program License Agreement or any equivalent agreementbetween us.

Information concerning non-IBM products was obtained from the suppliers ofthose products, their published announcements or other publicly available sources.IBM has not tested those products and cannot confirm the accuracy ofperformance, compatibility or any other claims related to non-IBM products.Questions on the capabilities of non-IBM products should be addressed to thesuppliers of those products.

This information is for planning purposes only. The information herein is subject tochange before the products described become available.

If you are viewing this information softcopy, the photographs and colorillustrations may not appear.


TrademarksThe following terms are trademarks of the International Business MachinesCorporation in the United States or other countries or both:

AIXIBMpSeriesRISC System/6000Tivoli

Microsoft®, Windows®, and the Windows logo are trademarks of MicrosoftCorporation in the United States, other countries, or both.

ActionMedia, LANDesk, MMX, Pentium and ProShare are trademarks of IntelCorporation in the United States, other countries, or both.

UNIX® is a registered trademark of The Open Group in the United States andother countries.

Other company, product and service names may be trademarks or service marks ofothers.

Notices 51

Index

Aarchive copy group 16autostart 36

Bbackdelete 12

and backup removal 20and Tivoli Storage Manager

policy 15backup copy group values 15backups

automating 33removing 19

bkdb.log 17bkdb.scr

and the Tivoli Storage Managerscheduler 34

Ccommand line syntax

characteristics 23commands

Oraclechange 19

tdpoconf password 23tdpoconf showenvironment 24tdposync

syncdb 27Tivoli Storage Manager Server

query actlog 20query association 34query node 19, 20query schedule 34query status 21

commmethod 13communication methods 6compression 14

DData Protection for Oracle

and Oracle databases 17configuring 13environment requirements 5generating trace file 20installing 5, 6overview 2prior versions 6recommendations 26Recovery Manager (RMAN) 2reporting problems 20supported Oracle versions 2, 6Tivoli Storage Manager policy

requirements 14version migration 3

disk space requirements 5

dsierror.logproblem determination 20

dsm.optdescription 13problem determination 20recommended options 14required options 13

dsmi_log 9dsmi_orc_config 10dsmsched.log 37duplex copy

considerations 18overview 18

Eenablelanfree 14examples

duplex copy 18include/exclude 15invoking RMAN 17removing backups 19RMAN scripts 17tdpoconf password command 24tdpoconf showenvironment

command 25tdposync syncdb command 28

pick window 29Tivoli Storage Manager scheduler 33

expiration of objects 14

Hhardware requirements 5

Iinclexcl

and Tivoli Storage Managerpolicy 15

includeand duplex copy 18and Tivoli Storage Manager

policy 15installation

instructionsnode name registration 12

installing Data Protection for Oracle 6client environment requirements 5

LLAN-free data transfer

description 3options 14

Mmanagement class

for automatic expiration 14using 19

maxnummp 18memory requirements 5migration considerations 3

Nnode name

registration 12nodename 13numcatalogs

and tdposync syncdb command 27

Ooperating system requirements 5options 9Oracle

supported versions 6orcsched.cmd file 36outfile

and tdpoconf showenvironmentcommand 25

Ppasswordaccess 13pick window 29policy domain 14problem determination 20

Rreadme.tdpo 5retonly 12


policy 15RMAN

description 2invoking 17scripts 17

Sschedlogname 37scripts 17set duplex 18software requirements 6

Ttcpclientaddress 37tcpclientport 37tdpo_date_fmt 10


tdpo_fs 10tdpo_language 11tdpo_mgmt_class_2 11tdpo_mgmt_class_3 11tdpo_mgmt_class_4 11tdpo_num_fmt 10tdpo_optfile

and tdpoconf password command 24and tdpoconf showenvironment

command 25and tdposync syncdb command 27example 9

tdpo_time_fmt 10tdpo_trace_file 21tdpo.opt

and version migration 3description 9problem determination 20

tdpoconfand password initialization 16and tdpo.opt 9description 23for problem determination 20password command 23

example 24syntax diagram 24tdpo_optfile 24

showenvironment command 24example 25outfile 25syntax diagram 24tdpo_optfile 25

tdpoerror.loghow to specify 9problem determination 20

tdposyncand tdpo.opt 9considerations 26description 25syncdb command 27

numcatalogs 27pick window 29syntax diagram 27tdpo_optfile 27

Tivoli Storage Managerfunctions 1management class 15policy requirements 14scheduler 33service 21services 1supported API 6

Tivoli Storage Manager API trace file 20Tivoli Storage Manager Server

supported version 6trace file, generating 20tracefile 21

Vverdeleted 12


policy 15


��

Program Number: 5698–APD

Printed in U.S.A.

SC32-9065-00

ibm tivoli storage manager for databases version...

Documents