cancel
Showing results for 
Search instead for 
Did you mean: 

backupu0094and u0093Redo log backupu0094;Except operation are failed

former_member439006
Discoverer
0 Kudos

I encounter a problem when i makeing backup,i ask for help.

<b>The situation is following:</b>os: windows 2003+sp2

SAP :NetWeaver 04S(BW7.0)

DB:ORACLE 10.2

Backup Software: VERITAS Backup Exec for Windows Servers 9.1

The problem which i encounter is following:

All are successful that use “BRTOOLS” operate “OFFLINE BACKUP” and “OFFLINE BACKUP”.

These operation are successful to use "DB13" Operate

“Whole database online + redo log backup”&#12289;“Whole database online backup”and “Redo log backup”;Except “Whole database offline + redo log backup" and"Whole database offline backup" these two operation are failed

<b>successful “AllOnl+Log”</b> BRABCKUP Detail log for database BWD

-


Detailliertes Protokoll: bdvvpedp.anf

-


BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdvvpedp.anf 2007-08-03 13.32.37

BR0477I Oracle pfile D:\oracle\BWD\102\database\initBWD.ora created from spfile D:\oracle\BWD\102\database\spfileBWD.ora

BR0280I BRBACKUP time stamp: 2007-08-03 13.32.40

BR0319I Control file copy created: D:\oracle\BWD\sapbackup\CNTRLBWD.DBF 12664832

BR0101I Parameters

Name Value

oracle_sid BWD

oracle_home D:\oracle\BWD\102

oracle_profile D:\oracle\BWD\102\database\initBWD.ora

sapdata_home D:\oracle\BWD

sap_profile D:\oracle\BWD\102\database\initBWD.sap

backup_mode ALL

backup_type online

backup_dev_type util_file

util_par_file D:\usr\sap\BWD\SYS\exe\uc\NTI386\biparam.ini

system_info SAPServiceBWD KHBWDEV Windows 5.2 Build 3790 Service Pack 2 Intel

oracle_info BWD 10.2.0.2.0 8192 826 6112865 KHBWDEV UTF8 UTF8

sap_info 700 SAPSR3 BWD TEMPLICENSE R3_ORA INITIAL

make_info NTintel OCI_10201_SHARE Oct 27 2006

command_line brbackup -u / -jid ALLOG20070803133227 -c force -t online -m all -p initBWD.sap -a -c force -p initBWD.sap -cds

BR0116I ARCHIVE LOG LIST before backup for database instance BWD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination C:\oracle\BWD\oraarch\BWDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 823

Next log sequence to archive 826

Current log sequence 826 SCN: 6112865

Database block size 8192 Thread: 1

Current system change number 6123378 ResetId: 628786982

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_1\SR3.DATA1 2243960832 4 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_2\SR3.DATA2 2327846912 5 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_3\SR3.DATA3 2243960832 6 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_4\SR3.DATA4 2243960832 7 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_5\SR3.DATA5 2243960832 16 3 NOLINK FILE 3145728000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_1\SR3700.DATA1 3795853312 8 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_2\SR3700.DATA2 3942653952 9 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_3\SR3700.DATA3 3732938752 10 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_4\SR3700.DATA4 3670024192 11 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_5\SR3700.DATA5 3670024192 17 3 NOLINK FILE 4194304000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 13 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 14 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 15 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3USR_1\SR3USR.DATA1 20979712 12 3 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ D:\ORACLE\BWD\SAPDATA1\TEMP_1\TEMP.DATA1 1048584192 -1 3 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ D:\ORACLE\BWD\SAPDATA1\UNDO_1\UNDO.DATA1 8115986432 2 3 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 209723392 3 3 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ D:\ORACLE\BWD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 524296192 1 3 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

D:\ORACLE\BWD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 2 INUSE NOLINK FILE

D:\ORACLE\BWD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 2 INUSE NOLINK FILE

D:\ORACLE\BWD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGA\LOG_G13M2.DBF 52429312 3 2 INUSE NOLINK FILE

D:\ORACLE\BWD\ORIGLOGB\LOG_G14M1.DBF 52429312 4 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGB\LOG_G14M2.DBF 52429312 4 2 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

D:\oracle\BWD\origlogA\cntrl\cntlrBWD.dbf 12664832 0 3 NOLINK FILE

D:\oracle\BWD\origlogB\cntrl\cntrlBWD.dbf 12664832 0 3 NOLINK FILE

D:\oracle\BWD\sapdata1\cntrl\cntrlBWD.dbf 12664832 0 3 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2007-08-03 13.32.40

BR0057I Backup of database: BWD

BR0058I BRBACKUP action ID: bdvvpedp

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: D:\oracle\BWD\sapbackup\CNTRLBWD.DBF

BR0061I 18 files found for backup, total size 42192.211 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0289I BRARCHIVE will be started at the end of processing

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2007-08-03 13.32.41

BR0315I 'Alter database begin backup' successful

BR0280I BRBACKUP time stamp: 2007-08-03 13.32.41

BR0229I Calling backup utility with function 'backup'...

BR0280I BRBACKUP time stamp: 2007-08-03 13.34.10

#FILE..... D:\oracle\BWD\sapbackup\CNTRLBWD.DBF

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.34.29

#FILE..... D:\ORACLE\BWD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.35.13

#FILE..... D:\ORACLE\BWD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.46.48

#FILE..... D:\ORACLE\BWD\SAPDATA1\UNDO_1\UNDO.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.49.58

#FILE..... D:\ORACLE\BWD\SAPDATA2\SR3_1\SR3.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.53.15

#FILE..... D:\ORACLE\BWD\SAPDATA2\SR3_2\SR3.DATA2

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.56.26

#FILE..... D:\ORACLE\BWD\SAPDATA2\SR3_3\SR3.DATA3

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 13.59.36

#FILE..... D:\ORACLE\BWD\SAPDATA2\SR3_4\SR3.DATA4

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.02.46

#FILE..... D:\ORACLE\BWD\SAPDATA2\SR3_5\SR3.DATA5

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.08.08

#FILE..... D:\ORACLE\BWD\SAPDATA3\SR3700_1\SR3700.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.13.42

#FILE..... D:\ORACLE\BWD\SAPDATA3\SR3700_2\SR3700.DATA2

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.18.59

#FILE..... D:\ORACLE\BWD\SAPDATA3\SR3700_3\SR3700.DATA3

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.24.10

#FILE..... D:\ORACLE\BWD\SAPDATA3\SR3700_4\SR3700.DATA4

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.29.21

#FILE..... D:\ORACLE\BWD\SAPDATA3\SR3700_5\SR3700.DATA5

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.32.18

#FILE..... D:\ORACLE\BWD\SAPDATA4\SR3DB_1\SR3DB.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.35.16

#FILE..... D:\ORACLE\BWD\SAPDATA4\SR3DB_2\SR3DB.DATA2

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.36.45

#FILE..... D:\ORACLE\BWD\SAPDATA4\SR3DB_3\SR3DB.DATA3

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.36.47

#FILE..... D:\ORACLE\BWD\SAPDATA4\SR3USR_1\SR3USR.DATA1

#SAVED.... 1186119250

BR0280I BRBACKUP time stamp: 2007-08-03 14.55.51

BR0232I 18 of 18 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2007-08-03 14.55.56

BR0317I 'Alter database end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-03 14.55.56

BR0340I Switching to next online redo log file for database instance BWD ...

BR0321I Switch to next online redo log file for database instance BWD successful

BR0117I ARCHIVE LOG LIST after backup for database instance BWD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination C:\oracle\BWD\oraarch\BWDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 824

Next log sequence to archive 827

Current log sequence 827 SCN: 6126274

Database block size 8192 Thread: 1

Current system change number 6126276 ResetId: 628786982

BR0018I Waiting for the next offline redo log file...

BR0280I BRBACKUP time stamp: 2007-08-03 14.56.02

BR0229I Calling backup utility with function 'backup'...

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.29

#PFLOG.... D:\oracle\BWD\102\database\initBWD.ora

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.29

#PFLOG.... D:\oracle\BWD\102\database\initBWD.sap

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.30

#PFLOG.... D:\oracle\BWD\102\database\spfileBWD.ora

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.30

#PFLOG.... D:\oracle\BWD\sapbackup\backBWD.log

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.31

#PFLOG.... D:\oracle\BWD\sapbackup\bdvvpedp.anf

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.31

#PFLOG.... D:\oracle\BWD\sapreorg\spaceBWD.log

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.31

#PFLOG.... D:\oracle\BWD\sapreorg\strucBWD.log

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 14.57.33

#PFLOG.... D:\usr\sap\BWD\SYS\exe\uc\NTI386\biparam.ini

#SAVED.... 1186124248

BR0280I BRBACKUP time stamp: 2007-08-03 15.01.28

BR0232I 8 of 8 files saved by backup utility

BR0230I Backup utility called successfully

BR0056I End of database backup: bdvvpedp.anf 2007-08-03 15.01.28

BR0280I BRBACKUP time stamp: 2007-08-03 15.01.28

BR0052I BRBACKUP completed successfully

BR0280I BRBACKUP time stamp: 2007-08-03 15.01.28

BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20070803133227 -d util_file -c force -p initBWD.sap -cds'

BR0280I BRBACKUP time stamp: 2007-08-03 15.15.55

BR0292I Execution of BRARCHIVE finished with return code 0

Failed “AllOff+Log”

BRABCKUP Detail log for database BWD

-


Detailliertes Protokoll: bdvvvghm.aff

-


BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdvvvghm.aff 2007-08-04 19.14.26

BR0477I Oracle pfile D:\oracle\BWD\102\database\initBWD.ora created from spfile D:\oracle\BWD\102\database\spfileBWD.ora

BR0101I Parameters

Name Value

oracle_sid BWD

oracle_home D:\oracle\BWD\102

oracle_profile D:\oracle\BWD\102\database\initBWD.ora

sapdata_home D:\oracle\BWD

sap_profile D:\oracle\BWD\102\database\initBWD.sap

backup_mode ALL

backup_type offline_force

backup_dev_type util_file

util_par_file D:\usr\sap\BWD\SYS\exe\uc\NTI386\biparam.ini

system_info SAPServiceBWD KHBWDEV Windows 5.2 Build 3790 Service Pack 2 Intel

oracle_info BWD 10.2.0.2.0 8192 829 6191434 KHBWDEV UTF8 UTF8

sap_info 700 SAPSR3 BWD TEMPLICENSE R3_ORA INITIAL

make_info NTintel OCI_10201_SHARE Oct 27 2006

command_line brbackup -u / -jid ALGOF20070804191417 -c force -t offline_force -m all -p initBWD.sap -a -c force -p initBWD.sap -cds

BR0116I ARCHIVE LOG LIST before backup for database instance BWD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination C:\oracle\BWD\oraarch\BWDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 826

Next log sequence to archive 829

Current log sequence 829 SCN: 6191434

Database block size 8192 Thread: 1

Current system change number 6215407 ResetId: 628786982

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_1\SR3.DATA1 2243960832 4 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_2\SR3.DATA2 2327846912 5 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_3\SR3.DATA3 2243960832 6 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_4\SR3.DATA4 2243960832 7 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA2\SR3_5\SR3.DATA5 2243960832 16 3 NOLINK FILE 3145728000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_1\SR3700.DATA1 3795853312 8 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_2\SR3700.DATA2 3942653952 9 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_3\SR3700.DATA3 3732938752 10 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_4\SR3700.DATA4 3670024192 11 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA3\SR3700_5\SR3700.DATA5 3670024192 17 3 NOLINK FILE 4194304000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 13 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 14 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 15 3 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA4\SR3USR_1\SR3USR.DATA1 20979712 12 3 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ D:\ORACLE\BWD\SAPDATA1\TEMP_1\TEMP.DATA1 1048584192 -1 3 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ D:\ORACLE\BWD\SAPDATA1\UNDO_1\UNDO.DATA1 8115986432 2 3 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ D:\ORACLE\BWD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 209723392 3 3 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ D:\ORACLE\BWD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 524296192 1 3 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

D:\ORACLE\BWD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 2 INUSE NOLINK FILE

D:\ORACLE\BWD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 2 INUSE NOLINK FILE

D:\ORACLE\BWD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGA\LOG_G13M2.DBF 52429312 3 2 INUSE NOLINK FILE

D:\ORACLE\BWD\ORIGLOGB\LOG_G14M1.DBF 52429312 4 3 INUSE NOLINK FILE

C:\ORACLE\BWD\MIRRLOGB\LOG_G14M2.DBF 52429312 4 2 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

D:\oracle\BWD\origlogA\cntrl\cntlrBWD.dbf 12664832 0 3 NOLINK FILE

D:\oracle\BWD\origlogB\cntrl\cntrlBWD.dbf 12664832 0 3 NOLINK FILE

D:\oracle\BWD\sapdata1\cntrl\cntrlBWD.dbf 12664832 0 3 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

did you find a solution to this?

former_member439006
Discoverer
0 Kudos

SAP_BASIS patch update to level 0011

Former Member
0 Kudos

Thanks, I'm actually on 12 and facing the same issue. did you replace your executables as well?

cheers

kev