13 Replies Latest reply: Mar 18, 2011 6:05 PM by Levi Pereira RSS

    how to check if tape available in RMAN

    848025
      sql statement: alter system archive log current

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of allocate command on t1 channel at 03/16/2011 08:58:55
      ORA-19554: error allocating device, device type: SBT_TAPE, device name:
      ORA-27211: Failed to load Media Management Library
      Additional information: 2

      Recovery Manager complete.
        • 1. Re: how to check if tape available in RMAN
          emre baransel
          can you send your allocate channel command.
          • 2. Re: how to check if tape available in RMAN
            tychos
            Hi,
            It looks like your libobk.so is not linked to your backup vendor supplied rman library.
            You need this before yao can run direct rman tape backups.
            Regards,
            Tycho
            • 3. Re: how to check if tape available in RMAN
              848025
              hi Tycho, I didn't find libobk.so in the $ORACLE_HOME/lib path. where is the vendor tape library


              connect catalog user/pass@catdb
              connect target /
              set echo on;
              run {
              sql 'alter system archive log current';
              allocate channel t1 type 'sbt_tape' format 'TRAIN1_HOT_201103181053_%U%t';
              setlimit channel t1 kbytes 2000000 maxopenfiles 16 readrate 200;
              backup full database filesperset=16 TAG='TRAIN1_HOT.....18-MAR-11_10:53';
              release channel t1;
              sql 'alter system archive log current';
              }
              exit

              Edited by: user5451383 on Mar 18, 2011 7:54 AM

              Edited by: user5451383 on Mar 18, 2011 8:15 AM
              • 4. Re: how to check if tape available in RMAN
                emre baransel
                As tychos said it may be a softlink issue, did you check it? But the error may also occur by another problem. Which tape vendor do you use?

                If it's legato you can use NSR_DEBUG_FILE=/some/path/debug.log inside the allocate command to see what is going wrong. I don't know the debug way for the other vendors but you can find by googling.
                • 5. Re: how to check if tape available in RMAN
                  19426
                  I don't see any reference to media management software in your 'allocate channel' command, RMAN cannot read/write directly from/to tape, it needs proper configuration.

                  For a general discussion see

                  http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmconfb.htm#i1006526
                  • 6. Re: how to check if tape available in RMAN
                    848025
                    thanks Emre, that is quick response. mine is TSM. no clue where to find the library. no soft link in oracle_home\lib.
                    • 7. Re: how to check if tape available in RMAN
                      DBA_1976
                      What is your OS? if it is linux or unix

                      run /usr/openv/netbackup/bin/oracle_link. You should be logged in as the oracle user. This will create all the soft links and connect the oracle and netbackup libraries.

                      Then try running the backup
                      • 8. Re: how to check if tape available in RMAN
                        19426
                        TSM is different from netbackup.

                        To OP:

                        I hope you also have Tivoli Data Protection for Oracle software, TSM basic software, which backs up filesystems is not enough to use RMAN.

                        IF you have it, refer to the installation guide for your version. It tells you all details.


                        Werner
                        • 9. Re: how to check if tape available in RMAN
                          848025
                          thanks it is hpux, the path doesn't exist on my server
                          • 10. Re: how to check if tape available in RMAN
                            848025
                            Hi Werner, I don't know about the TSM. how can you tell if it is RMAN problem or TSM problem? please give detail advice.
                            • 11. Re: how to check if tape available in RMAN
                              19426
                              You have to check with your system management which TSM components are installed. You need TSM for Databases as add-on, not only the basic product:

                              http://www-01.ibm.com/software/tivoli/products/storage-mgr-db/platforms.html

                              http://www-01.ibm.com/software/tivoli/products/storage-mgr

                              Werner
                              • 12. Re: how to check if tape available in RMAN
                                tychos
                                Hi,
                                On top of the base install of Tivoli backup software (for your OS level backup) you need to install an extra library (Tivoli Data Protection for Oracle).
                                If this has been done already by your sysadmin it has the following default location on HP.
                                /opt/tivoli/tsm/client/oracle/bin64
                                Next to that you need to buy a license to make it work.
                                If this has been setup you need to create a sym link in OH/lib so you have a libobk.so linked to the tivoli library.
                                how to check if tape available in RMAN?
                                Now you are ready to test the setup as the oracle user with sbttest.
                                Syntax < sbttest test.out -trace sbttest.trace >
                                Regards,
                                Tycho
                                • 13. Re: how to check if tape available in RMAN
                                  Levi Pereira
                                  Hi,

                                  I'll assume that you have skill in TSM or at least someone that has this knowledge to configure TSM, because configure TPD for Oracle is not a simple task.

                                  Just complementing previous replies.

                                  This problem is usually caused by three situations, if you installed the TDP for Oracle successfully.

                                  Situation A: LIB not configured properly.
                                  Situation B: Oracle user don't have permition to write on LOG (DSMI_LOG)
                                  Situation C: TDP not contains valid license

                                  You must create a simbolic link on $ORACLE_HOME/lib/libobk.so
                                  cd $ORACLE_HOME/lib
                                  
                                  32bit
                                  ln -s libobk.so /opt/tivoli/tsm/client/oracle/bin/libobk.so
                                  
                                  or
                                  
                                  64bit
                                  ln -s libobk.so /opt/tivoli/tsm/client/oracle/bin64/libobk64.so
                                  Check this parameter on tdpo.opt
                                  cat /opt/tivoli/tsm/client/oracle/tdpo.opt
                                  ...
                                  DSMI_LOG            /u01/tdp/logs
                                  ...
                                  You must configure permission to oracle be able read,write on this directory "/u01/tdp/logs". Usually I set this directory as the Oracle owner.

                                  If the lib is configured properly you can find the error on file ERRORLOGNAME:
                                  cat  /opt/tivoli/tsm/client/ba/bin/dsm.sys
                                  
                                  e.g
                                  ...
                                   ERRORLOGName         /TSMData/Logs/dsmerror_Oracle.log
                                  ...
                                  You can test if TPD is configured properly using this command:
                                  ./tdpoconf SHOWENV -TDPO_OPTfile=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt
                                  
                                  Check if last line will appear:
                                  License Information:  License file exists and contains valid license data.
                                  I hope this help you.

                                  Regards,
                                  Levi Pereira

                                  Edited by: Levi Pereira on Mar 18, 2011 5:35 PM

                                  Edited by: Levi Pereira on Mar 18, 2011 5:45 PM