IntelliSnap Restore - Oracle RAC - PFILE Issue

Last post 06-13-2018, 11:44 AM by PedroRocha. 4 replies.
Sort Posts: Previous Next
  • IntelliSnap Restore - Oracle RAC - PFILE Issue
    Posted: 06-13-2018, 9:43 AM

    Hello everyone!

    I am trying to restore one table from a intellisnap backup of a RAC DB (11.2 on Unix).

    Backup runs fine and during restore I am getting an error with the sga_target parameter used on the auto-generated pfile.

    I am not specifing a pfile during restore, but the auto-generated pfile is specifying a small sga_target (512M). This sga size is not sufficient and the restore fails.

    Is there any way (w/o specifing a pfile) to change the default sga_target used by commvault during the generation of the pfile for a restore?

    Kind regards,

    Pedro Rocha

  • Re: IntelliSnap Restore - Oracle RAC - PFILE Issue
    Posted: 06-13-2018, 10:20 AM
    • efg is not online. Last active: 12-06-2019, 8:50 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Master
    • Points 1,687

    Hi Pedro,

    I believe you want this setting:  sSGATARGET

    This needs to be set on the destination (where the auxiliary instance will get created)

    Let us know if this helps.

    Ernst F. Graeler
    Senior Engineer III
  • Re: IntelliSnap Restore - Oracle RAC - PFILE Issue
    Posted: 06-13-2018, 10:21 AM

    Please use this registry key to set the required SGA in auto generated file


    Shankar Reddy Vullupala
    Manager, UNIX DB
  • Re: IntelliSnap Restore - Oracle RAC - PFILE Issue
    Posted: 06-13-2018, 10:28 AM

    Hi Pedro,

    You need to set this registry key on the physical destination client where the auxilary instance runs. If you are using the RAC instance, it will be the first instance in the streams


    During table restore if no auxiliary instance is specified we create the auxiliary instance. For this auxiliary instance, default value for sga_target parameter is 512M which means the max shared memory limit for auxilary instance is 512M User can specify a different value by setting this registry key sSGATARGET
    If you need to set any other additional parameter in the pfile, you can us this registry key sORACLE_AUX_PARAMETER
    Use this additional setting to add Oracle parameters to Oracle PFILE. The Commvault software adds the lines to the Oracle PFILE. The parameters only apply when you select the option to have Commvault create the auxiliary instance for a clone, table restore or duplicate database. The maximum length is 4K. If you need to add additional parameters, then create up to 4 additional settings that end with the next consective even number (sORACLE_AUX_PARAMETER_0, sORACLE_AUX_PARAMETER_2) Separate each parameter by a semi-colon (;). Example Add the parameters DB_4K_CACHE_SIZE=4M and DB_16K_CACHE_SIZE=2G sORACLE_AUX_PARAMETER DB_16K_CACHE_SIZE=2G;DB_4K_CACHE_SIZE=4M
    Let me know if this helps.
  • Re: IntelliSnap Restore - Oracle RAC - PFILE Issue
    Posted: 06-13-2018, 11:44 AM


    Yes that is the one!

    Thank you once more for the prompt answer.


    Pedro Rocha

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.
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy