SAP Knowledge Base Article - Preview

2096851 - Backup related Housekeeping using HANA Studio

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 for Me (Login required).

Search for additional results

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