on 03-26-2014 3:43 PM
Hi,
We have oracle database 11g on RHEL.
Every once in a while we have issues with the backup sometimes related with TSM backup server and sometimes the issue comes even when there is no issue with the backup server.
Currently in our landscape we have issues in few SAP servers where the backup is not completing and going on error.
We have enabled RMAN to take the Full(levle-0) and follow it by incremental backup(levle-1) on week days.
By looking at the log of the backup, can I infer where the problem lies? Or do I need to check something else?
BR0278E Command output of 'SHELL=/bin/sh /oracle/<sid>/112_64/bin/rman nocatalog':
Recovery Manager: Release 11.2.0.2.0 - Production on Sat Mar 22 22:30:42 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: <sid> (DBID=2563681139)
using target database control file instead of recovery catalog
RMAN> **end-of-file**
RMAN>
host command complete
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
Thanks,
Rakesh
We have started to see the failure of the backups(incremental as well as the Full) in few other systems as well.
Can't check the TSM server log but when I check the TSM client log there were many errors logged in the dsierror.log file.
03/28/2014 09:00:55 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:03 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:03 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:03 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:03 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:03 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:03 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:08 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:08 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:08 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:08 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:08 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:08 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:08 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:08 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:08 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:32:10 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:10 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:10 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:10 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:10 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:10 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:10 ANS5216E Could not establish a TCP/IP connection with address 'x.y.z:p'. The TCP/IP error is 'Connection refused' (errno = 111).
03/28/2014 10:32:10 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.
03/28/2014 10:32:10 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 10:36:18 ANS1017E Session rejected: TCP/IP connection failure
03/28/2014 11:01:05 cuFSUpd: Received rc: -50 trying to read a EndTxn verb
03/28/2014 11:01:05 ANS1017E Session rejected: TCP/IP connection failure
This looks like network issue ...However I can telnet to the backup server suucessfully.
How can be sure that it is indeed network issue.
I can telent to the backup server successfully.
Thanks,
Rakesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Roman and Sumit.
@Reagan, We have been doing import in the whole landscape and the issues is rather intermittent which crops up every once in a while, 2-3 times in a month.
So I would consider the reinstalling the TDP later.
Can you please suggest if this particular piece of log means anything..
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on sbt_1 channel at 03/25/2014 21:42:06
ORA-19509: failed to delete sequential file, handle="<sid>_benmjqnr.7518_1", parms="ENV=(XINT_PROFILE=/oracle/<sid>/112_64/dbs/init<sid>R.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=benmjqnr.fnr)"
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
BKI9300E: Additional support information: Aborting 'send' operation. See previous error.
ORA-27191: sbtinfo2 returned error
Regards,
Rakesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rakesh
Could you upload the complete backup log please?
Is this error coming after implementing RMAN for the backup ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Reagan for your reply.
No, It's been more than a year when we implemented the RMAN configuration.
This is off and on situation when we face for backup.
Find the error log below:
Detail log: | benmjqnr.fnr |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BR0051I BRBACKUP 7.20 (34)
BR0055I Start of database backup: benmjqnr.fnr 2014-03-25 19.00.59
BR0484I BRBACKUP log file: /oracle/<sid>/sapbackup/benmjqnr.fnr
BR0477I Oracle pfile /oracle/<sid>/112_64/dbs/init<sid>.ora created from spfile /oracle/<sid>/112_64/dbs/spfile<sid>.ora
BR0101I Parameters
Name | Value |
oracle_sid | <sid> |
oracle_home | /oracle/<sid>/112_64 |
oracle_profile | /oracle/<sid>/112_64/dbs/init<sid>.ora |
sapdata_home | /oracle/<sid> |
sap_profile | /oracle/<sid>/112_64/dbs/init<sid>R.sap |
backup_mode | FULL |
backup_type | online |
backup_dev_type | rman_util |
util_par_file | /oracle/<sid>/112_64/dbs/init<sid>R.utl |
rman_channels | 1 |
rman_filesperset | 0 |
rman_proxy | no |
rman_parms | ENV=(XINT_PROFILE=/oracle/<sid>/112_64/dbs/init<sid>R.utl,PROLE_PORT=57323,&BR_INFO) |
rman_compress | no |
system_info | <sid>adm/ora<sid> prdat150v Linux 2.6.18-274.12.1.el5 #1 SMP Tue Nov 8 21:37:35 EST 2011 x86_64 |
oracle_info | <sid> 11.2.0.2.0 8192 10749 333108290 prdat150v UTF8 UTF8 2563681139 &<sid> |
sap_info | 701 SAPSR3 0002LK0003<sid>0011J15290865030013NetWeaver_ORA |
make_info | linuxx86_64 OCI_102 Sep 7 2013 720_REL |
command_line | brbackup -u / -jid FLLOG20140311190000 -c force -t online -m full -p init<sid>R.sap -a -c force -p init<sid>.sap -cds |
br_env | NLS_LANG=AMERICAN_AMERICA.UTF8, |
ORACLE_SID=<sid>, | |
ORACLE_BASE=/oracle, | |
TNS_ADMIN=/usr/sap/<sid>/SYS/profile/oracle, | |
SAPDATA_HOME=/oracle/<sid>, | |
JAVA_HOME=/usr/lib/jvm/java-1.4.2-ibm-sap-1.4.2.13.10.sap.x86_64, | |
DB_SID=<sid>, | |
SAPSYSTEMNAME=<sid>, | |
ORACLE_HOME=/oracle/<sid>/112_64 |
BR0116I ARCHIVE LOG LIST before backup for database instance <sid>
Parameter | Value |
Database log mode | Archive Mode |
Automatic archival | Enabled |
Archive destination | LOCATION=/oracle/<sid>/oraarch/<sid>arch |
Archive format | %t_%s_%r.dbf |
Oldest online log sequence | 10746 |
Next log sequence to archive 10749
Current log sequence | 10749 | SCN: 333108290 |
Database block size | 8192 | Thread: 1 |
Current system change number 333161115 | ResetId: 786742323 |
BR0118I Tablespaces and data files
Tablespace | TS-Status F-Status File | Size Id. | Device Link | Type | MaxSize | IncrSize BlkSize | CrtSize | CrtScn | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sr3_1/sr3.data1 | 23068680192 | 4 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 192916 | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sr3_40/sr3.data40 | 23068680192 50 | 64797 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 4553747 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_10/sr3.data10 | 23068680192 13 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 195769 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_11/sr3.data11 | 23068680192 14 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 196101 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_2/sr3.data2 | 23068680192 | 5 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 193253 | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_3/sr3.data3 | 23068680192 | 6 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 193579 | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_4/sr3.data4 | 23068680192 | 7 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 193887 | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_5/sr3.data5 | 23068680192 | 8 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 194234 | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_6/sr3.data6 | 23068680192 | 9 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 194542 | |
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_7/sr3.data7 | 23068680192 10 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 194848 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_8/sr3.data8 | 23068680192 11 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 195156 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata2/sr3_9/sr3.data9 | 23068680192 12 | 64792 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 195463 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_12/sr3.data12 | 23068680192 15 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 196408 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_13/sr3.data13 | 23068680192 16 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 196716 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_14/sr3.data14 | 23068680192 17 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 197019 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_15/sr3.data15 | 23068680192 18 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 197349 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_16/sr3.data16 | 23068680192 19 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 197658 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_17/sr3.data17 | 23068680192 20 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 197967 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_18/sr3.data18 | 23068680192 21 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 198279 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_19/sr3.data19 | 23068680192 22 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 198585 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_20/sr3.data20 | 23068680192 23 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 198892 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata3/sr3_21/sr3.data21 | 23068680192 24 | 64793 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 199200 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_22/sr3.data22 | 23068680192 25 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 199507 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_23/sr3.data23 | 23068680192 26 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 199813 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_24/sr3.data24 | 23068680192 27 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 200126 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_25/sr3.data25 | 23068680192 28 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 200781 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_26/sr3.data26 | 23068680192 29 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 201088 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_27/sr3.data27 | 23068680192 30 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 201393 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_28/sr3.data28 | 23068680192 31 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 201700 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_29/sr3.data29 | 23068680192 32 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 202014 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_30/sr3.data30 | 23068680192 33 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 202322 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata4/sr3_31/sr3.data31 | 23068680192 34 | 64794 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 202629 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_32/sr3.data32 | 23068680192 35 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 202939 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_33/sr3.data33 | 23068680192 36 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 203243 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_34/sr3.data34 | 23068680192 37 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 203747 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_35/sr3.data35 | 23068680192 38 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 204056 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_36/sr3.data36 | 23068680192 39 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 204365 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_37/sr3.data37 | 23068680192 40 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 204673 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_38/sr3.data38 | 23068680192 41 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 205191 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata5/sr3_39/sr3.data39 | 26214408192 49 | 64795 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 4550265 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata6/sr3_41/sr3.data41 | 23068680192 51 | 64796 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 23364723 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata6/sr3_42/sr3.data42 | 23068680192 52 | 64796 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 148239357 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata6/sr3_43/sr3.data43 | 23068680192 53 | 64796 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 148239360 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata6/sr3_44/sr3.data44 | 23068680192 54 | 64796 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 148239363 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata6/sr3_45/sr3.data45 | 23068680192 55 | 64796 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 154032339 | ||
PSAPSR3 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata6/sr3_46/sr3.data46 | 23068680192 56 | 64796 NOLINK FILE 26214400000 | 524288000 | 8192 23068672000 | 206631076 | ||
PSAPSR3701 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sr3701_1/sr3701.data1 | 20971528192 42 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 205507 | ||
PSAPSR3701 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sr3701_2/sr3701.data2 | 20971528192 43 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 205815 | ||
PSAPSR3701 | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sr3701_3/sr3701.data3 | 20971528192 44 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 206150 | ||
PSAPSR3USR | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sr3usr_1/sr3usr.data1 | 10485768192 45 | 64797 NOLINK FILE 12582912000 | 524288000 | 8192 10485760000 | 206441 | ||
PSAPTEMP | ONLINE# | ONLINE+ /oracle/<sid>/sapdata5/temp_1/temp.data1 | 23068680192 -1 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 3263 | ||
PSAPTEMP | ONLINE# | ONLINE+ /oracle/<sid>/sapdata5/temp_2/temp.data2 | 23068680192 -2 | 64795 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 207783 | ||
PSAPUNDO | ONLINE- | ONLINE+ /oracle/<sid>/sapdata1/undo_1/undo.data1 | 20971528192 | 3 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 2896 | |
PSAPUNDO | ONLINE- | ONLINE+ /oracle/<sid>/sapdata1/undo_2/undo.data2 | 20971528192 46 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 206904 | ||
PSAPUNDO | ONLINE- | ONLINE+ /oracle/<sid>/sapdata1/undo_3/undo.data3 | 20971528192 47 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 207212 | ||
PSAPUNDO | ONLINE- | ONLINE+ /oracle/<sid>/sapdata1/undo_4/undo.data4 | 20971528192 48 | 64797 NOLINK FILE 23068672000 | 524288000 | 8192 20971520000 | 207522 | ||
SYSAUX | ONLINE* | ONLINE+ /oracle/<sid>/sapdata1/sysaux_1/sysaux.data1 | 2097160192 | 2 | 64797 NOLINK FILE | 3145728000 | 524288000 | 8192 2097152000 | 1818 |
SYSTEM | ONLINE* | SYSTEM+ /oracle/<sid>/sapdata1/system_1/system.data1 | 2097160192 | 1 | 64797 NOLINK FILE | 3145728000 | 524288000 | 8192 2097152000 | 10 |
BR0119I Redolog files
File | Size Group | Device Status | Link | Type |
/oracle/<sid>/origlogA/log_g11m1.dbf | 209715712 | 1 | 64787 INUSE | NOLINK FILE |
/oracle/<sid>/mirrlogA/log_g11m2.dbf | 209715712 | 1 | 64789 INUSE | NOLINK FILE |
/oracle/<sid>/origlogB/log_g12m1.dbf | 209715712 | 2 | 64788 INUSE | NOLINK FILE |
/oracle/<sid>/mirrlogB/log_g12m2.dbf | 209715712 | 2 | 64790 INUSE | NOLINK FILE |
/oracle/<sid>/origlogA/log_g13m1.dbf | 209715712 | 3 | 64787 INUSE | NOLINK FILE |
/oracle/<sid>/mirrlogA/log_g13m2.dbf | 209715712 | 3 | 64789 INUSE | NOLINK FILE |
/oracle/<sid>/origlogB/log_g14m1.dbf | 209715712 | 4 | 64788 INUSE | NOLINK FILE |
/oracle/<sid>/mirrlogB/log_g14m2.dbf | 209715712 | 4 | 64790 INUSE | NOLINK FILE |
BR0120I Control files
File | Size Id. | Device Link | Type |
/oracle/<sid>/origlogA/cntrl/cntrl<sid>.dbf | 19513344 | 0 | 64787 NOLINK FILE |
/oracle/<sid>/origlogB/cntrl/cntrl<sid>.dbf | 19513344 | 0 | 64788 NOLINK FILE |
/oracle/<sid>/sapdata1/cntrl/cntrl<sid>.dbf | 19513344 | 0 | 64797 NOLINK FILE |
BR0280I BRBACKUP time stamp: 2014-03-25 19.01.04
BR0057I Backup of database: <sid>
BR0058I BRBACKUP action ID: benmjqnr
BR0059I BRBACKUP function ID: fnr
BR0110I Backup mode: FULL
BR0077I Database file for backup: /oracle/<sid>/sapbackup/cntrl<sid>.dbf
BR0061I 57 files found for backup, total size 1169019.047 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: rman_util
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0280I BRBACKUP time stamp: 2014-03-25 19.01.04
BR0504I Starting full database backup (level 0) using RMAN...
BR0280I BRBACKUP time stamp: 2014-03-25 19.01.08
BR0202I Saving /oracle/<sid>/sapdata5/sr3_39/sr3.data39 ...
BR0280I BRBACKUP time stamp: 2014-03-25 19.18.23
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7505_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 19.18.23
BR0202I Saving /oracle/<sid>/sapdata2/sr3_2/sr3.data2 ...
BR0280I BRBACKUP time stamp: 2014-03-25 19.31.50
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7506_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 19.31.50
BR0202I Saving /oracle/<sid>/sapdata3/sr3_12/sr3.data12 ...
BR0280I BRBACKUP time stamp: 2014-03-25 19.37.26
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7507_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 19.37.26
BR0202I Saving /oracle/<sid>/sapdata4/sr3_22/sr3.data22 ...
BR0280I BRBACKUP time stamp: 2014-03-25 19.46.11
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7508_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 19.46.11
BR0202I Saving /oracle/<sid>/sapdata1/sr3_1/sr3.data1 ...
BR0280I BRBACKUP time stamp: 2014-03-25 19.55.17
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7509_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 19.55.17
BR0202I Saving /oracle/<sid>/sapdata2/sr3_3/sr3.data3 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.02.23
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7510_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.02.24
BR0202I Saving /oracle/<sid>/sapdata3/sr3_13/sr3.data13 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.15.40
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7511_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.15.40
BR0202I Saving /oracle/<sid>/sapdata4/sr3_23/sr3.data23 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.23.25
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7512_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.23.25
BR0202I Saving /oracle/<sid>/sapdata1/sr3_40/sr3.data40 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.27.50
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7513_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.27.50
BR0202I Saving /oracle/<sid>/sapdata2/sr3_4/sr3.data4 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.33.26
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7514_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.33.26
BR0202I Saving /oracle/<sid>/sapdata3/sr3_14/sr3.data14 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.39.03
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7515_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.39.03
BR0202I Saving /oracle/<sid>/sapdata4/sr3_24/sr3.data24 ...
BR0280I BRBACKUP time stamp: 2014-03-25 20.44.29
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7516_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 20.44.29
BR0202I Saving /oracle/<sid>/sapdata5/sr3_32/sr3.data32 ...
BR0280I BRBACKUP time stamp: 2014-03-25 21.06.20
BR0521I Backup of database file save set piece - piece handle=<sid>_benmjqnr.7517_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
BR0280I BRBACKUP time stamp: 2014-03-25 21.06.20
BR0202I Saving /oracle/<sid>/sapdata2/sr3_5/sr3.data5 ...
BR0278E Command output of 'SHELL=/bin/sh /oracle/<sid>/112_64/bin/rman nocatalog':
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Mar 25 19:01:04 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: <sid> (DBID=2563681139)
using target database control file instead of recovery catalog
RMAN> **end-of-file**
RMAN>
host command complete
RMAN> 2> 3> 4> 5>
allocated channel: sbt_1
channel sbt_1: SID=56 device type=SBT_TAPE
channel sbt_1: Data Protection for SAP(R)
Starting backup at 25-MAR-14
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00049 name=/oracle/<sid>/sapdata5/sr3_39/sr3.data39
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7505_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:17:15
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/<sid>/sapdata2/sr3_2/sr3.data2
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7506_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:13:27
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/oracle/<sid>/sapdata3/sr3_12/sr3.data12
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7507_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:05:36
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00025 name=/oracle/<sid>/sapdata4/sr3_22/sr3.data22
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7508_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:08:45
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/<sid>/sapdata1/sr3_1/sr3.data1
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7509_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:09:06
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/oracle/<sid>/sapdata2/sr3_3/sr3.data3
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7510_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:07:06
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00016 name=/oracle/<sid>/sapdata3/sr3_13/sr3.data13
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7511_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:13:16
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00026 name=/oracle/<sid>/sapdata4/sr3_23/sr3.data23
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7512_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:07:45
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00050 name=/oracle/<sid>/sapdata1/sr3_40/sr3.data40
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7513_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:04:25
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/oracle/<sid>/sapdata2/sr3_4/sr3.data4
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7514_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:05:36
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00017 name=/oracle/<sid>/sapdata3/sr3_14/sr3.data14
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7515_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:05:37
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00027 name=/oracle/<sid>/sapdata4/sr3_24/sr3.data24
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7516_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:05:26
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00035 name=/oracle/<sid>/sapdata5/sr3_32/sr3.data32
channel sbt_1: starting piece 1 at 25-MAR-14
channel sbt_1: finished piece 1 at 25-MAR-14
piece handle=<sid>_benmjqnr.7517_1 tag=BENMJQNR comment=API Version 2.0,MMS Version 6.2.1.3
channel sbt_1: backup set complete, elapsed time: 00:21:51
channel sbt_1: starting incremental level 0 datafile backup set
channel sbt_1: specifying datafile(s) in backup set
input datafile file number=00008 name=/oracle/<sid>/sapdata2/sr3_5/sr3.data5
channel sbt_1: starting piece 1 at 25-MAR-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on sbt_1 channel at 03/25/2014 21:42:06
ORA-19509: failed to delete sequential file, handle="<sid>_benmjqnr.7518_1", parms="ENV=(XINT_PROFILE=/oracle/<sid>/112_64/dbs/init<sid>R.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=benmjqnr.fnr)"
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
BKI9300E: Additional support information: Aborting 'send' operation. See previous error.
ORA-27191: sbtinfo2 returned error
RMAN>
List of Backup Sets
===================
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7484 | Incr 0 24.25G | SBT_TAPE | 00:17:12 | 25-MAR-14 |
BP Key: 7484 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7505_1 Media: TSM_disk |
List of Datafiles in backup set 7484
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
49 0 Incr 333161161 25-MAR-14 /oracle/<sid>/sapdata5/sr3_39/sr3.data39
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7485 | Incr 0 20.09G | SBT_TAPE | 00:13:24 | 25-MAR-14 |
BP Key: 7485 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7506_1 Media: TSM_disk |
List of Datafiles in backup set 7485
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
5 | 0 Incr 333162582 25-MAR-14 /oracle/<sid>/sapdata2/sr3_2/sr3.data2 |
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7486 | Incr 0 20.34G | SBT_TAPE | 00:05:26 | 25-MAR-14 |
BP Key: 7486 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7507_1 Media: TSM_disk |
List of Datafiles in backup set 7486
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
15 0 Incr 333166132 25-MAR-14 /oracle/<sid>/sapdata3/sr3_12/sr3.data12
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7487 | Incr 0 19.61G | SBT_TAPE | 00:08:38 | 25-MAR-14 |
BP Key: 7487 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7508_1 Media: TSM_disk |
List of Datafiles in backup set 7487
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
25 0 Incr 333166688 25-MAR-14 /oracle/<sid>/sapdata4/sr3_22/sr3.data22
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7488 | Incr 0 19.67G | SBT_TAPE | 00:09:00 | 25-MAR-14 |
BP Key: 7488 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7509_1 Media: TSM_disk |
List of Datafiles in backup set 7488
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
4 | 0 Incr 333167418 25-MAR-14 /oracle/<sid>/sapdata1/sr3_1/sr3.data1 |
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7489 | Incr 0 19.98G | SBT_TAPE | 00:07:03 | 25-MAR-14 |
BP Key: 7489 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7510_1 Media: TSM_disk |
List of Datafiles in backup set 7489
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
6 | 0 Incr 333168264 25-MAR-14 /oracle/<sid>/sapdata2/sr3_3/sr3.data3 |
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7490 | Incr 0 20.55G | SBT_TAPE | 00:13:10 | 25-MAR-14 |
BP Key: 7490 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7511_1 Media: TSM_disk |
List of Datafiles in backup set 7490
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
16 0 Incr 333168952 25-MAR-14 /oracle/<sid>/sapdata3/sr3_13/sr3.data13
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7491 | Incr 0 19.83G | SBT_TAPE | 00:07:41 | 25-MAR-14 |
BP Key: 7491 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7512_1 Media: TSM_disk |
List of Datafiles in backup set 7491
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
26 0 Incr 333170195 25-MAR-14 /oracle/<sid>/sapdata4/sr3_23/sr3.data23
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7492 | Incr 0 17.92G | SBT_TAPE | 00:04:16 | 25-MAR-14 |
BP Key: 7492 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7513_1 Media: TSM_disk |
List of Datafiles in backup set 7492
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
50 0 Incr 333173160 25-MAR-14 /oracle/<sid>/sapdata1/sr3_40/sr3.data40
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7493 | Incr 0 19.89G | SBT_TAPE | 00:05:32 | 25-MAR-14 |
BP Key: 7493 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7514_1 Media: TSM_disk |
List of Datafiles in backup set 7493
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
7 | 0 Incr 333173458 25-MAR-14 /oracle/<sid>/sapdata2/sr3_4/sr3.data4 |
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7494 | Incr 0 20.39G | SBT_TAPE | 00:05:35 | 25-MAR-14 |
BP Key: 7494 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7515_1 Media: TSM_disk |
List of Datafiles in backup set 7494
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
17 0 Incr 333173895 25-MAR-14 /oracle/<sid>/sapdata3/sr3_14/sr3.data14
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7495 | Incr 0 19.95G | SBT_TAPE | 00:05:20 | 25-MAR-14 |
BP Key: 7495 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7516_1 Media: TSM_disk |
List of Datafiles in backup set 7495
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
27 0 Incr 333174413 25-MAR-14 /oracle/<sid>/sapdata4/sr3_24/sr3.data24
BS Key Type LV Size | Device Type Elapsed Time Completion Time |
------- ---- -- ---------- ----------- ------------ ---------------
7496 | Incr 0 20.41G | SBT_TAPE | 00:21:46 | 25-MAR-14 |
BP Key: 7496 Status: AVAILABLE Compressed: NO Tag: BENMJQNR | ||||
Handle: <sid>_benmjqnr.7517_1 Media: TSM_disk |
List of Datafiles in backup set 7496
File LV Type Ckp SCN | Ckp Time Name |
---- -- ---- ---------- --------- ----
35 0 Incr 333174852 25-MAR-14 /oracle/<sid>/sapdata5/sr3_32/sr3.data32
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2014-03-25 21.42.11
BR0279E Return code from 'SHELL=/bin/sh /oracle/<sid>/112_64/bin/rman nocatalog': 1
BR0522E 14 of 56 files / save sets processed by RMAN
BR0536E RMAN call for database instance <sid> failed
BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: /oracle/<sid>/sapbackup/.benmjqnr.cmd
@/oracle/<sid>/sapbackup/..benmjqnr..cmd
host '/usr/sap/<sid>/SYS/exe/run/brtools -f delete /oracle/<sid>/sapbackup/..benmjqnr..cmd';
run { allocate channel sbt_1 device type 'SBT_TAPE'
parms 'ENV=(XINT_PROFILE=/oracle/<sid>/112_64/dbs/init<sid>R.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=benmjqnr.fnr)';
backup incremental level 0 tag benmjqnr format '<sid>_benmjqnr.%s_%p' filesperset 1 check logical
database;
release channel sbt_1; }
list backup of database tag benmjqnr;
exit;
BR0280I BRBACKUP time stamp: 2014-03-25 21.42.11
BR0506E Full database backup (level 0) using RMAN failed
BR0056I End of database backup: benmjqnr.fnr 2014-03-25 21.42.11
BR0280I BRBACKUP time stamp: 2014-03-25 21.42.13
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2014-03-25 21.42.13
BR0291I BRARCHIVE will be started with options '+benmjqnr.fnr -U -jid FLLOG20140311190000 -c force -p init<sid>.sap -cds'
BR0280I BRBACKUP time stamp: 2014-03-25 21.42.17
BR0292I Execution of BRARCHIVE finished with return code 0
Thanks,
Rakesh
Hello Rakesh
If the issue is not happening all the time then I will rule out the possibility of having an issue with the configuration in the database server.
Based on my experience this is due to some issue at the backup server and If the backup works one day and fails on the third day then the backup server/software is having a problem. If this was due to some configuration then the backup would have never worked.
Also the errors in the backup log is diverting to the backup software. My guess is this could be due to a badly installed TDP / backup client software. I would get the TSM team investigate this issue and if required re-install or update the TDP software and let them configure the settings in the backup server.
Refer to this SAP note 636847 - Composite SAP note ORA-19511
Regards
RB
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.