Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OFF LINE Backup issue

Hi,

<i><b><u>Environment; SAP ECC6, Oracle, window server 2003</u></b></i>

Other day I scheduled OFF LINE Backup through DB13, but it did not work. It ran just for a second. Detail Log shows no error message. It also create file .lock.brb in E:\oracle\DEV\sapbackup folder.

I never had success taking OFFLINE backup through DB13 but I can take this backup by BRTOOLS*. Please help me with this, looking at detail Log file below;

Detail log: bdwholho.afd

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdwholho.afd 2007-10-05 18.15.28

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 2031 30773325 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 ALLOF20071005181500 -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 2028

Next log sequence to archive 2031

Current log sequence 2031 SCN: 30773325

Database block size 8192 Thread: 1

Current system change number 30797874 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 859840512 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

-


Thanks..

Regards,

Marej Khan

Former Member
Not what you were looking for? View more on this topic or Ask a question