Skip to Content
0
Former Member
Aug 21, 2008 at 10:24 AM

onLine / Offline backup fails with error BR0278E

34 Views

Dear Friends,

Using db13 Online backup and Offline backup program fails after a certain time of backup. I cheked up backup device / Tape media also by taking complete root backup which goes well. pl suggest how to overcome this problem.

the configuration is as under

OS : SUSE Linux server 9

Oracle : 9i

SAP : ECC 5.0

brtools : 6.40 patch level 46

Kernel : release 640 patch level 196

The error is as follows :

-


Detail log: bdyqbcxm.ant

-


BR0051I BRBACKUP 6.40 (46)

BR0055I Start of database backup: bdyqbcxm.ant 2008-08-20 16.55.06

BR0484I BRBACKUP log file: /oracle/RSL/sapbackup/bdyqbcxm.ant

BR0477I Oracle pfile /oracle/RSL/920_32/dbs/initRSL.ora created from spfile /oracle/RSL/920_32/dbs/spfileRSL.ora

BR0280I BRBACKUP time stamp: 2008-08-20 16.55.11

BR0319I Control file copy created: /oracle/RSL/sapbackup/cntrlRSL.dbf 7397376

BR0101I Parameters

Name Value

oracle_sid RSL

oracle_home /oracle/RSL/920_32

oracle_profile /oracle/RSL/920_32/dbs/initRSL.ora

sapdata_home /oracle/RSL

sap_profile /oracle/RSL/920_32/dbs/initRSL.sap

backup_mode ALL

backup_type online

backup_dev_type tape

compress no

tape_copy_cmd dd

cpio_flags -ovcB

cpio_in_flags -iuvcB

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 204800.000 MB

tape_address /dev/nst0

tape_address_rew /dev/st0

volume_backup RSLB01,RSLB02,RSLB03,RSLB04,RSLB05,RSLB06

expir_period 5

tape_use_count 100

exec_parallel 0

system_info rsladm/orarsl prdecc Linux 2.6.5-7.191-bigsmp #1 SMP Tue Jun 28 14:58:56 UTC 2005 i686

oracle_info RSL 9.2.0.6.0 8192 13566 133348521

sap_info 640 SAPRSL RSL E1882762756 R3_ORA 0020205991

make_info linuxintel OCI_920 Nov 13 2007

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

BR0116I ARCHIVE LOG LIST before backup for database instance RSL

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/RSL/oraarch/RSLarch

Archive format %t_%s.dbf

Oldest online log sequence 13563

Next log sequence to archive 13566

Current log sequence 13566 SCN: 133348521

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

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

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata3/rsl_1/rsl.data1 2097160192 3 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata3/rsl_2/rsl.data2 2097160192 4 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata3/rsl_3/rsl.data3 2097160192 5 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata3/rsl_4/rsl.data4 2097160192 6 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata3/rsl_5/rsl.data5 2097160192 7 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_10/rsl.data10 2097160192 12 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_11/rsl.data11 5242888192 27 2069 NOLINK FILE 5242880000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_12/rsl.data12 10737426432 28 2069 NOLINK FILE 10737418240 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_13/rsl.data13 9466552320 29 2069 NOLINK FILE 10737418240 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_14/rsl.data14 8355061760 30 2069 NOLINK FILE 10737418240 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_15/rsl.data15 8187289600 31 2069 NOLINK FILE 10737418240 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_6/rsl.data6 2097160192 8 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_7/rsl.data7 2097160192 9 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_8/rsl.data8 2097160192 10 2069 NOLINK FILE 2097152000 20971520

PSAPRSL ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl_9/rsl.data9 2097160192 11 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata1/rsl640_1/rsl640.data1 2097160192 13 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata1/rsl640_2/rsl640.data2 2097160192 14 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata1/rsl640_3/rsl640.data3 2097160192 15 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata1/rsl640_4/rsl640.data4 2097160192 16 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata1/rsl640_5/rsl640.data5 2097160192 17 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata2/rsl640_10/rsl640.data10 2097160192 22 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata2/rsl640_6/rsl640.data6 2097160192 18 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata2/rsl640_7/rsl640.data7 2097160192 19 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata2/rsl640_8/rsl640.data8 2097160192 20 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata2/rsl640_9/rsl640.data9 2097160192 21 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata3/rsl640_11/rsl640.data11 2097160192 23 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl640_12/rsl640.data12 2097160192 24 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl640_13/rsl640.data13 2097160192 25 2069 NOLINK FILE 2097152000 20971520

PSAPRSL640 ONLINE* ONLINE+ /oracle/RSL/sapdata4/rsl640_14/rsl640.data14 2411732992 34 2069 NOLINK FILE 10485760000 20971520

PSAPRSLUSR ONLINE* ONLINE+ /oracle/RSL/sapdata4/rslusr_1/rslusr.data1 20979712 26 2069 NOLINK FILE 2097152000 20971520

PSAPTEMP ONLINE# ONLINE+ /oracle/RSL/sapdata1/temp_1/temp.data1 2097160192 -1 2069 NOLINK FILE 2097152000 20971520

PSAPUNDO ONLINE- ONLINE+ /oracle/RSL/sapdata1/undo_1/undo.data1 2097160192 2 2069 NOLINK FILE 2097152000 20971520

PSAPUNDO ONLINE- ONLINE /oracle/RSL/sapdata1/undo_2/undo.data2 2097160192 32 2069 NOLINK FILE 0 0

SYSTEM ONLINE* SYSTEM+ /oracle/RSL/sapdata1/system_1/system.data1 639639552 1 2069 NOLINK FILE 2097152000 20971520

SYSTEM ONLINE* SYSTEM+ /oracle/RSL/sapdata1/system_2/system.data2 639639552 33 2069 NOLINK FILE 2097152000 20971520

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/RSL/origlogA/log_g11m1.dbf 52429312 1 2053 INUSE NOLINK FILE

/oracle/RSL/mirrlogA/log_g11m2.dbf 52429312 1 2069 INUSE NOLINK FILE

/oracle/RSL/origlogB/log_g12m1.dbf 52429312 2 2054 INUSE NOLINK FILE

/oracle/RSL/mirrlogB/log_g12m2.dbf 52429312 2 2069 INUSE NOLINK FILE

/oracle/RSL/origlogA/log_g13m1.dbf 52429312 3 2053 INUSE NOLINK FILE

/oracle/RSL/mirrlogA/log_g13m2.dbf 52429312 3 2069 INUSE NOLINK FILE

/oracle/RSL/origlogB/log_g14m1.dbf 52429312 4 2054 INUSE NOLINK FILE

/oracle/RSL/mirrlogB/log_g14m2.dbf 52429312 4 2069 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/RSL/origlogA/cntrl/cntrlRSL.dbf 7397376 0 2053 NOLINK FILE

/oracle/RSL/sapdata1/system_1/cntrl/cntrlRSL.dbf 7397376 0 2069 NOLINK FILE

/oracle/RSL/saparch/cntrl/cntrlRSL.dbf 7397376 0 2069 NOLINK FILE

BR0280I BRBACKUP time stamp: 2008-08-20 16.55.15

BR0057I Backup of database: RSL

BR0058I BRBACKUP action ID: bdyqbcxm

BR0059I BRBACKUP function ID: ant

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/RSL/sapbackup/cntrlRSL.dbf

BR0061I 35 files found for backup, total size 93591.320 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/nst0

BR0103I Following backup volume will be used: RSLB02

BR0289I BRARCHIVE will be started at the end of processing

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

BR0208I Volume with name RSLB02 required in device /dev/nst0

BR0280I BRBACKUP time stamp: 2008-08-20 16.55.15

BR0226I Rewinding tape volume in device /dev/st0 ...

BR0351I Restoring /oracle/RSL/sapbackup/.tape.hdr0

BR0355I from /dev/nst0 ...

BR0241I Checking label on volume in device /dev/nst0

BR0242I Scratch volume in device /dev/nst0 will be renamed to RSLB02

BR0280I BRBACKUP time stamp: 2008-08-20 16.55.15

BR0226I Rewinding tape volume in device /dev/st0 ...

BR0202I Saving /oracle/RSL/sapbackup/.tape.hdr0

BR0203I to /dev/nst0 ...

BR0209I Volume in device /dev/nst0 has name RSLB02

BR0202I Saving init_ora

BR0203I to /dev/nst0 ...

BR0202I Saving /oracle/RSL/920_32/dbs/initRSL.sap

BR0203I to /dev/nst0 ...

BR0280I BRBACKUP time stamp: 2008-08-20 16.55.24

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-08-20 16.55.25

BR0315I 'Alter tablespace PSAPRSL begin backup' successful

BR0202I Saving /oracle/RSL/sapdata3/rsl_1/rsl.data1

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata3/rsl_1/rsl.data1

#SAVED.... rsl.data1 RSLB02/4

BR0280I BRBACKUP time stamp: 2008-08-20 16.56.43

BR0063I 1 of 35 files processed - 2000.008 MB of 93591.320 MB done

BR0204I Percentage done: 2.14%, estimated end time: 18:03

BR0001I *_________________________________________________

BR0202I Saving /oracle/RSL/sapdata3/rsl_2/rsl.data2

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata3/rsl_2/rsl.data2

#SAVED.... rsl.data2 RSLB02/5

BR0280I BRBACKUP time stamp: 2008-08-20 16.57.50

BR0063I 2 of 35 files processed - 4000.016 MB of 93591.320 MB done

BR0204I Percentage done: 4.27%, estimated end time: 17:55

BR0001I **________________________________________________

BR0202I Saving /oracle/RSL/sapdata3/rsl_3/rsl.data3

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata3/rsl_3/rsl.data3

#SAVED.... rsl.data3 RSLB02/6

BR0280I BRBACKUP time stamp: 2008-08-20 16.58.58

BR0063I 3 of 35 files processed - 6000.023 MB of 93591.320 MB done

BR0204I Percentage done: 6.41%, estimated end time: 17:53

BR0001I ***_______________________________________________

BR0202I Saving /oracle/RSL/sapdata3/rsl_4/rsl.data4

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata3/rsl_4/rsl.data4

#SAVED.... rsl.data4 RSLB02/7

BR0280I BRBACKUP time stamp: 2008-08-20 17.00.08

BR0063I 4 of 35 files processed - 8000.031 MB of 93591.320 MB done

BR0204I Percentage done: 8.55%, estimated end time: 17:52

BR0001I ****______________________________________________

BR0202I Saving /oracle/RSL/sapdata3/rsl_5/rsl.data5

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata3/rsl_5/rsl.data5

#SAVED.... rsl.data5 RSLB02/8

BR0280I BRBACKUP time stamp: 2008-08-20 17.01.24

BR0063I 5 of 35 files processed - 10000.039 MB of 93591.320 MB done

BR0204I Percentage done: 10.68%, estimated end time: 17:52

BR0001I *****_____________________________________________

BR0202I Saving /oracle/RSL/sapdata4/rsl_10/rsl.data10

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata4/rsl_10/rsl.data10

#SAVED.... rsl.data10 RSLB02/9

BR0280I BRBACKUP time stamp: 2008-08-20 17.02.41

BR0063I 6 of 35 files processed - 12000.047 MB of 93591.320 MB done

BR0204I Percentage done: 12.82%, estimated end time: 17:53

BR0001I ******____________________________________________

BR0202I Saving /oracle/RSL/sapdata4/rsl_11/rsl.data11

BR0203I to /dev/nst0 ...

#FILE..... /oracle/RSL/sapdata4/rsl_11/rsl.data11

#SAVED.... rsl.data11 RSLB02/10

BR0280I BRBACKUP time stamp: 2008-08-20 17.05.36

BR0063I 7 of 35 files processed - 17000.055 MB of 93591.320 MB done

BR0204I Percentage done: 18.16%, estimated end time: 17:52

BR0001I *********_________________________________________

BR0202I Saving /oracle/RSL/sapdata4/rsl_12/rsl.data12

BR0203I to /dev/nst0 ...

BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/RSL/sapdata4/rsl_12/rsl.data12 of=/dev/nst0':

dd: writing to `/dev/nst0': Input/output error

116125+0 records in

116124+0 records out

dd: closing output file `/dev/nst0': Input/output error

BR0280I BRBACKUP time stamp: 2008-08-20 17.11.36

BR0279E Return code from 'LANG=C dd obs=64k bs=64k if=/oracle/RSL/sapdata4/rsl_12/rsl.data12 of=/dev/nst0': 1

BR0222E Copying /oracle/RSL/sapdata4/rsl_12/rsl.data12 to/from /dev/nst0 failed due to previous errors

BR0280I BRBACKUP time stamp: 2008-08-20 17.11.38

BR0317I 'Alter tablespace PSAPRSL end backup' successful

BR0056I End of database backup: bdyqbcxm.ant 2008-08-20 17.11.36

BR0280I BRBACKUP time stamp: 2008-08-20 17.11.38

BR0054I BRBACKUP terminated with errors

Pl give your valuable solution

Regards,

Atul Karajgi