Online Backup Failed from DB13, brbackup runs on application server

[Former Member]

Hi Everone,

I am getting problem when i am scheduling Online Backup from DB13 t-code.

Backup gets failed because logical command BRBACKUP execute on our Application server host rather than DBCI server host.

I have pest the lob logs below:

************************************

Job started

Step 001 started (program RSDBAJOB, variant &0000000000389, user ID BASIS)

Execute logical command BRBACKUP On host xyzapp - (Application server)

Parameters:-u / -jid ALLOG20110824210000 -c force -t online -m all -p initSEP.sap -a -c force -p initSEP.sap -s

d

BR0051I BRBACKUP 7.00 (40)

BR0252E Function fopen() failed for '/oracle/client/10x_64/instantclient/dbs/initSEP.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile /oracle/client/10x_64/instantclient/dbs/initSEP.sap

BR0280I BRBACKUP time stamp: 2011-09-02 21.01.09

BR0301E SQL error -12545 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-12545: Connect failed because target host or object does not exist

BR0310E Connect to database instance SEP failed

BR0056I End of database backup: begroqyn.log 2011-09-02 21.01.09

BR0280I BRBACKUP time stamp: 2011-09-02 21.01.09

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

****************************************

Please help.

Thanks,

Ocean

[Former Member · Accepted solution]

Hi,

It is highly unusual for the SAP profile to be read from the /oracle/client location irrespective from where it is run.

The ORACLE_HOME is definitely wrongly set. Correct the same. A very crude workaround would be to create a dbs directory in the path below and copy the init.SAP file at the same location.

System is only going to check the parameters.

Thanks and Regards,

Karan Shah

[Former Member]

Hello Parixit,

I have the same error. What was the solution?

[Former Member]

Hi Johan,

Please check whether init<SID>.sap profile available in $ORACLE_HOME/dbs. because brtools check the backup profile from that directory. and also mentioned on above please verify the oracle_home env parameters also.

Thanks & Regards

Balaji

[Former Member]

Dear Balaji,

The errror was in the SAPXPG rfc. The host was the app server. We changed to DB server and it was sucessfully.

[Former Member]

Hi Johan,

Thanks for the update.

Balaji

[Former Member]

If you can check permissions on directory.

Some time this can cause problem.

[Former Member]

Hello

The previous contributor is correct, the profile is usually read from ORACLE_HOME. I have never seen this error linking to the Oracle client directory, please double check the following

Ensure that your envirionment variables are correctly set ORACLE_HOME, DIR_LIBRARY

Brtools are always installed on the DB server and can be called from any application server. if you are scheduling from DB13 on the application server, what is the connection setup? RSH, RFC, standalone gateway?

If using a standalone gateway, it must be installed on the DB server, please refer to oss notes #446172, #1025707

Best Regards

Rachel

[former_member204746]

Hi,

try this link:

http://madhutekur.wordpress.com/2008/08/04/db13-sxpg_command_execute-failed-error/

[Former Member]

Hi,

we have to check two things to solve the issue.

1.IS the tape getting Initilized sucessfully --Y/N

2.If NO check whether tape is access at the O/S level(If its windows check through NTBACKUP)

3.If YES check the ORACLE_HOME directory permission. As fopen() --> BRBACKUP is not able to read the INIT<SID>.sap in the ORACLE_HOME=/oracle/<SID>/102_64.

Thanks and Regards,

Amarnath.

[Former Member]

Hi,

You can change the execution server of already scheduled backup job in SM37

Run SM37 tcode >> search for Backup job.

Select DBA: (brbackup job) >> Select from Menu ( JOB >> Move to Different Server)

Select DBCI host in "New Target Server"

Click on "Move".

Or simply delete and re-schedule the backup job by logging into DBCI host.

Regards.

Rajesh Narkhede