BRBACKUP with online_split with stage_copy_cmd = ftp

[former_member117942]

Hi,

we want to implement brbackup with split using stage_copy_cmd ftp since for new windows installation rcp command is no longer available (see note oss Note 1647272 - Minor functional enhancements in BR*Tools (4)) .

So we have installed IIS (ftp server) on backup server but when we execute brbackup we have this error:

################################################################################################

BR0051I BRBACKUP 7.20 (22)
BR0055I Start of database backup: beiprnut.anf 2012-05-24 18.27.51
BR0484I BRBACKUP log file: F:\oracle\PRD\sapbackup\beiprnut.anf

BR0351I Restoring F:\oracle\PRD\sapbackup\CNTRLPRD.DBF
BR0355I from SAP2R3P:F:\oracle\PRD\sapbackup\CNTRLPRD.DBF ...
BR0278E Command output of 'C:\WINDOWS\SapCluster\sapftp.exe -v -n -i SAP2R3P -u F:\oracle\PRD\sapbackup\.beiprnut.ftp -b -c get F:\oracle\PRD\sapbackup\CNTRLPRD.DBF F:\oracle\PRD\sapbackup\CNTRLPRD.DBF':
Connected to SAP2R3P Port 21.
220-Microsoft FTP Service

220 Welcome to SAP2R3P FTP SITE

331 Password required for SSV-IT\prdadm.

230 User SSV-IT\prdadm logged in.

200 Type set to I.

227 Entering Passive Mode (10,39,10,202,21,124).

Passive mode: Connected to Port 5500.
550 F:\oracle\PRD\sapbackup\CNTRLPRD.DBF: The filename, directory name, or volume label syntax is incorrect.
221 
inifilename = C:\WINDOWS\SapCluster\sapftp.ini
open Success
InputLine = passive_mode=on

Argument = passive_mode
Variant = on
Passive = 1
BR0280I BRBACKUP time stamp: 2012-05-24 18.27.54
BR0279E Return code from 'C:\WINDOWS\SapCluster\sapftp.exe -v -n -i SAP2R3P -u F:\oracle\PRD\sapbackup\.beiprnut.ftp -b -c get F:\oracle\PRD\sapbackup\CNTRLPRD.DBF F:\oracle\PRD\sapbackup\CNTRLPRD.DBF': 0
BR0359E Restore of F:\oracle\PRD\sapbackup\CNTRLPRD.DBF from F:\oracle\PRD\sapbackup\CNTRLPRD.DBF failed due to previous errors
BR0314E Collection of information on database files failed

BR0056I End of database backup: beiprnut.anf 2012-05-24 18.27.54
BR0280I BRBACKUP time stamp: 2012-05-24 18.27.54
BR0054I BRBACKUP terminated with errors

####################################################################################################################

In the backup server  this file "F:\oracle\PRD\sapbackup\CNTRLPRD.DBF" exist; file with command options "F:\oracle\PRD\sapbackup\.beiprnut.ftp" created in the backup server was deleted immediately after error and I cannot see the content of this file.

If in the initSID.sap file we set stage_copy_cmd = wcp, brbackup always use sapftp.exe command.

For a test I've also used in the backup server the last version of SAPFTP but with the same error.

Is Microsoft FTP Server usable with sapftp ?

How can I increase trace level of SAPFTP and what is the content of the file F:\oracle\PRD\sapbackup\.beiprnut.ftp ?

Thanks

  Maurizio Manera

[david_liu1]

Hello,

Try execute the command manually using sapftp, does it work?

'c:\windows\SapCluster\sapftp.exe -v -n -i SAP2R3P -u F:\oracle\PRD\sapbackup\.bdzfakrb.ftp -b
-c get F:\oracle\PRD\sapbackup\CNTRLPRD.DBF
D:\oracle\PRD\sapbackup\CNTRLPRD.DBF':

Please follow this note 156704.
If you want to use ftp (sapftp), notice the following:
* Set the init<SID>.sap parameter:
stage_copy_cmd = ftp
* Set the init<SID>.sap parameter:
remote_user = "<user> <password>"
You can omit the <password> here if the remote user has the same password as the database user who started BRBACKUP.

Hope this works.

Regards,

David

[former_member117942]

Hi,

as described in my message file .\xxxxxx.ftp was deleted immediately after sapftp return an error; so I can't test this command.

For a test I've created a file user.ftp with user and password and when I try to execute the command the output is this:

########

FILE user.ftp 

########

SSV-IT\prdadm prdadmin

COMMAND:

C:\script>C:\WINDOWS\SapCluster\sapftp.exe -v -n -i SAP2R3P -u F:\oracle\PRD\sapbackup\user.ftp -b -c get F:\oracle\PRD\sapbackup\CNTRLPRD.D
BF F:\oracle\PRD\sapbackup\CNTRLPRD.DBF
inifilename = C:\WINDOWS\SapCluster\sapftp.ini
open Success
InputLine = passive_mode=on

Argument = passive_mode
Variant = on
Passive = 1
Connected to SAP2R3P Port 21.
220-Microsoft FTP Service
220 Welcome to SAP2R3P FTP SITE
?Invalid command

Do you know what is the content of the file .xxxxxx.ftp ?

Thanks.

Maurizio

[former_member117942]

I've added this other information of FTP server log:

############################

#Software: Microsoft Internet Information Services 6.0

#Version: 1.0

#Date: 2012-05-25 07:39:39

#Fields: date time c-ip cs-username s-sitename s-computername s-ip s-port cs-method cs-uri-stem cs-uri-query sc-status sc-win32-status sc-bytes cs-bytes time-taken cs-version cs-host cs(User-Agent) cs(Cookie) cs(Referer)

2012-05-25 07:39:39 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [1]USER SSV-IT\prdadm - 331 0 0 0 0 FTP - - - -

2012-05-25 07:39:39 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [1]PASS - - 230 0 0 0 0 FTP - - - -

2012-05-25 07:39:39 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [1]DELE F:\oracle\PRD\sapbackup\CNTRLPRD.DBF - 550 123 0 0 0 FTP - - - -

2012-05-25 07:39:39 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [1]QUIT - - 550 0 0 0 0 FTP - - - -

2012-05-25 07:39:41 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [2]USER SSV-IT\prdadm - 331 0 0 0 0 FTP - - - -

2012-05-25 07:39:41 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [2]PASS - - 230 0 0 0 0 FTP - - - -

2012-05-25 07:39:41 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [2]sent /F:/oracle/PRD/sapbackup/CNTRLPRD.DBF - 550 123 0 0 0 FTP - - - -

2012-05-25 07:39:41 10.39.10.203 SSV-IT\prdadm MSFTPSVC1 SAP2R3P 10.39.10.202 21 [2]QUIT - - 550 0 0 0 0 FTP - - - -

###############################

As you can see in the log of FTP Server it seems there is a "/" before the path F:/oracle/PRD/sapbackup   and it seems it use a UNIX format ("/" instead of "\").

Any idea to solve this issue ?

Thanks.

  Maurizio