Blog Articles
Read MSP360’s latest news and expert articles about MSP business and technology
MSP360 Standalone Backup

How to Restore Oracle Database with MSP360 Backup

How to Restore Oracle Database with MSP360 Backup

In this blog post we will explain how you can restore an Oracle database using MSP360 Backup.

Restoring an Oracle Database

In order to restore the Oracle database, please follow the steps described below:

Step 1: First of all, you need to download your RMAN backups from the cloud.

1. Open MSP360 Backup and go to the “Backup Storage” tab.

2. Select your storage account where Oracle files are stored.

3. Right-click the folder that contains your backup files and press "Restore".

Please restore the backup to your RMAN directory, in our case, we will restore to the C:\Oracle\backup\ directory.

Note: If your server has crashed, you will need to recover your backup using the following guide.

Oracle Restore

4. The backup set contains two files - a copy of your control file (less size) and a copy of your database itself (larger size)

Step 2: After you have downloaded your backup set from the cloud, you need to recover your database.

We will use the previously mentioned Oracle RMAN utility for this purpose.

Please perform the steps below:

1. Open the command prompt and run the RMAN.exe file.

2. Execute the following RMAN commands:

Connect to the database that you are going to restore:

CONNECT TARGET SYSTEM/MANAGER

If your database is running, shut it down and start it in the NOMOUNT mode:

SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;

Recover your control file:

RESTORE CONTROLFILE FROM “C:\Oracle\backup\10Q5MFOT_1_1”;

Note: You need to replace the 10Q5MFOT_1_1 with the name of your control file backup.

After the control file is restored, mount your database:

ALTER DATABASE MOUNT;

Restore and recover the database itself:

RESTORE DATABASE;
RECOVER DATABASE;

After you have recovered your database, open it with the resetlogs option as it is shown below:

ALTER DATABASE OPEN RESETLOGS;

Step 3: Your database, all the control files and datafiles are restored, you can continue working with your database.

FREE WHITEPAPER
Full System Backup and Recovery

Our guide provides an overview of system backup and recovery methods:

  • System image and system state backup and recovery
  • Bare-metal recovery
  • Application-aware backup and recovery
New call-to-action
Whitepaper icon