Oracle Log Backup
Veeam Backup & Replication supports backup of Oracle database archived logs and restore of Oracle databases.
Database archived 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 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 archived 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 archived 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 deleted for Oracle databases.
Requirements for Archived Log Backup
- Veeam Backup & Replication supports archived log 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.
- Archived Log Backup Jobs
- How Oracle Archived Log Backup Works
- Retention for Archived Log Backup
- Log Shipping Servers
- Archived Log Backup Statistics