Oracle & MMSQL Backup Practies

Last post 04-28-2014, 1:35 PM by AIB. 2 replies.
Sort Posts: Previous Next
  • Oracle & MMSQL Backup Practies
    Posted: 04-27-2014, 1:21 PM

    I have some oracle as well MSSQL agents installed in CommCell. 

    What is the best practies of backing up the DBs.

    Should i take a full backup on like Saturday and then incremental backups until next Saturday?

    The backup options avaliable in MSSQL are (full, Transaction Log & Differential)

    The backup options avaliable in Oracle are (Full & oracle incremental level)

  • Re: Oracle & MMSQL Backup Practies
    Posted: 04-28-2014, 9:26 AM
    • efg is not online. Last active: 05-18-2018, 5:52 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,447

    It's kind of difficult to state what would be best for your environment...   That relies more on what your requirements are. 

    Oracle iDA has the capability of performing online and offline backups.  Also for incremental, there are incremental levels 1 through 4 as well as cumulative incrementals.  In addition to this is also the archive log backups where a subclient can be created to perform more frequent log backups if desired.

    Have you considered reaching out to your account team to arrange a PS engagement?  The Professional Services team from CommVault, can perform a site evaluation, based on your requirements and help with an implementation design that would be conducive to your environment and business requirements.  I have worked with the PS team on numerous occasions (For Oracle iDA roll-outs) they are quite good at configuring and implementing the Oracle iDA.  I believe they can also assist with the implementation of MSSQL iDA as well.

    Ernst F. Graeler
    Product Specialist
    Applications and File Systems
  • Re: Oracle & MMSQL Backup Practies
    Posted: 04-28-2014, 1:35 PM

    Thanks for your recommendation and i bit they are good. However, i don't need PS, our DB is not big yet. we have around 10 DBs and the size of each DB is not more then 15 GB. 

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