cancel
Showing results for 
Search instead for 
Did you mean: 

Remote Disk Backup

Former Member
0 Kudos

Hi gurus,

I want to ask some questions again..

I want to backup my SAP database to remote disk.

My server is using:

OS : Windows Server 2003 Enterprise 64bit

DB : Oracle 10.2.0.4

As i've read here: http://help.sap.com/saphelp_nwmobile71/helpdata/en/47/0b9ed8434f57dde10000000a1553f7/content.htm

my only option for windows user is use backup_dev_type = ftp right?

so I have configured all things according to what's in the article above.

i've mapped the disk storage location into drive z: in my SAP Server.

When i execute backup, SAP returns error saying that z: is unknown location.

I use windows ftp server which is in IIS component.

When i see the picture from that article above, it uses SAPFTP.

Do I must use SAPFTP to backup to remote disk?

If so, how could I configure it?

I have tried to open SAPFTP in 'TCP/IP Connections' via tcode 'SM59' and 'Test Connection', which returned something like:

Logon: 569 msec

0 KB: 1 msec

10 KB: 4 msec

20 KB: 5 msec

30 KB: 7 msec

Any help for me?

Thanks very much.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

i've figured it out.

You need not type the full path for stage_root_dir and archive_stage_dir.. just type the directory.

for example:

stage_root_dir = datafiles/

archive_stage_dir = log/

solved

Former Member
0 Kudos

and here's error message when i set:

stage_root_dir =
backup_server_ip\directories

archive_stage_dir =
backup_server_ip\directories

Detail log: adzqrpwv.sve

BR0002I BRARCHIVE 7.00 (32)

BR0006I Start of offline redo log processing: adzqrpwv.sve 2009-01-08 15.21.09

BR0484I BRARCHIVE log file: D:\oracle\DEV\saparch\adzqrpwv.sve

BR0477I Oracle pfile D:\oracle\DEV\102\database\initDEV.ora created from spfile D:\oracle\DEV\102\database\spfileDEV.ora

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home D:\oracle\DEV\102

oracle_profile D:\oracle\DEV\102\database\initDEV.ora

sapdata_home D:\oracle\DEV

sap_profile D:\oracle\DEV\102\database\initDEV_remote.sap

backup_dev_type stage

archive_stage_dir
backupdev\backup_dev

compress no

stage_copy_cmd ftp

remote_host backupDEV

remote_user administrator

system_info SAPServiceDEV SAPDEV Windows 5.2 Build 3790 Service Pack 1 AMD64

oracle_info DEV 10.2.0.2.0 8192 2582 20859434 SAPDEV UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003DEV0011S14735821930013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE Feb 6 2008

command_line brarchive -u / -jid LOG__20090108152107 -c force -p initDEV_remote.sap -s

BR0280I BRARCHIVE time stamp: 2009-01-08 15.21.19

BR0008I Offline redo log processing for database instance: DEV

BR0009I BRARCHIVE action ID: adzqrpwv

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 9 offline redo log files found for processing, total size 388.720 MB

BR0112I Files will not be compressed

BR0130I Backup device type: stage

BR0106I Files will be saved on disk in directory: backupDEV:
backupdev\backup_dev

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0202I Saving init_ora

BR0203I to
backupdev\backup_dev\DEV ...

BR0278E Command output of 'C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i backupDEV -u D:\oracle\DEV\saparch\.adzqrpwv.ftp -a -c put D:\oracle\DEV\102\database\initDEV.ora
backupdev\backup_dev\DEV\initDEV.ora -c bin -c put D:\oracle\DEV\102\datab

Connected to backupDEV Port 21.

220 Microsoft FTP Service

331 Password required for administrator.

230 User administrator logged in.

200 Type set to A.

200 PORT command successful.

550
backupdev\backup_dev\DEV\initDEV.ora: The system cannot find the path specified.

200 Type set to I.

200 PORT command successful.

550
backupdev\backup_dev\DEV\spfileDEV.ora: The system cannot find the path specified.

221

BR0280I BRARCHIVE time stamp: 2009-01-08 15.21.19

BR0279E Return code from 'C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i backupDEV -u D:\oracle\DEV\saparch\.adzqrpwv.ftp -a -c put D:\oracle\DEV\102\database\initDEV.ora
backupdev\backup_dev\DEV\initDEV.ora -c bin -c put D:\oracle\DEV\102\databa

BR0222E Copying init_ora to/from
backupdev\backup_dev\DEV failed due to previous errors

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: adzqrpwv.sve 2009-01-08 15.21.19

BR0280I BRARCHIVE time stamp: 2009-01-08 15.21.19

BR0005I BRARCHIVE terminated with errors

former_member204746
Active Contributor
0 Kudos

file
backupdev\backup_dev\DEV\initDEV.ora does not exist or is not reachable.

are you running this from DB13? if so, make sure that user SAPservice<SID> has full access to
backupdev\backup_dev\DEV

Former Member
0 Kudos

gurus,

i've changed stage_root dir to ftp://folder, and now it's seems more convincing, but another error displayed:

Detail log: adzqrhjw.sve

BR0002I BRARCHIVE 7.00 (32)

BR0006I Start of offline redo log processing: adzqrhjw.sve 2009-01-08 13.45.24

BR0484I BRARCHIVE log file: D:\oracle\DEV\saparch\adzqrhjw.sve

BR0477I Oracle pfile D:\oracle\DEV\102\database\initDEV.ora created from spfile D:\oracle\DEV\102\database\spfileDEV.ora

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home D:\oracle\DEV\102

oracle_profile D:\oracle\DEV\102\database\initDEV.ora

sapdata_home D:\oracle\DEV

sap_profile D:\oracle\DEV\102\database\initDEV_remote.sap

backup_dev_type stage

archive_stage_dir ftp://backupdev

compress no

stage_copy_cmd ftp

remote_host backupDEV

remote_user administrator

system_info SAPServiceDEV SAPDEV Windows 5.2 Build 3790 Service Pack 1 AMD64

oracle_info DEV 10.2.0.2.0 8192 2582 20859434 SAPDEV UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003DEV0011S14735821930013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE Feb 6 2008

command_line brarchive -u / -jid LOG__20090108134524 -c force -p initDEV_remote.sap -s

BR0280I BRARCHIVE time stamp: 2009-01-08 13.45.43

BR0008I Offline redo log processing for database instance: DEV

BR0009I BRARCHIVE action ID: adzqrhjw

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 9 offline redo log files found for processing, total size 388.720 MB

BR0112I Files will not be compressed

BR0130I Backup device type: stage

BR0106I Files will be saved on disk in directory: backupDEV:ftp://backupdev

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0202I Saving init_ora

BR0203I to ftp://backupdev\DEV ...

BR0278E Command output of 'C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i backupDEV -u D:\oracle\DEV\saparch\.adzqrhjw.ftp -a -c put D:\oracle\DEV\102\database\initDEV.ora ftp://backupdev\DEV\initDEV.ora -c bin -c put D:\oracle\DEV\102\database\spf

Connected to backupDEV Port 21.

220 Microsoft FTP Service

331 Password required for administrator.

230 User administrator logged in.

200 Type set to A.

200 PORT command successful.

550 ftp://backupdev\DEV\initDEV.ora: The filename, directory name, or volume label syntax is incorrect.

200 Type set to I.

200 PORT command successful.

550 ftp://backupdev\DEV\spfileDEV.ora: The filename, directory name, or volume label syntax is incorrect.

221

BR0280I BRARCHIVE time stamp: 2009-01-08 13.45.43

BR0279E Return code from 'C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i backupDEV -u D:\oracle\DEV\saparch\.adzqrhjw.ftp -a -c put D:\oracle\DEV\102\database\initDEV.ora ftp://backupdev\DEV\initDEV.ora -c bin -c put D:\oracle\DEV\102\database\spfi

BR0222E Copying init_ora to/from ftp://backupdev\DEV failed due to previous errors

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: adzqrhjw.sve 2009-01-08 13.45.43

BR0280I BRARCHIVE time stamp: 2009-01-08 13.45.43

BR0005I BRARCHIVE terminated with errors

can you tell me what's wrong with it?

Thanks gurus,

0 Kudos

Hello Bobby,

I do not much about sapft but I can see a mistake here:

> i've mapped the disk storage location into drive z: in my SAP Server.

Do not map disk storages. You have to use UNC.

Probably you have mapped the drive Z for the user <sid>adm. But SAP is started as a service by the user SAPService<SID>, and this user cannot see the mapped disks.

Please, change this and try again.

If it does not work, you should paste here the log file (where we can see the parameters you are using and the error)

Regards