cancel
Showing results for 
Search instead for 
Did you mean: 

Backup retention period

Former Member
0 Kudos

HI,

My question is about backup retention period. Currently we are doing the full online database backup + log for every Monday till Friday. And the backup media is disk. My problem here is I don't know where to set the retention period for our backup. Actually we want to keep the backup for 14 days.

So if anyone here know how to set the retention period so that after 14 days it will overwrite the 1st day backup.

I went to init<SID>.sap and found below setting:

  1. retention period in days for brarchive log files

  2. default: 30

  3. cleanup_brarchive_log = 30

  4. retention period in days for brbackup log files

  5. default: 30

  6. cleanup_brbackup_log = 30

  7. retention period in days for brconnect log files

  8. default: 30

  9. cleanup_brconnect_log = 30

  10. retention period in days for brrestore log files

  11. default: 30

  12. cleanup_brrestore_log = 30

  13. retention period in days for sapdba log files

  14. default: 30

  15. cleanup_sapdba_log = 30

  16. retention period in days for offline redo log files saved on disk

  17. default: 30

  18. cleanup_disk_archive = 30

  19. retention period in days for database file saved on disk

  20. default: 30

  21. cleanup_disk_backup = 30

  22. retention period in days for sapdba export dumps and scripts

  23. default: 30

I just wondering whether I need to choose the "# retention period in days for database file saved on disk

  1. default: 30" since we are doing full database backup and set it to 14. Do I need also to set for offline redo log files backup?

Please help.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Quare,

cleanup_sapdba_log = 14

cleanup_disk_archive = 14

you can have a month end backup and offline redo files for longer period or write it to tape to keep it permanently, so that if you require something will be there.

Regards,

Siv

Former Member
0 Kudos

Dear K.Siva,

Thanks for your answer. It's like that if we choose below:

cleanup_sapdba_log = 14

cleanup_disk_archive = 14

The old backup that longer than 14 days it will be deleted from directory rite?

Correct me if I'm wrong. It's mean that by using this option it's also can

consider overwrite function.

Thanks.

Former Member
0 Kudos

Dear Quare,

Yes, you are correct....any backup which older than 14days will be deleted.

Regards,

Siv

Former Member
0 Kudos

HI K.Siva,

I tried your solution and sad to inform that it was not working. Is there any setting that I need to do?

Please advise.

Thanks,

Quare

Former Member
0 Kudos

Dear Quare,

Are you moving the backups to different folders after backup is completed.

Also don't keep # before the parameter. takeout the hash and then try

Regards,

Siv

Edited by: K. Siva Srinivas Reddy on Nov 19, 2009 12:41 PM

Answers (0)