brbackup terminated with error: mkszip was interrupted

[Former Member]

Hello everybody,

BRBACKUP terminated with error: mkszip was interrupted when trying to backup to local disk with compression option by

mkszip. (ECC 6.0 SR3 on Windows server 2003, Oracle 10.2.0.2).

The version of my br*tools is 7.00(33).

-

---

>below is the returned info from brbackup commandline.

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.09

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0201I Compressing S:\ORACLE\ZCP\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to E:\sapbackup\onlinebackup_090717_ZCP\bebalglv\SR3.DATA1.Z ...

BR0280I BRBACKUP time stamp: 2009-07-16 19.15.06

BR0266E Program 'S:\usr\sap\ZCP\SYS\exe\uc\NTAMD64\mkszip -c S:\ORACLE\ZCP\SAPDA

TA1\SR3_1\SR3.DATA1 > E:\sapbackup\onlinebackup_090717_ZCP\bebalglv\SR3.DATA1.Z'

interrupted, exit status: c0000094

BR0272E Execution of program 'S:\usr\sap\ZCP\SYS\exe\uc\NTAMD64\mkszip -c S:\ORA

CLE\ZCP\SAPDATA1\SR3_1\SR3.DATA1 > E:\sapbackup\onlinebackup_090717_ZCP\bebalglv

\SR3.DATA1.Z' through pipe failed

BR0224E Compressing S:\ORACLE\ZCP\SAPDATA1\SR3_1\SR3.DATA1 to E:\sapbackup\onlin

ebackup_090717_ZCP\bebalglv\SR3.DATA1.Z failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-07-16 19.15.11

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

-

---

>brbackup log

BR0051I BRBACKUP 7.00 (33)

BR0055I Start of database backup: bebalglv.and 2009-07-16 19.02.59

BR0484I BRBACKUP log file: S:\oracle\ZCP\sapbackup\bebalglv.and

BR0477I Oracle pfile C:\oracle\ZCP\102\database\initZCP.ora created from spfile

C:\oracle\ZCP\102\database\spfileZCP.ora

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.05

BR0319I Control file copy created: S:\oracle\ZCP\sapbackup\CNTRLZCP.DBF 22364160

BR0101I Parameters

Name Value

oracle_sid ZCP

oracle_home C:\oracle\ZCP\102

oracle_profile C:\oracle\ZCP\102\database\initZCP.ora

sapdata_home S:\oracle\ZCP

sap_profile C:\oracle\ZCP\102\database\initZCP.sap

backup_mode ALL

backup_type online_cons

backup_dev_type disk

backup_root_dir E:\sapbackup\onlinebackup_090717_ZCP

compress yes

compress_cmd S:\usr\sap\ZCP\SYS\exe\uc\NTAMD64\mkszip -c $ > $

exec_parallel 0

system_info zcpadm ZECCPRD2 Windows 5.2 Build 3790 Service Pack 2

AMD64

oracle_info ZCP 10.2.0.2.0 8192 29430 182486075 ZECCPRD2 UTF8 UTF8

sap_info 700 SAPSR3

0002LK0003ZCP0011Q11464270120013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE May 5 2008

command_line brbackup -p initZCP.sap -d disk -t online_cons -m

all -k yes -e 0 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance ZCP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination S:\oracle\ZCP\oraarch\ZCParch

Archive format ARC%S_%R.%T

Oldest online log sequence 29423

Next log sequence to archive 29430

Current log sequence 29430 SCN: 182486075

Database block size 8192 Thread: 1

Current system change number 182490547 ResetId: 664984835

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status

File Size Id. Device

Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SR3_1

\SR3.DATA1 8589942784 4 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SR3_2

\SR3.DATA2 6102720512 5 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SR3_3

\SR3.DATA3 8589942784 6 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3_4

\SR3.DATA4 5872033792 7 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3_5

\SR3.DATA5 5913976832 8 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3_6

\SR3.DATA6 8589942784 9 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA3\SR3_7

\SR3.DATA7 5955919872 10 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA3\SR3_8

\SR3.DATA8 5704261632 11 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA3\SR3_9

\SR3.DATA9 8589942784 12 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3_10

\SR3.DATA10 5851062272 13 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3_11

\SR3.DATA11 5830090752 14 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3_12

\SR3.DATA12 8589942784 15 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3_13

\SR3.DATA13 3732938752 27 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SR3700_1

\SR3700.DATA1 10422853632 16 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SR3700_2

\SR3700.DATA2 9038733312 17 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3700_10

\SR3700.DATA10 10486816768 28 18 NOLINK FILE 34358689792

2684354560 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3700_11

\SR3700.DATA11 10486816768 29 18 NOLINK FILE 34358689792

2684354560 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3700_3

\SR3700.DATA3 10464796672 18 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA2\SR3700_4

\SR3700.DATA4 8074043392 19 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA3\SR3700_5

\SR3700.DATA5 10485768192 20 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA3\SR3700_6

\SR3700.DATA6 7927242752 21 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3700_7

\SR3700.DATA7 10422853632 22 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3700_8

\SR3700.DATA8 7822385152 23 18 NOLINK FILE 10485760000

20971520 8192

PSAPSR3700 ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA4\SR3700_9

\SR3700.DATA9 7822385152 26 18 NOLINK FILE 10485760000

52428800 8192

PSAPSR3USR ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SR3USR_1

\SR3USR.DATA1 41951232 24 18 NOLINK FILE 10485760000

20971520 8192

PSAPTEMP ONLINE# ONLINE+ S:\ORACLE\ZCP\SAPDATA2\TEMP_1

\TEMP.DATA1 2097160192 -1 18 NOLINK FILE 10485760000

20971520 8192

PSAPUNDO ONLINE- ONLINE+ S:\ORACLE\ZCP\SAPDATA3\UNDO_1

\UNDO.DATA1 10129252352 2 18 NOLINK FILE 10485760000

20971520 8192

PSAPUNDO ONLINE- ONLINE S:\ORACLE\ZCP\SAPDATA3\UNDO_2

\UNDO.DATA2 2147491840 25 18 NOLINK FILE

0 0 8192

SYSAUX ONLINE* ONLINE+ S:\ORACLE\ZCP\SAPDATA1\SYSAUX_1

\SYSAUX.DATA1 536879104 3 18 NOLINK FILE 10485760000

20971520 8192

SYSTEM ONLINE* SYSTEM+ S:\ORACLE\ZCP\SAPDATA1\SYSTEM_1

\SYSTEM.DATA1 1073750016 1 18 NOLINK FILE 10485760000

20971520 8192

BR0119I Redo log files

File Size Group Device

Status Link Type

S:\ORACLE\ZCP\ORIGLOGA\LOG_G11M1.DBF 52429312 1 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGA\LOG_G11M2.DBF 52429312 1 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGB\LOG_G12M1.DBF 52429312 2 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGB\LOG_G12M2.DBF 52429312 2 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGA\LOG_G13M1.DBF 52429312 3 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGA\LOG_G13M2.DBF 52429312 3 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGB\LOG_G14M1.DBF 52429312 4 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGB\LOG_G14M2.DBF 52429312 4 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGA\LOG_G15M1.DBF 52429312 5 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGA\LOG_G15M2.DBF 52429312 5 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGB\LOG_G16M1.DBF 52429312 6 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGB\LOG_G16M2.DBF 52429312 6 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGA\LOG_G17M1.DBF 52429312 7 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGA\LOG_G17M2.DBF 52429312 7 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\ORIGLOGB\LOG_G18M1.DBF 52429312 8 18

INUSE NOLINK FILE

S:\ORACLE\ZCP\MIRRLOGB\LOG_G18M2.DBF 52429312 8 18

INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link

Type

S:\oracle\ZCP\origlogA\cntrl\cntrlZCP.dbf 22364160 0 18 NOLINK

FILE

S:\oracle\ZCP\origlogB\cntrl\cntrlZCP.dbf 22364160 0 18 NOLINK

FILE

S:\oracle\ZCP\sapdata1\cntrl\cntrlZCP.dbf 22364160 0 18 NOLINK

FILE

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.06

BR0057I Backup of database: ZCP

BR0058I BRBACKUP action ID: bebalglv

BR0059I BRBACKUP function ID: and

BR0110I Backup mode: ALL

BR0077I Database file for backup: S:\oracle\ZCP\sapbackup\CNTRLZCP.DBF

BR0061I 30 files found for backup, total size 195807.555 MB

BR0143I Backup type: online_cons

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory:

E:\sapbackup\onlinebackup_090717_ZCP\bebalglv

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.06

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.08

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory E:\sapbackup\onlinebackup_090717_ZCP\bebalglv created

BR0370I Directory E:\sapbackup\onlinebackup_090717_ZCP\ZCP created

BR0202I Saving init_ora

BR0203I to E:\sapbackup\onlinebackup_090717_ZCP\ZCP ...

BR0202I Saving C:\oracle\ZCP\102\database\initZCP.sap

BR0203I to E:\sapbackup\onlinebackup_090717_ZCP\ZCP ...

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.08

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2009-07-16 19.03.09

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0201I Compressing S:\ORACLE\ZCP\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to E:\sapbackup\onlinebackup_090717_ZCP\bebalglv\SR3.DATA1.Z ...

BR0280I BRBACKUP time stamp: 2009-07-16 19.15.06

BR0266E Program 'S:\usr\sap\ZCP\SYS\exe\uc\NTAMD64\mkszip -c S:\ORACLE\ZCP\SAPDATA1

\SR3_1\SR3.DATA1 > E:\sapbackup\onlinebackup_090717_ZCP\bebalglv\SR3.DATA1.Z'

interrupted, exit status: c0000094

BR0272E Execution of program 'S:\usr\sap\ZCP\SYS\exe\uc\NTAMD64\mkszip -c

S:\ORACLE\ZCP\SAPDATA1\SR3_1\SR3.DATA1 >

E:\sapbackup\onlinebackup_090717_ZCP\bebalglv\SR3.DATA1.Z' through pipe failed

BR0224E Compressing S:\ORACLE\ZCP\SAPDATA1\SR3_1\SR3.DATA1 to

E:\sapbackup\onlinebackup_090717_ZCP\bebalglv\SR3.DATA1.Z failed due to previous

errors

BR0280I BRBACKUP time stamp: 2009-07-16 19.15.11

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0056I End of database backup: bebalglv.and 2009-07-16 19.15.06

BR0280I BRBACKUP time stamp: 2009-07-16 19.15.11

BR0054I BRBACKUP terminated with errors

-

---

>setting from initSID.sap

backup_mode = all

backup_type = online_cons

backup_dev_type = disk

backup_root_dir = E:\sapbackup\onlinebackup_090717_ZCP

stage_root_dir = E:\sapbackup\onlinebackup_090717_ZCP

compress = yes

compress_cmd = "S:\usr\sap\ZCP\SYS\exe\uc\NTAMD64\mkszip -c $ > $"

Thanks and BR

Lin

Edited by: ye zhulin on Jul 20, 2009 8:58 AM

Edited by: ye zhulin on Jul 20, 2009 8:58 AM

[former_member204746 · Accepted solution]

get rid of mkszip!

read SAP note 1173119 - New function in BR*Tools to replace MKS tools

[Former Member · Accepted solution]

Hi Eric, I am just trying to backup to local disk, not tape now.

Thanks

[former_member204746 · Accepted solution]

my solution should work. read the note again.

you can also stop compressing data. adapt file initSID.sap accordingly.

[Former Member · Accepted solution]

Hi Eric,

You mean what i should do now, is to download new brtools 710 patch12, and set "compress = brtools" in initSID.sap. And then try to backup to local disk again, right?

Thanks

Lin

[Former Member · Accepted solution]

Hi Eric, DBATL710O10_24-10004216.SAR can't even run on my os............(windows server 2003 on X86-64)

[former_member204746 · Accepted solution]

you downloaded the wrong package.

you need DBATL700O10_42-20001376.SAR

use this path:

http://service.sap.com/patches

Support Packages and Patches

Entry by Application Group

SAP NetWeaver

SAP NETWEAVER

SAP NETWEAVER 7.0

Entry by Component

Application Server ABAP

SAP KERNEL 7.00 64-BIT

Windows Server on x64 64bit

ORACLE

[Former Member · Accepted solution]

Hi Eric, brtools 700 do have the compression function?? below is the answer form sap support.

The error in compressing database files is caused by a bug in mkszip

tools. This error depends not necessarily on the size of the file but

probably on its contents. Since mkszip is a 3. party tool (MKS -

Mortice kern System Inc.) SAP cannot provide a fix for this.

There are two alternatives for using mkszip:

1. Oracle Recovery Manager (RMAN) backups to disk with compressed save

sets. Here is the parameter settings for it:

backup_dev_type = disk

disk_copy_cmd = rman_set

rman_compress = yes

Please see notes 1101530 and 968507 p.4 for more details.

2. BRTools own compressing routines implemented in BRTools 7.10 patch

12. Here is the parameter settings for it:

backup_dev_type = disk

disk_copy_cmd = copy

compress = brtools

Please see note 1173119 for more details.

And i have tried to change the compress tool , such as gzip for windows, it works also.

Thanks

[former_member204746 · Accepted solution]

it looks like brtools 700 does not have this option. Sorry about that.

go for file DBATL710O10_24-10004282.SAR

use this path:

http://service.sap.com/patches

Support Packages and Patches

Entry by Application Group

SAP NetWeaver

SAP NETWEAVER

SAP NETWEAVER PI 7.1

Entry by Component

Application Server ABAP

SAP KERNEL 7.00 64-BIT

Windows Server on x64 64bit

ORACLE

[Former Member]

Thanks you all.

[Former Member]

Backup cannot position to correct image

When searching for a backup image to restore, the tape manager did not find the correct backup ID at the expected position on the volume. This can indicate a drive hardware problem.

Try the restore on another drive if possible.