How to Restore Oracle Database from Amazon S3

After you perform Oracle backup using our previous article, you may need to restore your database. In this blog post we will explain how you can restore the Oracle database with CloudBerry Backup.

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 CloudBerry Backup and go to the Backup Storage tab.
  2. Select your Amazon S3 account from a drop-down list.
  3. Right-click the folder that contains your backup files and press restore.

Restore from Backup Storage

Please restore the backup to your RMAN directory - in our example we will restore it to C:\Oracle\backup\
Note: If your server crashed, you will need to recover your backup using the following guide

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 download your backup set from the cloud, you need to recover your database. We will use previously mentioned Oracle RMAN utility for this purpose.

Please perform the steps below:

  1. Open command prompt and run RMAN.exe
  2. Execute the following RMAN commands:

Connect to the database that you want 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 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 recover your database, open it with the resetlogs option as shown below:

ALTER DATABASE OPEN RESETLOGS;

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

Summary

With CloudBerry Backup you can keep Oracle databases in safe on any cloud storage. It is easy to set up backup and restore using the wizards.