Skip to main content
Start a Conversation

Unsolved

This post is more than 5 years old

tonyyesudas

2 Posts

9244

November 27th, 2012 18:00

Backup error when trying to run Oracle Full backup using RMAN

Hi all,

I am getting the following error when trying to backup Oracle 11. Two log file attached. The error "ORA-27191: sbtinfo2 returned error" is happening at different point of the back at each instance of the back. The avamar client was updated from   5.0.105.169 to 6.0.101.66 after which we have this issue.

Also attached id the avtar.log file and sbtio.log file  

"Avamar PRD Full Backup Log" 27/11/2012 22:00:00.29

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Nov 27 22:00:00 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: PRD (DBID=1804684268)

RMAN> run {
2>
3> configure controlfile autobackup on;
4> set controlfile autobackup format for device type sbt to 'CONTROLFILE.PRD.%F';
5> allocate channel c1 type 'sbt_tape'
6> PARMS="SBT_LIBRARY=c:\progra~1\avs\bin\orasbt64.dll, ENV=(PATH=c:\progra~1\avs\bin)";
7> send '"--prefix=11g/PRD/" "--flagfile=C:\flags.txt" "--cacheprefix=c1" ';
8> backup filesperset 1 database plus archivelog ;
9> delete archivelog all completed before 'sysdate-1';
10> release channel c1;
11>
12> }
13>
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: c1
channel c1: SID=207 device type=SBT_TAPE
channel c1: EMC|Avamar (avtar backup)

sent command to channel: c1


Starting backup at 27-NOV-12
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20731 RECID=36239 STAMP=800275921
channel c1: starting piece 1 at 27-NOV-12
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/27/2012 22:00:34
ORA-27191: sbtinfo2 returned error
ORA-19511: Error received from media manager layer, error text:
(UTF-8) sbtinfo2: avtar failed with error code -1

Recovery Manager complete.
"End of log " 27/11/2012 22:00:35.17

---------

another log

"Avamar PRD Full Backup Log" 23/11/2012 23:45:55.17

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Nov 23 23:45:55 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: PRD (DBID=1804684268)

RMAN> run {
2>
3> configure controlfile autobackup on;
4> set controlfile autobackup format for device type sbt to 'CONTROLFILE.PRD.%F';
5> allocate channel c1 type 'sbt_tape'
6> PARMS="SBT_LIBRARY=c:\progra~1\avs\bin\orasbt64.dll, ENV=(PATH=c:\progra~1\avs\bin)";
7> send '"--prefix=11g/PRD/" "--flagfile=C:\flags.txt" "--cacheprefix=c1" ';
8> backup filesperset 1 database plus archivelog ;
9> delete archivelog all completed before 'sysdate-1';
10> release channel c1;
11>
12> }
13>
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: c1
channel c1: SID=22 device type=SBT_TAPE
channel c1: EMC|Avamar (avtar backup)

sent command to channel: c1


Starting backup at 23-NOV-12
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20657 RECID=36092 STAMP=800023875
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n0nr2k1s_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20658 RECID=36094 STAMP=800026516
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n1nr2k2l_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20659 RECID=36096 STAMP=800029873
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n2nr2k35_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20660 RECID=36097 STAMP=800035240
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n3nr2k3u_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20661 RECID=36100 STAMP=800038841
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n4nr2k4o_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20662 RECID=36102 STAMP=800043615
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n5nr2k57_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:16
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20663 RECID=36103 STAMP=800047915
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n6nr2k5n_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20664 RECID=36105 STAMP=800055017
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n7nr2k6g_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20665 RECID=36108 STAMP=800060407
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n8nr2k7a_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20666 RECID=36109 STAMP=800064738
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=n9nr2k7p_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20667 RECID=36111 STAMP=800067667
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nanr2k88_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20668 RECID=36114 STAMP=800067733
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nbnr2k8o_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20669 RECID=36116 STAMP=800070034
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=ncnr2k97_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:26
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20670 RECID=36118 STAMP=800072390
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=ndnr2ka1_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20671 RECID=36119 STAMP=800073035
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nenr2kag_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20672 RECID=36121 STAMP=800078919
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nfnr2kba_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20673 RECID=36123 STAMP=800080260
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=ngnr2kbp_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20674 RECID=36125 STAMP=800083825
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nhnr2kcj_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20675 RECID=36127 STAMP=800091047
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=ninr2kdc_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20676 RECID=36130 STAMP=800093076
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=njnr2ke5_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20677 RECID=36132 STAMP=800093446
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nknr2kel_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20678 RECID=36133 STAMP=800094822
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nlnr2kf4_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:16
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20679 RECID=36136 STAMP=800096526
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nmnr2kfk_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:15
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20680 RECID=36138 STAMP=800099495
channel c1: starting piece 1 at 23-NOV-12
channel c1: finished piece 1 at 23-NOV-12
piece handle=nnnr2kg3_1_1 tag=TAG20121123T234603 comment=API Version 2.0,MMS Version 6.0.101.66
channel c1: backup set complete, elapsed time: 00:00:26
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20681 RECID=36140 STAMP=800101231
channel c1: starting piece 1 at 23-NOV-12
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/23/2012 23:54:30
ORA-27191: sbtinfo2 returned error
ORA-19511: Error received from media manager layer, error text:
(UTF-8) sbtinfo2: avtar failed with error code -1

Recovery Manager complete.
"End of log " 23/11/2012 23:54:30.88

---

2 Attachments

Sandeep_Sinha

307 Posts

November 28th, 2012 22:00

The backup seems to be failing with the error :

ORA-19511: Error received from media manager layer

The possible reasons for this error could be :

* The /var/avamar directory does not have correct permissions to start a backup.

The /var/avamar directory must have read, write, and execute permissions. For Avamar 4.1.100 and later, correct permissions are set for this directory during the RMAN plug-in installation. For Avamar 4.0.x and earlier, you must manually change the permissions to 777 at the directory level.

* Either RMAN or libobk cannot locate avtar.

The allocate channel command in the RMAN backup or restore script must include AVAMARHOME/bin as the PATH variable or include bindir="/usr/local/avamar/bin".
This requirement applies to Avamar 4.1.105 and later.

* An Oracle instance is running as a nonstandard user or group.

To determine if Oracle is installed as a nonstandard user or group, check the file permissions for the Oracle home directory.For example:

cd /home/oracle/oracle/product/10.2.0/db_1/oradata
ls -l
total 28
drwxr-x--- 2 oracle oinstall 4096 Aug 26 2009 cataloged
drwxr-x--- 2 oracle oinstall 4096 Mar 9 18:05 db2
drwxr-xr-x 2 oracle oinstall 4096 Mar 30 17:21 orcl
drwxr-xr-x 2 oracle oinstall 4096 Mar 30 16:26 orcl.w
drwxr-xr-x 2 oracle oinstall 4096 Mar 10 15:50 plargedb
drwxr-xr-x 2 oracle oinstall 4096 Feb 6 16:20 plargedb.w
-rw-r--r-- 1 oracle oinstall 696 Dec 28 16:58 sqlnet.log

In the example, “oracle” is the user and “oinstall” is the group.

If a user other than oracle installs the Oracle database, the avoracle program must use the

--storageapp_username=USERNAME option. For example, if the user named emc installs
the Oracle database, USERNAME is emc.

MArgrz

4 Posts

June 27th, 2019 08:00

But I don't understand the relationship with that answer

ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
(UTF-8) sbtinfo2: avtar failed with error code 1

 

 (UTF-8):  ¿ NLS error ? ,,,,   

avtar failed with error code 1:  ¿allocate channel Error ?

 

after Avamar 4 is necessary set --bindir ,also -flagfile .  I did it , but same error

View More

View All

No Events found!

Top