on 08-21-2008 11:24 AM
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
initilizing tape volume solved the querry.
Thanks
Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Atul,
If your problem resolved than please mark thread answered.And if you post a thred than follow your thread.
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check the characteristics of a tapedrive & change the block size 000 & than run again backup.
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.