Storage Manager for Enterprise Resource Planning

[tsmlover]

hey Rai,

tell me one thing, can i take incremental backups using tdp for ERP via BRTool ?

actully i want to send weekly full backup tapes on my DR site physically and send incremental backup electronically

Regards

[Rai]

There are 2 backup interfaces BACKINT and RMAN
.
BACKINT can handle "complete" and "partial"
RMAN can handle "complete" and "incremental"
.
http://help.sap.com/saphelp_NW04/hel...bd/content.htm

[ocarles]

Hi THE_WIPET!
I have implemented SAP/Oracle backup using brbackup and it works very well. Now, I want to test a restore. I am also using admin assistant and I know there is a simulate restore option. The thing is that I can't fine any good documentation that shows me how to do an SAP/ORACLE database restore.
I will appreciate very much your feed back about how to restore and/or any documentation that you cant point to me about this.

Have a good day

Regards

Oscar

[FBatista69]

Hi guys, i'm clueless with an issue that i'm facing while trying to restore the backups made through TDP SAP R3 agent.
I'm performing a disaster recovery , different machine, but same name, drives, and so on. After configuring TSM, i want to restore from my offsite tapes, like if we are dealing with a real disaster, and in fact i can restore what was backed up through baclient, but it doesn't work when trying to restore with brtools.
I'm getting an error message saying:

"BR0386E File (full name of the db file) reported as not found by backup utility"

I have spent the last few hours looking for hints, but zero progress!
Can someone please help?

[Jeroen]

check with backint if you connect to TSM in the correct way:
backint -p /path_to_utl_file/utl-file -f inquire

check with backfm if you can find the backup label and corresponding files
backfm -p /path_to_utl_file/utl-file

[FBatista69]

HI Jeroen, thank you for your quick reply.
Here are the details of the commands (had to put them in images, because i'm in a really controlled DRP environment and can't copy paste text). Prole seems ok i guess, backfm just can't find anything, i took a look in production and it finds all the files, but, could it be getting the files from a primary pool while i'm trying to restore from offsite volumes (Copypool) after marking the primary volumes as destroyed.
So my guess, something is wrong in this environment or something happenned to the data that should be migrated every single day from a specific tape pool to the SAP Data .
I'm restoring to a server configured exactly as the production server, same windows os and patch level, same drive letters and disk sizes.

Image1.JPGImage2.JPGImage3.JPG

[Jeroen]

"BR0386E File (full name of the db file) reported as not found by backup utility"
I think it means that TSM cannot find the entries in its' database. The backfm screen seems to support that idea

If the tape cannot be found or be read, you would get the message that the data is currently unavailable.

Could well be that the data is not being copied indeed.

[FBatista69]

Once more, thanks for your help on this.

I'm going to update the TSM database on the DRP Server, yesterday i have manualy migrated the data to the copypool so it has to be there.
The TSM node name is SAP_PRD , on production, when i run Q NODEDATA SAP_PRD tsm reports that there are related data on primary pool and on copypool, when i do the same on the recovered TSM system i can't get anything, but for other nodes i can without problems.
Let me move the tapes, and i will get back to you working with yesterdays backups.

[sosolotus@gmail.com]

when i use db13:
BR0279E Return code from 'E:\usr\sap\BWD\SYS\exe\uc\NTAMD64\backint.exe -u BWD -f backup -i E:\oracle\BWD\sapbackup\.behqrggq.lst -t file -p E:\oracle\BWD\102\database\initBWD.utl -c': 2
BR0232E 0 of 17 files saved by backup utility
BR0280I BRBACKUP time stamp: 2012-01-13 17.36.13
BR0231E Backup utility call failed

so,i copy the comm and run it :
E:\usr\sap\BWD\SYS\exe\uc\NTAMD64>E:\usr\sap\BWD\S YS\exe\uc\NTAMD64\backint.exe
-u BWD -f backup -i E:\oracle\BWD\sapbackup\.behqrggq.lst -t file -p E:\oracle\B
WD\102\database\initBWD.utl -c

Data Protection for SAP(R)

Interface between BR*Tools and Tivoli Storage Manager
- Version 6, Release 3, Modification 0.0 for Win x64 -
Build: 475Z compiled on Oct 7 2011
(c) Copyright IBM Corporation, 1996, 2011, All Rights Reserved.

BKI1210E: Input file not found or not accessible: 'E:\oracle\BWD\sapbackup\.behq
rggq.lst'.
BKI0020I: End of program at: 1/13/2012 6:29:27 PM.
BKI0021I: Elapsed time: 00 sec.
BKI0024I: Return code is: 2.

but 'backint -p E:\oracle\BWD\102\database\initBWD.utl -f password ' is ok!

Data Protection for SAP(R)

Interface between BR*Tools and Tivoli Storage Manager
- Version 6, Release 3, Modification 0.0 for Win x64 -
Build: 475Z compiled on Oct 7 2011
(c) Copyright IBM Corporation, 1996, 2011, All Rights Reserved.

BKI2027I: Using TSM-API version 6.2.1.0 (compiled with 5.5.0.0).
BKI2000I: Successfully connected to ProLE on port tdpr3ora64.
BKI0005I: Start of program at: 1/13/2012 6:19:25 PM.
BKI0049I: Enter the password for node ORA_BWDEV on server TSM01: ********
BKI0051I: Password successfully verified for node ORA_BWDEV on server TSM01
BKI0020I: End of program at: 1/13/2012 6:19:32 PM.
BKI0021I: Elapsed time: 07 sec.
BKI0024I: Return code is: 0.

the command 'brbackup -u / -c -m all -t online ' work well; who can help me?

[Jeroen]

brbackup makes the .lst file with all datafiles to backup
Why would you want to bypass brbackup and only use backint for backups?

brbackup also updates logfiles, sets DB in backup mode and so on

[Rai]

Hi soso...,
I guess you are running into a permission problem!
BRBackup generate a "file list" and the corresponding backint call.

E:\usr\sap\BWD\SYS\exe\uc\NTAMD64\backint.exe -u BWD -f backup -i E:\oracle\BWD\sapbackup\.behqrggq.lst -t file -p E:\oracle\BWD\102\database\initBWD.utl -c

the input file with the list of files for backup ( -i E:\oracle\BWD\sapbackup\.behqrggq.lst ) ist stored as ORACLE_ADMIN ( like orabwt )

But if you using DB13 ( CCMS the R3 Scheduler ) the call using as owner the SAP_ADMIN ( like bwtadm )

My assumption is that the SAP_ADMIN can't read ORA_ADMINs files.

Hope that will fix your issue, Rai

[sosolotus@gmail.com]

ora_admins and sap_admin are same account :bwdadm,brbackup works well,why db13 not?

[sosolotus@gmail.com]

brbackup makes the .lst file with all datafiles to backup
Why would you want to bypass brbackup and only use backint for backups?

brbackup also updates logfiles, sets DB in backup mode and so on

brbackup work well. i use backint to test the adapter.

[sosolotus@gmail.com]

Hi soso...,
I guess you are running into a permission problem!
BRBackup generate a "file list" and the corresponding backint call.

E:\usr\sap\BWD\SYS\exe\uc\NTAMD64\backint.exe -u BWD -f backup -i E:\oracle\BWD\sapbackup\.behqrggq.lst -t file -p E:\oracle\BWD\102\database\initBWD.utl -c

the input file with the list of files for backup ( -i E:\oracle\BWD\sapbackup\.behqrggq.lst ) ist stored as ORACLE_ADMIN ( like orabwt )

But if you using DB13 ( CCMS the R3 Scheduler ) the call using as owner the SAP_ADMIN ( like bwtadm )

My assumption is that the SAP_ADMIN can't read ORA_ADMINs files.

Hope that will fix your issue, Rai

thank Rai and Jeroen,i add user bwdadm in all groups,but meet the same err .

[Rai]

Maybe my acceptation about the used user was incorrect !?
I would recommend to enable backint trace in the init<SID>utl with flag "ALL".
The trace should print the user of the backup task.