2096851 - Backup related Housekeeping using HANA Studio

• You observe the size of log backup growing continuously;
• The file name of the log backup that is unexpectedly big starts with "log_backup_0_0_0_#########";
• The file system where SAP HANA log backups are stored is filling rapidly or has reached 100% causing the database to hang;
• The indexserver trace file show errors similar to the following:

  [72007]{-1}[-1/-1] 2015-01-18 09:12:54.379241 e Backup BackupExe_LogBackup.cpp(00472) : Report backup failure: Cannot open file ""<root>/.log_backup_5_0_5068115968_5068116992.1421572374350" 
  (mode= W, access= rwrwr-, flags= DIRECT|UNALIGNED_SIZE|TRUNCATE|MULTI_WRITERS), factory= (root= "/backup/log_backup/<SID>/" (access= rwrwr-, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage=
  LOG_BACKUP, fs= nfs, config= (AsyncWriteSubmitActive=auto,AsyncWriteSubmitBlocks=new,AsynReadSubmit=off,#SubmitQueues=1,#CompletionQueues=1)))", rc=28: No space left on device 
  [72007]{-1}[-1/-1] 2015-01-18 09:13:54.388498 e Logger  BackupHandlerImpl.cpp(00390) : Error during log segment backup: exception  1: no.2000004  (Basis/IO/FileAccess/impl/LocalFile.cpp:177)

• The backup.log file shows errors similar to the following:

  2015-01-18T09:09:27+00:00  P051968      14afc4dd68c INFO    LOGBCKUP state of service: nameserver, <hostname>:<port>, volume: 1, BackupLogStarted
  2015-01-18T09:09:27+00:00  P051968      14afc4dd68c INFO    LOGBCKUP to file: /backup/log_backup/<SID>/log_backup_1_0_166160768_166164608.1421572167308
  2015-01-18T09:09:27+00:00  P051968      14afc4dd68c INFO    LOGBCKUP state of service: nameserver,  <hostname>:<port>, volume: 1, BackupLogError
  2015-01-18T09:09:38+00:00  P051968      14afc4e0349 INFO    LOGBCKUP state of service: statisticsserver, <hostname>:<port>, volume: 2, BackupLogStarted
  2015-01-18T09:09:38+00:00  P051968      14afc4e0349 INFO    LOGBCKUP to file: /backup/log_backup/<SID>/log_backup_2_0_8174898432_8175824512.1421572178761
  2015-01-18T09:09:38+00:00  P051968      14afc4e0349 INFO    LOGBCKUP state of service: statisticsserver, <hostname>:<port>, volume: 2, BackupLogError 

• You want to know how to perform the housekeeping of the backup catalog in SAP HANA;

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP HANA, platform edition 1.0
• SAP HANA, platform edition 2.0

DISKFULL_ERROR, Disk full, AUTOCREATE_PATH|DISKFULL_ERROR,  rc=28: No space left on device, Cannot open file, Delete Data Backups, alter system reclaim log, Catalog and Backup Location , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , HAN-CPT-CPT2-BAC , SAP HANA Cockpit 2 Backup & Recovery , How To