Home » RDBMS Server » Backup & Recovery » RMAN & TAPE Library TS3100 (oracle 11gR2 at Red Hat advanced server 5.5)
RMAN & TAPE Library TS3100 [message #508690] Tue, 24 May 2011 01:44 Go to next message
mirasraf
Messages: 48
Registered: June 2006
Location: DHAKA
Member

Hi,
I take backup database with RMAN utility . Now
without any third-party software I want to take backup database with RMAN utility and put on TAPE LIBRARY TS3100 . and I got error message.plz guide me how to configure TAPE library for RMAN

RMAN> run {
2> allocate channel stb1 device type stb format '/dev/IBMtape0/Full_dwhtest2_%T_%s';
3> backup ( database include current controlfile );
4> backup format '/dev/IBMtape0/Arc_dwhtest2_%T_%s' ( archivelog all);
5> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on stb1 channel at 05/22/2011 19:47:14
ORA-19554: error allocating device, device type: STB, device name:
ORA-27001: unsupported device type
Re: RMAN & TAPE Library TS3100 [message #508691 is a reply to message #508690] Tue, 24 May 2011 01:50 Go to previous messageGo to next message
John Watson
Messages: 4566
Registered: January 2010
Location: Global Village
Senior Member
Typo! SBT, not STB
Re: RMAN & TAPE Library TS3100 [message #508692 is a reply to message #508691] Tue, 24 May 2011 01:59 Go to previous messageGo to next message
mirasraf
Messages: 48
Registered: June 2006
Location: DHAKA
Member

Thanks to quick view. It will be SBT. I change my RMAN script and run but error

RMAN> run {
2> allocate channel stb1 DEVICE TYPE sbt PARMS 'SBT_LIBRARY=/usr/bin/lin_taped';
3> backup ( database include current controlfile );
4> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on stb1 channel at 05/23/2011 15:44:14
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 3970

run {
allocate channel stb1 DEVICE TYPE sbt PARMS 'SBT_LIBRARY=/lib/modules/2.6.18-194.el5/kernel/drivers/scsi/lin_tape.ko';
backup format '/dev/IBMtape0/Arc_dwhtest2_%T_%s' ( database);
}

please guide me.
Re: RMAN & TAPE Library TS3100 [message #508711 is a reply to message #508692] Tue, 24 May 2011 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your MML is not install or has a wrong configuration.
error 3970 comes from the MML, see its documentation to know its meaning.

Regards
Michel
Re: RMAN & TAPE Library TS3100 [message #509247 is a reply to message #508711] Thu, 26 May 2011 11:14 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member

Ok before looking into MML configuration do you have "libobk.so" files in your ORACLE_HOME?

Babu
Re: RMAN & TAPE Library TS3100 [message #509475 is a reply to message #509247] Sat, 28 May 2011 04:19 Go to previous messageGo to next message
mirasraf
Messages: 48
Registered: June 2006
Location: DHAKA
Member

Hi babu ,

Thanks to reply, I could not find file "libobk.so" at $ORACLE_HOME . Tape library installed before oracle software.


Regards

Asraf
Re: RMAN & TAPE Library TS3100 [message #510227 is a reply to message #509475] Fri, 03 June 2011 00:34 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member

Ok then you can create one soft link from your media manager lib

Example:
ln -s /vendor/lib/oracle_lib.so $ORACLE_HOME/lib/libobk.soo

[Updated on: Fri, 03 June 2011 00:35]

Report message to a moderator

Re: RMAN & TAPE Library TS3100 [message #511187 is a reply to message #510227] Fri, 10 June 2011 01:05 Go to previous message
Michel Cadot
Messages: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or rather:

ln -s /vendor/lib/oracle_lib.so $ORACLE_HOME/lib/libobk.so


Regards
Michel
Previous Topic: ORA-19554: error allocating device, device type: SBT_TAPE, device name:
Next Topic: EBU - Job Failed
Goto Forum:
  


Current Time: Fri Sep 19 14:59:22 CDT 2014

Total time taken to generate the page: 0.25140 seconds