offline backup stops with return code 6

[Former Member]

Environment: Windows 2003 Server

DB: Oracle 10g

App: SAP ERP 2005 (ECC 6.0)

Kernel is patched upto level: 83

I am trying to schedule "Whole offline backup" from db13. the backup schdules successfully but it stops before getting start, without giving out any error message. the backup log look something like this.

-

---

Detail log: bduqqdjw.afd

-

---

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bduqqdjw.afd 2007-02-20 16.12.44

BR0477I Oracle pfile D:\oracle\DEV\102\database\initDEV.ora created from spfile D:\oracle\DEV\102\database\spfileDEV.ora

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home D:\oracle\DEV\102

oracle_profile D:\oracle\DEV\102\database\initDEV.ora

sapdata_home E:\oracle\DEV

sap_profile D:\oracle\DEV\102\database\initDEV.sap

backup_mode ALL

backup_type offline_force

backup_dev_type disk

backup_root_dir E:\oracle\DEV\sapbackup

compress yes

compress_cmd D:\usr\sap\DEV\SYS\exe\nuc\NTI386\mkszip -c $ > $

exec_parallel 0

system_info SAPServiceDEV QA Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info DEV 10.2.0.2.0 8192 1242 13588085 QA WE8DEC UTF8

sap_info 700 SAPSR3 DEV TEMPLICENSE R3_ORA INITIAL

make_info NTintel OCI_10201_SHARE Oct 30 2006

command_line brbackup -u / -jid ALLOF20070220161238 -c force -t offline_force -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 D:\oracle\DEV\oraarch\DEVarch

Archive format ARC%S_%R.%T

Oldest online log sequence 1239

Next log sequence to archive 1242

Current log sequence 1242 SCN: 13588085

Database block size 8192 Thread: 1

Current system change number 13593106 ResetId: 606578588

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 2097160192 24 4 NOLINK FILE 10485760000 20971520 8192

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

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

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

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

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

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

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

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

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

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

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

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3700_13\SR3700.DATA13 2097160192 36 4 NOLINK FILE 10485760000 20971520 8192

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

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

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\DEV\SAPDATA4\SR3700_16\SR3700.DATA16 2097160192 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 4466941952 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

F:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF 52429312 1 5 INUSE NOLINK FILE

D:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF 52429312 1 3 INUSE NOLINK FILE

F:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF 52429312 2 5 INUSE NOLINK FILE

D:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF 52429312 2 3 INUSE NOLINK FILE

F:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF 52429312 3 5 INUSE NOLINK FILE

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

F:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF 52429312 4 5 INUSE NOLINK FILE

D:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF 52429312 4 3 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

F:\oracle\DEV\origlogA\cntrl\cntrlDEV.dbf 12664832 0 5 NOLINK FILE

F:\oracle\DEV\origlogB\cntrl\cntrlDEV.dbf 12664832 0 5 NOLINK FILE

E:\oracle\DEV\sapdata1\cntrl\cntrlDEV.dbf 12664832 0 4 NOLINK FILE

-

---

there is no error as far as the log is concerned. But when i see list of running processes in Task Manager i can see brbackup still running with no activity(cpu utilization 0), Also by looking job list from sm37 the relevent backup job is already finished. DB status stays open and everything else works fine.

Furthermore everything works fine in case of online backup. If anyone have any clue about what exactly happening here please help.

Also on checking back<sid>.log file, the return code of the relevent backup is 6 (which means : internal termination)

Message was edited by:

Rizwan Javed

[Former Member]

Hi Rizwan,

Got the answer from SAP. Implement Correction of Note Note 988038 - External commands: Control flag "Wait for termination" or implement Basis Support Package Patch 11 (SAPKB70011)

regards

Jürgen

[Former Member]

Hi Rizwan,

We’ve got exactly the same problem. From DB 13 we are not able to schedule a full offline backupjob. When copy the command_line and delete parameter -jid and run it from the OS Command Box, it runs without errors

command_line brbackup -u / -jid ALLOF200705261512348 -c force -t offline_force -m all -p initQUA.sap

Have you solved your problem?

regards

Jürgen

[Former Member]

Hi,

This may because of OS Problem for more information refer this link http://support.microsoft.com/kb/917114.