cancel
Showing results for 
Search instead for 
Did you mean: 

brbackup on HA and backup strategy

Former Member
0 Kudos

Dear Expert,

We have a ECC6 on HA and node1 hosts AS and node2 host DB.

Now when we login to node1,

sapnode1:abcadm> brtools

BR0651I BRTOOLS 7.00 (24)

BR0152E Environment variable ORACLE_HOME is not set

BR0280I BRTOOLS time stamp: 2009-01-26 12.38.22

BR0654I BRTOOLS terminated with errors

1. Is there any doc which explains how to go with backup/restore on HA

2. Also a doc which explains the backup/restore strategy for production

3. For the DR site which method is the best one and how to do it?

Regards

Prash

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Prashant,

You can run db and sap instances on different nodes but if you want to run Brtools other than DB node you need to isntall either gateway instance or rsh should be enabled else brtools wont work.

Thanks,

Kiran.

Former Member
0 Kudos

Hi Kiran,

Thanks for the information.

I do have 2 nodes. But when we schedule the backup/update statistic through DB13, it fails.

Can you tell me about the gateway you talking about? How do I install and from where and on which node? Please provide me with more information on it.

Was curious to know, that lots of customer of sap must be using HA, then how do they use brtools, do they install the gateway which you say or any other method?

and rsh?

Your reply was very helpful.

Regards

Prash

Answers (6)

Answers (6)

Former Member
0 Kudos

Will try with the RSH and come back if there is any issue.

Former Member
0 Kudos

Hi Prash,

I do have 2 nodes. But when we schedule the backup/update statistic through DB13, it fails.

Since you have two nodes and DB and CI (probably application servers too ) are running on different hosts, I assumed that you dont have any sap instance on DB host. So whenever you are trying to schedule jobs over DB13 it will try to execute on SAP instance level and sap instance try to execute on DB system os level but it is unable to connect to DB system at OS level (but if you execute brconnect on db server it runs if you have dba tools installed on db server). If you want to execute via DB13 you need to install sap gateway server (from any master CD you can install by choosing option life cycle tools -> stand alone -> gateway instance) or enable rsh at unix level between all application servers and db server. your gateway should be installed on db node and it may take 3 to 5 minutes.

I implemented SAP on HA at several customers and honestly i am not willing to do rsh for security reasons and go with gateway installation. there are oss notes which you can browse your self.

Regards

Prash

Former Member
0 Kudos

Hi Kiran,

Thanks for the information.

I will try to get more information on the gateway services and its installation and will get resolve the DB13 issue.

If you do have anything to share, then pls...

Points awarded.

Thanks & Regards

Prash

Former Member
0 Kudos

Hi Prash,

Note 446172 given by upender will still apply for you. Just read the reason and prerequisites you can easily understand. This note will guide you what needs to be done. Once you installed gateway you need to setup RFC connection SAPXPG_DBDEST_<SAPDBHOST>. If you dont want to install Gateway just enable RSH which is very easy but remember sidadm from all your applicaiton servers can logon to db host with out entering password. Hope you can resolve your issue soon.

Thanks,

Kiran.

Former Member
0 Kudos

Hi Prashant,

Initially I misunderstood AS as Application Server instead of CI (Central Instance). Then I provided my recommendations.

Please ignore my earlier explanations and apologizes for the same.

You may get additional information with u201CNote 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13"

Regards

Upender Reddy

Former Member
0 Kudos

Hi Upender,

Very helpful answer indeed. Awarded points.

Will drill down to it and will check as what can be done so that DB13 can run smoothly. If you can make my approach more easy, if u have already done it.

My default profile

SAPSYSTEMNAME ABC

SAPGLOBALHOST abc-ascs-srv

rdisp/mshost abc-ascs-srv

rdisp/msserv sapmsABC

rdisp/msserv_internal 3902

enque/process_location REMOTESA

enque/serverhost abc-ascs-srv

enque/serverinst 02

login/system_client 001

j2ee/scs/host abc-scs-srv

j2ee/scs/system 01

j2ee/ms/port 3901

SAPDBHOST abc-db-srv

j2ee/dbtype ora

j2ee/dbname ABC

j2ee/dbhost abc-db-srv

rdisp/bufrefmode sendoff,exeauto

DIR_PUT /usr/sap/$(SAPSYSTEMNAME)/put

Instance profile

SAPLOCALHOST abc-d00-srv

Startup profile

SAPLOCALHOST abc-d00-srv

Can you give me some idea as what can be done.

My DB is on abc-db-srv and as u can see my default profile for various parameter?

Regards

Prash

Former Member
0 Kudos

Hi,

If you have DB and AS on different hotsts, then SAPXPG commond in SAPXPG_DBDEST_<hostname> in SM59 should run in DBHOST instead of AS host.

SAPXPG commond should execute target host as DBHOST.

This may helps you.

Regards

Upender Reddy

Former Member
0 Kudos

What do u mean by SAPXPG command in SAPXPG_DBDEST_<hostname> in SM59 should run in DBHOST instead of AS host??

How that is possible????

What is use of creating a rfc in sm59? have u implemented it?

Former Member
0 Kudos

Does in HA it is required to have both the AS and DB on the same node?

Former Member
0 Kudos

No it is not a requirement.

Former Member
0 Kudos

Naveed,

Following is the output of the job scheduled in DB13

Job log overview for job: DBA:CHECKDB_________@230256/2000 / 23030001

Date Time Message text

27.01.2009 23:03:00 Job started

27.01.2009 23:03:00 Step 001 started (program RSDBAJOB, variant &0000000000001, user ID ADMIN)

27.01.2009 23:03:01 No application server found on database host - rsh/gateway will be used

27.01.2009 23:03:01 Execute logical command BRCONNECT On host abc-db-srv

27.01.2009 23:03:01 Parameters: -u / -jid CHECK20090127230256 -c -f check

27.01.2009 23:03:35 SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: x_error

27.01.2009 23:03:35 Job cancelled after system exception ERROR_MESSAGE

Any suggestion?

Former Member
0 Kudos