How can i use DB13 to backup sap in distribution installation mode

[Former Member]

Dear all:

I've intalled my sapcrm system in one distribution mode: my database instance install in a A server,and the central instance installed in another B server.

So, i logon in sap system through my B server, and want to use the Tcode DB13 to backup automaticly. But the system give me the error info like this:

No application server found on database host - rshGateway will be used

BRBACKUP - reason program_start_error For More Information, See SYS...

How can i get it to backup in Db13 automaticly?

And someone told me to install one other gateway instance ,but i think it doesnot work well.

anyone can give me some advice?Thanks very much.

[Former Member]

HI,

brbackup is using user SAPSID and when he try to start on this host he is using this user.. create the same user(if you don't have it) and set the environments.

There is other way to deal with this:

change rfc destination SAPXPG_DBDEST_SAP_<Hostname>

use option : start on explicit host...

Program sapxpg

Target host DB Host

create the .bat file on your db server with the name sapxpg

in this bat file you can set the all the environments that you want to have.... this program will be started prior any brtools and will set all neceserry.

Ajay Kande

[Former Member]

Hi,

If you ave no application server or central insance running on your DB server you have 2 options.

1. install a gateway on your DB server so you can start remote commands on it.

2. Use rsh to connect via the os from your app server to your DB server.

This is what you see in the log in this line

No application server found on database host - rshGateway will be used

I would also recommend installing the gateway on your DB server. Using rsh is insecure. This can be replaced by ssh but setting up an ssh server is also not an easy job if you want to set it up so that it works securely.

Also read <a href="https://websmp202.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700010744542001">note 446172</a>.

Good luck setting it up and let us know how it went.

Kind regards,

Alexander

[Former Member]

Dear:

The notes tell me to Destination SAPXPG_DBDEST_<db_server> in SM59 to point to a stand alone

gateway on your

<db_server>. So the steps to follow are

1) Install standalone gateway on DB Server.

2) Start Standalone gateway.

3) Modify SAPXPG... RFC Destination.

The standalone gateway has it's own installer.

Now i have completed the 1 and 2,3.

but now the brbackup job is :

No application server found on database host - rsh/Gateway will be used

Execute logical command BRCONNECT On host CRM-DB

ŽQ”: -u / -c -f stats -t ALL

BR0801I BRCONNECT 6.40 (11)

BR0152E Environment variable ORACLE_SID is not set

BR0806I End of BRCONNECT processing: cdsexnyn.log2006-03-20 19.21.13

BR0280I BRCONNECT time stamp: 2006-03-20 19.21.13

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

but i set the ORACLE_SID anywhere i can.

[Former Member]

Hi Shao,

Please specify where you have set the ORACLE_SID env. variable.

Do the following users have it?

- the user running the appserver?

- the user which is running the gateway server?

Have you tested the SAPXPG_DBDEST_<dbserver> rfc connection? Are the gateway settings correct in the rfc?

Good luck and let me know what happens.

Best regards,

Alexander Webster