{"id":14779,"date":"2020-10-09T06:38:52","date_gmt":"2020-10-09T04:38:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/"},"modified":"2020-10-09T06:38:52","modified_gmt":"2020-10-09T04:38:52","slug":"getting-started-with-exasol-backup-and-restore-1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/","title":{"rendered":"Getting started with Exasol \u2013 Backup and restore (1)"},"content":{"rendered":"<p>Now that we have a system with a <a href=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\" target=\"_blank\" rel=\"noopener noreferrer\">proper network setup<\/a> we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure cannot put a system into production, so backup and restore always is a major topic to understand (with any system that holds data you do not want to lose). When it comes to backup and restore, this is what I expect at a minimum in that area:<\/p>\n<ul>\n<li>Backups should be non-blocking<\/li>\n<li>Given that Exasol is targeting massive data volumes, there should be a way to parallelize backups and restores<\/li>\n<li>There should be a way to check the integrity of backups<\/li>\n<li>Point in time recovery of course is a must<\/li>\n<li>Compression of backups becomes important with huge data, also this is not a blocker<\/li>\n<\/ul>\n<p>Let&#8217;s go and check what is available, and how it works.<\/p>\n<p><!--more--><\/p>\n<p>Backups in Exasol are either stored into &#8220;Local Archive Volumes&#8221;, or into &#8220;Remote Archive Volumes&#8221;. If you remember the last post, you can have &#8220;data&#8221; and &#8220;archive&#8221; volumes. The &#8220;archive&#8221; volumes are for backups. As the names imply, &#8220;Local Archive Volumes&#8221; are local inside the cluster, while backups to &#8220;Remote Archive Volumes&#8221; go out of the cluster. For the remote archives, there are the following options:<\/p>\n<ul>\n<li>FTP<\/li>\n<li>SMB<\/li>\n<li>AWS S3<\/li>\n<li>WebHDFS<\/li>\n<li>Azure Blob Storage<\/li>\n<li>Google Cloud Storage<\/li>\n<\/ul>\n<p>From my personal experience, backups should always be stored in a location that is not local to the database system or, in the case of Exasol, local to the cluster. Everything can fail and if you loose the whole cluster (for whatever reason) you really want to have a backup you can restore from somewhere else. There is one exception to that: If you can load your data into Exasol from external sources in a reasonable time, it might be sufficient to with local backups only.<\/p>\n<p>For the scope of this post we&#8217;ll go with an <a href=\"https:\/\/aws.amazon.com\/s3\/\" target=\"_blank\" rel=\"noopener noreferrer\">AWS S3 bucket<\/a>. Before we can attach an S3 bucket we need to do some more configurations in the Network configuration section of the web console which currently looks like this:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-36-08.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-36-08.jpg\" alt=\"\" width=\"1029\" height=\"760\" class=\"aligncenter size-full wp-image-43974\" \/><\/a><\/p>\n<p>What we need to provide are the DNS servers Exasol will use for DNS resolution, and the ntp servers to use (not really required here but required when you have multiple nodes):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-46-34.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-46-34.jpg\" alt=\"\" width=\"922\" height=\"750\" class=\"aligncenter size-full wp-image-43976\" \/><\/a><\/p>\n<p>A simple way of checking if the network setup is fine, is to go to the &#8220;Monitoring&#8221; section, and check if there is an IP address for one of the NTP servers (in case you used pool.ntp.org in the previous step):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-47-06.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-47-06.jpg\" alt=\"\" width=\"737\" height=\"879\" class=\"aligncenter size-full wp-image-43978\" \/><\/a><\/p>\n<p>Now, that connectivity is fine we can go ahead and <a href=\"https:\/\/docs.exasol.com\/administration\/aws\/manage_storage\/create_remote_archive_volume.htm\" target=\"_blank\" rel=\"noopener noreferrer\">attach a S3 bucket<\/a>. I&#8217;ve created a standard bucket with no special permissions:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-52-25.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-52-25.jpg\" alt=\"\" width=\"1200\" height=\"480\" class=\"aligncenter size-full wp-image-43980\" \/><\/a><\/p>\n<p>Remote archives in Exasol are configured in the &#8220;Storage&#8221; section:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-54-54.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-54-54.jpg\" alt=\"\" width=\"1058\" height=\"690\" class=\"aligncenter size-full wp-image-43982\" \/><\/a><\/p>\n<p>All you need to provide is the URL to the bucket, your <a href=\"\" target=\"_blank\" rel=\"noopener noreferrer\">AWS access key and the secret for that key<\/a>.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-57-28.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-57-28.jpg\" alt=\"\" width=\"615\" height=\"626\" class=\"aligncenter size-full wp-image-43984\" \/><\/a><\/p>\n<p>If all is fine, the remote archive should show a status of &#8220;online&#8221;:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-57-53.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-14-57-53.jpg\" alt=\"\" width=\"1030\" height=\"410\" class=\"aligncenter size-full wp-image-43986\" \/><\/a><\/p>\n<p>Before scheduling the actual backup let&#8217;s generate some data we can use for the backup (one simple table containing three rows):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ndwe@dwe:~\/EXAplus-7.0.0$ \/home\/dwe\/EXAplus-7.0.0\/exaplus -c 192.168.178.111:8563 -u sys -p exasol \nEXAplus 7.0.0 (c) EXASOL AG\n\nThursday, October 8, 2020 at 3:04:16 PM Central European Summer Time\nConnected to database my_exa_db1 as user sys.\nEXASolution 7.0.2 (c) EXASOL AG\n\nSQL_EXA&gt; create schema demo;\nEXA: create schema demo;\n\nRows affected: 0\n\nSQL_EXA&gt; create table t1 ( a int );\nEXA: create table t1 ( a int );\n\nRows affected: 0\n\nSQL_EXA&gt; open schema demo;\nEXA: open schema demo;\n\nSQL_EXA&gt; insert into t1 values (1);\nEXA: insert into t1 values (1);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (2);\nEXA: insert into t1 values (2);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (3);\nEXA: insert into t1 values (3);\n\nRows affected: 1\n<\/pre>\n<p>In Exasol everything related to backup starts with a backup schedule. As usual that is done in the web console:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-12-39.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-12-39.jpg\" alt=\"\" width=\"989\" height=\"437\" class=\"aligncenter size-full wp-image-43989\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-13-07.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-13-07.jpg\" alt=\"\" width=\"1011\" height=\"854\" class=\"aligncenter size-full wp-image-43990\" \/><\/a><\/p>\n<p>The schedule uses a cron like syntax:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-16-37.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-16-37.jpg\" alt=\"\" width=\"1385\" height=\"314\" class=\"aligncenter size-full wp-image-43991\" \/><\/a><\/p>\n<p>In this case that means:<\/p>\n<ul>\n<li>Do a full backup every day at 15:30<\/li>\n<li>Store the backup in the remote archive (S3) we just created<\/li>\n<li>Expire the backups after one week<\/li>\n<\/ul>\n<p>There will be a nice timeline once the first schedule is created:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-18-49-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-18-49-1.jpg\" alt=\"\" width=\"1200\" height=\"451\" class=\"aligncenter size-full wp-image-43993\" \/><\/a><\/p>\n<p>Let&#8217;s go a step a further and create an incremental backup 10 minutes after the full, and an incremental 2 backup 10 minutes after the first incremental. The level of the incremental backups always refer to the level before: 2 means incremental to level 1, 3 mean incremental level 2 and so on.<\/p>\n<p>A few minutes after the full backup schedule let&#8217;s check if it is there:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-32-54.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-32-54.jpg\" alt=\"\" width=\"1062\" height=\"306\" class=\"aligncenter size-full wp-image-43996\" \/><\/a><\/p>\n<p>Now we add some data so we have changes between the first full and the first incremental backup:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; select current_timestamp from dual;\nEXA: select current_timestamp from dual;\n\nCURRENT_TIMESTAMP         \n--------------------------\n2020-10-08 15:34:03.199000\n\n1 row in resultset.\n\nSQL_EXA&gt; insert into t1 values (-1);\nEXA: insert into t1 values (-1);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (-2);\nEXA: insert into t1 values (-2);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (-3);\nEXA: insert into t1 values (-3);\n\nRows affected: 1\n<\/pre>\n<p>One the first incremental is there:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-42-43.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-42-43.jpg\" alt=\"\" width=\"1069\" height=\"467\" class=\"aligncenter size-full wp-image-44003\" \/><\/a><\/p>\n<p>&#8230; again lets add some data and wait for the second incremental to complete:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; select current_timestamp from dual;\nEXA: select current_timestamp from dual;\n\nCURRENT_TIMESTAMP         \n--------------------------\n2020-10-08 15:43:45.369000\n\n1 row in resultset.\n\nSQL_EXA&gt; insert into t1 values (-300);\nEXA: insert into t1 values (-300);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (-301);\nEXA: insert into t1 values (-301);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (-302);\nEXA: insert into t1 values (-302);\n\nRows affected: 1\n\nSQL_EXA&gt; \n<\/pre>\n<p>Once it is there, we have something to test:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-52-47.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-15-52-47.jpg\" alt=\"\" width=\"1078\" height=\"495\" class=\"aligncenter size-full wp-image-44005\" \/><\/a><\/p>\n<p>Finally lets add some data again, which is not in any backup:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; select current_timestamp from dual;\nEXA: select current_timestamp from dual;\n\nCURRENT_TIMESTAMP         \n--------------------------\n2020-10-08 15:55:47.749000\n\n1 row in resultset.\n\nSQL_EXA&gt; insert into t1 values (-4001);\nEXA: insert into t1 values (-4001);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (-4002);\nEXA: insert into t1 values (-4002);\n\nRows affected: 1\n\nSQL_EXA&gt; insert into t1 values (-4003);\nEXA: insert into t1 values (-4003);\n\nRows affected: 1\n\nSQL_EXA&gt; \n<\/pre>\n<p>Let&#8217;s start with the easy case: Restore the full backup. If that work fine we should see this data after the restore:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL_EXA&gt; select * from t1;\nEXA: select * from t1;\n\nA                    \n---------------------\n                    1\n                    2\n                    3\n<\/pre>\n<p>Before we start the restore, there is another point to mention: Restores can be:<\/p>\n<ul>\n<li>Non blocking: While the restore is running, users can normally work with the database. If blocks are required for users while the restore is running, these blocks are restored with priority<\/li>\n<li>Blocking: Users can not work with the database while the restore is running. This is true for all restores that get the data from a remote archive. This is the fastest way to restore.<\/li>\n<li>Virtual access: Only blocks will be restored that are required by users. Changes will be allowed, but these changes will not be persistent and this method is only available for local archives.<\/li>\n<\/ul>\n<p>Btw: What was stored in our S3 bucket? Lets have a look. The folder structure that got created is: [DATABASE_NAME]\/[BACKUP_ID]\/[BACKUP_LEVEL]\/[NODE_ID]:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-32-56.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-32-56.jpg\" alt=\"\" width=\"1200\" height=\"351\" class=\"aligncenter size-full wp-image-44009\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-33-37.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-33-37.jpg\" alt=\"\" width=\"1200\" height=\"362\" class=\"aligncenter size-full wp-image-44010\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-34-37.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-16-34-37.jpg\" alt=\"\" width=\"1200\" height=\"357\" class=\"aligncenter size-full wp-image-44011\" \/><\/a><\/p>\n<p>Each of those contains a meta data file and the actual data. In our case they are quite small because we do not have much data. But that also gives us another hint: Even for the full backup this can not be a full backup of the entire database (it is only around 540 kB). It seems only user data and a bit of other stuff really makes it into the backup. Once we do a restore, a new, empty database is created and the user data gets restored.<\/p>\n<p>Coming to the real restore. Kicking of a restore is done in the same section as the backup overview. As we are restoring from S3 we can only do a &#8220;blocking restore&#8221;:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-21-29.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-21-29.jpg\" alt=\"\" width=\"1061\" height=\"474\" class=\"aligncenter size-full wp-image-44037\" \/><\/a><\/p>\n<p>If you try to do that while the database is running you&#8217;ll run into this error message:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-23-47.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-23-47.jpg\" alt=\"\" width=\"910\" height=\"419\" class=\"aligncenter size-full wp-image-44038\" \/><\/a><\/p>\n<p>So we need to shut it down before we attempt to restore:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-25-09.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-25-09.jpg\" alt=\"\" width=\"1059\" height=\"506\" class=\"aligncenter size-full wp-image-44039\" \/><\/a><\/p>\n<p>Kicking of the restore again will automatically start the database:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-28-43.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-28-43.jpg\" alt=\"\" width=\"1005\" height=\"335\" class=\"aligncenter size-full wp-image-44040\" \/><\/a><\/p>\n<p>In the monitoring section we can see that the restore was initiated:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-30-38.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-30-38.jpg\" alt=\"\" width=\"1216\" height=\"367\" class=\"aligncenter size-full wp-image-44041\" \/><\/a><\/p>\n<p>Finally checking the result:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\ndwe@dwe:~\/EXAplus-7.0.0$ \/home\/dwe\/EXAplus-7.0.0\/exaplus -c 192.168.178.111:8563 -u sys -p exasol \nEXAplus 7.0.0 (c) EXASOL AG\n\nFriday, October 9, 2020 at 8:31:22 AM Central European Summer Time\nConnected to database my_exa_db1 as user sys.\nEXASolution 7.0.2 (c) EXASOL AG\n\nCOLUMN   user_name ON\nFORMAT   a30\nCOLUMN   sql_text ON\nFORMAT   a30\nCOLUMN   effective_user ON\nFORMAT   a30\nCOLUMN   limit_value ON\nFORMAT   a30\nCOLUMN   status ON\nFORMAT   a15\nCOLUMN   index_schema ON\nFORMAT   a30\nCOLUMN   index_table ON\nFORMAT   a30\nCOLUMN   index_type ON\nFORMAT   a15\nCOLUMN   column_name ON\nFORMAT   a30\nCOLUMN   column_comment ON\nFORMAT   a50\nCOLUMN   CONSUMER_GROUP_COMMENT ON\nFORMAT   a30\nCOLUMN   SYS_CONSUMER_GROUP ON\nFORMAT   a30\nCOLUMN   CONSUMER_GROUP_NAME ON\nFORMAT   a30\nSQL_EXA&gt; open schema demo;\nEXA: open schema demo;\n\nRows affected: 0\n\nSQL_EXA&gt; select * from t1;\nEXA: select * from t1;\n\nA                    \n---------------------\n                    1\n                    2\n                    3\n\n3 rows in resultset.\n\nSQL_EXA&gt; \n<\/pre>\n<p>That works well and is pretty fast. As this post is alreay quite long we&#8217;ll look into the remaining topics in the next post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now that we have a system with a proper network setup we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure cannot put a system into production, so backup and restore always is a major topic to understand (with any [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":14802,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[2127,2128],"type_dbi":[],"class_list":["post-14779","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-exasol","tag-mpp"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Getting started with Exasol \u2013 Backup and restore (1) - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting started with Exasol \u2013 Backup and restore (1)\" \/>\n<meta property=\"og:description\" content=\"Now that we have a system with a proper network setup we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure cannot put a system into production, so backup and restore always is a major topic to understand (with any [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-09T04:38:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1070\" \/>\n\t<meta property=\"og:image:height\" content=\"664\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Getting started with Exasol \u2013 Backup and restore (1)\",\"datePublished\":\"2020-10-09T04:38:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\"},\"wordCount\":1078,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg\",\"keywords\":[\"Exasol\",\"MPP\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\",\"name\":\"Getting started with Exasol \u2013 Backup and restore (1) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg\",\"datePublished\":\"2020-10-09T04:38:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg\",\"width\":1070,\"height\":664},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting started with Exasol \u2013 Backup and restore (1)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Getting started with Exasol \u2013 Backup and restore (1) - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/","og_locale":"en_US","og_type":"article","og_title":"Getting started with Exasol \u2013 Backup and restore (1)","og_description":"Now that we have a system with a proper network setup we can take a look at how backup and restore works in Exasol. Without being able to restore and recover your database, you for sure cannot put a system into production, so backup and restore always is a major topic to understand (with any [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/","og_site_name":"dbi Blog","article_published_time":"2020-10-09T04:38:52+00:00","og_image":[{"width":1070,"height":664,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg","type":"image\/jpeg"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Getting started with Exasol \u2013 Backup and restore (1)","datePublished":"2020-10-09T04:38:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/"},"wordCount":1078,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg","keywords":["Exasol","MPP"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/","url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/","name":"Getting started with Exasol \u2013 Backup and restore (1) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg","datePublished":"2020-10-09T04:38:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-08-44-48.jpg","width":1070,"height":664},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-backup-and-restore-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting started with Exasol \u2013 Backup and restore (1)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14779"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14779\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14802"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14779"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}