Maintenance Notification:
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.

You are currently viewing an old documentation portal. This content will be removed on June 18th, 2019. Please view our current documentation portal at http://docs.exasol.com/.
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

  1. Go to Services > EXASolution, and the EXASolution Instance screen is displayed. 
  2. 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
  3. Next, click the database name. The EXASolution Instance Screen is displayed. 



  4. Click Backups. The EXASolution Database Backup List screen is displayed. 

    Note

    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

    DatabaseName 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:

    • 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.
    TimestampThe date and time the backup was created.
    ExpirationThe expiration date of the backup.
    Usage (GiB)The size of the backup in GiB.
    IncrementThe increment of the backup over the last full backup.
    StatusThe status of the backup.

    You can view all the expired backups by selecting the checkbox next to Show expired Backups and then click Refresh.

  5. Select the Restore Type from the following options: 
    1. 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.  
    2. 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.
    3. 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. 
  6. 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: 

OptionsDescriptions
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 backupsDisplays backups from other databases.
  • No labels