cancel
Showing results for 
Search instead for 
Did you mean: 

Backup to FTP Fails after connection has established

Former Member
0 Kudos

Hi Experts,<br />

<br />

I am having quite a problem managing to make a backup to FTP.<br />

We are using SolMan 7.01 Unicode on Windows Server 2008 x64 with Oracle 10.2.0.4.0<br />

<br />

When doing a full Offline + redo log Backup i get the following error message.<br />

<h3>Detail log</h3>

<font face="Courier New, Courier, monospace">BR0051I BRBACKUP 7.00 (49)<br />

BR0055I Start of database backup: beexmikb.ffs 2011-01-01 22.00.37<br />

BR0484I BRBACKUP log file: D:\oracle\SM1\sapbackup\beexmikb.ffs<br />

BR0477I Oracle pfile D:\oracle\SM1\102\database\initSM1.ora created from spfile D:\oracle\SM1\102\database\spfileSM1.ora<br />

<br />

BR0101I Parameters<br />

<br />

Name Value<br />

<br />

oracle_sid SM1<br />

oracle_home D:\oracle\SM1\102<br />

oracle_profile D:\oracle\SM1\102\database\initSM1.ora<br />

sapdata_home D:\oracle\SM1<br />

sap_profile D:\oracle\SM1\102\database\initSM1ftp.sap<br />

backup_mode FULL<br />

backup_type offline_force<br />

backup_dev_type stage<br />

stage_root_dir /mnt/array1/SAP/SM1<br />

compress no<br />

stage_copy_cmd ftp<br />

remote_host BACKUP-02<br />

remote_user backup_sap<br />

exec_parallel 0<br />

system_info SAPServiceSM1 PERCIVAL Windows 6.0 Build 6002 Service Pack 2 AMD64<br />

oracle_info SM1 10.2.0.4.0 8192 1270 18227389 PERCIVAL UTF8 UTF8<br />

sap_info 701 SAPSR3 0002LK0003SM10011P09271385650015Maintenance_ORA<br />

make_info NTAMD64 OCI_10201_SHARE Sep 23 2010<br />

command_line brbackup -u / -jid FLGOF20101211220000 -c force -t offline_force -m full -p initSM1ftp.sap -a -c force -p initSM1ftp.sap -sd<br />

<br />

BR0116I ARCHIVE LOG LIST before backup for database instance SM1<br />

<br />

Parameter Value<br />

<br />

Database log mode Archive Mode<br />

Automatic archival Enabled<br />

Archive destination D:\oracle\SM1\oraarch\SM1arch<br />

Archive format ARC%S_%R.%T<br />

Oldest online log sequence 1267<br />

Next log sequence to archive 1270<br />

Current log sequence 1270 SCN: 18227389<br />

Database block size 8192 Thread: 1<br />

Current system change number 18231179 ResetId: 733061021<br />

<br />

BR0118I Tablespaces and data files<br />

<br />

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize<br />

<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_10\SR3.DATA10 1426071552 13 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_1\SR3.DATA1 2894077952 4 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_2\SR3.DATA2 2789220352 5 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_3\SR3.DATA3 2894077952 6 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_4\SR3.DATA4 2915049472 7 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_5\SR3.DATA5 2956992512 8 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_6\SR3.DATA6 2915049472 9 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_7\SR3.DATA7 2894077952 10 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_8\SR3.DATA8 6794780672 11 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA2\SR3_9\SR3.DATA9 3376422912 12 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3701 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA3\SR3701_1\SR3701.DATA1 3250593792 14 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3701 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA3\SR3701_2\SR3701.DATA2 4194312192 15 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3701 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA3\SR3701_3\SR3701.DATA3 3900710912 16 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3701 ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA3\SR3701_4\SR3701.DATA4 5756690432 17 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 19 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 20 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 21 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPSR3USR ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA4\SR3USR_1\SR3USR.DATA1 20979712 18 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPTEMP ONLINE# ONLINE+ D:\ORACLE\SM1\SAPDATA1\TEMP_1\TEMP.DATA1 1038098432 -1 3 NOLINK FILE 10485760000 20971520 8192<br />

PSAPUNDO ONLINE- ONLINE+ D:\ORACLE\SM1\SAPDATA1\UNDO_1\UNDO.DATA1 3061850112 2 3 NOLINK FILE 10485760000 20971520 8192<br />

SYSAUX ONLINE* ONLINE+ D:\ORACLE\SM1\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 209723392 3 3 NOLINK FILE 10485760000 20971520 8192<br />

SYSTEM ONLINE* SYSTEM+ D:\ORACLE\SM1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 513810432 1 3 NOLINK FILE 10485760000 20971520 8192<br />

<br />

BR0119I Redo log files<br />

<br />

File Size Group Device Status Link Type<br />

<br />

D:\ORACLE\SM1\ORIGLOGA\LOG_G11M1.DBF 52429312 1 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\MIRRLOGA\LOG_G11M2.DBF 52429312 1 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\ORIGLOGB\LOG_G12M1.DBF 52429312 2 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\MIRRLOGB\LOG_G12M2.DBF 52429312 2 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\ORIGLOGA\LOG_G13M1.DBF 52429312 3 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\MIRRLOGA\LOG_G13M2.DBF 52429312 3 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\ORIGLOGB\LOG_G14M1.DBF 52429312 4 3 INUSE NOLINK FILE<br />

D:\ORACLE\SM1\MIRRLOGB\LOG_G14M2.DBF 52429312 4 3 INUSE NOLINK FILE<br />

<br />

BR0120I Control files<br />

<br />

File Size Id. Device Link Type<br />

<br />

D:\oracle\SM1\origlogA\cntrl\cntrlSM1.dbf 12664832 0 3 NOLINK FILE<br />

D:\oracle\SM1\origlogB\cntrl\cntrlSM1.dbf 12664832 0 3 NOLINK FILE<br />

D:\oracle\SM1\sapdata1\cntrl\cntrlSM1.dbf 12664832 0 3 NOLINK FILE<br />

<br />

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3: <br />

PSAPSR3, PSAPSR3701, PSAPSR3USR<br />

BR0280I BRBACKUP time stamp: 2011-01-01 22.00.39<br />

BR0057I Backup of database: SM1<br />

BR0058I BRBACKUP action ID: beexmikb<br />

BR0059I BRBACKUP function ID: ffs<br />

BR0110I Backup mode: FULL<br />

BR0077I Database files for backup: <br />

D:\ORACLE\SM1\ORIGLOGA\LOG_G11M1.DBF<br />

D:\ORACLE\SM1\ORIGLOGB\LOG_G12M1.DBF<br />

D:\ORACLE\SM1\ORIGLOGA\LOG_G13M1.DBF<br />

D:\ORACLE\SM1\ORIGLOGB\LOG_G14M1.DBF<br />

D:\oracle\SM1\origlogA\cntrl\cntrlSM1.dbf<br />

BR0061I 27 files found for backup, total size 56522.252 MB<br />

BR0143I Backup type: offline_force<br />

BR0112I Files will not be compressed<br />

BR0130I Backup device type: stage<br />

BR0106I Files will be saved on disk in directory: BACKUP-02:/mnt/array1/SAP/SM1/beexmikb<br />

BR0289I BRARCHIVE will be started at the end of processing<br />

BR0134I Unattended mode with 'force' active - no operator confirmation allowed<br />

BR0370I Directory BACKUP-02:/mnt/array1/SAP/SM1/beexmikb created<br />

BR0370I Directory /mnt/array1/SAP/SM1/SM1 created<br />

BR0202I Saving init_ora<br />

BR0203I to /mnt/array1/SAP/SM1/SM1 ...<br />

<font color="#FF0000">BR0278E Command output of 'D:\usr\sap\SM1\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i BACKUP-02 -u D:\oracle\SM1\sapbackup\.beexmikb.ftp -a -c put D:\oracle\SM1\102\database\initSM1.ora /mnt/array1/SAP/SM1/SM1/initSM1.ora -c bin -c put D:\oracle\SM1\102\database\spfileSM1.ora /mnt/array1/SAP/SM1/SM1/spfileSM1.ora':</font><br />

Connected to BACKUP-02 Port 21.<br />

220 <ip address> FTP server ready<br />

331 Password required for backup_sap<br />

230 User backup_sap logged in<br />

200 Type set to A<br />

200 PORT command successful<br />

425 Unable to build data connection: Connection timed out<br />

200 Type set to I<br />

200 PORT command successful<br />

425 Unable to build data connection: Connection timed out<br />

221 Goodbye.<br />

BR0280I BRBACKUP time stamp: 2011-01-01 22.08.14<br />

<font color="#FF0000">BR0279E Return code from 'D:\usr\sap\SM1\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i BACKUP-02 -u D:\oracle\SM1\sapbackup\.beexmikb.ftp -a -c put D:\oracle\SM1\102\database\initSM1.ora /mnt/array1/SAP/SM1/SM1/initSM1.ora -c bin -c put D:\oracle\SM1\102\database\spfileSM1.ora /mnt/array1/SAP/SM1/SM1/spfileSM1.ora': 0<br />

BR0222E Copying init_ora to/from /mnt/array1/SAP/SM1/SM1 failed due to previous errors</font><br />

BR0056I End of database backup: beexmikb.ffs 2011-01-01 22.08.14<br />

BR0280I BRBACKUP time stamp: 2011-01-01 22.08.14<br />

BR0054I BRBACKUP terminated with errors<br />

BR0280I BRBACKUP time stamp: 2011-01-01 22.08.14<br />

BR0291I BRARCHIVE will be started with options '-U -jid FLGOF20101211220000 -c force -p initSM1ftp.sap -sd'<br />

BR0280I BRBACKUP time stamp: 2011-01-01 22.15.55<br /></font>

<br />

<br />

<br />

The Connection is correct, the user and Password are right and initSM1.sap configuration looks correct to me.<br />

<h3>initSM1.sap</h3>

<font face="Courier New, Courier, monospace">backup_dev_type = stage<br />

backup_root_dir = "/mnt/array1/SAP/SM1"<br />

stage_root_dir = "/mnt/array1/SAP/SM1"<br />

archive_function = save_delete<br />

archive_stage_dir = "/mnt/array1/SAP/SM1"<br />

remote_host = "remote name"<br />

remote_user = "user password"<br />

stage_copy_cmd = ftp<br /></font>

<br />

The strange thing about all this is, that the very first time i tried my configuration it worked.<br />

<br />

Could you please help me out on this problem?<br />

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I have found the solution for my problem.

Note 831058

You have to change the FTP transfer to passive mode when you have a firewall between you SAP System and the FTP Server.

The other thing you can do is to allow all connections from your FTP server if you have an IP Adress.

Greatings,

Niklas