This is an archive version of the document. To get the most up-to-date information, see the current version.

Oracle Backup

You can use Veeam Agent for Linux to create transactionally consistent backups of Veeam Agent machines that run the Oracle database system.

Oracle Backup Note:

You can use Veeam Explorer for Oracle to restore Oracle databases from a Veeam Agent for Linux backup. For information about item-level recovery of Oracle systems, see Veeam Explorers User Guide.

How Oracle Processing Works

To ensure that the backed-up data is in the consistent state, Veeam Agent for Linux performs the Oracle database system processing. To process the database system, Veeam Agent performs the following operations:

When the backup job starts, Veeam Agent obtains information about Oracle databases that run on the Veeam Agent machine.
Veeam Agent connects to the Oracle database and operates depending on the database state:

Shutdown state
ARCHIVELOG mode
NOARCHIVELOG mode

After Veeam Agent for Linux finishes database system processing, Veeam Agent proceeds to the next step of the backup process. To learn more, see How Backup Works.

Processing of Database in Shutdown State

If the database is shut down, Veeam Agent skips it and connects to the next database. The skipped database will be included in the backup. To restore such database, you must restore the entire volume that contains the database. You cannot restore the database as an independent item using Veeam Explorer for Oracle. To learn more, see Veeam Explorers User Guide.

Veeam Agent displays a warning message about the database that is shut down in the job session logs. The backup job does not fail.

Processing of Database in ARCHIVELOG Mode

If the Oracle database is running in the ARCHIVELOG mode, the Oracle database system keeps archived logs that allow to recover all committed transactions of the database. To learn more, see Oracle documentation.

If the database operates in the ARCHIVELOG mode, Veeam Agent performs the following operations:

Veeam Agent switches the database to the backup mode. Veeam Agent changes the database state using the Oracle functionality.
Veeam Agent creates a snapshot of the volume.
Veeam Agent returns the database to the initial state.

Processing of Database in NOARCHIVELOG Mode

If the Oracle database is running in the NOARCHIVELOG mode, the Oracle database system does not create archived logs. Logs that are created before the database is switched to NOARCHIVELOG remain untouched. In this mode, you can only restore the database to the point of full database backup. You cannot recover transactions subsequent to that full database backup.

If the database operates in the NOARCHIVELOG mode, Veeam Agent performs the following operations:

Veeam Agent shuts down the database. Veeam Agent changes the database states using the Oracle functionality.
Veeam Agent creates a snapshot of the volume.
Veeam Agent returns the database to the initial state.

Authentication Methods

Veeam Agent for Linux can connect to the Oracle database system and perform Oracle archived logs backup and/or deletion using one of the following account types:

System account — Veeam Agent uses the account of the Veeam Agent machine OS. To connect to the Oracle database system, the account must be a member of the group that owns Oracle database files.
Oracle account — Veeam Agent uses the Oracle account. To connect to the Oracle database system, the account must have SYSDBA rights.

Archived Log Processing

Oracle Backup Note:

Veeam Agent for Linux operating in the standalone mode supports the backup of archived logs, but does not support a separate schedule and retention policy for the backup of archived logs. This functionality is available only for Veeam Agent for Linux operating in the managed mode within the Veeam Agent management scenario. For more information, see Oracle Archived Log Settings section in the Veeam Agent Management Guide.

In the ARCHIVELOG mode, the Oracle database system stores database archived logs to a certain location on the machine that runs the database system, as specified by the database administrator. Veeam Agent allows you to set up the following ways of archived logs processing:

Delete logs older than the specified time (in hours). After the backup job completes, Veeam Agent deletes archived logs that are older than the specified time from the Veeam Agent machine. This helps make sure that logs do not overflow the storage space on the processed machine.
Delete oldest logs larger than the specified size (in GB). After the backup job completes, Veeam Agent checks whether the total size of archived logs exceeds the specified size. After that, Veeam Agent deletes oldest archived logs that exceed the specified size from the processed machine. This helps make sure that logs do not overflow the storage space on the Veeam Agent machine.
Do not delete archived logs. Log files remain untouched on the Veeam Agent machine.

Veeam Agent processes archive logs via Oracle Call Interface (OCI).

Requirements and Limitations for Oracle Processing

Oracle Database versions 11g — 19c are supported for all operating systems supported by Veeam Agent for Linux. To learn more, see System Requirements.
Automatic Storage Management (ASM) is not supported.

Oracle Real Application Clusters (RAC) are not supported.

Oracle Grid Infrastructure is not supported.

Oracle Database Express Edition is not supported.

SAP on Oracle is not supported.

Oracle Database architectures with Data Guard are not supported.

Related Tasks