Find in this Blog

Friday, December 30, 2022

ALTER SYSTEM RECLAIM LOG;

 HANA LOG RECLAIM


TO STOP GENERATING LOG  FOLLOW THE STEPS


TAKE BACKUP OF DB


run below script to see the status of log  from tenant and Db

select b.host, b.service_name, a.state, count(*) from "PUBLIC"."M_LOG_SEGMENTS" a join"PUBLIC"."M_SERVICES" b on (a.host = b.host AND a.port = b.port) group by b.host, b.service_name,a.state;


if result show free recalim the log


ALTER SYSTEM RECLAIM LOG;

BAJUO LOG PATH  /usr/sap/SID/HDB01/backup/


set BELOW PARAMETER as below paramter to stop generating logs


log_mode = no


enalbe_auto_log_backup = overwrite