Storage Manager for Enterprise Resource Planning

[tsmlover]

Hey Rai hw u doin

in the below command the <User> is TSM node name that i created for TDP for SAP Or it is a SAP user ?
brbackup -u <user>/<password> -c -m all -t offline ????
when i put TSM node name in this command parameter it gives me the below output

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>brbackup -u EELPRD1/tsm -c -m all -t online
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: becqjrrz.anf 2010-02-23 11.46.55
BR0484I BRBACKUP log file: E:\oracle\PRD\sapbackup\becqjrrz.anf
BR0280I BRBACKUP time stamp: 2010-02-23 11.46.56
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT EELPRD1/***'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance PRD failed
BR0280I BRBACKUP time stamp: 2010-02-23 11.46.57
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT EELPRD1/***'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance PRD failed

BR0056I End of database backup: becqjrrz.anf 2010-02-23 11.46.56
BR0280I BRBACKUP time stamp: 2010-02-23 11.46.57
BR0054I BRBACKUP terminated with errors


My SAP Admin suggest me to try the below command ....

D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>brbackup -u / -c -m all -t online
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: becqgayx.anf 2010-02-22 17.59.35
BR0484I BRBACKUP log file: E:\oracle\PRD\sapbackup\becqgayx.anf
BR0477I Oracle pfile D:\oracle\PRD\102\database\initPRD.ora created from spfile
D:\oracle\PRD\102\database\spfilePRD.ora
BR0280I BRBACKUP time stamp: 2010-02-22 17.59.37
BR0319I Control file copy created: E:\oracle\PRD\sapbackup\CNTRLPRD.DBF 19841024

BR0280I BRBACKUP time stamp: 2010-02-22 17.59.37
BR0057I Backup of database: PRD
BR0058I BRBACKUP action ID: becqgayx
BR0059I BRBACKUP function ID: anf
BR0110I Backup mode: ALL
BR0077I Database file for backup: E:\oracle\PRD\sapbackup\CNTRLPRD.DBF
BR0061I 41 files found for backup, total size 103579.234 MB
BR0143I Backup type: online
BR0130I Backup device type: util_file_online
BR0109I Files will be saved by backup utility
BR0142I Files will be switched to backup status during the backup
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRBACKUP time stamp: 2010-02-22 17.59.37
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint.exe -u PRD
-f backup -i E:\oracle\PRD\sapbackup\.becqgayx.lst -t file_online -c':
Data Protection for SAP(R)
Interface between BR*Tools and Tivoli Storage Manager
- Version 6, Release 1, Modification 0.0 for Win x64 -
Build: 358 compiled on Nov 4 2008
(c) Copyright IBM Corporation, 1996, 2008, All Rights Reserved.
BKI0000E: Profile not specified.
usage:
backint -p <par_file> [-u <user_id>] [-f <function>]
[-t <type>] [-i <in_file>] [-o <out_file>] [-c]
where:
<user_id> backint utility user
<function> backup | restore | inquire | password | delete
<type> file | file_online
<par_file> parameter file for backup utility
<in_file> name of a text file that defines the objects
default: STDIN
<out_file> Pool for processing messages and the results
of the executed function.
default: STDOUT
BKI0405I: TDP waited 0 sec. for BRBACKUP in util_file_online communication.
BKI0020I: End of program at: 02/22/10 17:59:37 .
BKI0021I: Elapsed time: 00 sec .
BKI0024I: Return code is: 2.
BR0280I BRBACKUP time stamp: 2010-02-22 17.59.37
BR0279E Return code from 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint.exe -u PRD -
f backup -i E:\oracle\PRD\sapbackup\.becqgayx.lst -t file_online -c': 2
BR0232E 0 of 41 files saved by backup utility
BR0280I BRBACKUP time stamp: 2010-02-22 17.59.37
BR0231E Backup utility call failed
BR0056I End of database backup: becqgayx.anf 2010-02-22 17.59.37
BR0280I BRBACKUP time stamp: 2010-02-22 17.59.40
BR0054I BRBACKUP terminated with errors
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>

 

[Jeroen]

-u user/password is orasid. Most DBA configure it in such a way that the orasid user can connect to oracle without a password. Then you can use "-u /"

In the second output there is no reference to the actual utl-file.
BKI0000E: Profile not specified.

I suspect due lacking to specify the utl file in the initSID.sap file:
# backup utility parameter file
# default: no parameter file
util_par_file = /oracle/PR4/102_64/dbs/initPR4.utl

 

[Rai]

brbackup -u <user>/<password> -c -m all -t offline ????
# -u system/manager Oracle username/password ( see ERP sample )
BR0278I Command output of
'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint.exe -u PRD -f backup -i E:\oracle\PRD\sapbackup\.becqgayx.lst -t file_online -c':
Data Protection for SAP(R)
Interface between BR*Tools and Tivoli Storage Manager
- Version 6, Release 1, Modification 0.0 for Win x64 -
Build: 358 compiled on Nov 4 2008
(c) Copyright IBM Corporation, 1996, 2008, All Rights Reserved.
BKI0000E: Profile not specified.
I miss the parameter -p <path to initPRD.utl>
Seems that there is something wrong in your SAP setup ( initPRD.sap )

e.g.: output of one of my test systems
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of 'D:\usr\sap\A10\sys\exe\run\backint.exe -u A10 -f backup -i d:\oracle\A10\sapbackup\.becqkmcv.lst -t file -p d:\oracle\A10\ora10g\database\initA10.utl -c':

 

[tsmlover]

Hey Rai i am sure that the cause of the error is that I miss
-p D:\oracle\PRD\102\database\initPRD.sap

thats why it ask me the below information that is specified in initPRD.sap file

BKI0000E: Profile not specified.
usage:
backint -p <par_file> [-u <user_id>] [-f <function>]
[-t <type>] [-i <in_file>] [-o <out_file>] [-c]
where:
<user_id> backint utility user
<function> backup | restore | inquire | password | delete
<type> file | file_online
<par_file> parameter file for backup utility
<in_file> name of a text file that defines the objects
default: STDIN
<out_file> Pool for processing messages and the results
of the executed function.

yes i also understand ur points , but how to fix it up
'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint.exe -u PRD -f backup -i E:\oracle\PRD\sapbackup\.becqgayx.lst -t file_online -c':

 

[tsmlover]

I also added this parameter < -p D:\oracle\PRD\102\database\initPRD.sap > below is the output


D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>brbackup -u / -c -m all -t online -p D:\oracle\PRD\102\database\initPRD.sap
BR0051I BRBACKUP 7.00 (40)
BR0154E Unexpected option value 'ûp' found at position 8
BR0154E Unexpected option value 'D:\oracle\PRD\102\database\initPRD.sap' found a
t position 9

BR0056I End of database backup: becqkpkm.log 2010-02-23 16.14.04
BR0280I BRBACKUP time stamp: 2010-02-23 16.14.04
BR0054I BRBACKUP terminated with errors

 

[tsmlover]

Hey Rai i forget to add util_para_file = initPRD.util on initPRD.sap file
i added this parameter and run the following command here is the output...


D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>brbackup -u / -c -m all -t online
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: becqksmg.anf 2010-02-23 16.48.38
BR0484I BRBACKUP log file: E:\oracle\PRD\sapbackup\becqksmg.anf
BR0477I Oracle pfile D:\oracle\PRD\102\database\initPRD.ora created from spfile
D:\oracle\PRD\102\database\spfilePRD.ora

BR0280I BRBACKUP time stamp: 2010-02-23 16.48.42
BR0319I Control file copy created: E:\oracle\PRD\sapbackup\CNTRLPRD.DBF 19841024


BR0280I BRBACKUP time stamp: 2010-02-23 16.48.43
BR0057I Backup of database: PRD
BR0058I BRBACKUP action ID: becqksmg
BR0059I BRBACKUP function ID: anf
BR0110I Backup mode: ALL
BR0077I Database file for backup: E:\oracle\PRD\sapbackup\CNTRLPRD.DBF
BR0061I 41 files found for backup, total size 103579.234 MB
BR0143I Backup type: online
BR0130I Backup device type: util_file_online
BR0109I Files will be saved by backup utility
BR0142I Files will be switched to backup status during the backup
BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2010-02-23 16.48.43
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint.exe -u PRD
-f backup -i E:\oracle\PRD\sapbackup\.becqksmg.lst -t file_online -p D:\oracle\P
RD\102\database\initPRD.utl -c':

Data Protection for SAP(R)

Interface between BR*Tools and Tivoli Storage Manager
- Version 6, Release 1, Modification 0.0 for Win x64 -
Build: 358 compiled on Nov 4 2008
(c) Copyright IBM Corporation, 1996, 2008, All Rights Reserved.

BKI5014E: Tivoli Storage Manager Error:
ANS1035S (RC406) Options file '*' could not be found.

BKI0405I: TDP waited 0 sec. for BRBACKUP in util_file_online communication.
BKI0020I: End of program at: 02/23/10 16:48:43 .
BKI0021I: Elapsed time: 00 sec .
BKI0024I: Return code is: 2.

BR0280I BRBACKUP time stamp: 2010-02-23 16.48.43
BR0279E Return code from 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint.exe -u PRD -
f backup -i E:\oracle\PRD\sapbackup\.becqksmg.lst -t file_online -p D:\oracle\PR
D\102\database\initPRD.utl -c': 2

BR0232E 0 of 41 files saved by backup utility
BR0280I BRBACKUP time stamp: 2010-02-23 16.48.43
BR0231E Backup utility call failed

BR0056I End of database backup: becqksmg.anf 2010-02-23 16.48.43
BR0280I BRBACKUP time stamp: 2010-02-23 16.48.47
BR0054I BRBACKUP terminated with errors

 

[Jeroen]

BKI5014E: Tivoli Storage Manager Error:
ANS1035S (RC406) Options file '*' could not be found.

Missing environment variables?
DSMI_DIR=<TSM client install directory>\baclient
DSMI_CONFIG=<TSM client install directory>\baclient\dsm.opt

page 151 in the troubleshooting part of the user guide

 

[tsmlover]

the installation directory of my BA client is
C:\Program Files\tivoli\tsm\baclient\

so do i need to configure the environment variable like this ?

DSMI_CONFIG = C:\Program Files\tivoli\tsm\baclient\dsm.opt

DSMI_DIR = C:\Program Files\tivoli\tsm\baclient\

I am confused because the installation directory of TDP 4 SAP also have dsm.opt file so which file i have to point....

 

[Jeroen]

DSMI_CONFIG to the dsm.opt that you adjusted for SAP. So probably the one in the TDP install dir.
The DSMI_DIR keeps refering to the install dir of the ba-client.

 

[tsmlover]

the location of the directory of BA client
DSMI_DIR=<Installation directory of BA Client>\baclient


the location of dsm.opt file that belongs to the TDP for ERP
DSMI_CONFIG=<Installation directory of TDP for ERP>\dsm.opt

is it okay now ?

but dsm.opt file is empty that is exist on the installation path of TDP for ERP folder ?? do i need to enter any information on it or leave it blank ?

after updating the environment variable can i execute this command brbackup -u / -c -m all -t online

 

[Rai]

hi tsmlover I guess we turn in the circle.... here some questions

Q1: value of SERVER in initPRD.utl
A:
Q2: path of the file <SERVER>.opt ( see Q1 )
A:
Q3: files existing in path where <SERVER>.opt resists ( see Q2 )
A:
Q4: value of the system variables DSMI_* ( !! system not user !! )
A:
Q5: value of util_para_file in initPRD.sap
A:
Q5: result of "backint -p D:\oracle\PRD\102\database\initPRD.utl -f inquire"
A:

 

[tsmlover]

Still same error

BKI5014E: Tivoli Storage Manager Error:
ANS1035S (RC406) Options file '*' could not be found.

I set Environment Variable
DSMI_CONFIG = <Installation directory DP 4 SAP>\dsm.opt

I open the dsm.opt file on notepad i found that the file is empty, there are some lines of comments saying that set this file on the environemtn variable ...

 

[tsmlover]

hi tsmlover I guess we turn in the circle.... here some questions

Q1: value of SERVER in initPRD.utl
A: SERVER = server_a "server_a.opt file that is exisit on the installation directory of DP 4 SAP"
Q2: path of the file <SERVER>.opt ( see Q1 )
A: do u mean server_a.opt file or dsm.opt both files are in DP 4 SAP installation folder
Q3: files existing in path where <SERVER>.opt resists ( see Q2 )
A: do i need to create server.opt file
Q4: value of the system variables DSMI_* ( !! system not user !! )
A: Yes System Variables
DSMI_CONFIG = <Installation directory DP 4 SAP>\dsm.opt
DSMI_DIR = <the diffault installation directory of BA-Client>\baclient

Q5: value of util_para_file in initPRD.sap
A: util_par_file = initPRD.utl "I didnt mention the path before initPRD.util file name because both files initPRD.sap & InitPRD.utl are in the same folder = 'D:\oracle\PRD\102\database'

Q5: result of "backint -p D:\oracle\PRD\102\database\initPRD.utl -f inquire"
I didnt execute this command ?
A:

hey Rai, can you plz come on msn for a min. my ID is [email protected]

 

[tsmlover]

I updated only 3 files as per your instructions

D:\oracle\PRD\102\database\initPRD.util
D:\oracle\PRD\102\database\initPRD.sap
C:\program file\Tivoli\TSM\TDP4SAP\server_a.opt

---------------------------------------------------
C:\program file\Tivoli\TSM\TDP4SAP\dsm.opt <-this is empty file that i set with environment variable...

you didnt mention <server>.opt dnt know what is that

 

[Rai]

- please answer my questions exactly like
Q4: value of the system variables DSMI_* ( !! system not user !! )
A: DSMI_CONFIG=C:\Tivoli\TSM\config.opt\dsm.opt
A: DSMI_DIR=C:\tivoli\tsm\api
A: DSMI_LOG=C:\Tivoli\TSM\log\dsierror.log
Q1: value of SERVER in initPRD.utl
A: SERVER server_a
....
- copy the 2 opt files dsm.opt and <server>.opt into an other directory. the install directory of ERP is not the best place, and change the DSMI_* variabel.
Q5: this command verify your ERP setup. if this failed BR* will failed too

 

[Rai]

you didnt mention <server>.opt dnt know what is that

alle values in < value > are variables and need to be replaced with the value of your setup

<server>.opt = initPRD.utl > SERVER > server_a = server_a.opt

so <server>.opt = server_a.opt in your environment

 

[tsmlover]

Q1: value of SERVER in initPRD.utl

BACKUIDPREFIX PRD___
SERVER server_a
PASSWORDREQUIRED yes
ADSMNODE my_node_name
BRBACKUPMGT my_backup_class oh i set it copy group archive too
BRARCHIVEMGTCLASS my_archive_class

Note: I created 2 managemnet classes with a copy group of Archive, both management classes belongs to a same policy domain. and both management classes use a same storage pool ... is it ryte ?

Q2: path of the file <SERVER>.opt
the path of server_a.opt is the default installation path of TDP for SAP that is c:\program files\tivoli\tsm\tdpr3\server_a.opt
NODEname my_node_name
PASSWORDACCESS PROMPT
TCPServeraddress 10.0.0.1 <--tsm server ip address

DSMI_CONFIG=c:\program files\tivoli\tsm\tdpr3\dsm.opt

DSMI_DIR=C:\Program Files\Common Files\Tivoli\tsm\baclient

do i need to update dsm.opt file as well ?

 

[Rai]

looks fine, dsm.opt doesn't need an update
what is the result of:
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\backint -p D:\oracle\PRD\102\database\initPRD.utl -f inquire"

 

[tsmlover]

hello rai , here is the output
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>backint -p D:\oracle\PRD\102\database\initPRD.utl -f inquire

Data Protection for SAP(R)

Interface between BR*Tools and Tivoli Storage Manager
- Version 6, Release 1, Modification 0.0 for Win x64 -
Build: 358 compiled on Nov 4 2008
(c) Copyright IBM Corporation, 1996, 2008, All Rights Reserved.

Please enter the records for 'inquire' :
{ <backup_id1> | #NULL } [ <file1> ]
[ <backup_id2> | #NULL [ <file2> ] ]
(Press ENTER after each record / line. Press CTRL-Z and ENTER to finish the list
.)



^Z
BKI2027I: Using TSM-API version 5.5.0.0 (compiled with 5.3.2.0).
BKI2000I: Successfully connected to ProLE on port tdpr3ora64.
BKI0005I: Start of program at: 02/25/10 10:54:28 .


-- Parameters --
Input File : D:\s37o.
Profile : D:\oracle\PRD\102\database\initPRD.utl
Configfile : D:\oracle\PRD\102\database\initPRD.bki
Manual sorting file : disabled
Tracefile : disabled
Traceflags : disabled
Parallel sessions : 1
Multiplexed files : disabled
RL compression : disabled
Exit on error : disabled
BATCH : enabled
Buffer size : 32768
Buffer Copy Mode : SIMPLE
Redologcopies : disabled
Versioning : disabled
Backup Type : unknown
TSM log server : disabled
TSM server : SERVER_A with 2 sessions configured
TSM client node : my_client_node
Days for backup : Sun Mon Tue Wed Thu Fri Sat
Backup mgmt class : my_database_backup <--copyGroup=Archive
Archiv mgmt class :my_database_log <--copyGroup=Archive


BKI0020I: End of program at: 02/25/10 10:54:28 .
BKI0021I: Elapsed time: 00 sec .
BKI0024I: Return code is: 2.

I wonder why we put dsm.opt on dsmi_config variable this file is EMPTY, this file is exist in the installation folder of DP for SAP and the file contains only comments ?

 

[Rai]

BKI0024I: Return code is: 2 << ist not what I awaited, you have to enter #NULL
...
(Press ENTER after each record / line. Press CTRL-Z and ENTER to finish the list.)
#NULL
^Z
....
I wonder why we put dsm.opt on dsmi_config variable this file is EMPTY, this file is exist in the installation folder of DP for SAP and the file contains only comments ?
...
dsm.opt is only a hook to find the <server>.opt, thats the only way to realize "multiple server" and "alternate server" on Windows

retry the command till you get an BKI0024I: Return code is: 0

btw. you can start a manual backup with
D:\usr\sap\PRD\SYS\exe\uc\NTAMD64>backint -p D:\oracle\PRD\102\database\initPRD.utl -f backup
and add after (Press ENTER after each record / line. Press CTRL-Z and ENTER to finish the list.)
D:\oracle\PRD\102\database\initPRD.utl ( this file will be backuped )