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/.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  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. 

    Info
    titleNote

    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 To view all the expired backups by selecting , select the checkbox next to Show expired BackupsBackup 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. 

...