hi all,
i performed the backup with ALL,ONLINE,TAPE and i am getting a success status.
but where as when i schedue a ALL,ONLINE + REDOLOG, TAPE backup i am getting a red status indicating with error status as 3.
this is happening only when i schedule redolog backup's.
when i oversee the log i am not getting an idea of where the problem went wrong.
the detailed log for this is as;;;;;;
Detail log: bdylszrd.ant
BR0051I BRBACKUP 7.00 (22)
BR0055I Start of database backup: bdylszrd.ant 2008-07-28 21.30.01
BR0484I BRBACKUP log file: D:\oracle\P01\sapbackup\bdylszrd.ant
BR0252W Function remove() failed for 'D:\oracle\P01\102\database\sap.ora' at location BrInitOraCreate-1
BR0253W errno 13: Permission denied
BR0252W Function remove() failed for 'D:\oracle\P01\102\database\sap.ora' at location BrInitOraCopy-7
BR0253W errno 13: Permission denied
BR0166I Parameter 'control_files' not found in file D:\oracle\P01\102\database\initP01.ora - default assumed
BR0274W File 'D:\oracle\P01\102\database\CTL1P01.ORA' not found
BR0280I BRBACKUP time stamp: 2008-07-28 21.30.51
BR0319I Control file copy created: D:\oracle\P01\sapbackup\CNTRLP01.DBF 13615104
BR0101I Parameters
Name Value
oracle_sid P01
oracle_home D:\oracle\P01\102
oracle_profile D:\oracle\P01\102\database\initP01.ora
sapdata_home D:\oracle\P01
sap_profile D:\oracle\P01\102\database\initp01.sap
backup_mode ALL
backup_type online
backup_dev_type tape
compress no
compress_dir D:\oracle\P01\sapreorg
tape_copy_cmd dd
cpio_flags -ovB
cpio_in_flags -iuvB
dd_flags bs=64k
dd_in_flags bs=64k
rewind mt -f $ rewind
rewind_offline mt -f $ offline
tape_pos_cmd mt -f $ fsf $
tape_size 102400.000 MB
tape_address /dev/nmt0
tape_address_rew /dev/mt0volume_backup SCRATCH
expir_period 30
tape_use_count 100
exec_parallel 0
system_info SAPServiceP01 TSPLPRD Windows 5.2 Build 3790 Service Pack 2 IA64
oracle_info P01 10.2.0.2.0 8192 2885 28681904 TSPLPRD UTF8 UTF8
sap_info 700 SAPSR3 0002LK0003P010011D11498606370013NetWeaver_ORA
make_info NTia64 OCI_10201_SHARE Jan 29 2007
command_line brbackup -u / -jid ALLOG20080728213000 -c force -t online -m all -p initp01.sap -w use_dbv -v SCRATCH -a -c for
BR0116I ARCHIVE LOG LIST before backup for database instance P01
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\oracle\P01\oraarch\P01arch
Archive format ARC%S_%R.%T
Oldest online log sequence 2882
Next log sequence to archive 2885
Current log sequence 2885 SCN: 28681904
Database block size 8192 Thread: 1
Current system change number 28687073 ResetId: 640489057
BR0118I Tablespaces and data files
Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSi
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3_3\SR3.DATA3 2097160192 6 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3_4\SR3.DATA4 2097160192 7 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3_5\SR3.DATA5 2097160192 8 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3_10\SR3.DATA10 2097160192 13 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3_11\SR3.DATA11 2097160192 14 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3_12\SR3.DATA12 2097160192 15 3 NOLINK FILE 104857600PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3_13\SR3.DATA13 2097160192 16 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3_14\SR3.DATA14 2097160192 17 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3_15\SR3.DATA15 2097160192 18 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3_16\SR3.DATA16 2097160192 19 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3_17\SR3.DATA17 2097160192 20 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3_18\SR3.DATA18 2097160192 21 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3_19\SR3.DATA19 2097160192 22 3 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3_20\SR3.DATA20 2097160192 23 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3700_1\SR3700.DATA1 2600476672 24 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3700_2\SR3700.DATA2 2558533632 25 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3700_3\SR3700.DATA3 2600476672 26 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3700_4\SR3700.DATA4 2537562112 27 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3700_5\SR3700.DATA5 2537562112 28 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3700_6\SR3700.DATA6 2537562112 29 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3700_7\SR3700.DATA7 2474647552 30 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA2\SR3700_8\SR3700.DATA8 2432704512 31 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3700_10\SR3700.DATA10 2474647552 33 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3700_11\SR3700.DATA11 2474647552 34 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3700_12\SR3700.DATA12 2474647552 35 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA3\SR3700_9\SR3700.DATA9 2453676032 32 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_13\SR3700.DATA13 2516590592 36 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_14\SR3700.DATA14 2537562112 37 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_15\SR3700.DATA15 2558533632 38 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_16\SR3700.DATA16 2579505152 39 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_17\SR3700.DATA17 2579505152 44 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_18\SR3700.DATA18 2579505152 46 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_19\SR3700.DATA19 2579505152 47 3 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3700_20\SR3700.DATA20 2579505152 48 3 NOLINK FILE 104857600
PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 41 3 NOLINK FILE 104857600
PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 42 3 NOLINK FILE 104857600
PSAPSR3DB ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 43 3 NOLINK FILE 104857600
PSAPSR3USR ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 3 NOLINK FILE 104857600
PSAPTEMP ONLINE# ONLINE+ D:\ORACLE\P01\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 3 NOLINK FILE 104857600
PSAPUNDO ONLINE- ONLINE+ D:\ORACLE\P01\SAPDATA3\UNDO_1\UNDO.DATA1 5242888192 2 3 NOLINK FILE 104857600SYSAUX ONLINE* ONLINE+ D:\ORACLE\P01\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 209723392 3 3 NOLINK FILE 104857600
SYSTEM ONLINE* SYSTEM+ D:\ORACLE\P01\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 775954432 1 3 NOLINK FILE 104857600
SYSTEM ONLINE* SYSTEM+ D:\ORACLE\P01\SAPDATA1\SYSTEM_2\SYSTEM.DATA2 775954432 45 3 NOLINK FILE 104857600
BR0119I Redo log files
File Size Group Device Status Link Type
D:\ORACLE\P01\ORIGLOGA\LOG_G11M1.DBF 52429312 1 3 INUSE NOLINK FILE
D:\ORACLE\P01\MIRRLOGA\LOG_G11M2.DBF 52429312 1 3 INUSE NOLINK FILE
D:\ORACLE\P01\ORIGLOGB\LOG_G12M1.DBF 52429312 2 3 INUSE NOLINK FILE
D:\ORACLE\P01\MIRRLOGB\LOG_G12M2.DBF 52429312 2 3 INUSE NOLINK FILE
D:\ORACLE\P01\ORIGLOGA\LOG_G13M1.DBF 52429312 3 3 INUSE NOLINK FILE
D:\ORACLE\P01\MIRRLOGA\LOG_G13M2.DBF 52429312 3 3 INUSE NOLINK FILE
D:\ORACLE\P01\ORIGLOGB\LOG_G14M1.DBF 52429312 4 3 INUSE NOLINK FILE
D:\ORACLE\P01\MIRRLOGB\LOG_G14M2.DBF 52429312 4 3 INUSE NOLINK FILE
BR0120I Control files
File Size Id. Device Link Type
D:\oracle\P01\102\database\CTL1P01.ORA 8192 0 0 NOLINK FILE
BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:
PSAPSR3, PSAPSR3700, PSAPSR3USR
BR0280I BRBACKUP time stamp: 2008-07-28 21.31.06
BR0057I Backup of database: P01
BR0058I BRBACKUP action ID: bdylszrd
BR0059I BRBACKUP function ID: ant
BR0110I Backup mode: ALL
BR0077I Database file for backup: D:\oracle\P01\sapbackup\CNTRLP01.DBF
BR0061I 49 files found for backup, total size 100033.359 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: tape
BR0102I Following backup device will be used: /dev/nmt0
BR0104I 1 scratch volume will be used
BR0136I Verify option with value 'use_dbv' set - double work to do
BR0148I DBVERIFY will be used for verification
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowedBR0237I Scratch volume required in device /dev/nmt0
BR0280I BRBACKUP time stamp: 2008-07-28 21.31.06
BR0226I Rewinding tape volume in device /dev/mt0 ...
BR0351I Restoring D:\oracle\P01\sapbackup\.tape.hdr0
BR0355I from /dev/nmt0 ...
BR0241I Checking label on volume in device /dev/nmt0
BR0280I BRBACKUP time stamp: 2008-07-28 21.31.08
BR0226I Rewinding tape volume in device /dev/mt0 ...
BR0202I Saving D:\oracle\P01\sapbackup\.tape.hdr0
BR0203I to /dev/nmt0 ...
BR0209I Volume in device /dev/nmt0 has name SCRATCH
BR0202I Saving init_ora
BR0203I to /dev/nmt0 ...
BR0202I Saving D:\oracle\P01\102\database\initp01.sap
BR0203I to /dev/nmt0 ...
BR0280I BRBACKUP time stamp: 2008-07-28 21.31.22
BR0198I Profiles saved successfully
BR0280I BRBACKUP time stamp: 2008-07-28 21.31.23
BR0315I 'Alter tablespace PSAPSR3 begin backup' successful
BR0202I Saving D:\ORACLE\P01\SAPDATA1\SR3_1\SR3.DATA1
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA1\SR3_1\SR3.DATA1
#SAVED.... SR3.DATA1 SCRATCH/4
BR0280I BRBACKUP time stamp: 2008-07-28 21.32.06
BR0063I 1 of 98 files processed - 2000.008 MB of 200066.719 MB done
BR0204I Percentage done: 1.00%, estimated end time: 23:11
BR0001I __________________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA1\SR3_2\SR3.DATA2
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA1\SR3_2\SR3.DATA2
#SAVED.... SR3.DATA2 SCRATCH/5
BR0280I BRBACKUP time stamp: 2008-07-28 21.32.51
BR0063I 2 of 98 files processed - 4000.016 MB of 200066.719 MB done
BR0204I Percentage done: 2.00%, estimated end time: 22:58BR0001I *_________________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA1\SR3_3\SR3.DATA3
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA1\SR3_3\SR3.DATA3
#SAVED.... SR3.DATA3 SCRATCH/6
BR0280I BRBACKUP time stamp: 2008-07-28 21.33.30
BR0063I 3 of 98 files processed - 6000.023 MB of 200066.719 MB done
BR0204I Percentage done: 3.00%, estimated end time: 22:51
BR0001I *_________________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA1\SR3_4\SR3.DATA4
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA1\SR3_4\SR3.DATA4
#SAVED.... SR3.DATA4 SCRATCH/7
BR0280I BRBACKUP time stamp: 2008-07-28 21.34.06
BR0063I 4 of 98 files processed - 8000.031 MB of 200066.719 MB done
BR0204I Percentage done: 4.00%, estimated end time: 22:46
BR0001I **________________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA1\SR3_5\SR3.DATA5
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA1\SR3_5\SR3.DATA5
#SAVED.... SR3.DATA5 SCRATCH/8
BR0280I BRBACKUP time stamp: 2008-07-28 21.34.56
BR0063I 5 of 98 files processed - 10000.039 MB of 200066.719 MB done
BR0204I Percentage done: 5.00%, estimated end time: 22:47
BR0001I **________________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA2\SR3_10\SR3.DATA10
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA2\SR3_10\SR3.DATA10
#SAVED.... SR3.DATA10 SCRATCH/9
BR0280I BRBACKUP time stamp: 2008-07-28 21.35.40
BR0063I 6 of 98 files processed - 12000.047 MB of 200066.719 MB done
BR0204I Percentage done: 6.00%, estimated end time: 22:47
BR0001I ***_______________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA2\SR3_6\SR3.DATA6BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA2\SR3_6\SR3.DATA6
#SAVED.... SR3.DATA6 SCRATCH/10
BR0280I BRBACKUP time stamp: 2008-07-28 21.36.24
BR0063I 7 of 98 files processed - 14000.055 MB of 200066.719 MB done
BR0204I Percentage done: 7.00%, estimated end time: 22:46
BR0001I ***_______________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA2\SR3_7\SR3.DATA7
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA2\SR3_7\SR3.DATA7
#SAVED.... SR3.DATA7 SCRATCH/11
BR0280I BRBACKUP time stamp: 2008-07-28 21.37.19
BR0063I 8 of 98 files processed - 16000.063 MB of 200066.719 MB done
BR0204I Percentage done: 8.00%, estimated end time: 22:48
BR0001I ****______________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA2\SR3_8\SR3.DATA8
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA2\SR3_8\SR3.DATA8
#SAVED.... SR3.DATA8 SCRATCH/12
BR0280I BRBACKUP time stamp: 2008-07-28 21.37.55
BR0063I 9 of 98 files processed - 18000.070 MB of 200066.719 MB done
BR0204I Percentage done: 9.00%, estimated end time: 22:46
BR0001I ****______________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA2\SR3_9\SR3.DATA9
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA2\SR3_9\SR3.DATA9
#SAVED.... SR3.DATA9 SCRATCH/13
BR0280I BRBACKUP time stamp: 2008-07-28 21.38.43
BR0063I 10 of 98 files processed - 20000.078 MB of 200066.719 MB done
BR0204I Percentage done: 10.00%, estimated end time: 22:47
BR0001I *****_____________________________________________
BR0202I Saving D:\ORACLE\P01\SAPDATA3\SR3_11\SR3.DATA11
BR0203I to /dev/nmt0 ...
#FILE..... D:\ORACLE\P01\SAPDATA3\SR3_11\SR3.DATA11
........................
.................
..........
............
AT THE END OF THE LOG FILE.
BR0280I BRBACKUP time stamp: 2008-07-28 23.10.40
BR0063I 97 of 98 files processed - 200053.734 MB of 200066.719 MB done
BR0204I Percentage done: 99.99%, estimated end time: 23:10
BR0001I **************************************************
BR0351I Restoring D:\oracle\P01\sapreorg\CNTRLP01.DBF
BR0355I from /dev/nmt0 ...
BR0394I D:\oracle\P01\sapbackup\CNTRLP01.DBF is not a data file - its backup cannot be verified using DBVERIFY
BR0280I BRBACKUP time stamp: 2008-07-28 23.10.41
BR0353I Verifying backup of D:\oracle\P01\sapbackup\CNTRLP01.DBF
BR0355I from D:\oracle\P01\sapreorg\CNTRLP01.DBF ...
BR0362I Verification of backup of D:\oracle\P01\sapbackup\CNTRLP01.DBF successful
BR0280I BRBACKUP time stamp: 2008-07-28 23.10.41
BR0063I 98 of 98 files processed - 200066.719 MB of 200066.719 MB done
BR0204I Percentage done: 100.00%, estimated end time: 23:10
BR0001I **************************************************
BR0280I BRBACKUP time stamp: 2008-07-28 23.10.45
BR0340I Switching to next online redo log file for database instance P01 ...
BR0321I Switch to next online redo log file for database instance P01 successful
BR0117I ARCHIVE LOG LIST after backup for database instance P01
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\oracle\P01\oraarch\P01arch
Archive format ARC%S_%R.%T
Oldest online log sequence 2883
Next log sequence to archive 2886
Current log sequence 2886 SCN: 28692585
Database block size 8192 Thread: 1
Current system change number 28692587 ResetId: 640489057
BR0018I Waiting for the next offline redo log file...
BR0017E Offline redo log file 'D:\oracle\P01\102\RDBMS\ARC02885_0640489057.001' not found
BR0056I End of database backup: bdylszrd.ant 2008-07-28 23.10.50