{"id":8878,"date":"2018-01-23T19:09:29","date_gmt":"2018-01-23T18:09:29","guid":{"rendered":"http:\/\/arumel.com\/?p=8878"},"modified":"2018-01-23T19:09:29","modified_gmt":"2018-01-23T18:09:29","slug":"ovm-manager-mysql-database-restoration","status":"publish","type":"post","link":"https:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/","title":{"rendered":"OVM Manager MySQL database restoration"},"content":{"rendered":"<p>This morning we suffered a hardware failure in one of our OVM lab servers (version 3.4). In this environment, OVM Manager is deployed inside the OVM cluster, and the incident crashed its virtual machine. At VM startup using xm create command from the OVM Server command line, OS startup up OK, but OVM components did not. Why? Mysql data corruption after the failure.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">180123 17:53:24 mysqld_safe Starting mysqld daemon with databases from \/u01\/app\/oracle\/mysql\/data\r\n2018-01-23 17:53:24 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.\r\n2018-01-23 17:53:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\r\n2018-01-23 17:53:24 0 [Note] \/usr\/sbin\/mysqld (mysqld 5.6.32-enterprise-commercial-advanced) starting as process 3816 ...\r\n2018-01-23 17:53:24 3816 [Note] Plugin 'FEDERATED' is disabled.\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Using atomics to ref count buffer pool pages\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: The InnoDB memory heap is disabled\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Memory barrier is not used\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Compressed tables use zlib 1.2.3\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Using Linux native AIO\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Using CPU crc32 instructions\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Initializing buffer pool, size = 1.0G\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Completed initialization of buffer pool\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Highest supported file format is Barracuda.\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: The log sequence numbers 1484386085656 and 1484386085656 in ibdata files do not match the log sequence number 1511364890742 in the ib_logfiles!\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Database was not shutdown normally!\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Starting crash recovery.\r\n2018-01-23 17:53:24 3816 [Note] InnoDB: Reading tablespace information from the .ibd files...\r\n2018-01-23 17:53:26 3816 [Note] InnoDB: Restoring possible half-written data pages \r\n2018-01-23 17:53:26 3816 [Note] InnoDB: from the doublewrite buffer...\r\n2018-01-23 17:53:26 3816 [ERROR] InnoDB: We scanned the log up to 1511364890624. A checkpoint was at 1511364890742 and the maximum LSN on a database page was 0. It is possible that the database is now corrupt!\r\n2018-01-23 17:53:26 7f451f3e8720 InnoDB: Error: page 5 log sequence number 1511364907354\r\nInnoDB: is in the future! Current system log sequence number 1511364890742.\r\nInnoDB: Your database may be corrupt or you may have copied the InnoDB\r\nInnoDB: tablespace but not the InnoDB log files. See\r\nInnoDB: http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/forcing-innodb-recovery.html\r\nInnoDB: for more information.\r\n(...)\r\nInnoDB: 3 transaction(s) which must be rolled back or cleaned up\r\nInnoDB: in total 0 row operations to undo\r\nInnoDB: Trx id counter is 1018590976\r\nInnoDB: Cleaning up trx with id 1018590873\r\n2018-01-23 17:53:27 7f451f3e8720 InnoDB: Assertion failure in thread 139934853662496 in file trx0trx.cc line 292\r\nInnoDB: Failing assertion: trx-&gt;update_undo == NULL\r\nInnoDB: We intentionally generate a memory trap.\r\nInnoDB: Submit a detailed bug report to http:\/\/bugs.mysql.com.\r\nInnoDB: If you get repeated assertion failures or crashes, even\r\nInnoDB: immediately after the mysqld startup, there may be\r\nInnoDB: corruption in the InnoDB tablespace. Please refer to\r\nInnoDB: http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/forcing-innodb-recovery.html\r\nInnoDB: about forcing recovery.\r\n16:53:27 UTC - mysqld got signal 6 ;\r\nThis could be because you hit a bug. It is also possible that this binary\r\nor one of the libraries it was linked against is corrupt, improperly built,\r\nor misconfigured. This error can also be caused by malfunctioning hardware.\r\nWe will try our best to scrape up some info that will hopefully help\r\ndiagnose the problem, but since we have already crashed,\r\nsomething is definitely wrong and this may fail.\r\n\r\nkey_buffer_size=33554432\r\nread_buffer_size=2097152\r\nmax_used_connections=0\r\nmax_threads=151\r\nthread_count=0\r\nconnection_count=0\r\nIt is possible that mysqld could use up to\r\nkey_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 653196 K bytes of memory\r\nHope that's ok; if not, decrease some variables in the equation.\r\n\r\nThread pointer: 0x0\r\nAttempting backtrace. You can use the following information to find out\r\nwhere mysqld died. If you see no messages after this, something went\r\nterribly wrong...\r\nstack_bottom = 0 thread_stack 0x40000\r\n\/usr\/sbin\/mysqld(my_print_stacktrace+0x35)[0x918445]\r\n\/usr\/sbin\/mysqld(handle_fatal_signal+0x494)[0x69bdd4]\r\n\/lib64\/libpthread.so.0(+0xf7e0)[0x7f451efc97e0]\r\n\/lib64\/libc.so.6(gsignal+0x35)[0x7f451da695e5]\r\n\/lib64\/libc.so.6(abort+0x175)[0x7f451da6adc5]\r\n\/usr\/sbin\/mysqld[0xa48492]\r\n\/usr\/sbin\/mysqld[0xa41758]\r\n\/usr\/sbin\/mysqld[0x9b4488]\r\n\/usr\/sbin\/mysqld[0xa2f975]\r\n\/usr\/sbin\/mysqld[0x973e0d]\r\n\/usr\/sbin\/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x5df848]\r\n\/usr\/sbin\/mysqld[0x725cb1]\r\n\/usr\/sbin\/mysqld(_Z11plugin_initPiPPci+0xbb6)[0x729b16]\r\n\/usr\/sbin\/mysqld[0x5d21c8]\r\n\/usr\/sbin\/mysqld(_Z11mysqld_mainiPPc+0x3e5)[0x5d6de5]\r\n\/lib64\/libc.so.6(__libc_start_main+0xfd)[0x7f451da55d1d]\r\n\/usr\/sbin\/mysqld[0x5c83a5]\r\nThe manual page at http:\/\/dev.mysql.com\/doc\/mysql\/en\/crashing.html contains\r\ninformation that should help you find out what is causing the crash.\r\n180123 17:53:27 mysqld_safe mysqld from pid file \/u01\/app\/oracle\/mysql\/data\/mysqld.pid ended<\/pre>\n<p>It dos not look good, but even first thought was start working at MySQL level, reality is that this environment is very static and there were no changes in previous 24h, so we opted for fast and integrated VOM solution, MySQL restoration tool. It was enough to follow the clear Oracle&#8217;s documentation we can find <a href=\"https:\/\/docs.oracle.com\/cd\/E64076_01\/E64083\/html\/vmadm-manager-restore.html\">here<\/a>. In this case, we only need to restore the database, so we do not execute step one.<\/p>\n<p>OVMM automaticaly creates a daily full MySQL backup and stores it in the path <strong>\/u01\/app\/oracle\/mysql\/backup<\/strong> (OVM 3.4). Its contents in our server are:<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[oracle@ovmmanager ~]$ ls -latr \/u01\/app\/oracle\/mysql\/dbbackup\/\r\ntotal 2592\r\ndrwx------  4 oracle oinstall   4096 Apr  1  2015 3.3.1_preUpgradeBackup-20150401_114910\r\ndrwx------  4 oracle oinstall   4096 Mar 10  2016 3.3.2_preUpgradeBackup-20160310_145455\r\ndrwx------  4 oracle oinstall   4096 Mar 28  2016 3.3.3_preUpgradeBackup-20160328_133313\r\ndrwx------  4 oracle oinstall   4096 Dec 29  2016 3.4.1_preUpgradeBackup-20161229_195435\r\ndrwx------  4 oracle oinstall   4096 Sep 10 19:24 AutoFullBackup-20170910_192222\r\ndrwx------  4 oracle oinstall   4096 Sep 11 19:25 AutoFullBackup-20170911_192432\r\ndrwx------  4 oracle oinstall   4096 Sep 12 19:27 AutoFullBackup-20170912_192620\r\ndrwx------  4 oracle oinstall   4096 Sep 13 19:28 AutoFullBackup-20170913_192733\r\ndrwxr-xr-x  5 oracle dba        4096 Jan  5 12:18 ..\r\ndrwx------  4 oracle oinstall   4096 Jan  6 12:38 AutoFullBackup-20180106_123729\r\ndrwx------  4 oracle oinstall   4096 Jan  7 12:39 AutoFullBackup-20180107_123822\r\ndrwx------  4 oracle oinstall   4096 Jan  8 12:40 AutoFullBackup-20180108_123931\r\ndrwx------  4 oracle oinstall   4096 Jan  9 12:41 AutoFullBackup-20180109_124037\r\ndrwx------  4 oracle oinstall   4096 Jan 10 12:42 AutoFullBackup-20180110_124144\r\ndrwx------  4 oracle oinstall   4096 Jan 11 16:52 AutoFullBackup-20180111_165134\r\ndrwx------  4 oracle oinstall   4096 Jan 12 16:53 AutoFullBackup-20180112_165229\r\ndrwx------  4 oracle oinstall   4096 Jan 13 16:54 AutoFullBackup-20180113_165327\r\n-rw-r-----  1 oracle oinstall 251602 Jan 13 17:21 OVMModelExport-20180113_172134.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 14 16:55 AutoFullBackup-20180114_165436\r\n-rw-r-----  1 oracle oinstall 254527 Jan 14 17:21 OVMModelExport-20180114_172136.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 15 16:56 AutoFullBackup-20180115_165545\r\n-rw-r-----  1 oracle oinstall 257452 Jan 15 17:21 OVMModelExport-20180115_172138.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 16 16:57 AutoFullBackup-20180116_165655\r\n-rw-r-----  1 oracle oinstall 260363 Jan 16 17:21 OVMModelExport-20180116_172141.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 17 16:59 AutoFullBackup-20180117_165804\r\n-rw-r-----  1 oracle oinstall 263280 Jan 17 17:21 OVMModelExport-20180117_172144.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 18 17:00 AutoFullBackup-20180118_165918\r\n-rw-r-----  1 oracle oinstall 241287 Jan 18 17:21 OVMModelExport-20180118_172147.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 19 17:01 AutoFullBackup-20180119_170019\r\n-rw-r-----  1 oracle oinstall 244200 Jan 19 17:21 OVMModelExport-20180119_172149.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 20 17:02 AutoFullBackup-20180120_170140\r\n-rw-r-----  1 oracle oinstall 247125 Jan 20 17:21 OVMModelExport-20180120_172151.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 21 17:03 AutoFullBackup-20180121_170254\r\n-rw-r-----  1 oracle oinstall 250050 Jan 21 17:21 OVMModelExport-20180121_172154.xml\r\ndrwx------  4 oracle oinstall   4096 Jan 22 17:05 AutoFullBackup-20180122_170402\r\n-rw-r-----  1 oracle oinstall 250050 Jan 22 17:21 OVMModelExport-20180122_172156.xml\r\ndrwxr-xr-x 27 oracle dba        4096 Jan 22 17:21 .<\/pre>\n<p>Last copy, performed yesterday, is <strong>AutoFullBackup-20180122_170402<\/strong>. With this information, we firstly stop all OVMM processes (Weblogic OVM Server, Oracle VM Command Line Interface and MySQL database):<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[root@ovmmanager ~]# service ovmm stop\r\nStopping Oracle VM Manager                                 [  OK  ]\r\n\r\n[root@ovmmanager ~]# service ovmcli stop\r\nStopping Oracle VM Manager CLI                             [  OK  ]\r\n\r\n[root@ovmmanager ~]# service ovmm_mysql stop\r\nShutting down OVMM MySQL.. SUCCESS!<\/pre>\n<p>Now, as <strong>oracle<\/strong> user, we launch <strong>RestoreDatabase.sh<\/strong> shell script, specifying the name of the copy we will use for data restoration.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[oracle@ovmmanager ~]$ \/u01\/app\/oracle\/ovm-manager-3\/ovm_tools\/bin\/RestoreDatabase.sh AutoFullBackup-20180122_170402\r\n\r\nBefore the database can be restored, the following database directories\/files must be deleted:\r\nappfw ibdata1 ib_logfile0 ib_logfile1 mysql ovs performance_schema\r\n\r\nAre you sure it is safe to delete these directories\/files now? [y,n] y\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/appfw\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/ibdata1\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/ib_logfile0\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/ib_logfile1\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/mysql\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/ovs\r\nDeleting \/u01\/app\/oracle\/mysql\/data\/performance_schema\r\nINFO: Expanding the backup image...\r\nINFO: Applying logs to the backup snapshot...\r\nINFO: Restoring the backup...\r\nINFO: Restoring OVM keystores and certificates\r\nINFO: Success - Done!\r\nINFO: Log of operations performed is available at: \/u01\/app\/oracle\/mysql\/dbbackup\/AutoFullBackup-20180122_170402\/Restore.log\r\n\r\n\r\nIMPORTANT:\r\n\r\n      As 'root', please start the OVM Manager database and application using:\r\n            service ovmm_mysql start; service ovmm start; service ovmcli start\r\n\r\n\r\n[oracle@ovmmanager ~]$<\/pre>\n<p>It&#8217;s time to start services again.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[root@ovmmanager ~]# service ovmm_mysql start;\r\nStarting OVMM MySQL...... SUCCESS! \r\n\r\n[root@ovmmanager ~]# service ovmm start\r\nStarting Oracle VM Manager                                 [  OK  ]\r\n\r\n[root@ovmmanager ~]# service ovmcli start\r\nStarting Oracle VM Manager CLI                             [  OK  ]\r\n<\/pre>\n<p>Everything is OK, included the DB. Back to normal activity!<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">180123 18:03:50 mysqld_safe Starting mysqld daemon with databases from \/u01\/app\/oracle\/mysql\/data\r\n2018-01-23 18:03:50 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.\r\n2018-01-23 18:03:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).\r\n2018-01-23 18:03:50 0 [Note] \/usr\/sbin\/mysqld (mysqld 5.6.32-enterprise-commercial-advanced) starting as process 4526 ...\r\n2018-01-23 18:03:50 4526 [Note] Plugin 'FEDERATED' is disabled.\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Using atomics to ref count buffer pool pages\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: The InnoDB memory heap is disabled\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Memory barrier is not used\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Compressed tables use zlib 1.2.3\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Using Linux native AIO\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Using CPU crc32 instructions\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Initializing buffer pool, size = 1.0G\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Completed initialization of buffer pool\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Highest supported file format is Barracuda.\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: The log file was created by mysqlbackup --apply-log at ibbackup 180123 17:59:17. The following crash recovery is part of a normal restore.\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: The log sequence numbers 1484386085656 and 1484386085656 in ibdata files do not match the log sequence number 1511045530636 in the ib_logfiles!\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Database was not shutdown normally!\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Starting crash recovery.\r\n2018-01-23 18:03:51 4526 [Note] InnoDB: Reading tablespace information from the .ibd files...\r\n2018-01-23 18:03:54 4526 [Note] InnoDB: Restoring possible half-written data pages \r\n2018-01-23 18:03:54 4526 [Note] InnoDB: from the doublewrite buffer...\r\n2018-01-23 18:03:55 4526 [Note] InnoDB: 128 rollback segment(s) are active.\r\n2018-01-23 18:03:55 4526 [Note] InnoDB: Waiting for purge to start\r\n2018-01-23 18:03:55 4526 [Note] InnoDB: 5.6.32 started; log sequence number 1511045530636\r\n2018-01-23 18:03:55 4526 [Note] RSA private key file not found: \/u01\/app\/oracle\/mysql\/data\/\/private_key.pem. Some authentication plugins will not work.\r\n2018-01-23 18:03:55 4526 [Note] RSA public key file not found: \/u01\/app\/oracle\/mysql\/data\/\/public_key.pem. Some authentication plugins will not work.\r\n2018-01-23 18:03:55 4526 [Note] Server hostname (bind-address): '*'; port: 49500\r\n2018-01-23 18:03:55 4526 [Note] IPv6 is available.\r\n2018-01-23 18:03:55 4526 [Note]   - '::' resolves to '::';\r\n2018-01-23 18:03:55 4526 [Note] Server socket created on IP: '::'.\r\n2018-01-23 18:03:55 4526 [Note] Event Scheduler: Loaded 0 events\r\n2018-01-23 18:03:55 4526 [Note] \/usr\/sbin\/mysqld: ready for connections.\r\nVersion: '5.6.32-enterprise-commercial-advanced'  socket: '\/u01\/app\/oracle\/mysql\/data\/mysqld.sock'  port: 49500  MySQL Enterprise Server - Advanced Edition (Commercial)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This morning we suffered a hardware failure in one of our OVM lab servers (version 3.4). In this environment, OVM Manager is deployed inside the OVM cluster, and the incident crashed its virtual machine. At VM startup using xm create command from the OVM Server command line, OS startup up OK, but OVM components did [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":8889,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[26,49],"tags":[],"class_list":["post-8878","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portada-en","category-slider-post-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OVM Manager MySQL database restoration - Arumel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OVM Manager MySQL database restoration - Arumel\" \/>\n<meta property=\"og:description\" content=\"This morning we suffered a hardware failure in one of our OVM lab servers (version 3.4). In this environment, OVM Manager is deployed inside the OVM cluster, and the incident crashed its virtual machine. At VM startup using xm create command from the OVM Server command line, OS startup up OK, but OVM components did [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-23T18:09:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548\" \/>\n\t<meta property=\"og:image:width\" content=\"1492\" \/>\n\t<meta property=\"og:image:height\" content=\"548\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Alberto Pereiro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alberto Pereiro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/\"},\"author\":{\"name\":\"Alberto Pereiro\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"headline\":\"OVM Manager MySQL database restoration\",\"datePublished\":\"2018-01-23T18:09:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/\"},\"wordCount\":232,\"commentCount\":0,\"image\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vesubio.jpg?fit=1492%2C548&ssl=1\",\"articleSection\":[\"portada\",\"slider-post\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/\",\"url\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/\",\"name\":\"OVM Manager MySQL database restoration - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vesubio.jpg?fit=1492%2C548&ssl=1\",\"datePublished\":\"2018-01-23T18:09:29+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vesubio.jpg?fit=1492%2C548&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vesubio.jpg?fit=1492%2C548&ssl=1\",\"width\":1492,\"height\":548},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/arumel.com\\\/en\\\/ovm-manager-mysql-database-restoration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\\\/\\\/arumel.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OVM Manager MySQL database restoration\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\",\"url\":\"http:\\\/\\\/arumel.com\\\/\",\"name\":\"Arumel\",\"description\":\"Outro sitio WordPress m\u00e1is\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/arumel.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\",\"name\":\"Alberto Pereiro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"caption\":\"Alberto Pereiro\"},\"url\":\"https:\\\/\\\/arumel.com\\\/en\\\/author\\\/alberto\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OVM Manager MySQL database restoration - Arumel","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":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/","og_locale":"en_US","og_type":"article","og_title":"OVM Manager MySQL database restoration - Arumel","og_description":"This morning we suffered a hardware failure in one of our OVM lab servers (version 3.4). In this environment, OVM Manager is deployed inside the OVM cluster, and the incident crashed its virtual machine. At VM startup using xm create command from the OVM Server command line, OS startup up OK, but OVM components did [&hellip;]","og_url":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/","og_site_name":"Arumel","article_published_time":"2018-01-23T18:09:29+00:00","og_image":[{"width":1492,"height":548,"url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548","type":"image\/jpeg"}],"author":"Alberto Pereiro","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alberto Pereiro","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#article","isPartOf":{"@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/"},"author":{"name":"Alberto Pereiro","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"headline":"OVM Manager MySQL database restoration","datePublished":"2018-01-23T18:09:29+00:00","mainEntityOfPage":{"@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/"},"wordCount":232,"commentCount":0,"image":{"@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548&ssl=1","articleSection":["portada","slider-post"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/","url":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/","name":"OVM Manager MySQL database restoration - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#primaryimage"},"image":{"@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548&ssl=1","datePublished":"2018-01-23T18:09:29+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"breadcrumb":{"@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548&ssl=1","width":1492,"height":548},{"@type":"BreadcrumbList","@id":"http:\/\/arumel.com\/en\/ovm-manager-mysql-database-restoration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/arumel.com\/en\/"},{"@type":"ListItem","position":2,"name":"OVM Manager MySQL database restoration"}]},{"@type":"WebSite","@id":"http:\/\/arumel.com\/#website","url":"http:\/\/arumel.com\/","name":"Arumel","description":"Outro sitio WordPress m\u00e1is","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/arumel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc","name":"Alberto Pereiro","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","caption":"Alberto Pereiro"},"url":"https:\/\/arumel.com\/en\/author\/alberto\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2jc","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":8869,"url":"https:\/\/arumel.com\/restauracion-de-bd-mysql-ovm-manager\/","url_meta":{"origin":8878,"position":0},"title":"Restauraci\u00f3n de BD MySQL OVM Manager","author":"Alberto Pereiro","date":"23 January, 2018","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle VM&quot;","block_context":{"text":"Oracle VM","link":"https:\/\/arumel.com\/oracle-vm-5\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8872,"url":"https:\/\/arumel.com\/es\/restauracion-de-bd-mysql-ovm-manager\/","url_meta":{"origin":8878,"position":1},"title":"Restauraci\u00f3n de BD MySQL OVM Manager","author":"Alberto Pereiro","date":"23 January, 2018","format":false,"excerpt":"","rel":"","context":"In &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/es\/portada-es\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8874,"url":"https:\/\/arumel.com\/eu\/restauracion-de-bd-mysql-ovm-manager\/","url_meta":{"origin":8878,"position":2},"title":"Restauraci\u00f3n de BD MySQL OVM Manager","author":"Alberto Pereiro","date":"23 January, 2018","format":false,"excerpt":"Esta ma\u00f1ana se produjo un fallo hardware en uno de los servidores de laboratorio con OVM Server 3.4. En este entorno, OVM Manager est\u00e1 desplegado dentro del propio cl\u00faster OVM, y la incidencia provoc\u00f3 su ca\u00edda abrupta. Al arrancar la m\u00e1quina de manera manual desde el servidor OVM con el\u2026","rel":"","context":"In &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/eu\/portada-eu\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8876,"url":"https:\/\/arumel.com\/ca\/restauracion-de-bd-mysql-ovm-manager\/","url_meta":{"origin":8878,"position":3},"title":"Restauraci\u00f3n de BD MySQL OVM Manager","author":"Alberto Pereiro","date":"23 January, 2018","format":false,"excerpt":"","rel":"","context":"In &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/ca\/portada-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1200%2C441&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":9441,"url":"https:\/\/arumel.com\/en\/upgrading-ovm-manager-from-3-4-5-to-3-4-6\/","url_meta":{"origin":8878,"position":4},"title":"Upgrading OVM Manager from 3.4.5 to 3.4.6","author":"sm","date":"24 January, 2019","format":false,"excerpt":"You can download the software from Oracle web (version 3.4.6): ovmm-3.4.6-installer-OracleLinux-b2105.iso Mount .iso image into the dvd and install: [root@ovmmanager1 mnt]# blkid\/dev\/sr0: UUID=\u201d2018-11-18-18-00-21-00\u2033 LABEL=\u201dOVMManagerInstaller3.4.6_b2105\u2033 ENGINE=\u201diso9660\u2033 \/dev\/sdb1: UUID=\u201dYATjNB-faXI-4JI4-e1g0-Nule-j9PI-deUIL7\u2033 ENGINE=\u201dLVM2_member\u201d \/dev\/sda1: UUID=\u201dd6784bfc-5b94-4a89-b3c5-a178626c365e\u201d ENGINE=\u201dxfs\u201d \/dev\/sda2: UUID=\u201d0zW6wH-XKd7-WtFK-yVHe-qFv2-3HVA-j9XzFE\u201d ENGINE=\u201dLVM2_member\u201d \/dev\/mapper\/ol-root: UUID=\u201d1c5b0906-7d82-40cf-9f28-89835617b4e5\u2033 ENGINE=\u201dxfs\u201d \/dev\/mapper\/ol-swap: UUID=\u201d6e33b169-061e-4a36-89b7-6b38ac1f9457\u2033 ENGINE=\u201dswap\u201d [root@ovmmanager1 ~]# mount \/dev\/sr0 \/mntmount: \/dev\/sr0 is write-protected, mounting read-only\u2026","rel":"","context":"In &quot;Oracle VM&quot;","block_context":{"text":"Oracle VM","link":"https:\/\/arumel.com\/en\/oracle-vm-4\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9437,"url":"https:\/\/arumel.com\/es\/actualizando-ovm-manager-de-3-4-5-a-3-4-6\/","url_meta":{"origin":8878,"position":5},"title":"Actualizando OVM Manager de 3.4.5 a 3.4.6","author":"sm","date":"24 January, 2019","format":false,"excerpt":"Descargamos de la web de Oracle el software para la versi\u00f3n 3.4.6: ovmm-3.4.6-installer-OracleLinux-b2105.iso Montamos el dvd en la m\u00e1quina y procedemos con la instalaci\u00f3n: [root@ovmmanager1 mnt]# blkid \/dev\/sr0: UUID=\"2018-11-18-18-00-21-00\" LABEL=\"OVMManagerInstaller3.4.6_b2105\" ENGINE=\"iso9660\" \/dev\/sdb1: UUID=\"YATjNB-faXI-4JI4-e1g0-Nule-j9PI-deUIL7\" ENGINE=\"LVM2_member\" \/dev\/sda1: UUID=\"d6784bfc-5b94-4a89-b3c5-a178626c365e\" ENGINE=\"xfs\" \/dev\/sda2: UUID=\"0zW6wH-XKd7-WtFK-yVHe-qFv2-3HVA-j9XzFE\" ENGINE=\"LVM2_member\" \/dev\/mapper\/ol-root: UUID=\"1c5b0906-7d82-40cf-9f28-89835617b4e5\" ENGINE=\"xfs\" \/dev\/mapper\/ol-swap: UUID=\"6e33b169-061e-4a36-89b7-6b38ac1f9457\" ENGINE=\"swap\" [root@ovmmanager1 ~]# mount \/dev\/sr0\u2026","rel":"","context":"In &quot;Oracle VM&quot;","block_context":{"text":"Oracle VM","link":"https:\/\/arumel.com\/es\/oracle-vm\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vesubio.jpg?fit=1492%2C548&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/8878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/comments?post=8878"}],"version-history":[{"count":2,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/8878\/revisions"}],"predecessor-version":[{"id":8882,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/8878\/revisions\/8882"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/media\/8889"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/media?parent=8878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/categories?post=8878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/tags?post=8878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}