{"id":6141,"date":"2015-05-21T23:27:11","date_gmt":"2015-05-21T19:27:11","guid":{"rendered":"http:\/\/www.msp360.com\/blog\/?p=6141"},"modified":"2023-12-06T15:59:30","modified_gmt":"2023-12-06T11:59:30","slug":"how-to-restore-oracle-database","status":"publish","type":"post","link":"https:\/\/www.msp360.com\/resources\/blog\/how-to-restore-oracle-database\/","title":{"rendered":"How to Restore Oracle Database with MSP360 Backup"},"content":{"rendered":"<p>In this blog post we will explain how you can restore an Oracle database using MSP360 Backup.<\/p>\n<p><!--more--><\/p>\n<h2>Restoring an Oracle Database<\/h2>\n<p>In order to restore the Oracle database, please follow the steps described below:<\/p>\n<p><strong>Step 1:<\/strong> First of all, you need to download your RMAN backups from the cloud.<\/p>\n<p>1. Open <a href=\"https:\/\/msp360.com\/msp360-standalone-backup\/?show-product=windows-server\">MSP360 Backup<\/a> and go to the \u201cBackup Storage\u201d tab.<\/p>\n<p>2. Select your storage\u00a0account where Oracle files are stored.<\/p>\n<p>3. Right-click the folder that contains your backup files and press \"Restore\".<\/p>\n<p>Please restore the backup to your RMAN directory, in our case, we will restore to the C:\\Oracle\\backup\\ directory.<\/p>\n<p><strong>Note:<\/strong> If your server has crashed, you will need to recover your backup using <a href=\"https:\/\/www.msp360.com\/resources\/blog\/how-to-restore-data-from-amazon-s3-to-a-new-computer\/\">the following guide<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6142 size-full\" src=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2015\/05\/Oracle_Restore.png\" alt=\"Oracle Restore\" width=\"628\" height=\"181\" srcset=\"https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2015\/05\/Oracle_Restore.png 628w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2015\/05\/Oracle_Restore-300x86.png 300w, https:\/\/www.msp360.com\/resources\/wp-content\/uploads\/2015\/05\/Oracle_Restore-624x180.png 624w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/p>\n<p>4. The backup set contains two files - a copy of your control file (less size) and a copy of your database itself (larger size)<\/p>\n<p><strong>Step 2: <\/strong>After you have downloaded your backup set from the cloud, you need to recover your database.<\/p>\n<p>We will use the previously mentioned Oracle RMAN utility for this purpose.<\/p>\n<p>Please perform the steps below:<\/p>\n<p>1. Open the command prompt and run the RMAN.exe file.<\/p>\n<p>2. Execute the following RMAN commands:<\/p>\n<p>Connect to the database that you are going to restore:<\/p>\n<pre><strong>CONNECT TARGET SYSTEM\/MANAGER<\/strong><\/pre>\n<p>If your database is running, shut it down and start it in the NOMOUNT mode:<\/p>\n<pre><strong>SHUTDOWN IMMEDIATE;<\/strong><\/pre>\n<pre><strong>STARTUP NOMOUNT;<\/strong><\/pre>\n<p>Recover your control file:<\/p>\n<pre><strong>RESTORE CONTROLFILE FROM \u201cC:\\Oracle\\backup\\10Q5MFOT_1_1\u201d;<\/strong><\/pre>\n<p><strong>Note:<\/strong> You need to replace the 10Q5MFOT_1_1 with the name of your control file backup.<\/p>\n<p>After the control file is restored, mount your database:<\/p>\n<pre><strong>ALTER DATABASE MOUNT;<\/strong><\/pre>\n<p>Restore and recover the database itself:<\/p>\n<pre><strong>RESTORE DATABASE;\r\n<\/strong><strong>RECOVER DATABASE;<\/strong><\/pre>\n<p>After you have recovered your database, open it with the resetlogs option as it is shown below:<\/p>\n<pre><strong>ALTER DATABASE OPEN RESETLOGS;<\/strong><\/pre>\n<p><strong>Step 3: <\/strong>Your database, all the control files and datafiles are restored, you can continue working with your database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post we will explain how you can restore an Oracle database using MSP360 Backup.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[877,894,882],"tags":[],"class_list":["post-6141","post","type-post","status-publish","format-standard","hentry","category-blog-articles","category-msp360-backup","category-msp360-news"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/6141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/comments?post=6141"}],"version-history":[{"count":1,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/6141\/revisions"}],"predecessor-version":[{"id":56760,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/6141\/revisions\/56760"}],"wp:attachment":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media?parent=6141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/categories?post=6141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/tags?post=6141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}