How to Restore The Oracle Database From Amazon S3

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.

Alexander N

Alexander is the director of marketing at MSP360 and has been an important member of the company since its inception. He is an expert in IT marketing and has extensive knowledge of cloud storage services. Alexander cooperates with cloud vendors, MSPs, VARs and communicates the market needs and trends to our team.

See Full Bio

FREE WHITEPAPER

Full System Backup and Recovery

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