Weekly & Monthly backup for TDP SAP / oracle

[trick-on-tsm]

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)

can any help me to figure out

 

[DanGiles]

"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]

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]

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]

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]

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]

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]

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]

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 ??