SAP Knowledge Base Article - Preview

2096851 - Backup Catalog Housekeeping within SAP HANA

Symptom

  • 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, hand04:39701, 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, hand04:39701, volume: 1, BackupLogError
    2015-01-18T09:09:38+00:00  P051968      14afc4e0349 INFO    LOGBCKUP state of service: statisticsserver, hand04:39705, 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, hand04:39705, volume: 2, BackupLogError 
  • You want to know how to perform the housekeeping of the backup catalog in SAP HANA;


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

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 , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.