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.
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.
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/resources/blog/deleting-files-from-local-storage-after-a-successful-backup/
Finish up the wizard to create a backup plan. That’s it.
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.