MENU

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Thursday, December 31, 2015

how to check log backup in sap hana



Step 1:    Login to Database host as sidadm
     
Step 2:   Check if BKPMON key is working fine

hdbsql -jU bkpmon
Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql=>
hdbsql SID=>

    •If not check user privileges and grant missing role

Step 3:    Check what is log mode:

  SELECT DISTINCT log_mode FROM SYS.M_LOG_BUFFER

Step 4:    Check if log backups are running fine:

 select * from "SYS"."M_BACKUP_CATALOG" order by SYS_START_TIME desc

Checking Bkpmon User Status: 

Run the below command from OS :

> hdbuserstore list

DATA FILE       : xyz/usr/sap/SID/home/.hdb/vsa01/XSFS_HDB.DAT
KEY FILE        : xyz/usr/sap/SID/home/.hdb/vsa01/XSFS_HDB.KEY

KEY BKPKEY
  ENV : vadbabc:3001355
  USER: bkpkey
KEY WW
  ENV : vadbabc:3001355
  USER: system

No comments: