Skip to Content
0
Jul 29, 2008 at 07:18 AM

backup problem

65 Views

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