• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Weekly & Monthly backup for TDP SAP / oracle

trick-on-tsm

ADSM.ORG Member
Joined
Aug 11, 2008
Messages
23
Reaction score
0
Points
0
i would link to configure Weekly and monthly backups for my tdp SAP using oracle database i tried my following way but it seems it is looking for some where and counting it under one location like

i splited
daily = initPX0_da.utl, initPX0_da.bki & initPX0_tsm_da.sap
px0_da_dsm.opt,

monthly = initPX0_mo.utl, initPX0_mo.bki & initPX0_tsm_mo.sap
px0_mo_dsm.opt,

initially i have fired backup using BRtools by selecting daily configuration and profiles

and then next seelcted monthly profile
out put as follows
____________________________________________________________
Input File : /oracle/PX0/sapbackup/.beavxirs.lst
Profile : /oracle/PX0/102_64/dbs/initPX0_mo.utl
Configfile : /oracle/PX0/102_64/dbs/initPX0_mo.bki
Manual sorting file : disabled
Tracefile : disabled
Traceflags : disabled
Parallel sessions : 1
Multiplexed files : 2
RL compression : 0
Exit on error : disabled
BATCH : enabled
Buffer size : 131072
Buffer Copy Mode : SIMPLE
Redologcopies : disabled
Versioning : enabled
Current Version : 2
Versions to keep : 12
Backup Type : file
TSM log server : disabled
TSM server : [email protected] with 2 sessions configured, using 1 session
TSM client node :
Days for backup : Sun Mon Tue Wed Thu Fri Sat
Backup mgmt class : PRD_BACKUP.MC
Archiv mgmt class : PRD_ARCHIVE0.MC [DEV_ARCHIVE1.MC]



what i see in the above out put (Current Version : 2) :confused:

can any help me to figure out
 

DanGiles

ADSM.ORG Senior Member
Joined
Oct 25, 2002
Messages
628
Reaction score
16
Points
0
Location
Toronto, Ont. Canada
"it seems it is looking for some where and counting it under one location like..."
It is difficult to understand what, exactly, you are asking. If you want weekly/monthly backups to be handled differently, then you need to point them to different management classes. BUT if you are backing up the same thing, then changing management classes will only screw you up. Do your monthly "backups" using a different node name or create backup sets at the TSM server. (There may be other options, but those two are the most used.)
 

trick-on-tsm

ADSM.ORG Member
Joined
Aug 11, 2008
Messages
23
Reaction score
0
Points
0
actually iam confuse here that after pointing to different config/profile from where it picks the earlier backuped up version information.

i am not managing backup version from TSM server,
though i have to create different mgmt class to hold monthly backups
 

DanGiles

ADSM.ORG Senior Member
Joined
Oct 25, 2002
Messages
628
Reaction score
16
Points
0
Location
Toronto, Ont. Canada
Sorry, never mind what I said before: you're using BRtools. So, BRtools has to control the retention/deletion and you're management class should be 1/0/0/0. (I haven't used TDP SAP, but I am assuming that the set up will be the same as for Oracle.)
So, if you want to retain monthly backups, then you need to do an export (to disk) and archive this to TSM.

Hopefully, someone with specific SAP TDP experience will confirm or correct this, but I'm pretty sure that's what you'll have to do.
 

trick-on-tsm

ADSM.ORG Member
Joined
Aug 11, 2008
Messages
23
Reaction score
0
Points
0
The way you are suggesting is to take offline backup using BA but i configured online backups using TDP for EPR SAP
using backup method BRbackup---> Backint---> TDP SAP ---> TSM

2 different sap profiles ( .sap & .utl)
2 different config files ( .bki)
2 different node's for daily and monthly(xx_da , xx_mo)
2 different management class (xx_da.mc, _mo.mc)

is it he right way or do i need to do some more

but even after defining new mgmt for monthly i got one more version increased

Input File : /oracle/PB0/sapbackup/.beavyakb.lst
Profile : /oracle/PB0/102_64/dbs/initPB0_mo.utl
Configfile : /oracle/PB0/102_64/dbs/initPB0_mo.bki
Manual sorting file : disabled
Tracefile : disabled
Traceflags : disabled
Parallel sessions : 1
Multiplexed files : 2
RL compression : 0
Exit on error : disabled
BATCH : enabled
Buffer size : 131072
Buffer Copy Mode : SIMPLE
Redologcopies : disabled
Versioning : enabled
Current Version : 3
Versions to keep : 12
Backup Type : file
TSM log server : disabled
TSM server : [email protected] with 2 sessions configured, using 1 session
TSM client node :
Days for backup : Sun Mon Tue Wed Thu Fri Sat
Backup mgmt class : PRD_MO_BACKUP.MC
Archiv mgmt class : PRD_MO_ARCHIVE0.MC PRD_MO_ARCHIVE1.MC
 

trick-on-tsm

ADSM.ORG Member
Joined
Aug 11, 2008
Messages
23
Reaction score
0
Points
0
i found the solution

its init<SID>.bki which keep records for all backups & cnfigurations info

we dont need to have multiple mgmt just split .bki
and edit init<SID>.utl to point it different config files
for daily "CONFIG_FILE /oracle/PR0/102_64/dbs/init<SID>DA_.bki"
for month "CONFIG_FILE /oracle/PR0/102_64/dbs/init<SID>MO_.bki"
 

DanGiles

ADSM.ORG Senior Member
Joined
Oct 25, 2002
Messages
628
Reaction score
16
Points
0
Location
Toronto, Ont. Canada
I'm glad you figured it out. The only comment is to reiterate what I said before about exports. A TDP backup is a physical backup, and so if you upgrade the application, it becomes useless. Exports are logical backups, so if you upgrade, you can still recover. You can also recover individual tables with exports.
 

Rai

ADSM.ORG Member
Joined
Jul 22, 2008
Messages
54
Reaction score
4
Points
0
Location
Germany
Hi together,
*.bki file only storing "password, server"(pwa=prompt) and "version"(max_version n), and some other fix values so it make no sense to use 2 of them.
If you need different environments for daily and monthly backup use different *sap and *.utl file
here 2 brbackup call samples for monthly and daily backups ( daily and log using the default init<SID>.sap and the default init<SID>.utl )
....
brbackup -c -m full -t offline -p D:\oracle\A10\ora10g\database\initA10_monthly.sap
>>> with "util_par_file" = ( e.g: initA10_monthly.utl )
brbackup -c -m full -t online
>>> with "util_par_file" = ( e.g: initA10.utl )
....
both *.utl files using the same *.bki file, because both using the same server stanza, only with different MGMs.
NO canges in dsm.opt or other configuration files necessary.
...
I recommend offline backups for monthly backups, because otherwise you should also keep all redologs within this period.
...
FYI: restore ignores MGMs, or in other words it is unimportand which MGM you are using during backup, the restore find it.
...
IMPORTANT: don't use "max_version n" otherwise you will running into a disaster :)
Regards Rai
 

dishant

Newcomer
Joined
Sep 9, 2015
Messages
4
Reaction score
0
Points
0
I am using 2 different nodename,utl file and sap file for online and offline backup, Problem is It is authenticating only single node, If I am updating password for any of 1 other is giving authentication error,

Any suggestions ??
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 19 19.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 61 61.0%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.0%
  • Other (please comement)

    Votes: 8 8.0%

Forum statistics

Threads
31,774
Messages
135,487
Members
21,762
Latest member
Rambug
Top