SAP for Oracle Backups

You can back up SAP on Oracle databases, the control file, log files, or SAP on Oracle datafiles and tablespaces. You can back up the database when it is online or offline. If the database must be accessible and you have a small backup window, run a series of online backups for different database portions.

Full Backups

SAP on Oracle full backups include the entire database and the control file. A full backup is the most comprehensive backup and is the baseline for incremental backups. Full backups of online databases include the log files.

Incremental Backups

A SAP on Oracle incremental backup contains the changed data from the last full backup. Incremental backups use less media and resources than full backups.

Selective Online Full Backups

A selective online full backup is a backup taken when the database is online. The backed up data is copied to a selective copy, which you can use for a restore. This backup is useful in disaster recovery scenarios because the data and logs are stored together.

What is Backed Up

  • Oracle database files that include the datafiles and control files
  • Archived redo logs

What Is Not Backed Up

Application files that are associated with the SAP on Oracle installation.

Tip: Use the File System Agent to back up the application files.

Note: You can configure the software to exclude the database application files from the UNIX file system backup. For more information, see Excluding Database Application Files from a UNIX File System Backup.

Performing Backups

You can perform backups immediately or schedule them through the CommCell Console or by using the BR*Tools interface.

Job Restartability

For information on the default rules and how to change them, see Changing the Default SAP for Oracle Backup Job Restartability Behavior.

Last modified: 9/23/2020 2:40:41 PM