Skip to Content
author's profile photo Former Member
Former Member

onLine / Offline backup fails with error BR0278E

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Aug 21, 2008 at 11:01 AM

    Hi,

    Please check the characteristics of a tapedrive & change the block size 000 & than run again backup.

    Karan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2008 at 11:32 AM

    Hi,

    Please reinitialize tape with following command:

    brbackup -i force -v <volume_name>

    Then try taking backup again.

    Hope it will help you.

    Regards,

    Keyur Dave

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2008 at 05:11 AM

    Hi Atul,

    If your problem resolved than please mark thread answered.And if you post a thred than follow your thread.

    Karan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 07:22 AM

    initilizing tape volume solved the querry.

    Thanks

    Atul

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.