Skip to Content
0
Oct 25, 2018 at 05:18 AM

HANA BackupRestore using backint - QAS System Refresh.

1471 Views

Hi,

I am performing HANA BackupRestore using backint (ddbda) from PRD to QAS (System Refresh). Distributed enviroment PRD (4 Host) and QAS (4 Host)

I see backup available in PRD backup catalog and also able to see the backup in Backup Catalog of QAS in Recovery wizard from studio.

When I complete the wizard to start the recovery I see below logs and the recovery stops.

1) backup.log

2018-10-24T16:16:40+02:00 P130092 166a64c5ab9 INFO RECOVERY INQUIRE finished successfully 2018-10-24T21:25:25+02:00 P044874 166a789e8f1 INFO RECOVERY INQUIRE started 2018-10-24T21:25:25+02:00 P044874 166a789e8f1 INFO RECOVERY command: BACKUP COMPLETE LIST DATA USING SOURCE 'PRD' USING CATALOG BACKINT LIMIT 10 2018-10-24T21:25:25+02:00 P044874 166a789e8f1 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryInProgress 2018-10-24T21:25:32+02:00 P044874 166a789e8f1 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryFinished 2018-10-24T21:25:32+02:00 P044874 166a789e8f1 INFO RECOVERY using backup catalog 1540409008219 from backint /usr/sap/QAS/SYS/global/hdb/backint/log_backup_0_0_0_0 2018-10-24T21:25:32+02:00 P044874 166a789e8f1 INFO RECOVERY INQUIRE finished successfully 2018-10-24T21:25:47+02:00 P045828 166a78a4185 INFO RECOVERY INQUIRE started 2018-10-24T21:25:47+02:00 P045828 166a78a4185 INFO RECOVERY command: BACKUP COMPLETE LIST DATA USING SOURCE 'PRD' USING CATALOG BACKINT LIMIT 10 OFFSET 10 2018-10-24T21:25:47+02:00 P045828 166a78a4185 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryInProgress 2018-10-24T21:25:53+02:00 P045828 166a78a4185 INFO RECOVERY state of service: nameserver, psthanqbw01:37001, volume: 0, RecoveryExecuteCatalogRecoveryFinished 2018-10-24T21:25:53+02:00 P045828 166a78a4185 INFO RECOVERY using backup catalog 1540409008219 from backint /usr/sap/WAS/SYS/global/hdb/backint/log_backup_0_0_0_0 2018-10-24T21:25:54+02:00 P045828 166a78a4185 INFO RECOVERY INQUIRE finished successfully qasadm@psthanqbw01:/usr/sap/QAS/HDB70/psthanqbw01/trace>

2) backint.log

2018-10-24 15:38:38.000 backint started: command: /usr/sap/QAS/SYS/global/hdb/opt/hdbbackint -f inquire -p /opt/ddbda/config/sap_hana_QAS_ddbda.utl -i /var/tmp/hdbbackint_QAS.3d638s -o /var/tmp/hdbbackint_QAS.KFFGMc -u PRD pid: 130157 input: #SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.11.1499758750" #EBID 1531496953 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_0_1" #EBID 1531496959 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_1_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_2_1" #EBID 1531496958 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_3_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_4_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_5_1" #EBID 1531496957 "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_6_1" 2018-10-24 16:16:40.000 backint terminated: pid: 130157 exit code: 0 output: #SOFTWAREID "backint 1.06" "database app agent 3.0 3.0.0.0.Build.199 199" #BACKUP "1531496953" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_0_1" #BACKUP "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_2_1" #NOTFOUND "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_4_1" #NOTFOUND "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_5_1" #NOTFOUND "1531496957" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_6_1" #BACKUP "1531496958" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_3_1" #BACKUP "1531496959" "/usr/sap/PRD/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_1_1" 2018-10-24 21:25:25.000 backint started: command: /usr/sap/QAS/SYS/global/hdb/opt/hdbbackint -f restore -p /opt/ddbda/config/sap_hana_QAS_ddbda.utl -i /var/tmp/hdbbackint_QAS.xG13KB -o /var/tmp/hdbbackint_QAS.ieLdxU -u PRD pid: 44914 input: #SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.11.1499758750" #NULL "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0" "/usr/sap/QAS/SYS/global/hdb/backint/log_backup_0_0_0_0" 2018-10-24 21:25:32.000 backint terminated: pid: 44914 exit code: 0 output: #SOFTWAREID "backint 1.06" "database app agent 3.0 3.0.0.0.Build.199 199" #RESTORED "1540409010" "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0" 2018-10-24 21:25:48.000 backint started: command: /usr/sap/QAS/SYS/global/hdb/opt/hdbbackint -f restore -p /opt/ddbda/config/sap_hana_QAS_ddbda.utl -i /var/tmp/hdbbackint_QAS.ZgdoDo -o /var/tmp/hdbbackint_QAS.3uFy8G -u PRD pid: 45866 input: #SOFTWAREID "backint 1.04" "HANA HDB server 1.00.122.11.1499758750" #NULL "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0" "/usr/sap/QAS/SYS/global/hdb/backint/log_backup_0_0_0_0" 2018-10-24 21:25:53.000 backint terminated: pid: 45866 exit code: 0 output: #SOFTWAREID "backint 1.06" "database app agent 3.0 3.0.0.0.Build.199 199" #RESTORED "1540409010" "/usr/sap/PRD/SYS/global/hdb/backint/log_backup_0_0_0_0"

The above files show NOT FOUND but they are available in PRD backup catalog.

Thanks.

Regards,
Fernando