Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2007 at 08:21 AM

    Hi,

    " It also create file .lock.brb in E:\oracle\DEV\sapbackup folder"

    Check if BRBACKUP is running using the ps command on UNIX or the Task Manager on Windows. Only continue, if no BRBACKUP is running.

    2. Start BRTOOLS or BRGUI and choose Space management &#8594; Alter tablespace &#8594; Reset backup status. Choose continue twice to get a list of all tablespacesin backup mode.

    3. Enter 0 to select all tablespaces and choose continue to turn backup mode off.

    4. Delete the lock file $SAPDATA_HOME/sapbackup/.lock.brb.

    5. Run a test backup with BRBACKUP to check if everything is okayHope this helps.

    Pl award suitably.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi all ,

      -Yes, there is SAPBackup directory under E:\oracle\dev\

      - Iam taking backup on Disk ( not Tape).

      So nothing wrong with directory or parameters, because I take ONLINE backups through DB13 and OFF LINE Backup through BRTOOLS* using command prompt with same parameters i.e Disk and sapbackup directory and never had a problem

      Seems problem is some where else, thats why OFF LINE Backup through DB13 failed..need expert advice/suggestion.

      Thanks, Regards

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.