This discussion is archived
9 Replies Latest reply: Aug 22, 2013 2:19 AM by botang(唐波) RSS

RMAN Backup to tape using Oracle Secure Backup

799814 Newbie
Currently Being Moderated

I am trying to take 11g R2 (11.2.0.3) database backup using RMAN. I am using Oracle Secure Backup for configuring virtual tape library and virtual tape drive.

 

Whenever, I am running the RMAN backup script it simply hangs. While checking the backup job status from Oracle Secure Backup web interface, the job status are displaying 'pending resource availability'.

 

On, furthur investigating the job, the following error message are displayed,

 

" Dispatching job to run on oradb. Drive or volume on which mount attempted is unusable".

 

Library and Tape Creation:

 

mkdev -t library -o -S 4 -a oradb:/vlib -v vlib

mkdev -t tape -o -a ora11:/vt -v -l vlib -d 1 vt

 

Not able to fix this error. Need help

 

Message was edited by: 799814

  • 1. Re: RMAN Backup to tape using Oracle Secure Backup
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    Please see some answered threads for the same issue:

    https://forums.oracle.com/thread/1018216?start=0&tstart=299

     

    Check if it helps!

    Best Regards,

  • 2. Re: RMAN Backup to tape using Oracle Secure Backup
    rdoogan Journeyer
    Currently Being Moderated

    Looking at those attach points I'd say this isn't a proper setup. Do you have an actual tape unit or certified virtual library? It looks to me like you've setup some kind of fake VTL which won't be supported by OSB.

     

    Thanks

     

    Rich

  • 3. Re: RMAN Backup to tape using Oracle Secure Backup
    799814 Newbie
    Currently Being Moderated

    Hi Rich,

     

    I am testing RMAN backup to tape. I do not have any tape unit. Trying to test the backup via virtual library and tape drive using OSB.

  • 4. Re: RMAN Backup to tape using Oracle Secure Backup
    rdoogan Journeyer
    Currently Being Moderated

    Sorry that isn't a supported configuration.

     

    Thanks

     

    Rich

  • 6. Re: RMAN Backup to tape using Oracle Secure Backup
    rdoogan Journeyer
    Currently Being Moderated

    That's not an Oracle document and it is 6 years old. OSB does not provide a virtual library. There are some free/opensource ones but they are not supported either so I can't comment on if they work or not.

     

    Thanks

     

    Rich

  • 7. Re: RMAN Backup to tape using Oracle Secure Backup
    botang(唐波) Explorer
    Currently Being Moderated

    There is a VTL: http://mhvtl-linux-virtual-tape-library-community-forums.966029.n3.nabble.com/

      really work well with OSB 10.3.0.3 64bit, the version of it, fully tested by me , is 1.2

     

    The installation guide of it here:

     

     

     

    mh virtual tape & library system.

     

     

    Instructions assume reader is familiar with the kernel build process.

     

    There are two sections of code to build.

    - The kernel module

    - The user-space daemons.

     

    Kernel module mhvtl:

    ==================

    1) Make sure the kernel-devel package to match your running kernel is installed.

    e.g.

    RedHat AS 4 & 5:

    # rpm -qa|grep kernel

    kernel-2.6.9-34.0.1.EL

    kernel-devel-2.6.9-34.0.1.EL

    kernel-2.6.9-5.EL

    kernel-devel-2.6.9-5.EL

    kernel-utils-2.4-13.1.80

     

    SLES 9 & 10:

    # rpm -qa|grep kernel

     

     

    2) Extract the mhvtl source code.

    # tar xvfz mhvtl-2012-04-04.tgz

     

    3) Change directory into the kernel driver source.

    # cd mhvtl-1.2/kernel/

    # make

    # make install

     

     

    User space daemons:

    ===================

    Pre-req for a running mhvtl

    - sg3_utils (http://sg.danny.cz/sg/sg3_utils.html)

     

    Pre-req to build/compile userspace:

    - zlib-devel

     

    * To build an RPM

      ===============

    cp mhvtl-YYYY-MM-DD.tar.gz /usr/src/packages/SOURCE/

    cd /usr/src/packages/SOURCE

    rpmbuild -tb mhvtl-YYYY-MM-DD.tar.gz

    <wait for rpm build to complete>

    rpm -Uvh /usr/src/packages/RPMS/<cpu type>/mhvtl-1.2-z.<cpu type>.rpm

    (The rpm install will create system group & accounts vtl)

    - Note: For RedHat, replace 'packages' with 'redhat'

     

    * To build from tar archive (Debian / Ubuntu):

      ============================================

    apt-get install lsscsi

    apt-get install sg3_utils

     

    To limit damage that may occur by wayward daemons, I highly recommend creating

    a group and user called 'vtl'

    # /usr/sbin/groupadd --system vtl

    # /usr/sbin/useradd --system -c "Vitrual Tape Library" -d /opt/vtl -g vtl -m vtl

     

    Now build user space daemons:

    From the parent directory where you extracted the source.

    # cd mhvtl-1.2

     

    Build the binaries

    # make

     

    Install the rc script into /etc/init.d/ and binaries to /usr/local/bin/

    # make install

     

    Start daemons:

    /etc/init.d/mhvtl start

     

    Test:

    Note: Make sure the 'mtx' & 'lsscsi' utilities are installed

    The virtual devices are attached to HBA #5 in this example.

    e.g.

    # lsscsi -g

    [0:0:0:0]    disk    ATA      WDC WD1200BEVS-0 02.0  /dev/sda  /dev/sg0

    [3:0:0:0]    cd/dvd  Optiarc  DVD RW AD-7910A  1.D1  /dev/sr0  /dev/sg1

    [5:0:0:0]    mediumx SPECTRA  PYTHON           5500  /dev/sch0  /dev/sg6

    [5:0:1:0]    tape    QUANTUM  SDLT600          5500  /dev/st0  /dev/sg2

    [5:0:2:0]    tape    QUANTUM  SDLT600          5500  /dev/st1  /dev/sg3

    [5:0:3:0]    tape    IBM      ULT3580-TD4      5500  /dev/st2  /dev/sg4

    [5:0:4:0]    tape    IBM      ULT3580-TD4      5500  /dev/st3  /dev/sg5

     

     

    # mtx -f /dev/sg6 status

      Storage Changer /dev/sg6:4 Drives, 37 Slots ( 4 Import/Export )

    Data Transfer Element 0:Empty

    Data Transfer Element 1:Empty

    Data Transfer Element 2:Empty

    Data Transfer Element 3:Empty

          Storage Element 1:Full :VolumeTag=SDLT01S3                           

          Storage Element 2:Full :VolumeTag=SDLT02S3                           

          Storage Element 3:Full :VolumeTag=SDLT03S3                           

          Storage Element 4:Full :VolumeTag=SDLT04S3                           

          Storage Element 5:Full :VolumeTag=SDLT05S3                           

          Storage Element 6:Full :VolumeTag=SDLT06S3                           

          Storage Element 7:Full :VolumeTag=SDLT07S3                           

          Storage Element 8:Full :VolumeTag=SDLT08S3                           

          Storage Element 9:Full :VolumeTag=SDLT09S3                           

          Storage Element 10:Empty

          Storage Element 11:Full :VolumeTag=ULT001L1                           

          Storage Element 12:Full :VolumeTag=ULT002L2                           

          Storage Element 13:Full :VolumeTag=ULT003L3                           

          Storage Element 14:Full :VolumeTag=ULT004L4                           

          Storage Element 15:Full :VolumeTag=ULT005L1                           

          Storage Element 16:Full :VolumeTag=ULT006L2                           

          Storage Element 17:Full :VolumeTag=ULT007L3                           

          Storage Element 18:Full :VolumeTag=ULT008L4                           

          Storage Element 19:Full :VolumeTag=ULT009L1                           

          Storage Element 20:Empty

          Storage Element 21:Full :VolumeTag=8MM001X4                           

          Storage Element 22:Full :VolumeTag=8MM002X4                           

          Storage Element 23:Full :VolumeTag=8MM003X4                           

          Storage Element 24:Full :VolumeTag=8MM004X4                           

          Storage Element 25:Empty

          Storage Element 26:Empty

          Storage Element 27:Empty

          Storage Element 28:Empty

          Storage Element 29:Empty

          Storage Element 30:Empty

          Storage Element 31:Full :VolumeTag=CLN001L1                           

          Storage Element 32:Full :VolumeTag=CLN002L1                           

          Storage Element 33:Full :VolumeTag=CLN003L1                           

          Storage Element 34 IMPORT/EXPORT:Empty

          Storage Element 35 IMPORT/EXPORT:Empty

          Storage Element 36 IMPORT/EXPORT:Empty

          Storage Element 37 IMPORT/EXPORT:Empty

     

     

    Enjoy.

     

    Please feel free in letting me know if this works for you.

     

    Bug fixes and suggestions always welcome.

     

    markh794@gmail.com

    mark_harvey@symantec.com

  • 8. Re: RMAN Backup to tape using Oracle Secure Backup
    rdoogan Journeyer
    Currently Being Moderated

    Remember that this is in no way supported or even tested and there is no guarantee that your data is intact when using such opensource VTLs. The OSB hardware guide lists all the supported virtual and physical libraries/drives.

     

    http://www.oracle.com/technetwork/products/secure-backup/learnmore/index.html

     

    Thanks

     

    Rich

  • 9. Re: RMAN Backup to tape using Oracle Secure Backup
    botang(唐波) Explorer
    Currently Being Moderated

    Thanks for mention above,

       I don't mean the VTL shoud be used in production environment, it may be used in a test enviroment or education environment.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points