Backup on remote host?!

[Former Member]

Hi all,

i have discovered this Helpful Forum few days ago' and i started reading @ all your experiences to have a "Hint" on a situation on our My SAP ERP ECC 5.0 that is driving me crazy!!!

- I cannot start a Backup on a Remote Host, it doesn't work!

The Remote host is a Sun Machine in a Microsoft Domain where i have a Folder yet mapped on my SAP Server as <b>Z:\backup_sap</b>

I used both UNC both mapped network drive to edit the file and tell to SAP where to save data but it doesn't run!

What could i do?

Please help me if you can...

Thanks

Gianni

- I edited the "initSID.txt" file as follow:

-

---

1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

2. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>)]

4. default: all

<b>backup_mode = all</b>

1. restore mode [all | all_data | full | incr | incr_only | incr_full

2. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>)]

4. redirection with '=' is not supported here - use option '-m' instead

5. default: all

restore_mode = all

1. backup type [offline | offline_force | offline_standby | offline_split

2. | offline_mirror | offline_stop | online | online_cons | online_split

3. | online_mirror

4. default: offline

<b>backup_type = online</b>

1. backup device type

2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

5. | rman_prep]

6. default: tape

<b>backup_dev_type = disk</b>

1. backup root directory [<path_name> | (<path_name_list>)]

2. default: %SAPDATA_HOME%\sapbackup

<b>backup_root_dir = Z:\backup_sap</b>

1. stage root directory [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

stage_root_dir = F:\oracle\SLM\sapbackup

1. compression flag [yes | no | hardware | only]

2. default: no

compress = no

1. compress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <target_file_name> = <source_file_name>.Z

5. for compress command the -c option must be set

6. recommended setting for brbackup -k only run:

7. "%SAPEXE%\mkszip -l 0 -c $ > $"

8. no default

compress_cmd = "D:\usr\sap\SLM\SYS\exe\run\mkszip -c $ > $"

1. uncompress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <source_file_name> = <target_file_name>.Z

5. for uncompress command the -c option must be set

6. no default

uncompress_cmd = "D:\usr\sap\SLM\SYS\exe\run\uncompress -c $ > $"

1. directory for compression [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

compress_dir = F:\oracle\SLM\sapreorg

1. brarchive function [save | second_copy | double_save | save_delete

2. | second_copy_delete | double_save_delete | copy_save

3. | copy_delete_save | delete_saved | delete_copied]

4. default: save

<b>archive_function = save_delete</b>

1. directory for archive log copies to disk

2. default: first value of the backup_root_dir parameter

<b>archive_copy_dir = Z:\backup_sap</b>

1. directory for archive log copies to stage

2. default: first value of the stage_root_dir parameter

archive_stage_dir = F:\oracle\SLM\sapbackup

1. new sapdata home directory for disk_copy | disk_standby

2. no default

3. new_db_home = X:\oracle\C11

4. stage sapdata home directory for stage_copy | stage_standby

5. default: value of the new_db_home parameter

6. stage_db_home = /oracle/C11

7. original sapdata home directory for split mirror disk backup

8. no default

9. orig_db_home = /oracle/C11

10. remote host name

11. no default

<b>remote_host =
srvweb\backup_sap</b>

1. remote user name

2. default: current operating system user

<b>remote_user = admints\serv_bcksap</b>

-

---

[Former Member · Accepted solution]

What are the errors that you receive? Can you please state the command that you use to start the backup ( DB13, or brbackup etc.) and paste relevant part of the backup logs? They should be in /oracle/<SID>/sapbackup directory. As a last option, try changing the backup directory to a local temp folder and run a brarchive -s and see if that works.

Maybe sapdba wants the backup disk to be local and not on the network. Just guessing ....

Thanks, Sanket

[Former Member · Accepted solution]

Hello Sanket and thank you for your Reply!

I try to give answears to youur questions, ok?

- No exactly Error, IF i schedule a backup on Remote host using the Modifieds "initSID.sap as you read before, it just doesn't start, it stops after few seconds. some parameter is incorrect i think, but wich one?

- I schedule with DB13, usually and i cannot paste you an Incorrect backup log, it doesn't write anything at all!

Otherwise IF i schedule the backup on the local Disk it works Correctly and save data in "oracle/SID/sapbackup" as SAP wish to do; if you want i can attach or paste some of THIS one but i don't think it's helpful for you, actually.

- I will try to run "brarchive -s" and i will tell you, ok?

- I tried to map the network drive as Z:\ on mySAP ERP Server and insert this name in "initSID.sap" but it was the same...

Could you explain me better what do you mean?

Thanks again!

Gianni R.

[Former Member · Accepted solution]

how about permission of the directory. try to create a file as <sid>adm and/or ora<sid>(if applicable) in z: directory from sapserver.

[Former Member · Accepted solution]

@Paul:

Permission are OK, i often copy Archive logs or Backup File manually from Sapbackup / oraarch to
srvfile\etc...

Thank you.

[Former Member · Accepted solution]

Gianni.

I'm sorry to get back to you so late but which user did you test?

on unix environment, there are 2 users <sid>adm and ora<sid> SAP will make backup under one of the user ID depend on basis admin's ability. (btw, it supposed to be ora<sid>.)

on windows, 2 users are <sid>adm and Service<sid> I believe.. But not sure which one creates the backup. so you must test both.

hope it helps.

[Former Member · Accepted solution]

Yes Paul,

you are in Right with the users and i was using "SIDadm" on my Windows Box.

At the moment, i am busy on other activities and i cannot continue trying to run a backup on this Sap Server but i hope to have news as soon as possible.

Thanks to all.

GianniR.

[Former Member]

Hi Gianni,

I'm assuming that you are starting the backup on an NT machine and that Z:\backup_sap is a smb share from the sun machine. Am i correct?

Kind regards,

Alexander

[Former Member]

Hello Alexander,

and Yes, it should be Correct, i think that SMB protocol is active, because i can move with "SIDadm" varius files from the ERP Server to the File Server where i would save the Backup.

Do you need other informations?

Thanks in advance.

GianniR.

[Former Member]

Hi Gianni,

Try changing the env variable SAPBACKUP to Z:\backup_sap.

Then change backup_root_dir to %SAPBACKUP% and restart the backup

Alex

[Former Member]

Yes Alexander,

i think you are in right..but WHERE to change this ENV variable?

In Oracle? and where?

Or maybe you mean in SAP profile? and wich?

Anyway i think it's the correct Hint, i feel it!

Please help me more.

Thank you

GianniR.

[Former Member]

Sorry Gianni,

I meant the Windows environment variable on the host where you are doing your backups.

Hope this helps

Alex

[Former Member]

Yes Alex,

i entered the ENV Variable into Win2003Srv but nothing happen or better...

..it seems i have got another problem to solve!

Plese reade the log:

***

Esecuzione comando logico BRBACKUP Nel calcolatore srvsap01

Parametro: -u / -c force -t online -p initSLM.sap -m SYSTEM

BR0051I BRBACKUP 6.40 (15)

BR0055I Start of database backup: bdqkzvqg.pnd 2005-07-20 17.25.22

BR0477I Oracle pfile D:\ORACLE\SLM\920\database\initSLM.ora created from spfile D:\ORACLE\SLM\920\database\spfileSLM.ora

<b>BR0602E No valid SAP license found - please contact SAP</b>

BR0056I End of database backup: bdqkzvqg.pnd 2005-07-20 17.25.25

BR0280I BRBACKUP time stamp: 2005-07-20 17.25.25

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job terminato

****

Always Better...

[Former Member]

Hi Gianni,

No valid SAP license found means, that you need to apply for a license from SAP for the system. I presume you installed it recently. Once you have the license info, you need to install the license on this system.

I am pasting a link from SAP's online documentation about the command brbackup ...

http://help.sap.com/saphelp_erp2004/helpdata/en/c7/c90e6b7cfd44309bd90b2b7a8a89fd/frameset.htm

It clearly states - disk : Local disk

Based on that it appears the disk should be local. But no harm trying the network drive anyways.

1) Just use the utility sapdba and use the options to start your backup. In there specify that the device is disk, and the path is z:\backup etc.

This will eliminate any syntax errors on your part in running brbackup directly. SAPDBA will call brbackup to do the job once it has the required info.

2) What user do your SAP services defined on Windows, use for authentication? If you are using a local user, that may also be the problem.

You need to use a domain user for all SAP and maybe some Oracle services. Then stop and start SAP and the relevant services completely. Also the network file share should be part of the same domain or some other trust relationship must be established. If you restart your SAP server, login using the domain user that you used for the SAP services, you should be able to map to that network folder WITHOUT having to enter any passwords. If that does not work, the backup will not work either.

If you are not familiar with Windows, please enlist the help of a Windows Administrator to help you with these.

After all is said and done, the backup still may not work because the definition says local disk. But it is worth a shot.

Regards.... Sanket

[Former Member]

Hi Sanket

Local disk means that the disk needs to be accesible local.

If you're disk/directory is mounted/mapped on the server, this is considered a local disk.

What you said about the users right got me thinking.

Gianni, when you tried to move files manually which user did you use. Your SAPService<sid> user and <SID>adm should have the appropriate access to the disk.

Regards,

Alexander

[Former Member]

Hello Sanket,

thank you for your Helpful suggestions, i think you centered the Target about my question on Remote Backup.

I just have a quick read at your linked page but as soon as possible i will work on it.

I would like to tell you that SAPDBA is not more present in SAP WAS 6.40, how a pity!

About the User i dunno so much beacuse it was created by a System Administrator in my Company but i think it has Administrator's privilege on the share, i can check it better, anyway.

Maybe you are in right when you say to use a SAP User ("SIDadm" ?) to map the network drive, i think it's a great idea, it should work without any password request IF on the remote share the same User is Defined and it has administrative privileges.

More,

i agree with you about the help of a System Administrator, i will try to invite someone to help me.

Anyway, i will license my product and then i will try to start a remote backup again, you will be informed reading this topic,ok?

I am thinking to buy 1 S-DLT for Backup and a DAT for archive logs!

Thank you Sanket and thank you All in this Topic!

Bye

GianniR.

[Former Member]

Yes Alexander,

i checked and i think the problem is the user; i use "SIDadm" to move files BUT this user is not a domain user in my opinion such as "SapserviceSID".

I must go deeper into this situation...

[Former Member]

It's quite old but i've noticed the same on ECC 6.0

Solution:

add full access on remote drive to SAPServiceSID and use full UNC path

server\folder

mapping drive letter will not work.

[Former Member]

If you have mapped the folder on your SAP Server, you don't need to mention on the initSID.sap the remote server because this part is solved by your folder mapped.

You only must to define right path to put the files on disk and that's all (I mean).

Regards

[Former Member]

And Roman,

yes i think you are in Right BUT the Question is:

- Wich one is the right path to put files on (remote) disk? and WHERE i can tell to SAP System where to save these files IF i cannot use "initSID.sap" ???

Can you help me anymore?

Many thaks

[Former Member]

Ok so i will try again using your helpful suggestions, in the meanwhile if some other have a brilliant idea....

See you soon.

G.R.

[Former Member]

I tried to run a backup just now from db13 ad this is the Job Log:

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

Job lanciato

Step 001 lanciato (programma RSDBAJOB, variante &0000000000030, nome utente

Esecuzione comando logico BRBACKUP Nel calcolatore srvsap01

Parametro: -u / -c force -t online -p initSLM.sap -m SYSTEM

BR0051I BRBACKUP 6.40 (15)

BR0282E <b>Directory Z:\backup_sap not found </b>

BR0182E <b>Checking parameter/option 'backup_root_dir' failed </b> BR0056I End of database backup: bdqkymey.log 2005-07-20 10.46.08

BR0280I BRBACKUP time stamp: 2005-07-20 10.46.09

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job terminato

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

Ok some part of tis Log in in Italian language but the relevant is almost comprehensive, i hope.

Other suggestions?

[Former Member]

Try to comment out the remote_host and remote_user variables you have defined. Those are used for something else.

[Former Member]

Yes Norm,

i did and i doesn't work, anyway i will try it again.

Thank you.