on 08-04-2007 7:07 PM
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、Whole database online backupand 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
did you find a solution to this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.