Oracle Rman restore opens 2 commvault threads

Last post 02-16-2018, 12:09 PM by efg. 7 replies.
Sort Posts: Previous Next
  • Oracle Rman restore opens 2 commvault threads
    Posted: 02-12-2018, 2:40 PM

    Hello,

    We have made a backup using rman. backup was catalogue in CommVault as a command line backup.

    So far so good.

    The problem appears when we do the restore. When we launch it opens 2 different restore processes in CommVault and one of them always show an error (buffer type).

    We are using the following script:

    allocate auxiliary channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base64/libobk.a,BLKSIZE=1048576,ENV=(CVClientName=clientname01,CVInstanceName=Instance001,CvOraSID=SIGA)";
    allocate auxiliary channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base64/libobk.a,BLKSIZE=1048576,ENV=(CVClientName=clientname01,CVInstanceName=Instance001,CvOraSID=SIGA)";

    duplicate database xxxxxxxx
    nofilenamecheck

     

    Can anyone help understanding why this is happening and how to solve this?

    Regards,

    Stg

  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-12-2018, 3:12 PM
    • efg is not online. Last active: 02-20-2018, 4:08 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,416

    Hi Stg,

    What version of Commvault are you running?   Most of the ENV parameters are no longer required.

    Also is this RAC or non-RAC?  There are differences when dealing with RAC iDA.

    Let us know.

    BTW the parameters are case sensitive: SBT Parameters

    CvClientName, CvInstanceName

    And CvOraSid should only be needed if the Instance (ORACLE_SID) is not the same as the DB Name.


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-12-2018, 5:40 PM

    Hello,

    CommVault V11SP10.

    It’s a  non RAC with multiple instances.

    I just think it’s strange because it opens 2 different processes for the same duplicate/restore and 1 of them returns  CvArchive returned wrong buf_type=135.

    What’s wrong with the command? All backup pieces are available on the CommVault...

     

    Regards,

    Stg

  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-12-2018, 6:05 PM
    • efg is not online. Last active: 02-20-2018, 4:08 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,416

    OK, then you should not need to use the ENV parameter in this case.   Try the restore without any of the ENV parameters.   Is the instance name the same as the DB name (as it's defined in Commvault)?  If so then you don't need the CvOraSID parameter either.  Let us know if that works.


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-14-2018, 5:39 AM

    Hello,

    The auxiliary instance is not configured in commvault yet. After the duplicate we will add it.

    The instance name of the source DB is the same as defined in Commvault.

    is it mandatory to have the auxiliary database configured?

    We will run the duplicate using the following command:

    allocate auxiliary channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base64/libobk.a,BLKSIZE=1048576";
    allocate auxiliary channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base64/libobk.a,BLKSIZE=1048576";

    duplicate database xxxxxxxx
    nofilenamecheck
     
    Regards,
    Stg
  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-15-2018, 9:13 AM
    • efg is not online. Last active: 02-20-2018, 4:08 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,416

    Hi Stg,

    Is the auxiliary instance on the same server as the target instance or is it on another server?


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-16-2018, 9:36 AM

    Hello,

    Its on the same server.

    Regards,

    Stg

  • Re: Oracle Rman restore opens 2 commvault threads
    Posted: 02-16-2018, 12:09 PM
    • efg is not online. Last active: 02-20-2018, 4:08 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,416

    Hi Stg,

    I have a small lab environment so I decided to test this myself, and was able to duplicate a database called ora1db to an instance called devdb on the same server.  The instance devdb is NOT configured in Commvault, but the source is getting backed up (using 2 streams/channels) and so I scripted the restore to also use 2 streams/channels as well.  I have created 3 text files:

    Duplicate ORA1DB to DEVDB initfile.txt

    Duplicate ORA1DB to DEVDB script.txt

    Duplicate ORA1DB to DEVDB output.txt

    That contain the init file (for the auxiliary instance) the script file (that I called from the RMAN session) as well the output file (that contains the entire RMAN session plus RMAN output.)

    Let me know if this helps, and if you are able to run the duplicate.

    Note that I did not have to add ANY of the ENV parameters into the RMAN script, and the 3rd party command restore ran as a single job ID in Commvault using both channels/streams to transfer the data.


    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2018 Commvault | All Rights Reserved. | Legal | Privacy Policy