Disk backup troubles!!! Urgent

[Former Member]

Hello!

I have a very urgent problem!!!

How can I make backup Oracle DB, which is placed on one host from Appl.Server (launch BRTools) wich plased on another?

Regards,

Artem Ivashkin

[markus_doehr2 · Accepted solution]

Please post the output of

grep -v \# initVRP_disk_offline.sap | sed -e '/^$/d'

and

rsh oraerp-prd ls $ORACLE_HOME

Markus

[Former Member · Accepted solution]

backup_mode = all

restore_mode = all

backup_type = offline

backup_dev_type = disk

backup_root_dir = /sysvrp/oraerp-prd/backup/VRPdb

stage_root_dir = /oracle/VRP/sapbackup

compress = yes

compress_cmd = "compress -c $ > $"

uncompress_cmd = "uncompress -c $ > $"

compress_dir = /oracle/VRP/sapreorg

archive_function = save_delete

archive_copy_dir = /sysvrp/oraerp-prd/backup/VRPrd

archive_stage_dir = /oracle/VRP/sapbackup

tape_copy_cmd = cpio

disk_copy_cmd = copy

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

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 = (VRPA01, VRPA02, VRPA03, VRPA04, VRPA05,

VRPA06, VRPA07, VRPA08, VRPA09, VRPA10,

VRPA11, VRPA12, VRPA13, VRPA14, VRPA15,

VRPA16, VRPA17, VRPA18, VRPA19, VRPA20,

VRPA21, VRPA22, VRPA23, VRPA24, VRPA25,

VRPA26, VRPA27, VRPA28, VRPA29, VRPA30)

volume_backup = (VRPB01, VRPB02, VRPB03, VRPB04, VRPB05,

VRPB06, VRPB07, VRPB08, VRPB09, VRPB10,

VRPB11, VRPB12, VRPB13, VRPB14, VRPB15,

VRPB16, VRPB17, VRPB18, VRPB19, VRPB20,

VRPB21, VRPB22, VRPB23, VRPB24, VRPB25,

VRPB26, VRPB27, VRPB28, VRPB29, VRPB30)

expir_period = 30

tape_use_count = 100

for the second post:

"permission denied" on both hosts.

my .rhosts files contents:

"cierp-prd # more .rhosts

oraerp-prd vrpadm

oraerp-prd oravrp

cierp-prd #"

"oraerp-prd # more .rhosts

cierp-prd vrpadm

cierp-prd oravrp

oraerp-prd vrpadm

oraerp-prd oravrp

oraerp-prd #"

"oraerp-prd # cd /export/home/vrpadm/

oraerp-prd # more .rhosts

cierp-prd vrpadm

cierp-prd oravrp

oraerp-prd #"

Remind that /oracle/VRP - shared folder for both hosts, that's why I wrote

cierp-prd vrpadm

cierp-prd oravrp

oraerp-prd vrpadm

oraerp-prd oravrp

[markus_doehr2 · Accepted solution]

> for the second post:

> "permission denied" on both hosts.

as user "vrpadm" or "oravrp"?

Markus

[Former Member · Accepted solution]

FROM CIERP-PRD

under vrpadm:

bash-3.00$ rsh oraerp-prd ls $ORACLE_HOME

dev_cp

dev_xpg

sqlnet.log

startdb.log

stopdb.log

trans.log

under oravrp:

gives a big list of files

FROM ORAERP-PRD

under vrpadm:

bash-3.00$ rsh cierp-prd ls /

backup

bin

dev

dev_ensmon

dev_ensmon.old

etc

export

home

inst_cierp

inst_cierp2

instci

instci2

lib

local

mnt

net

opt

oracle

platform

proc

sapmnt

sbin

system

sysvrp

tmp

usr

var

under oravrp:

permission denied

[markus_doehr2 · Accepted solution]

> under vrpadm:

> bash-3.00$ rsh oraerp-prd ls $ORACLE_HOME

> dev_cp

> dev_xpg

> sqlnet.log

> startdb.log

> stopdb.log

> trans.log

>

> under oravrp:

> gives a big list of files

so it seems, that from the application server rsh is working - that is good.

Now to dig further: when you execute the test in SM59 - does it succeed?

Markus

[Former Member · Accepted solution]

Hello Markus!

In Unix there is no news - server now is damaged... But I've the same problem in Windows.

Two systems: one with application server and another with dbserver

In sm59 I get the following information:

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: timeout during allocate

Error Details LOCATION: SAP-Gateway on host BIAPP / sapgw36

Error Details DETAIL: no connect of TP sapxpg from host dbbidm.vct.victoria-group.ru after 2

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 2227

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1872

Error Details RETURN CODE: 242

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Thu May 22 23:49:00 2008

Error Details VERSION: 2

Do you know what should I do to correct error?

There is no any information about how to setup RSH between two Windows system.

P.S. Seems that SAP must sounds like - Systems Applications PROBLEMS...

P.S.S. But it's the best

[markus_doehr2 · Accepted solution]

> In Unix there is no news - server now is damaged...

damaged?

> But I've the same problem in Windows.

> Two systems: one with application server and another with dbserver

> In sm59 I get the following information:

> Logon Connection Error

> Error Details Error when opening an RFC connection

> Error Details ERROR: timeout during allocate

> Error Details LOCATION: SAP-Gateway on host BIAPP / sapgw36

> Error Details DETAIL: no connect of TP sapxpg from host dbbidm.vct.victoria-group.ru after 2

> Error Details COMPONENT: SAP-Gateway

> Error Details COUNTER: 2227

> Error Details MODULE: gwr3cpic.c

> Error Details LINE: 1872

> Error Details RETURN CODE: 242

> Error Details SUBRC: 0

> Error Details RELEASE: 700

> Error Details TIME: Thu May 22 23:49:00 2008

> Error Details VERSION: 2

In that case I would check the network connection between the two machines...

Markus

[Former Member · Accepted solution]

Hi!

damaged? 

Yes, it's imposible but server is wet

Network works fine between servers...

C:\Documents and Settings\sidadm>ping DBBIDM

Pinging DBBIDM [10.1.0.103] with 32 bytes of data:

Reply from 10.1.0.103: bytes=32 time<1ms TTL=128
Reply from 10.1.0.103: bytes=32 time<1ms TTL=128
Reply from 10.1.0.103: bytes=32 time<1ms TTL=128
Reply from 10.1.0.103: bytes=32 time<1ms TTL=128

Ping statistics for 10.1.0.103:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

I don't understand how to adapt rsh client for windows.

[former_member204746]

please explain your question.

are you trying to start backup from DB13?

if not from DB13... why do you want to start a backup from an application server? This is feasible by using an external program. one of them is a free tool from Microsoft called PSEXEC. it is very easy to install and very easy to use.

check that out.

[Former Member]

Hello Eric!

I use SUN cluster, where DB server placed on one node and application on another. It's first try to make a backup after installation. Now my work is stopped, because I don't want to take a risk during SP upgrade. As you maybe know, after initial installation of ERP 2005 with SP level 9 backup operation doesn't work well via DB13, that's why I want to use backup tool at OS level.

I can logon via sqlplus using full parameter string, but in BR*Tools this option doesn't exitst (I cant describe hostname like in sqlplus "conn user/pass@hostname as dba"). It's looks so strange because I think that SUN cluster is one of the famous type of installtion, and SAP doesn't have the GREAT number of notes for this theme...

[markus_doehr2]

Do you have the full client installed on the application server (sqlplus et al)?

Markus

[Former Member]

I can't say "installed", it's just mounted in /oracle/SID directory.

[markus_doehr2]

Application servers (and BR*TOOLS) connect via OPS$ mechanism, does there exist an OPS$ user for the application server?

check

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Note 361641 - Creating OPS$ users on UNIX

What error message do you get when you start the brtools?

Markus

[Former Member]

When I start job in db13 I get a log with message in x_error during execution sapxpg program. I've check remote connection in SM59 (SAPXPG_DBDEST_ORAERP-PRD) but it looks like no gateway exists. How can I maintain gateway? I heard about special installation within Addition Life-Cycle tool in sapinst. Is it true?

P.S. I also created .rhost file in users' home directory for both nodes

Edited by: Artem Ivashkin on May 18, 2008 9:18 AM

[Former Member]

Hi Artem. Can you post the error if it's no so long? Well that you try to understand why error comes, but what for ask a question on a forum? If you want to receive help, please provide

concrete information , not like "t looks like no gateway exists". Удачи.

[Former Member]

Hello!

Once db13 gave me the following log:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000002, user ID AIVASHKIN)

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

Execute logical command BRBACKUP On host oraerp-prd

Parameters:-u / -jid ALGOF20080518021200 -c force -t offline_force -m all -p initVRP_disk_offline.sap -a -c for

ce -p initVRP_disk_offline.sap -sd

SXPG_COMMAND_EXECUTE failed for BRBACKUP - Reason: x_error

Job cancelled after system exception ERROR_MESSAGE

Now it gave me another log:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000003, user ID AIVASHKIN)

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

Execute logical command BRBACKUP On host oraerp-prd

Parameters:-u / -jid ALGOF20080518161723 -c force -t offline_force -m all -p initVRP_disk_offline.sap -a -c for

ce -p initVRP_disk_offline.sap -sd

Job finished

I can't understand what's happening?!