To reduce throttling and API limits, you can now use extra accounts or credentials during GIT and ADO restores.
CHANGELOG
🏠︎ HOME@ WEBSITE↘ FREE TRIAL✉︎ CONTACT SUPPORT

Oracle database backup

This article describes how to configure the Oracle database environment in Xopero ONE.

General information

The Oracle database backup process in Xopero ONE consists of two stages:

  1. Creating a database dump using backup scripts.

  2. Backing up the created dump file.

The first stage is executed through Xopero ONE using the backup scripts feature, while the second stage is performed as a standard file-level backup.

Xopero ONE creates a full database copy using the RMAN tool. It does not interfere with other copies performed by RMAN, but the backup created by Xopero ONE will be visible in RMAN.

The backup reflects the database state at the moment the dump creation task finishes, as Xopero ONE attaches the archive logs to ensure data consistency.

Requirements and limitations

Xopero ONE supports Oracle database environments starting from version 19c.

Xopero ONE supports Oracle database backup only on supported Linux operating systems.

The Oracle database environment must operate in ARCHIVELOG mode. For instructions on how to change the database mode, refer to this article.

Backup configuration

If a file-level backup plan has already been created and is running, you can skip directly to step 6.

1

Log in to , go to the Backup tab (Plans > Backup) and click the + Add plan button in the top toolbar.

2

Select Devices from the platforms list.

3

In the next aside, select Files & folders option and choose one or more devices for the plan to apply to (you can also select the plan to include all activated devices).

4

Define the name of the backup plan.

5

Configure your backup plan according to your needs (more information about the backup plan setup can be found in this article).

6

Go to the Advanced settings section and click Edit to customize additional options.

7

Scroll down to the Backup scripts section and click the Pre-task script toggle to turn it on.

8

Select the script dedicated to backing up the Oracle database environment.

9

Set up the script arguments — it should be entered in the Script arguments field as follows:

ORACLE_SID;dbuser;temp_directory

  1. ORACLE_SID – the database identifier.

  2. dbuser – the name of the user with backup privileges (for example, database_user). This must be a local Linux OS user with permissions to back up the Oracle environment. Instructions for creating this user are provided in the x section of this article.

  3. temp_directory – the directory where the Oracle tool will temporarily write backup files. After the backup tasks are complete, these files will be deleted. This directory must also be included in the Data to protect section when creating a file-level backup plan.

10

Enable the two additional options using the checkboxes:

  1. Wait for the script to continue the task — the application will wait until the dump is ready.

  2. Fail the task if the script fails — if the script fails, the system will notify you of the backup error.

11

Double-check your settings and click Save to close the Advanced settings aside.

12

After completing the configuration, click the Save button. The protection plan will then automatically begin protecting your devices and databases according to the schedule you defined.

You can also click Save&Run button to immediately start the backup process, regardless of schedule.

Creating a user to back up Oracle

  1. Add a new user (for example, dbuser) to the Linux operating system by executing the following command:

sudo useradd dbuser

  1. Add the user to the dba group, which has permission to perform backups:

sudo usermod -a -G dba dbuser

Oracle tools may require additional permissions, such as access to the file system — in that case, you may need to add the user to other groups depending on your system configuration.

  1. Finally, configure the system environment variables by following the instructions in this article.

Last updated