Tuesday 17 March 2020

Change HANA DATA and LOG backup location without downtime

Change HANA DATA and LOG backup location without downtime


We are going to see, How can we change HANA Data and LOG backup location without affecting system functionality.

Note: Change HANA Backup location is on fly


Reasons :

1: We observed that HANA DB size increasing, hence we failed to keep the last two COMPLETE DATA BACKUP. because it may lead to   /Backup FS full situation and it will affect the system. Once backup FS full then log backup creation will stop.

2: We want to resize /Backup FS but as it's in use it difficult to resize FS. In a few cases, it asks for the restart of OS. which is not possible in the Production System.

Procedure: 

1: Add a disk to the respective server. 

2: Create FS and make the directory as   "backunew"  ( below are command for OS admin). you can ask you os team to mount fs then start with point  "3"

--> mkfs -t ext4 /dev/nvmexxxx     
--> mkdir -p /backupnew
--> mkdir Data 
--> mkdir Log
--> Chown /Data /Log  

3: Change parameter as shown below

global.in --> persistence 

basepath_databackup --> /backupnew/HDB/data

basepath_logbackup --> /backupnew/HDB/log












4: Now run test configuration by running COMPLETE DATA Backup. Once we start backup we can see log backup started at new location 


Thanks 
Rupesh Chavan