HANA System Database Restore and Recovery Guide

To restore and recover a HANA system database, follow these steps:

1. Log in to the HANA server as the SYSTEM user.

2. Start the HANA database using the command:

   HDB start

3. Stop the HANA database using the command:

   HDB stop

4. Restore the database backup using the command:

   HDB restore '<backup_file_path>'

   Replace '<backup_file_path>' with the path to the backup file.

5. Start the HANA database using the command:

   HDB start

6. Connect to the HANA database using the command:

   hdbsql -i '<instance_number>' -d '<database_name>'

   Replace '<instance_number>' with the HANA instance number and '<database_name>' with the name of the system database.

7. Run the RECOVER DATA command to recover the database:

   RECOVER DATA USING FILE ('<log_file_path>') UNTIL TIMESTAMP '<timestamp>'

   Replace '<log_file_path>' with the path to the log file and '' with the timestamp of the last successful backup.

8. Once the recovery is complete, run the CHECK DATA command to ensure the database is consistent:

   CHECK DATA '<schema_name>' ALL

   Replace '<schema_name>' with the name of the schema to check.

9. Exit the HANA database using the command:

   exit