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.
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.
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.
MSP360 and Wasabi are joining forces to bring you a comprehensive webinar that delves into…
An educational webinar where we'll walk you through the key steps to getting started with…
Managed service providers (MSPs) understand the importance of being proactive regarding security threats, data breaches,…
Like any system, the MSP360 platform offers many features that are used every day to…
Managing your data and ensuring compliance with the ever-evolving regulatory landscape is not just a…
We’re excited to introduce MSP360 Managed Backup for Microsoft 365 and Google Workspace 4.0 with…