on 10-23-2007 4:53 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.