Link Search Menu Expand Document

Oracle

General

Veeam can backup Oracle databases via image level backup or via an RMAN plugin. Which one to use depends on your environment, requirements and limitations. You can also mix and match these methods to achieve more restore options and granularity, though when you handle archive logs, be sure to do this in only one of the backup methods to keep consistency.

Oracle Image-Level backup

Job configuration

Avoid using aggressive log truncation settings for databases protected with Data Guard as it may affect logs synchronization to secondary server. Data Guard should have enough time to transport logs remotely before they are truncated. Thus generally having “Delete logs older than” option configure to less than 24 hours is not recommended.

Archived Log Backup

Please be aware that archived logs are processed periodically and stored in a temporary folder inside the VM before transmitting them to a repository/shipping server.

Windows

The default location of the temporary folder on Windows systems is :\Veeam\Backup\OracleLogBackup.

If you wish to specify the location of the temporary file you can do so by adding or changing the OracleTempLogPath registry value in the guest OS:

  • Path: HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication
  • Key: OracleTempLogPath
  • Type: REG_SZ
  • Default value: undefined

Linux

For Linux, the directory with the most free space will be chosen between /var/tmp and /tmp in the default configuration. To change this path create a file in /tmp called VeeamOracleAgent.xml with the following content, where /location has to be replaced with your desired path: <config OracleTempLogPath=”/location”></config>

Veeam Plugin for Oracle RMAN

Oracle Enviroment

Veeam performs SQL queries on Oracle database to collect the statistical information about the RMAN job process, based on available resources Oracle can decide to use Temp Tablespace resources, it’s best practice to configure the Temp Tablespace resources to avoid shortage of Temporary tablespace. You can check the Temp Tablespace size with the below SQL query:

SELECT * FROM DBA_TEMP_FREE_SPACE;

You can also create new temp tablespace, for example the new tablespace for 500M:

CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE '/DATA/database/ifsprod/temp_01.dbf' SIZE 500m autoextend on next 10m maxsize unlimited;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_NEW;

Oracle RAC:

Before starting the configuration of Veeam Plugin for Oracle RMAN, it is recommended to check the oratab file. It should have entries about all the Oracle RAC nodes, if any node is missing please add that in oratab file.

As a best practice, it’s recommended to install Veeam Pugin for RMAN on all Oracle RAC nodes.

Oracle Home

It’s recommended to backup the Oracle home along with Oracle RMAN backup. You can use the Veeam Agent or Veeam Backup & Replication image level backup for this.

Veeam Environment

Use a dedicated backup repository for Oracle RMAN backups. The following resources are required:

Oracle server: 1 CPU core and 200 MB of RAM per concurrently used channel. Backup repository server: 1 CPU core and 1 GB of RAM per 5 concurrently used channels.

Oracle restore and failover workflow

Before the backup, the database (in ARCHIVELOG mode only) is put into backup mode. This has to be taken into consideration when performing restore. Restoring the database server VM is not enough for restoring the service. The database has to be put out of backup mode:

ALTER DATABASE END BACKUP

Network:

Network plays the important role in the overall backup performance.

The following network settings should be configured:

Item Value Comments
Jumbo Frames Enable Veeam Repository and Oracle Servers
Network Speed Mutiple 10 Gbps cards ideally delicated layer 2 network for backup operation
IPV6 Disable IPv6 should be disable on Oracle Database server when possible

RMAN Backup Retention:

The RMAN backup retention is controlled by RMAN, you cannot set the different retention policy on the backups, RMAN retentions is set globally.

Use Veeam backup copy option set configure different retention policy.

To configure the backup retention policy on the RMAN use:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

RMAN FILEPERSET:

FILESPERSET:

FILESPERSET set as 1 can increase the backup performance, FILESPERSET settings can be increased based on the environment, it’s recommended to test the different value and use the one which validate the performance improvement.

Generally the ideal value for FILESPERSET is ranging from 3 to 5.

Veeam Repository for Oracle RMAN Backup:

Veeam Repository:

As per the best practice it’s recommended to have a delicated backup repository for Veeam Plugin for Oracle RMAN backup, sharing repository among the different workloads may reduce the backup performance.

When possible it’s also recommended to use simple backup repository.

CPU and Memory:

Veeam Backup Repository Server should have 8 GB of Memory and 2 CPU core for Windows operations, and for 1 CPU core and 1 GB of RAM per 5 currently used channels.

Please be cautions to count number of database backups run in parallel, also consider the restore operations for the large environment where during the backup operations for database A and database B, you need to perform restores for Database C

Number of Numbers Channels * Number of Databases = Total Number of Channels Total Numbers of Channels / 5 = Amount of Memory + 15% Amount of Memory in GBs = Number of CPU Core

For example:

5 Databases backup running in parallel with 4 RMAN channels:

4 * 5 = 20 20 / 5 = 4 GB + 15% = Number of CPUs Core = 4

If you are using Veeam Agent for Windows or Linux to run the Oracle RMAN backup as pre or post script inculde the repository channels for the agents job as well.

##MAXPIECESIZE

MAXPIECESIZE can help to limit the backup piece for the large database file, the smaller files can be good fit for the scale out repository and optizmed Veeam backup copy operations.

##MAXOPENFILES

This defines the number of files that can be read simultaneously by each channel, the default number of MAXOPENFILES are 8

You can reduce or increase the MAXOPENFILES depends on source server load, if the source server is overutlized consider reducing the MAXOPENFILES to be best fit for the enviroment.

##RMAN Compression:

Compression help reduced the space utilized by backup set on the backup storage, RMAN uses a binary compression algorithm to the backup set, The default compression algorithm setting is BASIC and does not require the Advanced Compression Option.

RMAN compression is CPU intensive and CPU avabaility can be a limiting factor.

Compression Mode Default Backup Size CPU overhead
Basic Yes Small Very Low
Low No Small low
Medium No smaller than low High
High No Smallest Very High

If you are using RMAN compression, disable Veeam compression.

Granular item restore

Oracle restore using Veeam Explorer for Oracle uses a combination of executing commands via SSH or RPC depending on the platform, and using the RMAN client. VM disks are mounted to target server using iSCSI (Windows) or FUSE and loop device (Linux). Only database files will be restored, not instance files. Instance files may be recovered through file-level recovery if needed.

Ensure the account used to connect to target/staging server has enough permissions on operating system and database as described in the corresponding section of User Guide.

Note: When restoring to Linux ensure that account used to connect to restore target server has valid shell (bash).


References


Back to top

Copyright © 2019-2021 Solutions Architects, Veeam Software.