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

Oracle Logs Backup and Restore

In this article

    Veeam Backup & Replication supports backup of Oracle database transaction logs and restore of Oracle databases.

    Database transaction logs are created by the Oracle system. The Oracle database can run in one of the following logging modes:

    • ARCHIVELOG turned on — logs are saved and can be used for recovery purposes.
    • ARCHIVELOG turned off — no transaction logs are saved. This mode is not recommended as it does not provide for proper disaster recovery.

    With ARCHIVELOG turned on, the Oracle system stores database transaction logs to a certain location on the VM guest OS, as specified by the database administrator. Veeam Backup & Replication allows you to set up the following ways of log handling:

    • Instruct the backup job to collect log files from the Oracle VM and ship them to the backup repository where they are stored next to image-level backups of the Oracle VM.
    • Skip log processing — log files remain untouched on the Oracle VM and are preserved within the image-level backup.

    If you enable application-aware processing for an Oracle VM, during the job session Veeam Backup & Replication installs a runtime process on this VM to collect information about the database and process transaction logs according to job settings. Application-specific settings are configured at the Guest Processing step of the backup job wizard — you can specify how logs should be backed up and\or truncated for Oracle databases.

    Requirements for Transaction Log Backup

    • Veeam Backup & Replication supports transaction logs backup and restore for Oracle database version 11 and later. The Oracle database may run on a Microsoft Windows VM or Linux VM.
    • Automatic Storage Management (ASM) is supported for Oracle 11 and later.
    • Oracle Express Databases are supported if running on Microsoft Windows machines only.
    • The database must run in the ARCHIVELOG mode.

    Related Topics