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
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:
Post a Comment