cancel
Showing results for 
Search instead for 
Did you mean: 

BRBACKUP: Return code 0005 Error during processing

Former Member
0 Kudos

Hello!

I have problem to execute one successful online backup from DB13.

During the job some first files will be bakuped, but the job terminates after a while.

Additionaly I included the BRBACKUP Actio Log:

-


Detail log: bdwkuudu.ans

-


BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdwkuudu.ans 2007-10-22 19.01.38

BR0477I Oracle pfile C:\oracle\SSM\102\database\initDEV.ora created from spfile C:\oracle\SSM\102\database\spfileDEV.ora

BR0280I BRBACKUP time stamp: 2007-10-22 19.01.42

BR0319I Control file copy created: H:\oracle\DEV\sapbackup\CNTRLDEV.DBF 13058048

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home C:\oracle\SSM\102

oracle_profile C:\oracle\SSM\102\database\initDEV.ora

sapdata_home H:\oracle\DEV

sap_profile C:\oracle\SSM\102\database\initDEV.sap

backup_mode ALL

backup_type online

backup_dev_type stage

stage_root_dir /sap/DEVB

compress no

stage_copy_cmd ftp

remote_host 192.168.200.3

remote_user sapbackup

exec_parallel 0

system_info SAPServiceDEV SAPDEV Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info DEV 10.2.0.1.0 8192 1618 17244956 SAPDEV UTF8 UTF8

sap_info 700 SAPSR3

make_info NTAMD64 OCI_10201_SHARE Oct 26 2006

command_line brbackup -u / -jid ALL__20071022190131 -c force -t online -m all -p initDEV.sap

BR0116I ARCHIVE LOG LIST before backup for database instance DEV

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination H:\oracle\DEV\oraarch\DEVarch

Archive format ARC%S_%R.%T

Oldest online log sequence 1615

Next log sequence to archive 1618

Current log sequence 1618 SCN: 17244956

Database block size 8192 Thread: 1

Current system change number 17262465 ResetId: 627659303

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3_3\SR3.DATA3 2097160192 6 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3_4\SR3.DATA4 2097160192 7 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3_5\SR3.DATA5 2097160192 8 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3_10\SR3.DATA10 2097160192 13 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3_11\SR3.DATA11 2097160192 14 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3_12\SR3.DATA12 2097160192 15 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3_13\SR3.DATA13 2097160192 16 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3_14\SR3.DATA14 2097160192 17 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3_15\SR3.DATA15 2097160192 18 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3_16\SR3.DATA16 2097160192 19 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3_17\SR3.DATA17 2097160192 20 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3_18\SR3.DATA18 2097160192 21 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3_19\SR3.DATA19 2097160192 22 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3_20\SR3.DATA20 2097160192 23 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3700_1\SR3700.DATA1 3082821632 24 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3700_2\SR3700.DATA2 3082821632 25 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3700_3\SR3700.DATA3 3145736192 26 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3700_4\SR3700.DATA4 3082821632 27 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3700_5\SR3700.DATA5 3040878592 28 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3700_6\SR3700.DATA6 2915049472 29 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3700_7\SR3700.DATA7 2894077952 30 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA2\SR3700_8\SR3700.DATA8 2894077952 31 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3700_10\SR3700.DATA10 3061850112 33 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3700_11\SR3700.DATA11 3040878592 34 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3700_12\SR3700.DATA12 3082821632 35 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA3\SR3700_9\SR3700.DATA9 3040878592 32 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3700_13\SR3700.DATA13 3019907072 36 4 NOLINK FILE 1048縶760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3700_14\SR3700.DATA14 3124764672 37 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3700_15\SR3700.DATA15 3124764672 38 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3700_16\SR3700.DATA16 3103793152 39 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 4 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ E:\ORACLE\DEV\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 4 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ E:\ORACLE\DEV\SAPDATA3\UNDO_1\UNDO.DATA1 5788147712 2 4 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 272637952 3 4 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ E:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 838868992 1 4 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

H:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF 52429312 1 7 INUSE NOLINK FILE

H:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF 52429312 1 7 INUSE NOLINK FILE

H:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF 52429312 2 7 INUSE NOLINK FILE

H:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF 52429312 2 7 INUSE NOLINK FILE

H:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF 52429312 3 7 INUSE NOLINK FILE

H:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF 52429312 3 7 INUSE NOLINK FILE

H:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF 52429312 4 7 INUSE NOLINK FILE

H:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF 52429312 4 7 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

H:\oracle\DEV\origlogA\cntrl\cntlrDEV.dbf 13058048 0 7 NOLINK FILE

H:\oracle\DEV\origlogB\cntrl\cntrlDEV.dbf 13058048 0 7 NOLINK FILE

H:\oracle\DEV\sapdata1\cntrl\cntrlDEV.dbf 13058048 0 7 NOLINK FILE

BR0280I BRBACKUP time stamp: 2007-10-22 19.01.44

BR0057I Backup of database: DEV

BR0058I BRBACKUP action ID: bdwkuudu

BR0059I BRBACKUP function ID: ans

BR0110I Backup mode: ALL

BR0077I Database file for backup: H:\oracle\DEV\sapbackup\CNTRLDEV.DBF

BR0061I 41 files found for backup, total size 93092.766 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: stage

BR0106I Files will be saved on disk in directory: 192.168.200.3:/sap/DEVB/bdwkuudu

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0370I Directory 192.168.200.3:/sap/DEVB/bdwkuudu created

BR0202I Saving init_ora

BR0203I to /sap/DEVB/DEV ...

BR0202I Saving C:\oracle\SSM\102\database\initDEV.sap

BR0203I to /sap/DEVB/DEV ...

BR0280I BRBACKUP time stamp: 2007-10-22 19.01.46

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2007-10-22 19.01.49

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0202I Saving E:\ORACLE\DEV\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA1 ...

#FILE..... E:\ORACLE\DEV\SAPDATA1\SR3_1\SR3.DATA1

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA1 #1/1

BR0280I BRBACKUP time stamp: 2007-10-22 20.23.52

BR0063I 1 of 41 files processed - 2000.008 MB of 93092.766 MB done

BR0204I Percentage done: 2.15%, estimated end time: 10:44

BR0001I *_________________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA1\SR3_2\SR3.DATA2縶BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA2 ...

#FILE..... E:\ORACLE\DEV\SAPDATA1\SR3_2\SR3.DATA2

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA2 #1/2

BR0280I BRBACKUP time stamp: 2007-10-22 21.41.45

BR0063I 2 of 41 files processed - 4000.016 MB of 93092.766 MB done

BR0204I Percentage done: 4.30%, estimated end time: 9:05

BR0001I **________________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA1\SR3_3\SR3.DATA3

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA3 ...

#FILE..... E:\ORACLE\DEV\SAPDATA1\SR3_3\SR3.DATA3

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA3 #1/3

BR0280I BRBACKUP time stamp: 2007-10-22 22.53.42

BR0063I 3 of 41 files processed - 6000.023 MB of 93092.766 MB done

BR0204I Percentage done: 6.45%, estimated end time: 7:00

BR0001I ***_______________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA1\SR3_4\SR3.DATA4

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA4 ...

#FILE..... E:\ORACLE\DEV\SAPDATA1\SR3_4\SR3.DATA4

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA4 #1/4

BR0280I BRBACKUP time stamp: 2007-10-22 23.55.32

BR0063I 4 of 41 files processed - 8000.031 MB of 93092.766 MB done

BR0204I Percentage done: 8.59%, estimated end time: 4:00

BR0001I ****______________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA1\SR3_5\SR3.DATA5

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA5 ...

#FILE..... E:\ORACLE\DEV\SAPDATA1\SR3_5\SR3.DATA5

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA5 #1/5

BR0280I BRBACKUP time stamp: 2007-10-23 00.51.41

BR0063I 5 of 41 files processed - 10000.039 MB of 93092.766 MB done

BR0204I Percentage done: 10.74%, estimated end time: 1:19

BR0001I *****_____________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA2\SR3_10\SR3.DATA10

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA10 ...

#FILE..... E:\ORACLE\DEV\SAPDATA2\SR3_10\SR3.DATA10

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA10 #1/6

BR0280I BRBACKUP time stamp: 2007-10-23 01.44.35

BR0063I 6 of 41 files processed - 12000.047 MB of 93092.766 MB done

BR0204I Percentage done: 12.89%, estimated end time: 23:06

BR0001I ******____________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA2\SR3_6\SR3.DATA6

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA6 ...

#FILE..... E:\ORACLE\DEV\SAPDATA2\SR3_6\SR3.DATA6

#SAVED.... /sap/DEVB/bdwkuudu/SR3.DATA6 #1/7

BR0280I BRBACKUP time stamp: 2007-10-23 02.38.05

BR0063I 7 of 41 files processed - 14000.055 MB of 93092.766 MB done

BR0204I Percentage done: 15.04%, estimated end time: 21:36

BR0001I ********__________________________________________

BR0202I Saving E:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7

BR0203I to /sap/DEVB/bdwkuudu/SR3.DATA7 ...

<b>BR0278E Command output of 'F:\usr\sap\DEV\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i 192.168.200.3 -u H:\oracle\DEV\sapbackup\.bdwkuudu.ftp -b -c put E:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7 /sap/DEVB/bdwkuudu/SR3.DATA7':

Connected to 192.168.200.3 Port 21.

220-FTP server ready.

220 This is a private system - No anonymous login

331 User sapbackup OK. Password required

230-User sapbackup has group access to: administrator

230-This server supports FXP transfers

230-OK. Current restricted directory is /

230-************************************************

230-* Use SITE command to change client codepage: *

230-* ie, site codepage [client codepage] *

230 ************************************************

200 TYPE is now 8-bit binary

200 PORT command successful

150 Connecting to port 4977

NiWrite error: -6, bytes to send: 32767 bytes written: 0

BR0280I BRBACKUP time stamp: 2007-10-23 03.08.37

BR0279E Return code from 'F:\usr\sap\DEV\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i 192.168.200.3 -u H:\oracle\DEV\sapbackup\.bdwkuudu.ftp -b -c put E:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7 /sap/DEVB/bdwkuudu/SR3.DATA7': 1

BR0222E Copying E:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7 to/from /sap/DEVB/bdwkuudu/SR3.DATA7 failed due to previous errors</b>

BR0280I BRBACKUP time stamp: 2007-10-23 03.08.43

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0056I End of database backup: bdwkuudu.ans 2007-10-23 03.08.37

BR0280I BRBACKUP time stamp: 2007-10-23 03.08.43

BR0054I BRBACUP terminated with errors

It will be great to get some helpful information regarding this problem.

Thank you very much!

regards

Thom

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member204746
Active Contributor
0 Kudos

this post is duplicated at

please only post your question once and only in 1 forum.

thanks.

Former Member
0 Kudos

Hello Thom,

Do the file "E:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7" fits at destination HDD/FS "192.168.200.3:/sap/DEVB/bdwkuudu"?

Seems that sapftp.exe can't copy the file to the target disk. At this moment there'll be free space, but look for a "full HDD/FS" warning at the system at time the backup was running.

Best Regards,

JC Llanes.

Former Member
0 Kudos

Hi!

Thank you very much for your response.

>look for a "full HDD/FS" warning at the system at time the backup was running

What do you mean with that statement?

What is full HDD/FS?

Please give more technical details (transaction, OS.directory, Log files)

regards

Thom