How to check Log Backup in SAP HANA

  • Lo-gin to Database host as sidadm 
  • Check if BKPMON key is working fine

    hdbsql -U BKPMON
    hdbsql  NAN=>
    •If not check user privileges and grant missing role

 

  • Check what is log mode:
    SELECT DISTINCT log_mode FROM SYS.M_LOG_BUFFER

 

  • Check if log backups are running fine:
    select * from “SYS”.”M_BACKUP_CATALOG” order by SYS_START_TIME desc

Leave a Reply