How to Back Up Oracle Database to Amazon S3, Microsoft Azure (or other cloud storage provider)

Users who want to back up their Oracle databases to cloud storage using CloudBerry Backup should take some extra actions to perform cloud database backup.

The main point is that you need a backup script for the Oracle database backup that CloudBerry Backup will run prior uploading the backup script result in to the cloud. Below is the step-by-step guide for the Oracle database backup with CloudBerry Backup.

How to configure a backup plan

Step 1. Choose temporary storage and create a folder for your backup files. For example, C:\Oracle\backup

Step 2. Create a script to run by a system. It’s quite simple. Use RMAN (Recovery Manager), it is a native Oracle utility, that is included into default installation of the Oracle database. RMAN is a backup and recovery manager supplied for Oracle databases (from version 8) created by the Oracle Corporation.

The script is:

CONNECT TARGET SYSTEM/MANAGER

BACKUP DATABASE FORMAT="C:\Oracle\backup\%U";

This script connects to your database under default SYSTEM user and creates a copy of all critical datafiles, tablespaces and logs. Please note that in order to run this RMAN job, your database should be in the ARCHIVELOG mode. Let’s save this script as a C:\Oracle\backup\backup.rman

Step 3. Launch CloudBerry Backup then click on the "Backup Files" button in the top menu.

Step 4. Specify Backup Source. Here you need to choose the folder created in Step 1. If it is a network share, don't forget to specify your network credentials in Tools | Network Credentials.

Step 5. We strongly recommended to include empty folders and hidden/system files into your backup to fully keep Oracle database structure.

Advanced Filter

Step 6. On the Pre/Post Actions step, you need to specify the RMAN script file created in Step 2. It will be executed before the backup job runs.

Pre-action step

Note: If you don't want to store results of the RMAN backup after you have uploaded it to the cloud,  you can create the BAT file that will delete those files. Learn more at https://www.cloudberrylab.com/blog/deleting-files-from-local-storage-after-a-successful-backup/

Finish up the wizard to create a backup plan. That’s it.

Summary

CloudBerry Backup allows to back up Oracle databases to any cloud storage. Its Pre/Post Action step automatically creates an RMAN backup of your database and then it uploads the backup to the cloud.

Note: You can skip Pre/Post Actions and intermediate folder steps, if you manually execute the RMAN.exe, and then specify the folder with Oracle backup data when creating a backup plan in CloudBerry Backup.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...