Recovering from database crashes

Every Genian ZTNA's system configures, policies, collection stored on database. If a database problem occurs by H/W or S/W error, you can recover database by using backup file.

Symptom

Web Console login failure, policy assignment and policy renewal failure, setting lookup failure, etc.

Cause

Crashes occur in databases due to various problems. H/W problems Internal database engine problems, setup problems, etc.

Resolution

Recover the database using the database information in the backup file.

Step 1 If the backup file is inside the equipment you want to restore, navigate to Step3.

genian> en
genian# @shell
!!! WARNNING !!! - SHELL PROMPT IS JUST FOR MAINTENANCE.
!!! WARNNING !!! - USE AT YOUR OWN RISK.
Genians$ cd /disk/data/DBBACKUP
Genians$ rz [Backup File]
Genians$ ls
drwxr-xr-x    2 root     root          4096 May 11 09:43 ./
drwxr-xr-x   36 root     root          4096 Apr 21 13:50 ../
-rw-r--r--    1 root     root     193863371 May 11 09:43 ALDER-93180-20210511-094236.tar.gz

Step 2 Connect to the gnlogin CLI.

genian$ gnlogin

Step 3 Verify the backup files at the time you restore them.

genian# show backup

Backup lists
---------------------------------
ALDER-93180-20210511-094236

Step 4 Restore the database (select Database Only under Options).

genian# do restore [Backup File Name]
Are you sure to restore configuration files (y/N): n
Are you sure to restore agent files (y/N): n
Are you sure to restore custom files (y/N): n
Are you sure to restore database (y/N): y
Do you want to start service after restore? (Y/n): y

Step 5 If the system is restarted and the database restore is successful, all systems will function normally.