Users who want to back up their Oracle databases to cloud storage using MSP360 Backup should take some extra actions to perform a cloud database backup.
The main point is that you need a backup script for the Oracle database backup that MSP360 Backup will run prior to uploading the backup script result into the cloud. Below is the step-by-step guide for the Oracle database backup with MSP360 Backup.
How to Configure a Backup Plan
1. Choose temporary storage and create a folder for your backup files. For example, C:\Oracle\backup
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 in 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 data files, 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
3. Launch MSP360 Backup then click on the "Backup Files" button in the top menu.
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.
We strongly recommended to include empty folders and hidden/system files into your backup to fully keep the Oracle database structure.
5. 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.
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 how to delete files from local storage in our article.
6. Finish up the wizard to create a backup plan. That’s it.
Summary
MSP360 Backup allows you 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 MSP360 Backup.
- Image-based, system state and file-level backup
- Local, cloud and hybrid backup
- Multiple recovery options (bare-metal, USB, cloud)
