SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS

Last post 12-29-2020, 6:46 AM by Rene.Sarodnick. 6 replies.
Sort Posts: Previous Next
  • SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 11-25-2020, 11:40 AM

    Hi Team,

    We dont want take full mount point backup of redo logs , it will take time also till backup get complete, it will not delete any logs from OS. Instead we want to take 20-30 logs backup ,so it will finish quickly and also delete these logs from OS.

    In TSM we have option of "-n" using which we can provide number of logs like "-n 20"

     

    Now we have migrated to commvault. SAP team is asking same option is available in commvault or not.

     

    It will help us to reduce the redo log size quickly from OS.

     

    Regards,

    Harpreetsingh

  • Re: SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 11-25-2020, 1:48 PM
    • efg is not online. Last active: 01-03-2021, 8:12 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Master
    • Points 1,767

    There is an option in Commvault to create an automatic schedule for certain database agents to backup and clear logs based on threshold settings.  Take a look at this link to the documentation and let us know if this helps:  Creating an Automatic Schedule for Database Log Backups

     


    Ernst F. Graeler
    Senior Engineer III
    Development
  • Re: SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 11-25-2020, 2:40 PM

    if you are looking for a manual archive log backup , there is an option to backup with sequence number in the advanced tab > Backup Archive Logs

     

  • Re: SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 11-25-2020, 2:43 PM
  • Re: SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 11-26-2020, 4:24 AM

    Thanks for reply, but we are running the backup from cmmand line , we have 3rd party tool UC4 for backup job scheduling. 

    So we are looking for any way from command line to run minimum 20 archives to free up the space quickly ?

    If there is any work around please let me know.

  • Re: SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 12-01-2020, 10:28 AM

    you can generate a xml file while triggering the manual archive log backup and review the parameter and update the same in your custom script

  • Re: SAP for Oracle - How to take 20 redo logs backup to reduce the size of redo log mount point from OS
    Posted: 12-29-2020, 6:46 AM

    Hey,

    you can mostly use the same commands you are using with TSM, if you say you are using -n 20 .... Just executed from command line it will trigger a 3rd party command line backup with your commcell (regardless, i think you need to create the client and DB instance in commvault).

    When you perform an agent based backup from the commvault gui and afterwards check the output in the saparch folder, you will find that cv executes regular commands:

    ....
    command_line brarchive -d util_file -OSC -cds -c -u /
    ...

    There is no reason you can't match that command and run it directly, either as permanent log backup with -f or to limit it with -n.
    All these options belong to brarchive and not commvault. But remember, when using the 3rd party integration with scheduling via UC4 you may miss some possibilities when it comes to automatic alerts from the commserve and i am not sure if all reports will work properly with 3rd party backups.

    Regards, René

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