cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

OFF LINE Backup issue

Former Member

on ‎10-09-2007 6:59 AM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎10-09-2007 9:21 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎10-09-2007 10:00 AM
0 Kudos

Hi Manas,

Thanks for responce.

Yes, I did checked BRBACKUP is running in Task Manager.

What it means??? what I should do, please help me...need experts advice.

Regards,

marej

Former Member
‎10-09-2007 12:44 PM
0 Kudos

Ok

End the task in Task Manager.

Delete the .lock.brb in E:\oracle\DEV\sapbackup folder or make a search for *.brb and delete it from the folder.

Then run BRTOOLS from cmd prompt.

Then enter option 4 ie backup and database copy.

Then select option 9 ie reset prog status.

Once it is done exit and try running bkup again from db13.

Hope this helps

Pl award suitable points

Regards

Former Member
‎10-17-2007 8:04 AM
0 Kudos

Hi Manas,

I ran the Off Line Backup again through DB13, after completing the tasks you mentioned earlier but it failed again with similar job detail log without any Error message. It does created file .brb.lock in SAPbackup folder again and BRBACKUP process running in Task Manager again.

What do you suggest of any fix? what Iam doing wrong or missing any thing…I have already tried 3 times to run backup through DB13 but it always failed.

Please help.

Regards,

Former Member
‎10-17-2007 9:38 AM
0 Kudos

Hi,

Sorry for the delay.

It seems you have pasted only a portion of the log file upto

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

Pl paste the rest of the logfile for analysis.

Also paste the detailed evironment variables set by you .

Regards

Former Member
‎10-17-2007 9:54 AM
0 Kudos

Hi Marej,

This lock file will be created if tape/back up aborted suddenly. So rem. lock file and check DB13 logs, look for red lines and paste that redlines(some lines before red... some lines after red) .

Regards,

Hari.

PS: Points are welcome.

Former Member
‎10-17-2007 11:29 AM
0 Kudos

Hi,

Iam reposting OFF LINE Backup detail log and this is complete, end on the same line as you have mentioned i.e E:\oracle\DEV\sapdata1\cntrl\cntrlDEV.dbf 12664832 0 4 NOLINK FILE, seems like it is not complete Log but it is and there is no Error message or Red Lines for failure.

-

Detail log: bdwjadfg.afd

-

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdwjadfg.afd 2007-10-13 10.15.48

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 2076 31431371 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 ALLOF20071013101500 -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 2073

Next log sequence to archive 2076

Current log sequence 2076 SCN: 31431371

Database block size 8192 Thread: 1

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

Former Member
‎10-17-2007 12:11 PM
0 Kudos

Hi

In the next step it has to verify the TAORA and IAORA tables to see the tablespaces.

Where is the termination message in the log?

Otherwise check th log file from db13.

Regards

Former Member
‎10-17-2007 12:50 PM
0 Kudos

Marej,

Please post the exact red lines in DB13 log.(double click on failed job and go to detailed log).

Regards,

Hari.

PS: Points are welcome.

Former Member
‎10-17-2007 1:31 PM
0 Kudos

Following message is from DB13 job Log,,,as you can see it shows Backup ran for just 48 second, status showing 'completed" infact it did not;

<u>Job name</u> <u>Status</u> <u>Scheduled start</u> <u>Actual start</u> <u>End Time</u>

DBA:ALLOFFLINE______@101500/6000 Completed 13.10.2007 10:15:00 13.10.2007 10:15:48 13.10.2007 10:15:48

Job log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000041, user ID BASIS)

Execute logical command BRBACKUP On host qa

Parameters:-u / -jid ALLOF20071013101500 -c force -t offline_force -m all -p initDEV.sap

Job finished

-

There is no other message or Error message in any Logs.

Regards,

Former Member
‎10-17-2007 1:49 PM
0 Kudos

Marej,

" backup_dev_type disk

backup_root_dir E:\oracle\DEV\sapbackup"

Are you trying to take back up in Disk? or tape?

If it is disk, Have you created the 'sapbackup' directory in E:\oracle\DEV\ ?

Regards,

Hari.

PS: Points are welcome.

Former Member
‎10-17-2007 7:39 PM
0 Kudos

Dear Marej,

Kindly recheck your initDBSID.sap parameter settings.

Regards

Shantanu

Former Member
‎10-22-2007 11:06 AM
0 Kudos

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

Ask a Question