Restore Database Instance from Backup
All database backups are stored in the archive volume which can be on either local or remote servers. In case of a database instance failure, unsuccessful upgrades, or errors on your database, it can be restored to the previous state using these backups.
Prerequisites
To restore the database instance from a backup, ensure the following:
-
The database is shut down. You will not be able to restore the backup if the database is running.
-
The database to which you are restoring the backup has the same number of active nodes as the one used to create the backup.
-
The version of the database to which you are restoring the backup, must be one of the following:
-
Exact version as the database used to create the backup. For example, both databases are Exasol 6.2.3.
-
A newer version within the same minor release as the database used to create the backup. For example, backed up database is Exasol 6.2.3 and the new one is Exasol 6.2.12.
-
One release newer than the database used to create the backup. For example, backed up database is Exasol 6.2.3 and the new one is Exasol 7.0.2.
-
Procedure
Follow the below steps to restore a database instance from a backup.
- Go to Services > EXASolution, The EXASolution Instance screen is displayed.
- Select the checkbox next to the database name you want to restore from the backup and click Shutdown. The database is shut down when the green light next to the database name turns grey, and the status is Created.
- Next, click the database name. The EXASolution Instance Screen is displayed.
- Click Backups. The EXASolution Database Backup List screen is displayed.
- Level 0 is a full backup
- Level 1 is an incremental backup to the full backup (only changes since the full backup are saved)
- Level 2 is an incremental backup to level 1 (only changes since the level 1 backup are saved)
- Level 3 is an incremental backup to level 2 (only changes since the level 2 backup are saved)
- And so on until level 9.
- Select the Restore Type from the following options:
- Blocking: Continue to restore the data from the backup into the database with the database still in offline mode. This is the fastest way to restore the backup. Read or write operations on the database is not possible.
- Non-blocking: Restores the most necessary part of the data into the database and the database is in online mode. This option is usefully when you want to have a smaller downtime for the database. The data is loaded slightly slower as compared to the blocking restore type.
- Virtual Access: Use this option if you want to restore a single object of a database into another database. Selecting Virtual-access starts the database in a read-only mode.
- Click Restore to restore the database. You can monitor the progress of the database restore process in the monitoring section.
The expiration dates set up for each database backup can be changed. Update the new date under the Expiration column and click Apply to save your changes.
This screen displays all the database backups available with the following information:
Backup Property | Description |
---|---|
Database | Name of the database instance. |
Backup ID | A unique identifier of the backup. |
Volume | The volume name that the backup is stored on. |
Level |
EXASolution provides some flexibility with backup levels: |
Timestamp | The date and time the backup was created. |
Expiration | The expiration date of the backup. |
Usage (GiB) | The size of the backup in GiB. |
Increment | The increment of the backup over the last full backup. |
Status | The status of the backup. |
To view all expired backups, select the checkbox next to Show expired Backup and then click Refresh.
Additional operations you can perform in the EXASolution Database Backup List screen include the following:
Options | Descriptions |
---|---|
Delete |
Deletes a backup. Select the backup(s) to be deleted and click Delete.
|
Delete unusable backups | Deletes unusable backups - for example, corrupt backups, foreign backup with a different number of nodes or incremental backups to backups that are no longer stored - are deleted to clear up space. Select Delete unusable backups. |
Show foreign database backups | Displays backups from other databases. |