dp backup error
dear all:
my system is r3 4.7 os is alpha tr64 5.1 db is oracle9203 when i bakcup r3 database online the error occur.below is the error log :
[Normal] From: BSM@sgbackup "r3dev_log" Time: 2007-2-5 6:00:07
OB2BAR application on "adev" successfully started.
BR0002I BRARCHIVE 6.40 (40)
BR0262I Enter database user name[/password]:
BR0169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored for
'brarchive' - 'util_file' assumed
BR0006I Start of offline redo log processing: adunrrjy.cds 2007-02-05 05.54.38
BR0477I Oracle pfile /oracle/DV1/920_64/dbs/initDV1.ora created from spfile
/oracle/DV1/920_64/dbs/spfileDV1.ora
BR0280I BRARCHIVE time stamp: 2007-02-05 05.54.40
BR0008I Offline redo log processing for database instance: DV1
BR0009I BRARCHIVE action ID: adunrrjy
BR0010I BRARCHIVE function ID: cds
BR0048I Archive function: copy_delete_save
BR0011I 3 offline redo log files found for processing, total size 149.997 MB
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRARCHIVE time stamp: 2007-02-05 05.54.40
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/DV1/SYS/exe/run/backint -u DV1 -f backup -i
/oracle/DV1/saparch/.adunrrjy.lst -t file -c':
[Normal] From: OB2BAR_BACKINT@adev "DV1" Time: 02/05/07 05:54:41
Backint is started with the following parameters
/usr/sap/DV1/SYS/exe/run/backint -u DV1 -f backup -i
/oracle/DV1/saparch/.adunrrjy.lst -t file -c.
[Normal] From: BMA@adev "HP:Ultrium 3-SCSI_1" Time: 2007-2-5 5:54:46
STARTING Media Agent "HP:Ultrium 3-SCSI_1"
[Normal] From: BMA@adev "HP:Ultrium 3-SCSI_1" Time: 2007-2-5 5:54:48
By: UMA@bwprd2@/dev/rac/c4t0d0
Loading medium from slot 57 to device /dev/ntape/tape8
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:55:31
Starting OB2BAR Backup: adev:DV1.1 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:55:31
Starting OB2BAR Backup: adev:DV1.2 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:55:31
Starting OB2BAR Backup: adev:DV1.0 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:55:31 Starting
OB2BAR Backup: adev:DV1.2 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:55:31 Starting
OB2BAR Backup: adev:DV1.0 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:55:31 Starting
OB2BAR Backup: adev:DV1.1 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.42
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26945.dbf
#SAVED.... 20070205.0003.02
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.42
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26944.dbf
#SAVED.... 20070205.0003.01
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.43
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26943.dbf
#SAVED.... 20070205.0003.00
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.43
BR0015I Offline redo log file /oracle/DV1/oraarch/DV1arch1_26943.dbf deleted
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.43
BR0015I Offline redo log file /oracle/DV1/oraarch/DV1arch1_26944.dbf deleted
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.43
BR0015I Offline redo log file /oracle/DV1/oraarch/DV1arch1_26945.dbf deleted
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:49
Completed OB2BAR Backup: adev:DV1.1 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:49
Completed OB2BAR Backup: adev:DV1.2 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:49
Completed OB2BAR Backup: adev:DV1.0 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:49 Completed
OB2BAR Backup: adev:DV1.2 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:49 Completed
OB2BAR Backup: adev:DV1.1 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:49 Completed
OB2BAR Backup: adev:DV1.0 "SAP"
[Normal] From: OB2BAR_BACKINT@adev "DV1" Time: 02/05/07 05:56:49
Backint exits with the code (0).
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.49
BR0232I 3 of 3 files saved by backup utility
BR0230I Backup utility called successfully
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.51
BR0012I 5 next offline redo log files found for processing, total size 249.991 MB
BR0280I BRARCHIVE time stamp: 2007-02-05 05.56.51
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/DV1/SYS/exe/run/backint -u DV1 -f backup -i
/oracle/DV1/saparch/.adunrrjy.lst -t file -c':
[Normal] From: OB2BAR_BACKINT@adev "DV1" Time: 02/05/07 05:56:51
Backint is started with the following parameters
/usr/sap/DV1/SYS/exe/run/backint -u DV1 -f backup -i
/oracle/DV1/saparch/.adunrrjy.lst -t file -c.
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:51
Starting OB2BAR Backup: adev:DV1.3 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:53
Starting OB2BAR Backup: adev:DV1.4 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:55
Starting OB2BAR Backup: adev:DV1.5 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:56:57
Starting OB2BAR Backup: adev:DV1.6 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:51 Starting
OB2BAR Backup: adev:DV1.3 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:53 Starting
OB2BAR Backup: adev:DV1.4 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:55 Starting
OB2BAR Backup: adev:DV1.5 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:56:57 Starting
OB2BAR Backup: adev:DV1.6 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.00
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26946.dbf
#SAVED.... 20070205.0003.03
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.00
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26950.dbf
#SAVED.... 20070205.0003.03
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:06
Completed OB2BAR Backup: adev:DV1.4 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:06
Completed OB2BAR Backup: adev:DV1.3 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.06
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26947.dbf
#SAVED.... 20070205.0003.04
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:06 Completed
OB2BAR Backup: adev:DV1.4 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:06 Completed
OB2BAR Backup: adev:DV1.3 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.07
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26948.dbf
#SAVED.... 20070205.0003.05
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.08
#ARCHIVE.. /oracle/DV1/oraarch/DV1arch1_26949.dbf
#SAVED.... 20070205.0003.06
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:15
Completed OB2BAR Backup: adev:DV1.5 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:15
Completed OB2BAR Backup: adev:DV1.6 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:15 Completed
OB2BAR Backup: adev:DV1.5 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:15 Completed
OB2BAR Backup: adev:DV1.6 "SAP"
[Normal] From: OB2BAR_BACKINT@adev "DV1" Time: 02/05/07 05:57:15
Backint exits with the code (0).
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.15
BR0232I 5 of 5 files saved by backup utility
BR0230I Backup utility called successfully
BR0016I 8 offline redo log files processed, total size 399.988 MB
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.17
BR0229I Calling backup utility with function 'backup'...
BR0278I Command output of '/usr/sap/DV1/SYS/exe/run/backint -u DV1 -f backup -i
/oracle/DV1/saparch/.adunrrjy.lst -t file -c':
[Normal] From: OB2BAR_BACKINT@adev "DV1" Time: 02/05/07 05:57:17
Backint is started with the following parameters
/usr/sap/DV1/SYS/exe/run/backint -u DV1 -f backup -i
/oracle/DV1/saparch/.adunrrjy.lst -t file -c.
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:18
Starting OB2BAR Backup: adev:DV1.7 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:20
Starting OB2BAR Backup: adev:DV1.8 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:22
Starting OB2BAR Backup: adev:DV1.9 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:24
Starting OB2BAR Backup: adev:DV1.10 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:24
Completed OB2BAR Backup: adev:DV1.7 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:18 Starting
OB2BAR Backup: adev:DV1.7 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:20 Starting
OB2BAR Backup: adev:DV1.8 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:22 Starting
OB2BAR Backup: adev:DV1.9 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:24 Starting
OB2BAR Backup: adev:DV1.10 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.25
#PFLOG.... /oracle/DV1/920_64/dbs/initDV1.ora
#SAVED.... 20070205.0003.07
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.25
#PFLOG.... /oracle/DV1/saparch/archDV1.log
#SAVED.... 20070205.0003.07
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:24 Completed
OB2BAR Backup: adev:DV1.7 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:31
Completed OB2BAR Backup: adev:DV1.9 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:31
Completed OB2BAR Backup: adev:DV1.8 "SAP"
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 2007-2-5 5:57:31
Completed OB2BAR Backup: adev:DV1.10 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
#PFLOG.... /oracle/DV1/920_64/dbs/initDV1.sap
#SAVED.... 20070205.0003.09
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:31 Completed
OB2BAR Backup: adev:DV1.9 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
#PFLOG.... /oracle/DV1/920_64/dbs/spfileDV1.ora
#SAVED.... 20070205.0003.08
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:31 Completed
OB2BAR Backup: adev:DV1.8 "SAP"
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
#PFLOG.... /oracle/DV1/sapreorg/spaceDV1.log
#SAVED.... 20070205.0003.10
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
#PFLOG.... /oracle/DV1/sapreorg/strucDV1.log
#SAVED.... 20070205.0003.10
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
#PFLOG.... /oracle/DV1/saparch/adunrrjy.cds
#SAVED.... 20070205.0003.10
[Normal] From: OB2BAR_SAPBACK@adev "DV1" Time: 02/05/07 05:57:31 Completed
OB2BAR Backup: adev:DV1.10 "SAP"
[Normal] From: OB2BAR_BACKINT@adev "DV1" Time: 02/05/07 05:57:31
Backint exits with the code (0).
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
BR0232I 7 of 7 files saved by backup utility
BR0230I Backup utility called successfully
BR0007I End of offline redo log processing: adunrrjy.cds 2007-02-05 05.57.31
BR0280I BRARCHIVE time stamp: 2007-02-05 05.57.31
BR0003I BRARCHIVE completed successfully
[Critical] From: OB2BAR_OMNISAP@adev "OMNISAP" Time: 02/05/07 05:57:34
Failed to execute 'connect %s as sysdba;
alter database backup controlfile to '%s';
'.
[Major] From: OB2BAR_OMNISAP@adev "OMNISAP" Time: 02/05/07 05:57:34
Oracle control file backup failed.
[Normal] From: BSM@sgbackup "r3dev_log" Time: 2007-2-5 6:03:04
OB2BAR application on "adev" disconnected.
[Normal] From: BMA@adev "HP:Ultrium 3-SCSI_1" Time: 2007-2-5 5:58:39
/dev/ntape/tape8
Medium header verification completed, 0 errors found
[Normal] From: BMA@adev "HP:Ultrium 3-SCSI_1" Time: 2007-2-5 5:58:59
By: UMA@bwprd2@/dev/rac/c4t0d0
Unloading medium to slot 57 from device /dev/ntape/tape8
[Normal] From: BMA@adev "HP:Ultrium 3-SCSI_1" Time: 2007-2-5 5:59:20
COMPLETED Media Agent "HP:Ultrium 3-SCSI_1"
[Normal] From: BSM@sgbackup "r3dev_log" Time: 2007-2-5 6:04:50
Backup Statistics:
Session Queuing Time (hours) 0.00
----------------------------------------
Completed Disk Agents ........ 11
Failed Disk Agents ........... 0
Aborted Disk Agents .......... 0
----------------------------------------
Disk Agents Total ........... 11
========================================
Completed Media Agents ....... 1
Failed Media Agents .......... 0
Aborted Media Agents ......... 0
----------------------------------------
Media Agents Total .......... 1
========================================
Mbytes Total ................. 402 MB
Used Media Total ............. 1
Disk Agent Errors Total ...... 0
pls help me! thanks a lot!
frank
[Critical] From: OB2BAR_OMNISAP@adev "OMNISAP" Time: 02/05/07 05:57:34
Failed to execute 'connect %s as sysdba;
alter database backup controlfile to '%s';
Do you setup the user properly?
i have granted sysdba to system ,it is ok ?
You need to run sapdba_role.sql script that is supplied by the SAP installation through SQLPLUS.