On next Monday August 5th 2019 starting at 7am CEST we will conduct some maintenance. You might encounter some issues using the Exasol User Portal and Issue Tracker! We will restore the Exasol User Portal and Issue Tracker before 9am CEST on Monday August 5th 2019.
- Go to Services > EXASolution, and 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.
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:
Database Name of the database instance.
A unique identifier of the backup. Volume
The volume name that the backup is stored on.
EXASolution provides some flexibility with backup levels:
- 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.
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.
- 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.
Additional operations you can perform in the EXASolution Database Backup List screen include the following:
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.
|Show foreign database backups||Displays backups from other databases.|