Cannot display backup logs in DB14 on a distributed system

[symon_braunbaer]

Dear experts,

I'm opening a new thread for a known problem, as I've went through almost everything

I could find on the topic, but nothing could bring the solution to my problem, which is:

Problem: In a distributed environment - DB server on one host and AS server on another host,

it is not possible to view the BRBACKUP logs in the DB14 transaction. Clicking the Detail Log

button doesn't work.

I know, that it is necessary to have the SAPXPG_DBDEST_<hostname> RFCs working, which

wasn't the case at the beginning.

I tried to make rsh work, without much success. Then I've exchanged ssh keys between both

nodes for the SIDadm user and maintained the gw/remsh parameter with the result of "which ssh".

Now on OS level ssh dbhost -l SIDadm sapxpg is working fine, though the RFC destination was

still malfunctioning.

Then I've installed an SAP gateway on the DB server. After appending the gateway to the

RFC settings and adding the kernel directory of the SIDadm on the DB server to the path

of the gateway user, the RFC destination finally started working !!

Though, when I click Detail Log in DB14, I am STILL getting the following error:

Detail log:                    benbtxsb.and

Can't exec external program (No such file or directory)

External program terminated with exit code 1

WHICH external program is being executed at this step ? I went to SM69, supplied the path

to the benbtxsb.and log file as an argument to the cat command and this runs fine !!

I have been assuming, that there would be problems in DB13 as well - I've tried to schedule

a simple statistics calculation there. After submitting the definition and clicking on Execute

immediately, the task is being shown as green at the bottom of SAPGUI, but double clicking

on that message hangs the session, until the workprocess has been restarted 😞

What is the problem on my system ??? PLEASE HELP 🙂

[symon_braunbaer · Accepted solution]

I have finally solved the problem. For others, who might have the same situation:

Set the variable $SAPDATA_HOME for the user, under which the gateway is running.

In order to be able to run DBA jobs from DB13, make sure that R3trans is working for the user, under which the gateway is running.

[symon_braunbaer]

Through debug mode, I found something additional:

Detail log:

benbvktn.and

BR0252E Function fopen() failed for '/oracle/<SID>/11203/sapbackup/benbvktn.and' at location file_printout-4

BR0253E errno 2: No such file or directory

External program terminated with exit code 5

This is the wrong location, the file is not /oracle/<SID>/112

03/sapbackup/benbvktn.and BUT /oracle/<SID>/sapbackup/benbvktn.and...

WHY is DB14 looking at the wrong location and how to correct this behaviour ?

[Former Member]

Check settings in init<SID>.sap file first. Are you sure it contains correct settings?

[symon_braunbaer]

Hi Roman and thanks for spending your time on my problem...

Which settings exactly to check in init<SID>.sap ? Could you

please be a little bit more specific ?

[Former Member]

If possible please upload init<SID>.sap file.

[symon_braunbaer]

Hello Roman,

here are the impersonated contents of init<SID>.sap, I've removed everything that starts with #:

backup_mode = all

restore_mode = all

backup_type = online_cons

backup_dev_type = disk

backup_root_dir = <backup_location>

stage_root_dir = <backup_location>

compress = no

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = /oracle/<SID>/sapreorg

archive_function = delete_saved

archive_copy_dir = <backup_location>/oraarch

archive_stage_dir = /oracle/<SID>/sapbackup

tape_copy_cmd = cpio

disk_copy_cmd = rman

stage_copy_cmd = rcp

pipe_copy_cmd = rsh

cpio_flags = -ovB

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

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

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

saveset_members = 1

rman_channels = 1

rman_filesperset = 300

_rman_sess_stmt = ("alter session set optimizer_mode=RULE")

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/rmt/0mn

tape_address_rew = /dev/rmt/0m

volume_archive = (Q07A01, Q07A02, Q07A03, Q07A04, Q07A05,

                  Q07A06, Q07A07, Q07A08, Q07A09, Q07A10,

                  Q07A11, Q07A12, Q07A13, Q07A14, Q07A15,

                  Q07A16, Q07A17, Q07A18, Q07A19, Q07A20,

                  Q07A21, Q07A22, Q07A23, Q07A24, Q07A25,

                  Q07A26, Q07A27, Q07A28, Q07A29, Q07A30)

volume_backup = (Q07B01, Q07B02, Q07B03, Q07B04, Q07B05,

                 Q07B06, Q07B07, Q07B08, Q07B09, Q07B10,

                 Q07B11, Q07B12, Q07B13, Q07B14, Q07B15,

                 Q07B16, Q07B17, Q07B18, Q07B19, Q07B20,

                 Q07B21, Q07B22, Q07B23, Q07B24, Q07B25,

                 Q07B26, Q07B27, Q07B28, Q07B29, Q07B30)

expir_period = 30

tape_use_count = 100

P.S.: Just to clarify some details - we are trying to integrate rman in brbackup, though it's still not a full success, as we are still fighting with our sbt_tape device drivers...

[Former Member]

any errors in dev_rfc* or dev_rd

[symon_braunbaer]

Hello Sunil and thanks for answering...

There were errors when the RFC destinations SAPXPG_DBDEST_<hostname> were not working.

Now after installing SAP Gateway on the DB system there are no more error messages, RFCs are

working fine, but the problem is still not solved...

[Reagan]

Could you provide the technical settings screen shot of the RFC ?

Check if the target host is set as the DB host.

Regards

RB