BrBackup on TSM and Netbackup running Linux Question

[Former Member]

I have 3 oracle/sap databases on 2 linux servers that are new in our, otherwise, aix environment.

I have several issues I need direction with.

The first question(s), and probably simplest to answer are related to the lib files and agent.lic (tsm) file required for Rman backups to work under Linux.

The final question here is related to backup log file extention.

First question...

In my netbackup datacenter...

On 1 linux server with 1 database (APX), I have configured for standard, Non-Rman backups and am getting the expected and desired ".anf" extention on the backup log files.

However on the other linux server (databases AJD and AJQ), configured also for Non-Rman backups, the log file extentions are ".fnf".

I have saved copies of the pertinent ".sap" and ".utl" files for AJD/AJQ and copied the ones from APX to them, modifying accordingly, yet when I run new backups, I STILL get ".fnf" extentions though the .sap and .utl files are identical to APX where I get ".anf" extentions.

I will post copies of the .sap and .utl files at the end of this.

Second question...

For both my Netbackup datacenter and my TSM datacenter, I need to know where to get copies of the lib file necessary for Rman backups to work (that of, libsapora.a64 for Netbackup and libtdp_r364.a for TSM) under Linux.

Likewise, I need to know where to get the pertinent agent.lic file for my TSM Linux database server so ANY backups will work.

Thanks in advance!

Jesse Josserand

Here is a copy of the ".sap" and ".utl" file for the ".anf vs. .fnf" backup log file extention question(s)....

...sap file...

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = util_file

backup_root_dir = /oracle/APX/sapbackup

stage_root_dir = /oracle/APX/sapbackup

compress = no

compress_cmd = "gzip -c $ > $"

uncompress_cmd = "gunzip -c $ > $"

compress_dir = /oracle/APX/sapreorg

archive_function = save_delete

archive_copy_dir = /oracle/APX/sapbackup

archive_stage_dir = /oracle/APX/sapbackup

archive_dupl_del = no

tape_copy_cmd = cpio

disk_copy_cmd = copy

stage_copy_cmd = rcp

pipe_copy_cmd = rsh

cpio_flags = -ovcB

cpio_in_flags = -iuvcB

cpio_disk_flags = -pdcu

dd_flags = "obs=64k bs=64k"

dd_in_flags = "ibs=64k bs=64k"

saveset_members = 1

copy_out_cmd = "dd ibs=8k obs=64k of=$"

copy_in_cmd = "dd ibs=64k obs=8k if=$"

rewind = "mt -f $ rewind"

rewind_offline = "mt -f $ offline"

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 100G

exec_parallel = 0

tape_address = /dev/nst0

tape_address_rew = /dev/st0

volume_archive = (APXA01, APXA02, APXA03, APXA04, APXA05,

APXA06, APXA07, APXA08, APXA09, APXA10,

APXA11, APXA12, APXA13, APXA14, APXA15,

APXA16, APXA17, APXA18, APXA19, APXA20,

APXA21, APXA22, APXA23, APXA24, APXA25,

APXA26, APXA27, APXA28, APXA29, APXA30)

volume_backup = (APXB01, APXB02, APXB03, APXB04, APXB05,

APXB06, APXB07, APXB08, APXB09, APXB10,

APXB11, APXB12, APXB13, APXB14, APXB15,

APXB16, APXB17, APXB18, APXB19, APXB20,

APXB21, APXB22, APXB23, APXB24, APXB25,

APXB26, APXB27, APXB28, APXB29, APXB30)

expir_period = 30

tape_use_count = 100

util_par_file = initAPX.utl

...utl file...

switch_list /oracle/APX/sapbackup/.switch.lis

switch_sem /oracle/APX/sapbackup/.switch.sem

switch_log /oracle/APX/sapbackup/.switch.log

server de08u796-bkp3

client de08u3032-bkp

drives 2

policy SAP_NonProdDB_Tape

schedule 34Days

[volker_borowski2]

First question...

Hi,

one backup is made with backup_mode=ALL and the other is made with backup_mode=FULL.

since the initSID.sap files are identical, the difference must be in the brbackup call, which will override the profile

brbackup -m all

brbackup -m full

check the COMMAND_LINE output from both backup logs.

As already pointed out, exactly this is the difference in FULL and WHOLE backups in DB13 scheduler.

Second question...

agent.lic for tsm should come with the client installation of TDPR3 it should be located

somewhere in /usr/tivoli/tsm/client/ba/... and would be symlinked from $ORACLE_HOME/dbs upon configuration.

Same applies for the backint executable and the library as well.

/usr/tivoli/tsm/client/ba/bin

For netbackup these should be located in

/usr/openv/netbackup/bin/

Keep in mind, that the name might need to be adjusted in the symlink so that rman is loading libobk.a or libobk.so or ...

I only have AIX systems, so I do not know what Linux requires.

Hope this helps

Volker

[Former Member]

Thanks for the list of filetypes, but that doesn't really help me.

Regarding my 1st question, the problem is that the exact same .sap/.utl file combination produces .anf files for backups of the one database, while producing .fnf files for backups of the other two - though, again I say, the files are exactly the same except for the SID. So why is this happening? I want .anf's in this case, not '.fnf' files.

Regarding my 2nd question... it has nothing to do with 'whole' vs. 'full' anything... it has to do with getting the missing components for both TSM (agent.lic and libtdp_r364.a) and for Netbackup (libsapora.a64) compatible with Linux (RHEL) for SAP/Oracle... as the installs we've done do not seem to include these files.

Please someone help with these 2 separate issues.

Thanks

[Former Member]

Start by reading about the meaning of the various extensions of brbackup log files:

http://help.sap.com/saphelp_nw73/helpdata/de/47/204b5bc4091149e10000000a11466f/frameset.htm

Your next question will be about the difference between whole database backup and full backup.

This too is explained somewhere; I haven't a link at hand; please search yourself.

hope this helps