You can easily get the HANA database backup progress (while the backup is running) and duration from the Backup Catalog (using HANA Studio). But, how about for HANA restoration? How do you find the duration and progress?
- HANA backup progress (How to Perform HANA Full Database Backup)
- HANA backup duration (How to Get HANA Database Backup Duration)
Solution
Go to the operating system level, in our case, it’s a Red Hat Linux. Change to below directory and look for backup.log file
#cd /hana/shared/SID/HDB00/HOSTNAME/trace/DB_SID
#ls -lrt *backup*
backup.log
Now, execute below command. In this example, we are looking for the restore which was happen on 21st June 2019.
more backup.log | grep 'RECOVERY' | grep '2019-06-21' | more
Now, here to get the following status,
- Duration – Take the time from the starting recovery start up to the recovery is completed.
#####START OF THE RECOVERY#####
2019-06-21T11:32:16+00:00 RECOVERY INQUIRE started
2019-06-21T11:32:16+00:00 RECOVERY command: BACKUP LIST DATA FOR EX2 UNTIL TIMESTAMP '2019-06-21 00:00:00' USING SOURCE 'SID@SID' USING CATALOG BACKINT LIMIT 10
#####END OF RECOVERY#####
2019-06-21T17:41:20+00:00 RECOVERY state of service: indexserver, itsiti:30003, volume: 3, RecoveryLogReplayFinished
2019-06-21T17:41:26+00:00 RECOVERY state of service: xsengine, itsiti:30007, volume: 2, RecoveryLogReplayFinished
2019-06-21T17:45:27+00:00 RECOVERY state of service: indexserver, itsiti:30003, volume: 3, RecoveryRestartCompleted
2019-06-21T17:45:31+00:00 RECOVERY state of service: xsengine, itsiti:30007, volume: 2, RecoveryRestartCompleted
2019-06-21T17:48:10+00:00 RECOVERY RECOVER DATA finished successfully, reached timestamp 2019-06-20T23:59:59+00:00, reached log position 4787973554240
2019-06-21T17:48:10+00:00 RECOVERY state of service: xsengine, itsiti:30007, volume: 2, RecoverySuccess
2019-06-21T17:48:10+00:00 RECOVERY state of service: indexserver, itsiti:30003, volume: 3, RecoverySucces
- Progress – You can get the progress of the restoration from the same backup.log file.
2019-06-21T17:22:37+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 31% 59/189
2019-06-21T17:23:35+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 32% 60/189
2019-06-21T17:24:14+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 32% 61/189
2019-06-21T17:25:09+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 33% 62/189
2019-06-21T17:26:35+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 33% 63/189
2019-06-21T17:28:01+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 34% 64/189
2019-06-21T17:29:19+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 34% 65/189
2019-06-21T17:29:43+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 35% 66/189
2019-06-21T17:30:34+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 35% 67/189
2019-06-21T17:31:33+00:00 RECOVERY progress of service: indexserver, itsiti:30003, volume: 3, 36% 68/189
