db13 backup on a remote backup device

[Former Member]

Hi all,

Can you please let me know, is it possible to take backup through DB13 on a remote backup device. I have an backup device which is attached to my production server. I want to take backup of my development server through DB13, is it possible that without shifting the backup device I can still take backup of my development server through DB13.

Your inputs will be of great help..

Thanking you

Best regards

Dilip

[Former Member]

Hi Dilip,

You can achieve this from DB13. All you need to change is the init<sid>.sap parameter as per your requirement.

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

backup_dev_type = stage

we set it to stage to backup to a stage area on a remote disk. you need to provide authentication to be able to backup to that device in the parameter file.

Hope this help.

Cheers,

Nisch

[Former Member]

Hi

It is possible to achieve two SAP BAckups on a single device.

Use the Dynamic Multi Pathing for Veritas backup utility and try to achieve the same.

Device must be available on both of the machines. But you have to maintain the different names and use the device.

But the issue is at a time the prioritised backup will only run and administration task would be more.

Please check this doumentation

http://www-03.ibm.com/systems/storage/disk/ess/pdf/sun-sap.pdf

[Former Member]

Dear,

Thanks for your reply.

I am not using any 3rd party tool for taking SAP Backup. Backup is only taken through DB13 and OS level backup. Is it not possible to take remote backup without 3rd party tool.

Regards

Dilip

[Former Member]

Hello,

set thease parameters in init<SID>.sap file

backup_dev_type = pipe

remote_host = <remote host name>

remote_user = root

[Former Member]

Hi,

Thanks for your reply. I made the necessary changes in initSID.sap file and tried to initilize the tape through DB13, I got an error ...

Job started

Step 001 started (program RSDBAJOB, variant &0000000000150, user ID XXXXX)

Execute logical command BRBACKUP On host XXXXX

Parameters: -u / -i force -c force -n 1 -v SCRATCH

BR051I BRBACKUP 6.20 (100)

BR181E Option '-i' not supported for 'stage'

BR169I Value 'rcp' of parameter/option 'stage_copy_cmd' ignored for 'compress/-k yes' - 'ftp' assumed

BR206I End of backup volume initialization

BR280I Time stamp 2008-06-22 15.17.36

BR054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished...

Can you please let me know, are there any additional settings to be done, like at the OS level. Does the device needs to be shared or access from OS? What should be the output of the cmd "# ioscan -fnC tape".

Thanks

Best Regards

Dilip