Skip to Content
author's profile photo Former Member
Former Member

Calculate needed space in case you need to backup to disk

Hei,

I have the following practical question regarding Hana Log Backups.

Normally the Log Backups are set to: Automatic send to an external location using backint integration.

But if the external location is unavailable (defect or maintenance) we need to switch to file backup for Log Backups.

The question now is the following:

Given is that the external backup location is unavailable for 48 hours.

Hana is up and running.

I want to calculate how many MB it has written to Log Backup the last 48 hours.

With this info I can make a calculation (not 100% but ok for me) how big the filesystem should be where I can send the File Log Backups to.

Who has any tips on how to attack this question ??

Credits for the good tip/hint

Kind regards,

Frans Trip

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Aug 23, 2016 at 11:40 AM

    Hi Johan,

    Assuming there is no big change during daily business operation, the daily space required for log backup in filesystem can be got from the daily size report (check your third-party backup tools) of log backup using backint.

    Regards,

    Ning

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Frans,

      Try the following SQL which will give you a daily sum of the backed up logs. It's not elegant but it gets you the daily info.

      select TO_DATS(t1.SYS_END_TIME), sum(t2.backup_size) FROM SYS.M_BACKUP_CATALOG t1, SYS.M_BACKUP_CATALOG_FILES t2 WHERE t1.entry_id = t2.entry_id AND (t1.ENTRY_TYPE_NAME = 'log backup') and (rtrim(t1.STATE_NAME) = 'successful') group by TO_DATS(t1.SYS_END_TIME) ;

      Cheers,

      Amerjit

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.