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 />