Skip to Content

BRBACKUP with online_split with stage_copy_cmd = ftp

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 25, 2012 at 01:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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