on 01-07-2009 9:01 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.