Home » RDBMS Server » Backup & Recovery » rman and Tivoli backup
rman and Tivoli backup [message #531115] Sun, 13 November 2011 11:24 Go to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
I am rying to change my backup to go directly to tape and
I am encountering the error below. Has anybody see this
type of error before and if so how can it be fixed?

Is RMAN trying to load a shared library?

Thanks to all who answer


RMAN> show all;
RMAN configuration parameters for database with db_unique_name OTAPDEV are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u10/otapdev/sp
file_control_files/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa
ult
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(MAXOPENFILES=1,BLKSIZE=2
097152,TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(MAXOPENFILES=1,BLKSIZE=2
097152,TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(MAXOPENFILES=1,BLKSIZE=2
097152,TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(MAXOPENFILES=1,BLKSIZE=2
097152,TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u10/otapdev/spfile_control_files/snapcf
_otapdev.f';

RMAN>
sql statement: alter system archive log current

RMAN> 2>
Starting backup at 11-11-2011 15:12:12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/11/2011 15:12:13
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2

Re: rman and Tivoli backup [message #531116 is a reply to message #531115] Sun, 13 November 2011 11:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
19554, 00000, "error allocating device, device type: %s, device name: %s"
// *Cause:  The specified device could not be allocated.
// *Action: One or more other messages should be displayed to help pinpoint
//          the cause of the error.  Correct the error and retry the
//          allocation.
bcm@bcm-laptop:~$ oerr ora 27211
27211, 00000, "Failed to load Media Management Library"
// *Cause:  User-supplied SBT_LIBRARY or libobk.so could not be loaded. Call
//          to dlopen for media library returned error. See Additional
//          information for error code.
// *Action: Retry the command with proper media library. Or re-install
//          Media management module for Oracle.
Re: rman and Tivoli backup [message #531122 is a reply to message #531116] Sun, 13 November 2011 12:08 Go to previous messageGo to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
Thanks, it sounded like I was missing a shared library but
was not 100% sure since this is my first time setting this up.
Re: rman and Tivoli backup [message #531128 is a reply to message #531122] Sun, 13 November 2011 13:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to buy the MML for your tape management software.
In your case, it is TDPO (Tivoli Data Protection for Oracle). Ask your IBM contact.
With it comes a manual that gives you how to create the shared library and to link it with RMAN.

Regards
Michel
Re: rman and Tivoli backup [message #531956 is a reply to message #531128] Fri, 18 November 2011 14:46 Go to previous messageGo to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
I found the problem for those of you who are interested


My LD_LIBRARY_PATH was set like this:

echo $LD_LIBRARY_PATH
/u01/app/oracle/product/11g/lib:/u01/app/oracle/product/11g/rdbms/lib

Therefore it could not find the libobk.a library.. So I created
a link in $ORACLE_HOME/lib to point to the actual library.

$ pwd
/u01/app/oracle/product/11g/lib


$ ls -tlr libobk.a
lrwxrwxrwx    1 root     system           17 Nov 14 13:02 libobk.a -> /usr/lib/libobk.a




Re: rman and Tivoli backup [message #531958 is a reply to message #531956] Fri, 18 November 2011 14:55 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: restore issue
Next Topic: duplicate database error : ORA-01405: fetched column value is NULL
Goto Forum:
  


Current Time: Wed Apr 17 22:35:42 CDT 2024