Recently after database out-of-place upgrade to a higher version (11.2.0.x to 11.2.0.x+1), TAPE backup started failing with following error
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE SBT;
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_2 channel at 01/02/2012 02:27:30
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
As this was an out-of-place upgrade, ORACLE_HOME has changed. Due to ORACLE_HOME change, link between oracle MML & vendor libraries is broken.
1. Verify the link
Db-01:ORCL:/u01/app/oracle/product/11.2.0.x/database/lib>ls -al | grep obk | wc -l
2. Create the required link
$ ln -s /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a
3. Verify the link again
Db-01:ORCL:/u01/app/oracle/product/11.2.0.x/database/lib>ls -al | grep obk
lrwxrwxrwx 1 oracle dba 19 Feb 01 05:45 libobk.a -> /usr/lib/libobk64.a
NOTE: I’m using tdpo (Tivoli/TDP for oracle) as my TAPE library solution. The steps I’ve mentioned are specific to tdpo. Location for other media vendor library files will be different.
Once this link was established, I was able to run the TAPE backups again